trees

Custom SQL query returning 15 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
73123 119673 4 66 1207 De Haro St 1 Front Yard : Yard Tree 2           6012287 2102743 37.7544236952833 -122.400431054928 (37.7544236952833, -122.400431054928) 10 3 8 28856 29
127768 30054 1 66 610X Junipero Serra Blvd 7 Median : Cutout Tree 1           5991361.953164 2093442.610307 37.7276980777014 -122.472116715696 (37.7276980777014, -122.472116715696) 9 8 4 64 40
9604 56991 7 66 4160 26th St 1 Sidewalk: Curb side : Cutout Tree 2   08/27/1974 12:00:00 AM     Permit Number 767882 6002854.60493399 2100676.90172362 37.7482201548247 -122.432903090117 (37.7482201548247, -122.432903090117) 2 4 5 28862 22
27497 21133 1 66 2292X Sunset Blvd 2 Sidewalk: Curb side : Cutout Tree 1     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
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
162770 21130 1 66 2292X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree 1     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696 (37.7442358239277, -122.49474388696) 1 8 3 29491 35
186666 65625 7 66 238 Ney St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 02/07/1990 12:00:00 AM     Permit Number 28533 6004892.15539073 2094035.47955331 37.7300996701998 -122.425384739364 (37.7300996701998, -122.425384739364) 9 7 6 28861 5
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
44729 114527 4 66 1 TIOGA AVE 3 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
88436 114528 4 66 1 TIOGA AVE 4 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
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
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
187 112917 1 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
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