Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantDate, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 104 | 104 | 251210 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1170 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | |||||||||
| 4668 | 4668 | 253644 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/05/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4669 | 4669 | 253646 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/09/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4684 | 4684 | 253645 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 03/11/2006 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 13240 | 13240 | 187608 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
| 13250 | 13250 | 187606 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
| 13251 | 13251 | 187611 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 100 Northridge Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
| 13256 | 13256 | 187607 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 101 Northridge Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018884.0 | 2094052.0 | 37.730925622785 | -122.37701375897899 | (37.730925622785, -122.377013758979) | ||||
| 13889 | 13889 | 11219 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/28/1992 12:00:00 AM | 30 | 3X4 | 6018141.66576 | 2094727.81231 | 37.7327403559813 | -122.379627091035 | (37.7327403559813, -122.379627091035) | ||
| 14018 | 14018 | 99640 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000X Gilman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | City Owned Lot | 6015553.4063 | 2089548.4030000002 | 37.7183756251523 | -122.38821408703001 | (37.7183756251523, -122.38821408703) | ||
| 14069 | 14069 | 11218 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X4 | 6018145.287959999 | 2094715.08165 | 37.73270559986911 | -122.379613683941 | (37.7327055998691, -122.379613683941) | |||
| 14285 | 14285 | 11226 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/1992 12:00:00 AM | 35 | 3X4 | 6018091.97554 | 2094860.3210200001 | 37.7331014580651 | -122.379808087687 | (37.7331014580651, -122.379808087687) | ||
| 14426 | 14426 | 4895 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1993 12:00:00 AM | 12 | 3X4 | 6018140.882180001 | 2094365.07214 | 37.7317442992597 | -122.379604608867 | (37.7317442992597, -122.379604608867) | ||
| 14846 | 14846 | 11225 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/1992 12:00:00 AM | 35 | 3X4 | 6018100.6161400005 | 2094835.81488 | 37.733034645636394 | -122.37977651247101 | (37.7330346456364, -122.379776512471) | ||
| 15149 | 15149 | 22069 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/18/2000 12:00:00 AM | 3 | 3X3 | 6015996.14125 | 2101854.73781 | 37.7521908608401 | -122.387541804919 | (37.7521908608401, -122.387541804919) | ||
| 16239 | 16239 | 22065 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016001.4583 | 2101755.32387 | 37.7519181854896 | -122.387516482698 | (37.7519181854896, -122.387516482698) | ||
| 16356 | 16356 | 11215 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6018142.31163 | 2094695.6186 | 37.732651993985705 | -122.37962262229799 | (37.7326519939857, -122.379622622298) | |||
| 16446 | 16446 | 22064 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2955 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2000 12:00:00 AM | 3 | 3X3 | 6016002.11901 | 2101736.21307 | 37.751865747830294 | -122.38751286473301 | (37.7518657478303, -122.387512864733) | ||
| 16458 | 16458 | 11221 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1050X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X4 | 6018130.45859 | 2094749.06198 | 37.7327980852604 | -122.379667313208 | (37.7327980852604, -122.379667313208) | |||
| 16971 | 16971 | 4468 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1497 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004583.98516 | 2100211.8834700002 | 37.7470412591526 | -122.426889829809 | (37.7470412591526, -122.426889829809) | |||
| 17421 | 17421 | 4245 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4038 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003639.78589 | 2100421.5344700003 | 37.7475634792894 | -122.430169743652 | (37.7475634792894, -122.430169743652) | |||
| 18452 | 18452 | 10752 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 18851 | 18851 | 22861 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 151 Turquoise Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 5999939.19286 | 2099172.51002 | 37.7439236657612 | -122.44287645099199 | (37.7439236657612, -122.442876450992) | |||
| 19420 | 19420 | 12067 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1225X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017323.1868972 | 2094393.2571117 | 37.7317765554235 | -122.38243353641701 | (37.7317765554235, -122.382433536417) | |||
| 20209 | 20209 | 4252 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 4072 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003430.396430001 | 2100411.11399 | 37.747523005287206 | -122.430893055767 | (37.7475230052872, -122.430893055767) | |||
| 20904 | 20904 | 12016 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | ||
| 21291 | 21291 | 2046 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 701X Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001912.87216 | 2095420.3332200001 | 37.733733385587 | -122.43578352768299 | (37.733733385587, -122.435783527683) | |||
| 22187 | 22187 | 4461 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1451 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004572.77209 | 2100404.42204 | 37.74756929159079 | -122.42694231424299 | (37.7475692915908, -122.426942314243) | |||
| 23224 | 23224 | 4372 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1007 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6000961.422590001 | 2096155.46194 | 37.7356977864326 | -122.439125632357 | (37.7356977864326, -122.439125632357) | |||
| 38339 | 38339 | 8592 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 47273 | 47273 | 10756 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 49627 | 49627 | 4480 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1544 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6004537.43405 | 2099923.54921 | 37.7462469275435 | -122.427030266568 | (37.7462469275435, -122.427030266568) | |||
| 72160 | 72160 | 10810 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6017615.78501 | 2094776.3050099998 | 37.7328444878546 | -122.38144858171499 | (37.7328444878546, -122.381448581715) | |||
| 72215 | 72215 | 11275 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 77361 | 77361 | 17319 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 98X Otis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006649.48331 | 2109199.16396 | 37.7718348142851 | -122.42038530226101 | (37.7718348142851, -122.420385302261) | |||
| 77827 | 77827 | 11247 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2003 12:00:00 AM | 8 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | ||
| 77931 | 77931 | 10799 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x4 | 6017498.59701 | 2094875.2630099999 | 37.733109736403705 | -122.381860615174 | (37.7331097364037, -122.381860615174) | |||
| 78253 | 78253 | 12004 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 78989 | 78989 | 11248 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 79089 | 79089 | 11278 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 79233 | 79233 | 10737 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 79391 | 79391 | 12006 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1230X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 79498 | 79498 | 12022 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 79673 | 79673 | 12115 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1295X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6016958.2682626 | 2094597.9426773998 | 37.7323184171755 | -122.383709392876 | (37.7323184171755, -122.383709392876) | |||
| 81021 | 81021 | 17318 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 98X Otis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6006649.48331 | 2109199.16396 | 37.7718348142851 | -122.42038530226101 | (37.7718348142851, -122.420385302261) | |||
| 81116 | 81116 | 11239 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | |||
| 81260 | 81260 | 10730 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 81312 | 81312 | 11243 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | |||
| 82251 | 82251 | 12036 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 82684 | 82684 | 11268 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 82997 | 82997 | 10741 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 84760 | 84760 | 10732 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018138.790397401 | 2094650.7890521 | 37.7325287066123 | -122.379631682873 | (37.7325287066123, -122.379631682873) | |||
| 85139 | 85139 | 6395 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 5X Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1993 12:00:00 AM | 3 | 3X4 | 6018168.8629005 | 2094369.8502073998 | 37.7317589621466 | -122.379508204595 | (37.7317589621466, -122.379508204595) | ||
| 85254 | 85254 | 6176 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1075 Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005893.15301 | 2113273.27935 | 37.782978696051 | -122.423291166859 | (37.782978696051, -122.423291166859) | |||
| 86062 | 86062 | 10809 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017607.97201 | 2094759.3780099999 | 37.7327975782942 | -122.381474416821 | (37.7327975782942, -122.381474416821) | |||
| 86336 | 86336 | 8593 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 86825 | 86825 | 11235 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 12:00:00 AM | 18 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | ||
| 86885 | 86885 | 11999 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 87739 | 87739 | 12023 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 87797 | 87797 | 11991 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 88148 | 88148 | 12074 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017245.0743814 | 2094442.9323578998 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | |||
| 88419 | 88419 | 10839 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017986.87901 | 2094607.0340099998 | 37.732400183828396 | -122.380153842969 | (37.7324001838284, -122.380153842969) | |||
| 88459 | 88459 | 104427 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1000x GILMAN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6015570.0 | 2089525.0 | 37.71831228448 | -122.3881550967 | (37.71831228448, -122.3881550967) | |||
| 88915 | 88915 | 10784 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 89725 | 89725 | 12020 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 90150 | 90150 | 10785 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 90337 | 90337 | 83074 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 6017910.254851099 | 2094654.90941097 | 37.7325274125135 | -122.380422079616 | (37.7325274125135, -122.380422079616) | ||||
| 91396 | 91396 | 10743 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 92296 | 92296 | 11266 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1990 12:00:00 AM | 26 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | ||
| 93700 | 93700 | 17476 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2050X Palou Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6012504.429269999 | 2097052.5732200001 | 37.7388111244659 | -122.399279687607 | (37.7388111244659, -122.399279687607) | |||
| 94331 | 94331 | 10779 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 94658 | 94658 | 11363 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1351X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/05/1992 12:00:00 AM | 45 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | ||
| 94761 | 94761 | 10740 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 95728 | 95728 | 8589 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 96515 | 96515 | 12076 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017245.0743814 | 2094442.9323578998 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | |||
| 96730 | 96730 | 16821 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2130 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001107.6476595 | 2113179.9385941 | 37.782451166007 | -122.439840308676 | (37.782451166007, -122.439840308676) | |||
| 97663 | 97663 | 19232 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1220X Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001981.40919 | 2110539.7077099998 | 37.7752514546823 | -122.436628435964 | (37.7752514546823, -122.436628435964) | |||
| 98284 | 98284 | 11286 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 99278 | 99278 | 11244 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | |||
| 99336 | 99336 | 10761 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1999 12:00:00 AM | 8 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | ||
| 99438 | 99438 | 11256 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1145X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/09/2003 12:00:00 AM | 3 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | ||
| 99618 | 99618 | 12111 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1291X La Salle Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016979.7352729 | 2094586.3401911 | 37.7322877456302 | -122.383634368276 | (37.7322877456302, -122.383634368276) | |||
| 99737 | 99737 | 10739 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 102487 | 102487 | 10778 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 102867 | 102867 | 10766 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 103065 | 103065 | 12025 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
| 103589 | 103589 | 11241 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1100X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X4 | 6018021.124713 | 2094004.401623 | 37.7307473625426 | -122.37999358681499 | (37.7307473625426, -122.379993586815) | |||
| 104315 | 104315 | 11345 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1300X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 104681 | 104681 | 10805 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1990 12:00:00 AM | 12 | 3x4 | 6017572.81601 | 2094794.5340099998 | 37.732892168704204 | -122.381598405298 | (37.7328921687042, -122.381598405298) | ||
| 104800 | 104800 | 8590 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2355X Geary Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6000490.27762 | 2113338.60243 | 37.7828516547291 | -122.44198752522699 | (37.7828516547291, -122.441987525227) | |||
| 105361 | 105361 | 11992 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/26/2016 12:00:00 AM | 18 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | ||
| 105402 | 105402 | 10757 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 105607 | 105607 | 10746 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 106941 | 106941 | 10744 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 107134 | 107134 | 12043 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1250X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/1993 12:00:00 AM | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
| 107681 | 107681 | 26534 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200X La Salle Ave | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017464.4799176 | 2094331.6246005 | 37.731615128467496 | -122.381940767084 | (37.7316151284675, -122.381940767084) | |||
| 108963 | 108963 | 26713 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 340 Lake St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2x2 | 5994414.30523 | 2114928.2579900003 | 37.7868683042504 | -122.46312306923099 | (37.7868683042504, -122.463123069231) | |||
| 108965 | 108965 | 10753 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1120X Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 108988 | 108988 | 10842 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1139X Hudson Ave | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018020.73301 | 2094608.3360099997 | 37.732405626582796 | -122.380036890979 | (37.7324056265828, -122.380036890979) | |||
| 109373 | 109373 | 11264 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1176X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1992 12:00:00 AM | 45 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");