trees

Custom SQL query returning 20 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
5675 261201 1 63 699x Benton Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6007339 2095419 37.7340364554683 -122.417023656077 (37.7340364554683, -122.417023656077) 2 7 7 28859 2
6140 243478 1 63 1499X Eugenia Ave 4 Sidewalk: Curb side : Cutout Tree 2     0 3x3   6008755.36846 2097659.39973 37.7402676797185 -122.412285110476 (37.7402676797185, -122.412285110476) 10 7 7 28859 2
18973 233322 1 63 51 Prentiss St 2 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6008884.18383 2098343.89419 37.7421543791283 -122.411888074199 (37.7421543791283, -122.411888074199) 10 7 7 28859 2
22573 105838 1 63 39X Bonview St 1 Front Yard : Yard Tree 1     15     6007716.90579 2099172.41141 37.7443637468546 -122.415982827151 (37.7443637468546, -122.415982827151) 2 7 7 28859 2
32405 246702 1 63 1 Bonview St 8 Sidewalk: Curb side : Yard Tree 2     15     6007696.68665 2099102.86041 37.7441716385189 -122.416047816374 (37.7441716385189, -122.416047816374) 2 7 7 28859 2
43298 23673 1 63 319 Virginia Ave 2 Median : Cutout Tree 1     12 12   6006936.2458165 2098250.5638735 37.741788638282 -122.418616833275 (37.741788638282, -122.418616833275) 2 7 7 28859 2
58718 234516 1 63 90x Peralta Ave 2 Median : Yard Tree 1     15 Width 10ft   6010366.95066 2100295.32111 37.7475956480377 -122.406898611185 (37.7475956480377, -122.406898611185) 2 7 7 28859 2
61382 234515 1 63 2 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   6010924.44859 2100544.92665 37.7483121900522 -122.404988378323 (37.7483121900522, -122.404988378323) 2 7 7 28859 2
66441 109838 6 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
103851 247910 1 63 399 Franconia St 1 Side Yard : Yard Tree 2     11     6009965.37797 2098759.56576 37.7433563212371 -122.408178935533 (37.7433563212371, -122.408178935533) 2 7 7 28859 2
108195 247896 1 63 351 Mayflower St 1 Sidewalk: Property side : Yard Tree 2     29 Width 5ft   6010145.43386 2098385.46575 37.7423392041921 -122.407529975731 (37.7423392041921, -122.407529975731) 10 7 7 28859 2
128520 246698 1 63 1 Bonview St 4 Sidewalk: Curb side : Yard Tree 2     1     6007671.81678 2099058.43431 37.7440482560225 -122.416130665494 (37.7440482560225, -122.416130665494) 2 7 7 28859 2
139657 256152 4 63 80X Peralta Ave 1 Median : Cutout Tree 2       3x3   6010428 2100359 37.747773912222 -122.406691992098 (37.747773912222, -122.406691992098) 2 7 7 28859 2
145433 234514 1 63 998 York St 10 Sidewalk: Curb side : Yard Tree 2     1 Width 7ft   6009944.54234 2103430.26244 37.7561798559202 -122.408580392894 (37.7561798559202, -122.408580392894) 2 4 7 28859 19
152878 234517 1 63 10x Benton Ave 1 Median : Yard Tree 1     29     6004828.72428 2095028.54608 37.7328228256069 -122.425674682059 (37.7328228256069, -122.425674682059) 2 7 7 28861 2
156992 253621 6 63 200x Montcalm St 1 Back Yard : Yard Tree 2       3x3   6010036 2099760 37.7461072494139 -122.408005278478 (37.7461072494139, -122.408005278478) 2 7 7 28859 2
176495 234508 1 63 201 Coso Ave 2 Side Yard : Yard Tree 2     28 Width 5ft   6007691.39954 2099521.32268 37.745320345265 -122.416095727735 (37.745320345265, -122.416095727735) 2 7 7 28859 2
186214 234513 1 63 998 York St 4 Sidewalk: Curb side : Yard Tree 2     5 Width 7ft   6009942.57021 2103461.5506 37.7562656557487 -122.408589420289 (37.7562656557487, -122.408589420289) 2 4 7 28859 19
188305 178179 1 63 201 Yale St 1 Sidewalk: Curb side : Cutout Tree 2     20 Width 4ft   6007200.07685 2092715.80897 37.7266062646522 -122.417312460112 (37.7266062646522, -122.417312460112) 9 3 7 309 28
191676 247975 1 63 503 Peralta Ave 1 Side Yard : Yard Tree 2     21     6009813.28917 2099236.81382 37.744658223 -122.408738483811 (37.744658223, -122.408738483811) 2 7 7 28859 2