trees

Custom SQL query returning 33 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
3213 26499 1 66 2710 Harrison St 3 Sidewalk: Curb side : Cutout Tree 1     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.412167121652 (37.7537504562032, -122.412167121652) 2 4 7 28859 19
76533 27143 1 66 1775 Silver Ave 4 Sidewalk: Curb side : Cutout Tree 1     12 2X3   6011388.84182 2095356.57174 37.7340920254878 -122.403017629645 (37.7340920254878, -122.403017629645) 10 3 8 58 1
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
116531 30139 1 66 410X Mansell St 1 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
158368 30141 1 66 410X Mansell St 3 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
184604 30143 1 66 410X Mansell St 5 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
129104 30145 1 66 410X Mansell St 7 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
186 30163 1 66 410X Mansell St 20 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
455 30164 1 66 410X Mansell St 21 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
99453 30165 1 66 410X Mansell St 22 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
79158 30166 1 66 410X Mansell St 25 Median : Cutout Tree 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
51790 37371 7 66 755 Morse St 5 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
44868 37377 7 66 755 Morse St 11 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
175412 37379 7 66 755 Morse St 13 Sidewalk: Property side : Cutout Tree 2 FUF 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993) 9 7 6 28861 5
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
28264 4893 1 66 745X Mansell St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6009751.8988059 2090059.5024837 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874) 9 3 8 309 18
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
14115 61098 7 66 806 Shotwell St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 09/24/1988 12:00:00 AM   3x3 Permit Number 25594 6007925.06671696 2103219.75918175 37.7554885536992 -122.415549543793 (37.7554885536992, -122.415549543793) 2 4 7 28859 19
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
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
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
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
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
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
94409 9382 1 66 337 Gold Mine Dr 1 Sidewalk: Curb side : Cutout Tree 1     0 3X3   6001129.4629101 2097791.8544146 37.7402004981777 -122.438661870607 (37.7402004981777, -122.438661870607) 2 7 5 63 7
68664 94197 7 66 355 Ocean Ave 5 Sidewalk: Curb side : Cutout Tree 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
96160 94198 7 66 355 Ocean Ave 6 Sidewalk: Curb side : Cutout Tree 2   05/25/2010 12:00:00 AM   3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662) 9 7 6 28861 25
66991 96631 7 66 1212 10th Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/24/2015 12:00:00 AM   4x4 Permit Number 776835 5993035.2 2107183.3 37.7655231963247 -122.467331039359 (37.7655231963247, -122.467331039359) 11 8 11 56 12
9498 97930 4 66 1615 Grant Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6010461.1 2120070.1 37.801897866839 -122.40796734514 (37.801897866839, -122.40796734514) 3 1 10 308 23
38858 98972 1 66 825 Shotwell St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   0 5x5   6008234.2 2102998.9 37.7548994960031 -122.414464835105 (37.7548994960031, -122.414464835105) 2 4 7 28859 19
182004 99583 4 66 650X Brunswick St 23 Sidewalk: Curb side : Cutout Tree 2     3 3x6   5998578.4 2086902.6 37.710155688278 -122.446699086535 (37.710155688278, -122.446699086535) 9 7 6 28861 5
150789 99672 1 66 1250X Shrader St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   3 3x3   5997882 2106337.7 37.7634800016896 -122.450506162624 (37.7634800016896, -122.450506162624) 15 5 11 29492 9
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