trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
6989 109119 10 22 2036x 15TH ST 5 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
15934 113606 10 9 2900 18TH ST 4 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
20563 109121 10 22 2036x 15TH ST 7 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
21125 109116 10 22 2036x 15TH ST 2 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
25414 109115 10 22 2036x 15TH ST 1 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
38343 85458 10 17 265 Guerrero St 4 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
38713 113610 10 9 595 ALABAMA ST 1 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
42613 85457 10 17 265 Guerrero St 3 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
43092 85452 10 17 275 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006138 2107427 37.7669400383946 -122.422028645748 (37.7669400383946, -122.422028645748) 8 4 7 28853 19
57202 109123 10 22 2036x 15TH ST 9 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
59693 113605 10 9 2900 18TH ST 3 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
65275 113613 10 9 595 ALABAMA ST 4 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
69927 113600 10 9 550 FLORIDA ST 1 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM 1 3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
71895 113602 10 9 550 FLORIDA ST 3 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
73175 85449 10 17 287 GUERRERO ST 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005798 2107491.2 37.7670971345308 -122.423209217168 (37.7670971345308, -122.423209217168) 8 4 5 28853 19
77706 85451 10 17 281 GUERRERO ST 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6005518.5 2107341.2 37.7666694929162 -122.424165297356 (37.7666694929162, -122.424165297356) 8 4 5 28853 19
89445 113603 10 9 2900 18TH ST 1 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
89702 109120 10 22 2036x 15TH ST 6 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
92107 109124 10 22 2036x 15TH ST 10 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
98942 113300 10 19 29 DORLAND ST 1 Sidewalk: Curb side : Cutout Tree 2   09/18/2015 12:00:00 AM 3 3x3   6005366 2105717 37.7622012138481 -122.424577222119 (37.7622012138481, -122.424577222119) 8 4 5 28859 19
102176 85456 10 17 265 Guerrero St 2 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
106808 113611 10 9 595 ALABAMA ST 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19
109575 109117 10 22 2036x 15TH ST 3 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
115452 113608 10 9 2900 18TH ST 6 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
119541 85450 10 17 285 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006141 2107369 37.7667809533476 -122.422014148516 (37.7667809533476, -122.422014148516) 8 4 7 28853 19
124812 85460 10 17 245x Guerrero St 2 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128 2107603 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783) 8 4 7 28853 19
125555 85455 10 17 265 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
126583 109122 10 22 2036x 15TH ST 8 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
131278 85454 10 17 269 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
138387 110499 10 149 900X JESSIE ST 1 Sidewalk: Curb side : Cutout Tree 2     2 3x3   6007667 2110717 37.7760597176113 -122.416973193872 (37.7760597176113, -122.416973193872) 8 2 9 28853 34
138839 113607 10 9 2900 18TH ST 5 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
140705 85459 10 17 245x Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128 2107603 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783) 8 4 7 28853 19
142909 85461 10 17 245x Guerrero St 3 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006128 2107603 37.7674227286224 -122.422075738783 (37.7674227286224, -122.422075738783) 8 4 7 28853 19
157435 113601 10 9 550 FLORIDA ST 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3 Permit Number 773946 6009233 2105681 37.7623199946126 -122.411200142124 (37.7623199946126, -122.411200142124) 8 4 7 28859 19
163668 113604 10 9 2900 18TH ST 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
170467 85453 10 17 271 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   12/12/2014 12:00:00 AM 3 4x4 Permit Number 774478 6006135 2107486 37.7671018691982 -122.42204321409 (37.7671018691982, -122.42204321409) 8 4 7 28853 19
181612 113609 10 9 2900 18TH ST 7 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009122 2105484 37.7617728518996 -122.411570131816 (37.7617728518996, -122.411570131816) 8 4 7 28859 19
182184 109118 10 22 2036x 15TH ST 4 Sidewalk: Curb side : Cutout Tree 2       12x6   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
193056 113612 10 9 595 ALABAMA ST 3 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM   3x3   6009000 2105472 37.7617330585457 -122.411991234579 (37.7617330585457, -122.411991234579) 8 4 7 28859 19