Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2849 | 2849 | 253236 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2862 | 2862 | 253241 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2866 | 2866 | 253244 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2884 | 2884 | 253239 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2888 | 2888 | 253238 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2901 | 2901 | 253237 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 2902 | 2902 | 253245 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | ||||
| 3523 | 3523 | 253474 | Planning Code 138.1 required 4 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3541 | 3541 | 253472 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3548 | 3548 | 253473 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 134 Lunado Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991633.0 | 2092401.0 | 37.7248537561355 | -122.471103859098 | (37.7248537561355, -122.471103859098) | ||||
| 3637 | 3637 | 253235 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3647 | 3647 | 253240 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 101 Paloma Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3654 | 3654 | 253242 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 3679 | 3679 | 253243 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 299X Moncada Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | Permit Number 780627 | 5992091.0 | 2093757.0 | 37.728603476542396 | -122.469619290083 | (37.7286034765424, -122.469619290083) | |||
| 5090 | 5090 | 253789 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5101 | 5101 | 253790 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1651X 15th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991453.0 | 2104016.0 | 37.756735165128205 | -122.47257252055401 | (37.7567351651282, -122.472572520554) | ||||
| 5102 | 5102 | 253784 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1709X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x2 | 5991403.0 | 2103783.0 | 37.756092514171904 | -122.472728448949 | (37.7560925141719, -122.472728448949) | ||||
| 5129 | 5129 | 253815 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 144 Paloma Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991858.0 | 2093861.0 | 37.728875565325 | -122.470432347955 | (37.728875565325, -122.470432347955) | ||||
| 5158 | 5158 | 253816 | Undocumented 2 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 144 Paloma Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5991858.0 | 2093861.0 | 37.728875565325 | -122.470432347955 | (37.728875565325, -122.470432347955) | ||||
| 6789 | 6789 | 3104 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3066 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x2 | 5999678.80765 | 2115082.09673 | 37.7875925616812 | -122.44492023407899 | (37.7875925616812, -122.444920234079) | |||
| 6860 | 6860 | 93474 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1345 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008356.752640001 | 2116586.1732799998 | 37.792213826952704 | -122.41500266293501 | (37.7922138269527, -122.415002662935) | |||
| 7195 | 7195 | 3045 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2679 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x2 | 6001570.5744 | 2115283.6786 | 37.788253837365296 | -122.438389555625 | (37.7882538373653, -122.438389555625) | |||
| 7315 | 7315 | 93472 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1329 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x2 | 6008412.15519 | 2116591.32221 | 37.7922310777524 | -122.414811333085 | (37.7922310777524, -122.414811333085) | |||
| 8119 | 8119 | 93480 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1356- 1360 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/2014 12:00:00 AM | 12 | 3x2 | Permit Number 770976 | 6008293.467119999 | 2116608.96674 | 37.7922728557673 | -122.415223246858 | (37.7922728557673, -122.415223246858) | |
| 8623 | 8623 | 93473 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1345 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008345.85317 | 2116585.5339599997 | 37.792211459052794 | -122.415040330141 | (37.7922114590528, -122.415040330141) | |||
| 11855 | 11855 | 112294 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2606 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5989896.9401 | 2097604.9354 | 37.7390418709124 | -122.47748532406099 | (37.7390418709124, -122.477485324061) | |||
| 14141 | 14141 | 24957 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015942.08752 | 2100884.12488 | 37.749522766571395 | -122.387661019958 | (37.7495227665714, -122.387661019958) | ||
| 14239 | 14239 | 24955 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015938.87832 | 2100945.4369200002 | 37.7496909388885 | -122.387676394756 | (37.7496909388885, -122.387676394756) | ||
| 14665 | 14665 | 24958 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 3150 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015944.400780001 | 2100851.85574 | 37.7494342903725 | -122.387650769466 | (37.7494342903725, -122.387650769466) | ||
| 16360 | 16360 | 24956 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1995 12:00:00 AM | 8 | 3x2 | 6015941.492819999 | 2100915.86741 | 37.7496098920009 | -122.387665290844 | (37.7496098920009, -122.387665290844) | ||
| 17464 | 17464 | 10037 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 351 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x2 | 6005536.7714599995 | 2106975.8845599997 | 37.765667455319 | -122.424076117338 | (37.765667455319, -122.424076117338) | |||
| 18264 | 18264 | 10085 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 648 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1998 12:00:00 AM | 13 | 3x2 | 6005571.80442 | 2105186.7253099997 | 37.7607568250935 | -122.423827714701 | (37.7607568250935, -122.423827714701) | ||
| 19969 | 19969 | 10013 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 215 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x2 | 6005495.275 | 2107715.11687 | 37.7676948680391 | -122.42427222529899 | (37.7676948680391, -122.424272225299) | |||
| 22996 | 22996 | 4591 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x2 | 6011425.16703 | 2118064.77563 | 37.796445660597 | -122.40448996415199 | (37.796445660597, -122.404489964152) | |||
| 32967 | 32967 | 105663 | Undocumented 2 | Ginkgo biloba :: Maidenhair Tree 44 | 263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x2 | 5990541.506469999 | 2113621.53342 | 37.783056548593 | -122.476426424914 | (37.783056548593, -122.476426424914) | |||
| 38343 | 38343 | 122390 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x2 | 5991007.0 | 2102078.0 | 37.7513881006776 | -122.47397354599501 | (37.7513881006776, -122.473973545995) | |||
| 41062 | 41062 | 55568 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 1132 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/1972 12:00:00 AM | 13 | 3x2 | Permit Number 11537 | 6011293.45596 | 2089493.71978 | 37.7179885201224 | -122.40293519190901 | (37.7179885201224, -122.402935191909) | |
| 57947 | 57947 | 93475 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1354 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008310.152840001 | 2116609.77027 | 37.7922759997842 | -122.415165570649 | (37.7922759997842, -122.415165570649) | |||
| 81747 | 81747 | 122384 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Melrose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5999501.0 | 2095545.0 | 37.7339383930574 | -122.444131009745 | (37.7339383930574, -122.444131009745) | ||||
| 81953 | 81953 | 24954 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1995 12:00:00 AM | 5 | 3x2 | 6015932.0505800005 | 2100862.75397 | 37.7494635305395 | -122.38769423744199 | (37.7494635305395, -122.387694237442) | ||
| 82751 | 82751 | 34551 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3662 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/1997 12:00:00 AM | 9 | 3x2 | Permit Number 778622 | 6008447.76168785 | 2097836.53869706 | 37.7407367985354 | -122.413361219105 | (37.7407367985354, -122.413361219105) |
| 85051 | 85051 | 107853 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 150 APTOS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | ||||
| 87048 | 87048 | 111727 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 158 MAYWOOD DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5994266.0 | 2095568.0 | 37.733701506188396 | -122.462231535938 | (37.7337015061884, -122.462231535938) | ||||
| 89155 | 89155 | 113309 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 COLONIAL WAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6000472.0 | 2093592.0 | 37.728631254327105 | -122.440633939625 | (37.7286312543271, -122.440633939625) | ||||
| 89416 | 89416 | 101620 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 32 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x2 | 6004057.0 | 2108606.0 | 37.7700596990804 | -122.429310574863 | (37.7700596990804, -122.429310574863) | |||
| 94418 | 94418 | 112623 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 228 HESTER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6012539.0 | 2087662.0 | 37.7130284556779 | -122.398501400627 | (37.7130284556779, -122.398501400627) | ||||
| 96218 | 96218 | 122383 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x2 | 5999501.0 | 2095545.0 | 37.7339383930574 | -122.444131009745 | (37.7339383930574, -122.444131009745) | |||
| 97150 | 97150 | 24953 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/20/1995 12:00:00 AM | 5 | 3x2 | 6015932.0505800005 | 2100862.75397 | 37.7494635305395 | -122.38769423744199 | (37.7494635305395, -122.387694237442) | ||
| 104233 | 104233 | 106802 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1850 BRYANT ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 30 | 3x2 | 6009455.7 | 2106195.7 | 37.763745730245795 | -122.41046624869301 | (37.7637457302458, -122.410466248693) | |||
| 107276 | 107276 | 113147 | Undocumented 2 | Tree(s) :: 17 | 400X KENWOOD WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2015 12:00:00 AM | 3x2 | Permit Number 776488 | 5993487.0 | 2093680.0 | 37.728472638436706 | -122.46478768754801 | (37.7284726384367, -122.464787687548) | ||
| 107322 | 107322 | 104048 | Undocumented 2 | Tree(s) :: 17 | 2679 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x2 | 5991726.5 | 2097212.7 | 37.7380708864129 | -122.471131034042 | (37.7380708864129, -122.471131034042) | |||
| 116317 | 116317 | 114483 | Undocumented 2 | Geijera parviflora :: Australian Willow 68 | 784 CLEMENTINA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x2 | 6009096.0 | 2110140.0 | 37.7745556909018 | -122.41198909995701 | (37.7745556909018, -122.411989099957) | |||
| 124460 | 124460 | 113307 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 COLONIAL WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6000472.0 | 2093592.0 | 37.728631254327105 | -122.440633939625 | (37.7286312543271, -122.440633939625) | ||||
| 140949 | 140949 | 107852 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 150 APTOS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | ||||
| 141634 | 141634 | 112877 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 300x FRANCONIA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x2 | 6010100.0 | 2099291.0 | 37.744823060949294 | -122.407750909418 | (37.7448230609493, -122.407750909418) | |||
| 142166 | 142166 | 118329 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 3662 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6008447.76168785 | 2097836.53869706 | 37.7407367985354 | -122.413361219105 | (37.7407367985354, -122.413361219105) | ||||
| 143312 | 143312 | 113308 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 COLONIAL WAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 6000472.0 | 2093592.0 | 37.728631254327105 | -122.440633939625 | (37.7286312543271, -122.440633939625) | ||||
| 143491 | 143491 | 24960 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3150 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1995 12:00:00 AM | 3 | 3x2 | 6015932.0505800005 | 2100862.75397 | 37.7494635305395 | -122.38769423744199 | (37.7494635305395, -122.387694237442) | ||
| 151427 | 151427 | 101362 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2040 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x2 | 6003351.20709 | 2115826.8016 | 37.7898462357712 | -122.432267671327 | (37.7898462357712, -122.432267671327) | |||
| 154657 | 154657 | 94865 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 30 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2010 12:00:00 AM | 2 | 3x2 | Permit Number 53936 | 6006380.989130001 | 2094288.72029 | 37.7308790183509 | -122.42025560931002 | (37.7308790183509, -122.42025560931) | |
| 169272 | 169272 | 112624 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 238 Hester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x2 | 6012530.7402099995 | 2087662.8306099998 | 37.713030276211796 | -122.39853000764799 | (37.7130302762118, -122.398530007648) |
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");