trees

Custom SQL query returning 18 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
25370 28296 1 133 1432 Guerrero St 1 Sidewalk: Curb side : Cutout Tree 2   02/26/2003 12:00:00 AM 6 2X3   6005818.9272 2100626.68333 37.7482499542668 -122.422648971496 (37.7482499542668, -122.422648971496) 2 4 5 28859 19
31240 47741 7 133 1384 York St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/08/2002 12:00:00 AM     Permit Number 45524 6010066.05430582 2101146.00958918 37.7499146097647 -122.407999079784 (37.7499146097647, -122.407999079784) 2 4 7 28859 19
32772 255586 1 133 157 San Carlos St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6006708 2105213 37.760893044988 -122.419899978675 (37.760893044988, -122.419899978675) 2 4 7 28859 19
33731 67340 7 133 2520 25th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/22/1992 12:00:00 AM     Permit Number 30824 6011380.01787368 2101864.42331106 37.7519606958911 -122.403505842523 (37.7519606958911, -122.403505842523) 10 4 8 28859 19
34239 46345 7 133 382 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/14/2002 12:00:00 AM     Permit Number 44591 6005460.79581087 2101487.62598308 37.7505936931274 -122.423948593876 (37.7505936931274, -122.423948593876) 2 4 5 28859 19
40601 223023 1 133 330 Lexington St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6006515.40022 2104174.73701 37.7580313639845 -122.420492397202 (37.7580313639845, -122.420492397202) 2 4 7 28859 19
45934 69199 7 133 1342 Florida St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/31/1994 12:00:00 AM     Permit Number 33247 6009509.54623645 2101351.16759285 37.7504467544428 -122.409938000531 (37.7504467544428, -122.409938000531) 2 4 7 28859 19
52294 28791 1 133 2737 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6008967.21311 2102509.30076 37.7535963186214 -122.411895265148 (37.7535963186214, -122.411895265148) 2 4 7 28859 19
56077 51543 7 133 330 Lexington St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/22/2006 12:00:00 AM     Permit Number 47842 6006500.80110502 2104175.14616456 37.7580316646871 -122.4205429163 (37.7580316646871, -122.4205429163) 2 4 7 28859 19
70202 223024 1 133 979 York St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6009975.92603 2103539.78877 37.756482348292 -122.408479582484 (37.756482348292, -122.408479582484) 2 4 7 28859 19
70967 28792 1 133 2731 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2     6 3x3   6008964.24348 2102548.86607 37.7537047894643 -122.411908330514 (37.7537047894643, -122.411908330514) 2 4 7 28859 19
85167 223025 1 133 380 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6005467.6636 2101500.58617 37.7506296665394 -122.423925765973 (37.7506296665394, -122.423925765973) 2 4 5 28859 19
106219 34302 7 133 1261 Hampshire St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38090 6010338.30191232 2101880.05024725 37.7519453623814 -122.407109364623 (37.7519453623814, -122.407109364623) 10 4 7 28859 19
123656 223036 1 133 2743 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6008969.13541 2102480.10351 37.7535162573804 -122.411886554326 (37.7535162573804, -122.411886554326) 2 4 7 28859 19
134483 34301 7 133 1257 Hampshire St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38089 6010337.06875453 2101902.38195398 37.7520066112995 -122.407115203053 (37.7520066112995, -122.407115203053) 10 4 7 28859 19
155068 255587 1 133 157 San Carlos St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6006708 2105213 37.760893044988 -122.419899978675 (37.760893044988, -122.419899978675) 2 4 7 28859 19
165574 65260 7 133 1153 Florida St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 06/08/2002 12:00:00 AM     Permit Number 28059 6009500.12226017 2102463.02471256 37.7534991381214 -122.410049073844 (37.7534991381214, -122.410049073844) 2 4 7 28859 19
165972 34344 7 133 1325 York St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 07/14/1997 12:00:00 AM     Permit Number 38101 6010099.44079349 2101484.52277039 37.7508459613928 -122.407907495355 (37.7508459613928, -122.407907495355) 2 4 7 28859 19