DIYFuturism.com - Location Geocoding and SQL Logging

[{"id":"5de7dc9e.707dc4","type":"mqtt in","z":"3e83e17a.f6037e","name":"brad","topic":"owntracks/brad/owntracks","qos":"2","broker":"843a7e82.291a5","x":210,"y":200,"wires":[["ef8138df.bb8e98"]]},{"id":"ef8138df.bb8e98","type":"owntracks","z":"3e83e17a.f6037e","x":362.7381362915039,"y":199.76192378997803,"wires":[["c43be78.4c3fb18","281cc682.55cd5a"]]},{"id":"de894da4.36715","type":"sqldbs","z":"3e83e17a.f6037e","mydb":"a66bd958.0488a8","querytype":"Insert","name":"Insert GPS Data","x":1369.057273864746,"y":395.0794253349304,"wires":[[]]},{"id":"5078d4b7.da6c2c","type":"google places","z":"3e83e17a.f6037e","reqType":"placesNearby","googleAPI":"","name":"Get Place Info","lat":"","lon":"","query":"","radius":"","rankBy":"distance","keyword":"","language":"","minPrice":"","maxPrice":"","placeName":"","placeId":"","extensions":"","openNow":false,"types":"establishment","outputnumber":"1","outputas":"single","x":870.8431396484375,"y":296.4286332130432,"wires":[["36f87eb2.b46c02","bb5d8af8.7312f8"]]},{"id":"7481b3fb.3f261c","type":"function","z":"3e83e17a.f6037e","name":"Format SQL Query","func":"msg.topic = \"INSERT INTO gps_tracks VALUES ( NULL, 'bw',NOW(),\\\"\" + msg.payload.source + \"\\\",\" + msg.payload.lon +\",\" + msg.payload.lat +\",\" + msg.payload.acc + \",\\\"\"+ msg.payload.placeid +\"\\\",\\\"\"+ msg.payload.vicinity +\"\\\",\\\"\" + msg.payload.title +\"\\\")\";\n\nreturn msg;","outputs":1,"noerr":0,"x":1167.4107513427734,"y":392.0437512397766,"wires":[["de894da4.36715"]]},{"id":"efe6d09a.46af","type":"mqtt out","z":"3e83e17a.f6037e","name":"Post Home","topic":"location/brad/vicinity","qos":"","retain":"","broker":"843a7e82.291a5","x":1374.985969543457,"y":192.00399351119995,"wires":[]},{"id":"36f87eb2.b46c02","type":"mqtt out","z":"3e83e17a.f6037e","name":"Post Vicinity","topic":"location/brad/vicinity","qos":"","retain":"","broker":"843a7e82.291a5","x":1374.0573844909668,"y":256.051616191864,"wires":[]},{"id":"5c8b1087.8e7e7","type":"comment","z":"3e83e17a.f6037e","name":"Add Location to Database","info":"","x":1341.5573501586914,"y":337.0040063858032,"wires":[]},{"id":"29013dfd.13e0c2","type":"comment","z":"3e83e17a.f6037e","name":"Send Location info to HA","info":"","x":1348.4624099731445,"y":136.9444546699524,"wires":[]},{"id":"c43be78.4c3fb18","type":"change","z":"3e83e17a.f6037e","name":"Format Source","rules":[{"t":"set","p":"payload.source","pt":"msg","to":"Owntracks","tot":"str"}],"action":"","property":"","from":"","to":"","reg":false,"x":366.14085388183594,"y":245.87301969528198,"wires":[["3c585ec.01316a2"]]},{"id":"45598d44.41d284","type":"function","z":"3e83e17a.f6037e","name":"Add Home Info","func":"msg.payload.name = \"Home\";\nmsg.payload.title = \"Home\"\nmsg.payload.vicinity = \"MY ADDRESS\";\nmsg.payload.placeid = \"XXX\";\nmsg.payload.types = \"Home\";\n\nreturn msg;","outputs":1,"noerr":0,"x":995.426643371582,"y":194.14683866500854,"wires":[["efe6d09a.46af","7481b3fb.3f261c"]]},{"id":"bb5d8af8.7312f8","type":"merge","z":"3e83e17a.f6037e","name":"","timeout":"2","x":873.700382232666,"y":337.5396866798401,"wires":[["55015f38.192b2"]]},{"id":"55015f38.192b2","type":"function","z":"3e83e17a.f6037e","name":"Format SQL Query","func":"msg.topic = \"INSERT INTO gps_tracks VALUES ( NULL, 'bw',NOW(),\\\"\" + msg.payload[0].payload.source + \"\\\",\" + msg.payload[0].payload.lon +\",\" + msg.payload[0].payload.lat +\",\" + msg.payload[0].payload.acc + \",\\\"\"+ msg.payload[1].placeid +\"\\\",\\\"\"+ msg.payload[1].description +\"\\\",\\\"\" + msg.payload[1].title +\"\\\")\";\n\nreturn msg;","outputs":1,"noerr":0,"x":1170.3669357299805,"y":439.6230254173279,"wires":[["de894da4.36715"]]},{"id":"fdefb5ec.91b618","type":"rbe","z":"3e83e17a.f6037e","name":"Changed?","func":"rbei","gap":"","start":"","inout":"out","x":865.15869140625,"y":252.12302923202515,"wires":[["5078d4b7.da6c2c","bb5d8af8.7312f8"]]},{"id":"ab71a426.369568","type":"rbe","z":"3e83e17a.f6037e","name":"Changed?","func":"rbei","gap":"","start":"","inout":"out","x":818.28369140625,"y":194.6230263710022,"wires":[["45598d44.41d284"]]},{"id":"281cc682.55cd5a","type":"geofence","z":"3e83e17a.f6037e","name":"","mode":"circle","inside":"true","rad":0,"points":[],"centre":{"latitude":0,"longitude":0},"x":579.1666666666666,"y":198.33333333333331,"wires":[["ab71a426.369568"]]},{"id":"3c585ec.01316a2","type":"geofence","z":"3e83e17a.f6037e","name":"","mode":"circle","inside":"true","rad":0,"points":[],"centre":{"latitude":0,"longitude":0},"x":600,"y":260,"wires":[["fdefb5ec.91b618"]]},{"id":"843a7e82.291a5","type":"mqtt-broker","z":"","broker":"localhost","port":"1883","clientid":"node-red-doom","usetls":false,"compatmode":true,"keepalive":"60","cleansession":true,"willTopic":"","willQos":"0","willPayload":"","birthTopic":"","birthQos":"0","birthPayload":""},{"id":"a66bd958.0488a8","type":"sqldbsdatabase","z":"","host":"127.0.0.1","port":"3306","db":"hass","dialect":"mysql"}]