Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99896 | 99896 | 20988 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2002X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 200 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 113211 | 113211 | 19366 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5993786.07945 | 2114905.6520700003 | 37.7867700254284 | -122.465294925074 | (37.7867700254284, -122.465294925074) | |||
| 96237 | 96237 | 11349 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 78038 | 78038 | 11356 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1339 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | |||
| 92365 | 92365 | 11339 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 105162 | 105162 | 11365 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 113692 | 113692 | 11352 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1339 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | |||
| 116087 | 116087 | 11262 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 117080 | 117080 | 11353 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1339 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | |||
| 117759 | 117759 | 11323 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1223 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017540.6929483 | 2093936.3628531997 | 37.730534025837706 | -122.38164980170299 | (37.7305340258377, -122.381649801703) | |||
| 117848 | 117848 | 11315 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1216X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | |||
| 128595 | 128595 | 11290 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 138396 | 138396 | 11362 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 143481 | 143481 | 11367 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 144910 | 144910 | 113889 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1x STORRIE ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 90 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 77748 | 77748 | 11361 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1350X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017253.696644001 | 2093959.2156363998 | 37.7305809242894 | -122.382643589629 | (37.7305809242894, -122.382643589629) | |||
| 88340 | 88340 | 11272 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 96390 | 96390 | 11261 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1145X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
| 99687 | 99687 | 11344 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 140115 | 140115 | 11346 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 92881 | 92881 | 11274 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 116764 | 116764 | 11332 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 123566 | 123566 | 11357 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1350X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017253.696644001 | 2093959.2156363998 | 37.7305809242894 | -122.382643589629 | (37.7305809242894, -122.382643589629) | |||
| 123629 | 123629 | 11355 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1339 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | |||
| 125319 | 125319 | 11348 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
| 126591 | 126591 | 11335 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 142547 | 142547 | 11333 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
| 81197 | 81197 | 11295 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 87198 | 87198 | 11271 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 97470 | 97470 | 11281 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 97973 | 97973 | 11291 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 101277 | 101277 | 11316 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1216X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | |||
| 107553 | 107553 | 11280 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 120294 | 120294 | 113893 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 5x STORRIE ST | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 60 | 6000722.0 | 2105303.0 | 37.76080110933629 | -122.440609317727 | (37.7608011093363, -122.440609317727) | ||||
| 139637 | 139637 | 11293 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 144616 | 144616 | 11301 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 28478 | 28478 | 176327 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 31 | Median : Cutout 11 | Tree 1 | DPW 2 | 46 | Width 0ft | 6009212.31958 | 2089948.46975 | 37.7191207387124 | -122.41016088932699 | (37.7191207387124, -122.410160889327) | |||
| 80713 | 80713 | 12013 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
| 81643 | 81643 | 11276 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 122499 | 122499 | 11277 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
| 127046 | 127046 | 11368 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 130335 | 130335 | 176324 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 43 | Width 0ft | 6009336.81226 | 2089985.3560799998 | 37.719228998190204 | -122.409733166348 | (37.7192289981902, -122.409733166348) | |||
| 101111 | 101111 | 106599 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 42 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 146098 | 146098 | 11297 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
| 23642 | 23642 | 176313 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 38 | Width 0ft | 6010259.13784 | 2090270.57035 | 37.7200637812891 | -122.40656510840799 | (37.7200637812891, -122.406565108408) | |||
| 41295 | 41295 | 187029 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 38 | Width 0ft | 5984947.4301 | 2097843.1311 | 37.7394074439231 | -122.49461576933999 | (37.7394074439231, -122.49461576934) | |||
| 165999 | 165999 | 199400 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 299 Cashmere St | 16 | : 4 | Tree 1 | Private 1 | 38 | 6016698.52819 | 2095954.85127 | 37.7360298565815 | -122.384701870897 | (37.7360298565815, -122.384701870897) | ||||
| 47306 | 47306 | 224452 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6003256.424219999 | 2095477.2065700002 | 37.7339657739995 | -122.43114253132099 | (37.7339657739995, -122.431142531321) | ||||
| 62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
| 8000 | 8000 | 19575 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY1 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 100ST | ||||||||
| 16222 | 16222 | 19870 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 25ST | ||||||||
| 19129 | 19129 | 12492 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
| 84752 | 84752 | 106462 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 108418 | 108418 | 110145 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 64 WOODLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3x15 | 5997139.6 | 2106104.1 | 37.76279607600021 | -122.45305700914801 | (37.7627960760002, -122.453057009148) | |||
| 174476 | 174476 | 176315 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | Width 0ft | 6010056.94301 | 2090202.23729 | 37.7198648386596 | -122.40725921596399 | (37.7198648386596, -122.407259215964) | |||
| 63643 | 63643 | 224453 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6003249.48151 | 2095473.62453 | 37.733955545103505 | -122.43116627879499 | (37.7339555451035, -122.431166278795) | ||||
| 152213 | 152213 | 176314 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 35 | Width 0ft | 6010185.666130001 | 2090251.18564 | 37.720006444117296 | -122.406817710885 | (37.7200064441173, -122.406817710885) | |||
| 118789 | 118789 | 106592 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 147460 | 147460 | 217803 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2x Sloat Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 34 | 5991018.47185 | 2095992.29774 | 37.734678993934494 | -122.473490022742 | (37.7346789939345, -122.473490022742) | ||||
| 91579 | 91579 | 109086 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
| 104967 | 104967 | 108502 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2300 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 5986128.8 | 2099536.7 | 37.7441266056665 | -122.49065574130199 | (37.7441266056665, -122.490655741302) | ||||
| 175024 | 175024 | 224211 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6005190.349119999 | 2097382.93272 | 37.739307871065996 | -122.424591870417 | (37.739307871066, -122.424591870417) | ||||
| 40506 | 40506 | 176323 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 0ft | 6009342.20287 | 2090002.90208 | 37.719277477945 | -122.40971577078399 | (37.719277477945, -122.409715770784) | |||
| 50131 | 50131 | 199404 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6016629.65755 | 2096008.94769 | 37.7361745853726 | -122.38494375437 | (37.7361745853726, -122.38494375437) | ||||
| 8891 | 8891 | 19873 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY33 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 25ST | ||||||||
| 71049 | 71049 | 224216 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005148.6559 | 2097255.3705700003 | 37.73895525948029 | -122.424726954897 | (37.7389552594803, -122.424726954897) | ||||
| 79746 | 79746 | 23414 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X VAN NESS AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006192.0 | 2116736.0 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | |||
| 80719 | 80719 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | DPW 4 | 30 | 10X10 | 5991377.0 | 2094742.0 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | ||
| 94436 | 94436 | 24061 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
| 104850 | 104850 | 24058 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
| 114463 | 114463 | 111293 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 6005565.0 | 2097823.0 | 37.7405373480538 | -122.42332776776699 | (37.7405373480538, -122.423327767767) | ||||
| 117581 | 117581 | 14900 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 170 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6016995.24275 | 2098361.00599 | 37.7426530781013 | -122.38384348369499 | (37.7426530781013, -122.383843483695) | |||
| 127605 | 127605 | 11204 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | |||
| 141942 | 141942 | 10770 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1120X Hudson Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X4 | 6017909.652863 | 2094654.0666341 | 37.73252506519629 | -122.380424102302 | (37.7325250651963, -122.380424102302) | |||
| 158093 | 158093 | 224205 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005328.89296 | 2097313.9887099997 | 37.7391263896815 | -122.424107945232 | (37.7391263896815, -122.424107945232) | ||||
| 169095 | 169095 | 199401 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 18 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6016684.16305 | 2095970.28806 | 37.7360714484387 | -122.38475261246799 | (37.7360714484387, -122.384752612468) | ||||
| 153553 | 153553 | 176310 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 29 | Width 0ft | 6010469.51848 | 2090335.25755 | 37.720253166839704 | -122.40584244467199 | (37.7202531668397, -122.405842444672) | |||
| 164248 | 164248 | 122943 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 300 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 5993109.61739 | 2113257.70524 | 37.7822061800557 | -122.467515420271 | (37.7822061800557, -122.467515420271) | |||
| 182619 | 182619 | 187037 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984959.5362 | 2097794.0341 | 37.7392733453171 | -122.49457029390899 | (37.7392733453171, -122.494570293909) | |||
| 77566 | 77566 | 106463 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 115347 | 115347 | 106464 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 152160 | 152160 | 51577 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 584 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/08/2005 12:00:00 AM | 28 | Permit Number 47871 | 5982583.51771 | 2111812.9357 | 37.7776259284617 | -122.50382336032 | (37.7776259284617, -122.50382336032) | |
| 158945 | 158945 | 176305 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 0ft | 6010925.6651800005 | 2090483.18833 | 37.7206848540134 | -122.404276094583 | (37.7206848540134, -122.404276094583) | |||
| 61013 | 61013 | 199410 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015932.24155 | 2096672.73443 | 37.7379586091972 | -122.387401320018 | (37.7379586091972, -122.387401320018) | |||
| 147712 | 147712 | 224218 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 60 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6007258.1885 | 2099113.30571 | 37.744175654874894 | -122.417564790989 | (37.7441756548749, -122.417564790989) | |||
| 161898 | 161898 | 199408 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 5 Cashmere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6017196.63462 | 2095827.84715 | 37.7357086637323 | -122.38297086303801 | (37.7357086637323, -122.382970863038) | |||
| 166853 | 166853 | 176331 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 36 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | Width 0ft | 6009160.31915 | 2089943.1989099998 | 37.7191033512163 | -122.410340263619 | (37.7191033512163, -122.410340263619) | |||
| 180472 | 180472 | 199409 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015943.979280001 | 2096692.6549900002 | 37.738013957089 | -122.387362125771 | (37.738013957089, -122.387362125771) | |||
| 101240 | 101240 | 106579 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 128785 | 128785 | 106466 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
| 141186 | 141186 | 61435 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 327 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/15/2003 12:00:00 AM | 26 | Permit Number 21367 | 5999764.1184147 | 2104644.81954389 | 37.7589393153031 | -122.44387490382499 | (37.7589393153031, -122.443874903825) | |
| 159148 | 159148 | 224215 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6005165.86979 | 2097298.42463 | 37.739074448424 | -122.424670499065 | (37.739074448424, -122.424670499065) | ||||
| 184281 | 184281 | 199402 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 20 | Median : Yard 3 | Tree 1 | DPW 2 | 26 | 6016663.61896 | 2095979.5906099998 | 37.736095855134394 | -122.384824290234 | (37.7360958551344, -122.384824290234) | ||||
| 26478 | 26478 | 63265 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1760 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/1987 12:00:00 AM | 25 | Permit Number 24158 | 6001156.49330664 | 2111800.30825294 | 37.7786658324282 | -122.439572390689 | (37.7786658324282, -122.439572390689) | |
| 34116 | 34116 | 224214 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6005180.62218 | 2097351.71746 | 37.73922161167361 | -122.424623281961 | (37.7392216116736, -122.424623281961) | ||||
| 55441 | 55441 | 199405 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016273.90453 | 2096214.7321400002 | 37.736719944173004 | -122.386188091409 | (37.736719944173, -122.386188091409) | ||||
| 106381 | 106381 | 99751 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 500x Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 1046 Diamond St | 6001860.7 | 2100931.8 | 37.748863621629894 | -122.436358217698 | (37.7488636216299, -122.436358217698) | ||
| 108041 | 108041 | 106585 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
| 117856 | 117856 | 75663 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 400 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1990 12:00:00 AM | 25 | 6003991.19971734 | 2108404.68072341 | 37.769503199887296 | -122.429523817606 | (37.7695031998873, -122.429523817606) | |||
| 125322 | 125322 | 106587 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) |
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");