trees

Custom SQL query returning 17 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3309 120871 1 66 1387 08th Ave 1 Sidewalk: Curb side : Pot Landscaping 2           5993606 2106068 37.7624938100726 -122.465275766733 (37.7624938100726, -122.465275766733) 1 8 11 56 12
94878 117511 1 66 2634 37TH AVE 1 Median : Yard Landscaping 1     20 3x3   5984921 2097163 37.7375384395308 -122.494657023299 (37.7375384395308, -122.494657023299) 1 8 3 29491 35
123486 99732 1 66 4150 Ocean Ave 1 Sidewalk: Property side : Cutout Landscaping 2           5986619.2 2095203.6 37.7322576937009 -122.488641645288 (37.7322576937009, -122.488641645288) 1 8 4 64 35
161563 116580 6 66 3000x 19TH AVE 3 Sidewalk: Property side : Cutout Landscaping 3 DPW     3x3   5990602 2095184 37.7324354869182 -122.47487091251 (37.7324354869182, -122.47487091251) 1 8 4 64 40
43687 117610 1 66 391 NEVADA ST 1 Unaccepted Street : Yard Landscaping 2       3x3   6008958 2096497 37.7370873514658 -122.411502385785 (37.7370873514658, -122.411502385785) 10 7 7 28859 2
112926 251642 1 66 2253 Broderick St 4 Sidewalk: Curb side : Cutout Landscaping 2       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286) 13 6 1 29490 27
35821 93164 1 66 201 Upper Ter 2 Sidewalk: Property side : Cutout Landscaping 2   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
36468 140265 1 66 2100X Grove St 3 Sidewalk: Curb side : Cutout Landscaping 2     0 Width 0ft   5997671.17 2110272.3417 37.7742714515841 -122.45151917218 (37.7742714515841, -122.45151917218) 15 5 2 29492 16
133338 93163 1 66 201 Upper Ter 1 Sidewalk: Property side : Cutout Landscaping 2   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.7638858848202 -122.444328283325 (37.7638858848202, -122.444328283325) 15 5 5 29492 3
25702 89015 1 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping 2   09/30/2008 12:00:00 AM   3x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
34209 107409 1 66 125 VILLA TER 1 Sidewalk: Curb side : Cutout Landscaping 2           5999028.2 2104385.8 37.7581861070008 -122.446401410764 (37.7581861070008, -122.446401410764) 2 5 5 28862 3
67643 92611 1 66 3856 23rd St   Sidewalk: Property side : Pot Landscaping 2   08/31/2009 12:00:00 AM     Permit Number 52924 6004067 2102488 37.7532616988935 -122.428839761175 (37.7532616988935, -122.428839761175) 2 4 5 28862 22
101202 88829 1 66 4437 20th St   Sidewalk: Curb side : Cutout Landscaping 2   09/30/2008 12:00:00 AM   8x1 Permit Number 51764 6001659 2104076 37.7574853780776 -122.437280798466 (37.7574853780776, -122.437280798466) 2 4 5 28862 3
161681 4313 1 66 727 Chenery St 1 Sidewalk: Curb side : Cutout Landscaping 1   08/17/2013 12:00:00 AM   3X3   6002321.25178 2095689.19659 37.7344948117373 -122.434390856497 (37.7344948117373, -122.434390856497) 2 7 5 63 7
22629 106932 1 66 358 SHOTWELL ST 1 Sidewalk: Curb side : Cutout Landscaping 2       8x10   6007793.2 2105846.4 37.7626932925098 -122.416191600332 (37.7626932925098, -122.416191600332) 8 4 7 28859 19
1437 109607 1 66 775 Congo St 1 Front Yard : Yard Landscaping 2           6000381.8 2095947.7 37.7350943222142 -122.441114705419 (37.7350943222142, -122.441114705419) 9 7 4 63 40
155364 105003 1 66 607 CONGO ST   Sidewalk: Property side : Yard Landscaping 2           6000094.1 2095817 37.7347190590407 -122.44210000591 (37.7347190590407, -122.44210000591) 9 7 4 63 40