Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
37 | 37 | 226924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Newburg St | 1 | Sidewalk: Property side : Pot 6 | Tree 1 | Private 1 | 11 | Width 4ft | 6002558.65829 | 2099967.6575700003 | 37.7462559468486 | -122.433875776072 | (37.7462559468486, -122.433875776072) | |||
80 | 80 | 225032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 4425 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2004 12:00:00 AM | 11 | Width 3ft | Permit Number 47310 | 6001257.01437 | 2105216.66208 | 37.7605944983664 | -122.43875275812799 | (37.7605944983664, -122.438752758128) | |
108 | 108 | 192593 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1399X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008031.0 | 2110483.0 | 37.775437677991796 | -122.41569744526699 | (37.7754376779918, -122.415697445267) | |||
168 | 168 | 179480 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 5989599.0 | 2090767.0 | 37.7202493457345 | -122.478015677124 | (37.7202493457345, -122.478015677124) | ||||
202 | 202 | 138810 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 2355 PINE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002718.089 | 2115091.954 | 37.787792613821004 | -122.434405637805 | (37.787792613821, -122.434405637805) | |||
207 | 207 | 138805 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | |||
333 | 333 | 242579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 818 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2016 12:00:00 AM | 11 | Width 3ft | Permit Number 778239 | 6001257.943419999 | 2101462.97247 | 37.7502878270446 | -122.438480597209 | (37.7502878270446, -122.438480597209) | |
334 | 334 | 246360 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1932 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6006755.8259 | 2107130.7038 | 37.76616130474321 | -122.419870652653 | (37.7661613047432, -122.419870652653) | |||
442 | 442 | 9602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003083.4108 | 2112017.0963 | 37.779370559175206 | -122.432921935155 | (37.7793705591752, -122.432921935155) | |||
453 | 453 | 200966 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1438 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | Permit Number 779897 | 6007276.3996 | 2110716.1923 | 37.776035520315205 | -122.418324330264 | (37.7760355203152, -122.418324330264) | ||
458 | 458 | 221750 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 275 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 11 | Width 4ft | 5997409.41415 | 2106414.31665 | 37.7636633116224 | -122.45214620578699 | (37.7636633116224, -122.452146205787) | |||
560 | 560 | 131782 | Undocumented 2 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2646 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779549 | 6000337.27442 | 2118211.39807 | 37.7962223607332 | -122.442866875924 | (37.7962223607332, -122.442866875924) | ||
732 | 732 | 25708 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 586 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6012145.80041 | 2110254.86265 | 37.77504171494321 | -122.40144725460199 | (37.7750417149432, -122.401447254602) | |||
872 | 872 | 5299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001101.8528 | 2114070.3216 | 37.7848955998057 | -122.43992421757 | (37.7848955998057, -122.43992421757) | |||
916 | 916 | 224714 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 3 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 11 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
965 | 965 | 130085 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 600 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6006282.409 | 2112253.58537 | 37.7802008260541 | -122.421872043567 | (37.7802008260541, -122.421872043567) | |||
977 | 977 | 242613 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 48 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 777782 | 6007306.44134 | 2099195.30791 | 37.744403529591395 | -122.417403753004 | (37.7444035295914, -122.417403753004) | ||
1089 | 1089 | 9603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003102.1679 | 2112019.7759 | 37.7793789805584 | -122.43285723801 | (37.7793789805584, -122.43285723801) | |||
1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
1307 | 1307 | 212207 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 11 | 6001467.5944 | 2095628.72955 | 37.7342802902926 | -122.43733789885 | (37.7342802902926, -122.43733789885) | ||||
1344 | 1344 | 141858 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1110 TURK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004615.4703 | 2112626.4811 | 37.781130557433706 | -122.427665325896 | (37.7811305574337, -122.427665325896) | |||
1400 | 1400 | 235284 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 4235 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 11 | Width 3ft | 6001885.77275 | 2104671.54401 | 37.7591334867264 | -122.43653915428499 | (37.7591334867264, -122.436539154285) | ||
1454 | 1454 | 234074 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1400 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 11 | Width 3ft | 6011143.5049 | 2101689.8522900003 | 37.751468148541996 | -122.40431145682301 | (37.751468148542, -122.404311456823) | |||
1518 | 1518 | 243948 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 11 | Width 5ft | Permit Number 47529 | 6006987.09759 | 2110205.04369 | 37.774615739356705 | -122.41928883630399 | (37.7746157393567, -122.419288836304) | |
1575 | 1575 | 246375 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2248 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6003217.3444 | 2106843.7794 | 37.765173499092995 | -122.43208906900499 | (37.765173499093, -122.432089069005) | |||
1684 | 1684 | 236727 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1616 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779934 | 6002562.04117 | 2100731.79845 | 37.7483542900352 | -122.43391868899201 | (37.7483542900352, -122.433918688992) | ||
1844 | 1844 | 240844 | Permitted Site 1 | Styphnolobium japonicum :: Chinese scholar tree 156 | 2512 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/1992 12:00:00 AM | 11 | Width 4ft | Permit Number 30823 | 6011341.20529 | 2101862.92497 | 37.7519544137647 | -122.403639957344 | (37.7519544137647, -122.403639957344) | |
1886 | 1886 | 231239 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2000 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | Permit Number 779645 | 6009523.6668300005 | 2105264.06886 | 37.7611914935157 | -122.410165393114 | (37.7611914935157, -122.410165393114) | ||
1952 | 1952 | 139587 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | |||
2046 | 2046 | 131756 | Undocumented 2 | Tree(s) :: 17 | 1818 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004733.3748 | 2117781.6991 | 37.795292161346104 | -122.427624834041 | (37.7952921613461, -122.427624834041) | |||
2062 | 2062 | 8436 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1730 Geary Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/1997 12:00:00 AM | 11 | 3X3 | 6003412.8094 | 2113950.8814 | 37.784698926436796 | -122.431920527552 | (37.7846989264368, -122.431920527552) | ||
2188 | 2188 | 124801 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2898 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | Permit Number 780062 | 5999229.08983 | 2118053.40815 | 37.7957253216105 | -122.446690033314 | (37.7957253216105, -122.446690033314) | ||
2202 | 2202 | 139878 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 870 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6005025.9501 | 2111995.4887 | 37.779421217898204 | -122.426200333481 | (37.7794212178982, -122.426200333481) | |||
2259 | 2259 | 191494 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 4ft | 6016613.84098 | 2094824.1997599998 | 37.7329206295756 | -122.384915925743 | (37.7329206295756, -122.384915925743) | |||
2311 | 2311 | 193166 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 282 02nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | Permit Number 778941 | 6013536.23807 | 2114063.46383 | 37.7855767457266 | -122.396904475854 | (37.7855767457266, -122.396904475854) | ||
2331 | 2331 | 122431 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 598X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x4 | Permit Number 778941 | 6013729.7725 | 2114223.4236 | 37.786026729010295 | -122.396246113338 | (37.7860267290103, -122.396246113338) | ||
2341 | 2341 | 138904 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 743 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6004092.4052 | 2110770.0131 | 37.7760035542999 | -122.429342446805 | (37.7760035542999, -122.429342446805) | |||
2352 | 2352 | 195026 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6013748.5801800005 | 2113848.78027 | 37.7849990913834 | -122.39615477762301 | (37.7849990913834, -122.396154777623) | |||
2568 | 2568 | 227812 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 79 Piedmont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x15 | 5999345.2069 | 2106945.6167 | 37.765232827359 | -122.44548913263701 | (37.765232827359, -122.445489132637) | |||
2576 | 2576 | 247475 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 330 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1998 12:00:00 AM | 11 | Width 0ft | Permit Number 38697 | 6002266.1755 | 2109683.5253 | 37.7729167694499 | -122.435582100921 | (37.7729167694499, -122.435582100921) | |
2577 | 2577 | 42596 | Permitted Site 1 | Melaleuca ericifolia :: Heath Melaleuca 184 | 1950 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42667 | 6005477.78345 | 2116550.81967 | 37.791954555107296 | -122.424961440544 | (37.7919545551073, -122.424961440544) | |
2636 | 2636 | 239448 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 224 Miguel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1997 12:00:00 AM | 11 | Width 4ft | Permit Number 38139 | 6004193.01737 | 2096717.47365 | 37.7374242967807 | -122.427992792539 | (37.7374242967807, -122.427992792539) | |
2653 | 2653 | 116000 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1454 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6008456.02855 | 2117561.49656 | 37.7948974030383 | -122.41472821952499 | (37.7948974030383, -122.414728219525) | |||
2801 | 2801 | 142460 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 536 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6004827.4421 | 2110579.0189 | 37.775520717053205 | -122.426786154864 | (37.7755207170532, -122.426786154864) | |||
2822 | 2822 | 229979 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 536 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1982 12:00:00 AM | 11 | Width 3ft | Permit Number 19659 | 6003305.39384 | 2095901.6279 | 37.7351339132885 | -122.431003509611 | (37.7351339132885, -122.431003509611) | |
2936 | 2936 | 246076 | Permitted Site 1 | Tristania conferta :: 79 | 1215 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/1979 12:00:00 AM | 11 | Width 0ft | Permit Number 17670 | 5999867.5576 | 2108450.6663 | 37.769395122673394 | -122.443790589358 | (37.7693951226734, -122.443790589358) | |
2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
2994 | 2994 | 142170 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1477 GROVE ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000804.7229 | 2110664.0211 | 37.7755258488103 | -122.440707770392 | (37.7755258488103, -122.440707770392) | |||
3059 | 3059 | 126695 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2829 Divisadero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 10x10 | Permit Number 779774 | 6000551.43021 | 2118023.61416 | 37.7957189625051 | -122.44211236900601 | (37.7957189625051, -122.442112369006) | ||
3060 | 3060 | 203634 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 432 Flood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 11 | Width 2ft | Permit Number 42544 | 5997859.0322900005 | 2094116.10367 | 37.7299211747225 | -122.449704832412 | (37.7299211747225, -122.449704832412) | |
3069 | 3069 | 128380 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Waverly Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6010746.0 | 2116993.0 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | |||
3833 | 3833 | 246108 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1899 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997166.7764 | 2108416.598 | 37.769147161957605 | -122.453129960901 | (37.7691471619576, -122.453129960901) | |||
3852 | 3852 | 244053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997903.1431 | 2109164.16 | 37.7712419510675 | -122.450636826227 | (37.7712419510675, -122.450636826227) | |||
3893 | 3893 | 227810 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 974 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/1979 12:00:00 AM | 11 | Width 3ft | Permit Number 18080 | 5999262.93769 | 2106710.24786 | 37.7645818665711 | -122.44575675288401 | (37.7645818665711, -122.445756752884) | |
3894 | 3894 | 52352 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1078 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | 11 | 3x3 | Permit Number 48492 | 6009562.81073 | 2117112.1754400004 | 37.793725799570396 | -122.41086683016701 | (37.7937257995704, -122.410866830167) |
4175 | 4175 | 244050 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Cole St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997945.2406 | 2109187.6851 | 37.771308954489 | -122.45049290616699 | (37.771308954489, -122.450492906167) | |||
4233 | 4233 | 244049 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 400 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997947.3042 | 2109165.8109 | 37.7712490116574 | -122.450484190924 | (37.7712490116574, -122.450484190924) | |||
4239 | 4239 | 244052 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 401 Cole St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997900.6668 | 2109181.4943 | 37.771289404865 | -122.450646641766 | (37.771289404865, -122.450646641766) | |||
4521 | 4521 | 225798 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008119.80842 | 2103888.79141 | 37.757336508198705 | -122.414923414683 | (37.7573365081987, -122.414923414683) | |||
4593 | 4593 | 129647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009820.66032 | 2121686.06094 | 37.80629901694589 | -122.41029773825899 | (37.8062990169459, -122.410297738259) | |||
4696 | 4696 | 236340 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 60 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1993 12:00:00 AM | 11 | Width 3ft | Permit Number 31569 | 6005504.459869999 | 2099359.7250599996 | 37.7447534297269 | -122.423646325024 | (37.7447534297269, -122.423646325024) | |
4717 | 4717 | 240016 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 6 Ford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x6 | 6003449.63845 | 2105676.77669 | 37.7619823582336 | -122.431202314632 | (37.7619823582336, -122.431202314632) | |||
4882 | 4882 | 206247 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 502 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5994193.69759 | 2106695.40852 | 37.7642503845792 | -122.463288680925 | (37.7642503845792, -122.463288680925) | |||
5334 | 5334 | 17712 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1214 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6002329.348999999 | 2112708.9615 | 37.7812274480895 | -122.435580057373 | (37.7812274480895, -122.435580057373) | |||
5345 | 5345 | 2950 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2000 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004708.4584 | 2115781.93381 | 37.7897999027004 | -122.427568507708 | (37.7897999027004, -122.427568507708) | |||
6473 | 6473 | 4379 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2425X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6007005.3355 | 2120662.9996700003 | 37.803331735330204 | -122.419968034 | (37.8033317353302, -122.419968034) | |||
6558 | 6558 | 2682 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2094 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/11/1995 12:00:00 AM | 11 | 3X3 | 6003513.5745 | 2114908.5919 | 37.787334269689495 | -122.431640312975 | (37.7873342696895, -122.431640312975) | ||
6625 | 6625 | 9932 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2336 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005031.67767 | 2117702.0644 | 37.795090373265296 | -122.42658698402501 | (37.7950903732653, -122.426586984025) | |||
6650 | 6650 | 23522 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2775 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6005635.08955 | 2119853.97072 | 37.801033055589706 | -122.42465223832701 | (37.8010330555897, -122.424652238327) | |||
7048 | 7048 | 18853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2222 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004009.33777 | 2116018.08762 | 37.7904087527096 | -122.430004251319 | (37.7904087527096, -122.430004251319) | |||
7126 | 7126 | 18854 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003994.67741 | 2116017.3776 | 37.790405972895705 | -122.430054924512 | (37.7904059728957, -122.430054924512) | |||
7151 | 7151 | 9599 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1355 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/1990 12:00:00 AM | 11 | 3X3 | 6003022.227000001 | 2112007.7178 | 37.7793413376686 | -122.43313292513201 | (37.7793413376686, -122.433132925132) | ||
7282 | 7282 | 9902 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 1800 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005282.34014 | 2115923.27251 | 37.7902204265742 | -122.425592993016 | (37.7902204265742, -122.425592993016) | |||
8057 | 8057 | 18494 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 45 Powell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4X4 | 6010359.58232 | 2113994.15068 | 37.785209095679 | -122.407889941061 | (37.785209095679, -122.407889941061) | |||
8317 | 8317 | 106949 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Broadway | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 4x4 | 6002070.184169999 | 2117343.17856 | 37.7939370979581 | -122.43680848054599 | (37.7939370979581, -122.436808480546) | |||
8441 | 8441 | 2879 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1474 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6007275.200180001 | 2116137.7979099997 | 37.7909218635931 | -122.418713050772 | (37.7909218635931, -122.418713050772) | |||
8459 | 8459 | 13033 | DPW Maintained 3 | Lagerstroemia indica :: Crape Myrtle 199 | 468 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6010099.3086 | 2120611.2701 | 37.803363523958296 | -122.40925752960301 | (37.8033635239583, -122.409257529603) | |||
8542 | 8542 | 2850 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1299 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6008196.1347 | 2116200.81096 | 37.7911466896244 | -122.41553110997 | (37.7911466896244, -122.41553110997) | |||
8641 | 8641 | 3138 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3310 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 5998499.66954 | 2114915.23875 | 37.7870670482462 | -122.44898777689 | (37.7870670482462, -122.44898777689) | |||
8766 | 8766 | 6075 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1945 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 4X4 | 6001069.4283 | 2112430.3485 | 37.780390807207496 | -122.439918767679 | (37.7803908072075, -122.439918767679) | |||
9031 | 9031 | 3063 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2815 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 3X3 | 6000837.7887 | 2115174.1519 | 37.7879113976115 | -122.44091700521003 | (37.7879113976115, -122.44091700521) | |||
9071 | 9071 | 2637 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1902 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004310.9716 | 2115017.5275 | 37.7876785449104 | -122.428889255161 | (37.7876785449104, -122.428889255161) | |||
9093 | 9093 | 12590 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 521 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 11 | 4x4 | 5993790.57771 | 2114837.48993 | 37.786583130222 | -122.465274409298 | (37.786583130222, -122.465274409298) | ||
9159 | 9159 | 19367 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 445X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 6x10 | 5994012.35224 | 2114842.43406 | 37.7866094923379 | -122.464507488788 | (37.7866094923379, -122.464507488788) | |||
9326 | 9326 | 26258 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1530 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6005847.527000001 | 2100032.50262 | 37.746620083181796 | -122.42250785943199 | (37.7466200831818, -122.422507859432) | |||
10747 | 10747 | 25359 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 940 Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6000403.81279 | 2089008.5844700001 | 37.7160423566536 | -122.440541061816 | (37.7160423566536, -122.440541061816) | |||
10756 | 10756 | 110237 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Winston Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | 6x18 | 5989487.1744800005 | 2093569.3277200002 | 37.7279373404144 | -122.47860704469 | (37.7279373404144, -122.47860704469) | |||
11149 | 11149 | 61515 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 84 De Long St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 21471 | 5994704.395 | 2086819.71376 | 37.7097060419596 | -122.46008232624901 | (37.7097060419596, -122.460082326249) |
11529 | 11529 | 27065 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 801 Silver Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | 4 | 6007029.903419999 | 2093602.64409 | 37.7290317461035 | -122.417963584568 | (37.7290317461035, -122.417963584568) | |||
11699 | 11699 | 116226 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1555 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5985576.2948 | 2104625.5047 | 37.758066784446896 | -122.49294092097999 | (37.7580667844469, -122.49294092098) | |||
11865 | 11865 | 939 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | |||
11898 | 11898 | 96740 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1090 Quintara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x5 | 5990158.2855 | 2101115.2789 | 37.7486955239894 | -122.47683813481702 | (37.7486955239894, -122.476838134817) | |||
12221 | 12221 | 1017 | Permitted Site 1 | Ulmus americana :: American Elm 119 | 1863 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001211.31639 | 2091358.64779 | 37.7225410511223 | -122.437918182794 | (37.7225410511223, -122.437918182794) | |||
12299 | 12299 | 15779 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4830 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6001211.7244 | 2090718.9229 | 37.720784534287404 | -122.437870974677 | (37.7207845342874, -122.437870974677) | |||
12975 | 12975 | 65624 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 234 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/07/1990 12:00:00 AM | 11 | 3x4 | Permit Number 28532 | 6004932.148580001 | 2094045.1422299999 | 37.7301284612426 | -122.425247165046 | (37.7301284612426, -122.425247165046) |
13121 | 13121 | 96741 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1090 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 4x6 | 5990138.4947 | 2101114.1148 | 37.7486911796305 | -122.476906485462 | (37.7486911796305, -122.476906485462) | |||
13596 | 13596 | 39526 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 11 | 3x3 | Permit Number 41411 | 6012822.50354 | 2106773.24892 | 37.7655197209944 | -122.39886197172 | (37.7655197209944, -122.39886197172) |
14423 | 14423 | 103148 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 255 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/28/2013 12:00:00 AM | 11 | 3x3 | Permit Number 770156 | 6009048.0907 | 2110053.72052 | 37.7743160996399 | -122.412148729189 | (37.7743160996399, -122.412148729189) | |
14517 | 14517 | 39534 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 88 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/1999 12:00:00 AM | 11 | 3x3 | Permit Number 41411 | 6012823.46447 | 2106790.35067 | 37.765566732135504 | -122.39885984841801 | (37.7655667321355, -122.398859848418) |
15412 | 15412 | 117198 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 78 Ringold St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2.5x2.5 | 6009460.131469999 | 2109802.88553 | 37.773650476322295 | -122.410705680637 | (37.7736504763223, -122.410705680637) |
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");