trees

Custom SQL query returning 21 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
19070 15154 7 53 895X Mission St 8 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
27832 15155 7 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
31550 15160 7 53 895X Mission St 14 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
39622 15164 7 53 895X Mission St 18 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
58538 15152 7 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
68900 15165 7 53 895X Mission St 19 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
92451 15169 7 53 895X Mission St 23 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
103078 15168 7 53 895X Mission St 22 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
110518 15161 7 53 895X Mission St 15 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
112808 15167 7 53 895X Mission St 21 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
121554 15163 7 53 895X Mission St 17 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143433 15157 7 53 895X Mission St 11 Sidewalk: Curb side : Cutout Tree 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
143636 15150 7 53 895X Mission St 4 Sidewalk: Curb side : Cutout Tree 7     18 3x3   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
185169 15159 7 53 895X Mission St 13 Sidewalk: Curb side : Cutout Tree 7 Private   18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
67462 24840 7 16 200X Alemany Blvd 18 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
116587 24836 7 16 200X Alemany Blvd 14 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
152434 24828 7 173 200X Alemany Blvd 6 Sidewalk: Curb side : Cutout Tree 7   01/12/1996 12:00:00 AM 18 3X3   6009416.6826304 2095906.0445619 37.7354904326241 -122.409874802768 (37.7354904326241, -122.409874802768) 10 7 7 28859 2
98069 240 7 16 3010X 19th Ave 2 Sidewalk: Curb side : Cutout Tree 7     18 5x5   5990623.3177 2095139.449 37.7323143965058 -122.474793962374 (37.7323143965058, -122.474793962374) 1 8 4 64 40
56609 9951 7 27 95X Grove St 2 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36
128940 23156 7 11 50 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree 7   08/24/1993 12:00:00 AM 18 3X3   6007006.484382 2110627.274272 37.7757761752428 -122.419251731369 (37.7757761752428, -122.419251731369) 7 9 9 28852 36
165205 9950 7 27 95X Grove St 1 Sidewalk: Curb side : Cutout Tree 7     18 3X3   6007383.306516 2111592.002729 37.7784463030985 -122.418016611499 (37.7784463030985, -122.418016611499) 7 9 9 28852 36