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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49339 | 49339 | 250483 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 475 Seacliff Ave | 6 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 5986409.292859999 | 2115158.05614 | 37.787034880407205 | -122.490835095073 | (37.7870348804072, -122.490835095073) | |||
178080 | 178080 | 250752 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2901 Lake St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5986424.93008 | 2114442.0046599996 | 37.785069723239104 | -122.490728288873 | (37.7850697232391, -122.490728288873) | |||
75678 | 75678 | 250753 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2901 Lake St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5986440.50803 | 2114442.51108 | 37.7850720236993 | -122.490674432088 | (37.7850720236993, -122.490674432088) | |||
184971 | 184971 | 250754 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2901 Lake St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5986452.66826 | 2114440.57637 | 37.7850674218586 | -122.490632219704 | (37.7850674218586, -122.490632219704) | |||
69228 | 69228 | 250657 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 6 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986677.325759999 | 2115081.37781 | 37.786839998225496 | -122.48990213208201 | (37.7868399982255, -122.489902132082) | |||
169511 | 169511 | 250656 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986684.519119999 | 2115099.84858 | 37.7868911336549 | -122.48987860404199 | (37.7868911336549, -122.489878604042) | |||
36894 | 36894 | 250655 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986693.41224 | 2115118.28322 | 37.7869422691247 | -122.48984919260799 | (37.7869422691247, -122.489849192608) | |||
29642 | 29642 | 250654 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986699.80995 | 2115139.3106400003 | 37.787000377908704 | -122.489828605331 | (37.7870003779087, -122.489828605331) | |||
34481 | 34481 | 250653 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986703.58682 | 2115157.00739 | 37.787049188603504 | -122.489816840378 | (37.7870491886035, -122.489816840378) | |||
186570 | 186570 | 250652 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 600 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986706.54079 | 2115175.99151 | 37.7871014859956 | -122.489808017137 | (37.7871014859956, -122.489808017137) | |||
149538 | 149538 | 250501 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 540 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986824.08944 | 2115367.06151 | 37.7876329718436 | -122.489415384816 | (37.7876329718436, -122.489415384816) | |||
166863 | 166863 | 250463 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 285 Seacliff Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 5986841.007119999 | 2115627.98923 | 37.788350391596104 | -122.489376046686 | (37.7883503915961, -122.489376046686) | |||
44728 | 44728 | 250461 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 285 Seacliff Ave | 2 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 5986857.40047 | 2115685.46606 | 37.7885091633186 | -122.489323556844 | (37.7885091633186, -122.489323556844) | |||
176918 | 176918 | 250500 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 540 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5986857.46811 | 2115377.35874 | 37.7876631935443 | -122.48930066009899 | (37.7876631935443, -122.489300660099) | |||
152632 | 152632 | 179421 | Undocumented 2 | Salix spp :: Willow 218 | 700 John Muir Dr | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5986275.223040001 | 2087885.25154 | 37.7121433180403 | -122.489292946617 | (37.7121433180403, -122.489292946617) | |||
1334 | 1334 | 250499 | Undocumented 2 | Tree(s) :: 17 | 540 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 05/10/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779924 | 5986884.24135 | 2115388.89729 | 37.7876964378791 | -122.489208879795 | (37.7876964378791, -122.489208879795) | |
136624 | 136624 | 250498 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 540 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5986910.921019999 | 2115396.03511 | 37.7877175935458 | -122.489117099479 | (37.7877175935458, -122.489117099479) | |||
47916 | 47916 | 250455 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200 Seacliff Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5987146.00356 | 2115751.2233 | 37.7887065564079 | -122.48832988241101 | (37.7887065564079, -122.488329882411) | |||
183102 | 183102 | 250454 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 200 Seacliff Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5987161.73503 | 2115752.9728099997 | 37.788712277894504 | -122.488275583153 | (37.7887122778945, -122.488275583153) | |||
137822 | 137822 | 103130 | Section 143 8 | Magnolia grandiflora :: Southern Magnolia 21 | 418 28th Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | 5987189.392469999 | 2113118.1924900003 | 37.781479539688505 | -122.487986220863 | (37.7814795396885, -122.487986220863) | ||||
176534 | 176534 | 250646 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2610 Lake St | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987286.31285 | 2114656.0296099996 | 37.7857076546263 | -122.487763944473 | (37.7857076546263, -122.487763944473) | |||
135875 | 135875 | 250645 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 6 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987300.52243 | 2114656.77456 | 37.78571052885479 | -122.48771483877199 | (37.7857105288548, -122.487714838772) | |||
39473 | 39473 | 250644 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2610 Lake St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987312.1046400005 | 2114657.5756599996 | 37.785713403992 | -122.487674827026 | (37.785713403992, -122.487674827026) | |||
131303 | 131303 | 250643 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2610 Lake St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5987323.664609999 | 2114657.3301 | 37.7857134039901 | -122.48763481530001 | (37.7857134039901, -122.4876348153) | |||
50030 | 50030 | 250642 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2610 Lake St | 3 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987348.361190001 | 2114656.80551 | 37.7857134039994 | -122.487549334736 | (37.7857134039994, -122.487549334736) | |||
43525 | 43525 | 250638 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2609 Lake St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987350.36914 | 2114602.8431 | 37.7855653557873 | -122.487538422371 | (37.7855653557873, -122.487538422371) | |||
50466 | 50466 | 250641 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2610 Lake St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987362.06762 | 2114658.60831 | 37.7857191533476 | -122.48750204749201 | (37.7857191533476, -122.487502047492) | |||
36828 | 36828 | 250336 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 107 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5987380.06723 | 2115230.15893 | 37.787289517132294 | -122.48748177497 | (37.7872895171323, -122.48748177497) | |||
29586 | 29586 | 250335 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 123 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5987383.88616 | 2115115.01872 | 37.7869735978985 | -122.487460101328 | (37.7869735978985, -122.487460101328) | |||
126319 | 126319 | 250334 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 123 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5987384.94959 | 2115132.32414 | 37.787021175632 | -122.48745769383801 | (37.787021175632, -122.487457693838) | |||
133284 | 133284 | 250640 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 2610 Lake St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987377.820230001 | 2114657.75032 | 37.785717716240896 | -122.487447485608 | (37.7857177162409, -122.487447485608) | |||
172011 | 172011 | 250333 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5987387.37303 | 2115049.79038 | 37.786794702950395 | -122.487443244435 | (37.7867947029504, -122.487443244435) | |||
130969 | 130969 | 250332 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 141 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987387.77846 | 2115003.34197 | 37.786667192588894 | -122.487438428541 | (37.7866671925889, -122.487438428541) | |||
165524 | 165524 | 250331 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 149 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5987389.174 | 2114970.7351900004 | 37.7865777451115 | -122.487431204304 | (37.7865777451115, -122.487431204304) | |||
172395 | 172395 | 250329 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 155 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5987389.94758 | 2114941.60729 | 37.786497813367205 | -122.487426387523 | (37.7864978133672, -122.487426387523) | |||
133832 | 133832 | 250330 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 155 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987390.3046699995 | 2114925.65751 | 37.7864540406708 | -122.48742398005501 | (37.7864540406708, -122.487423980055) | |||
155050 | 155050 | 250327 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5987392.49904 | 2114897.88557 | 37.7863779148594 | -122.487414347421 | (37.7863779148594, -122.487414347421) | |||
24574 | 24574 | 250326 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 161 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5987393.53331 | 2114913.8058 | 37.786421687562104 | -122.487411939018 | (37.7864216875621, -122.487411939018) | |||
27074 | 27074 | 250328 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 161 27th Ave | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987394.32135 | 2114885.37066 | 37.7863436587784 | -122.487407123146 | (37.7863436587784, -122.487407123146) | |||
48672 | 48672 | 250325 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 165 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5987394.93306 | 2114848.62147 | 37.7862427917124 | -122.487402306398 | (37.7862427917124, -122.487402306398) | |||
67422 | 67422 | 250323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.03432 | 2114802.15795 | 37.7861152804279 | -122.48739508214399 | (37.7861152804279, -122.487395082144) | |||
70401 | 70401 | 250324 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 179 27th Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987396.8518 | 2114775.1083299997 | 37.7860410575969 | -122.487390266267 | (37.7860410575969, -122.487390266267) | |||
132215 | 132215 | 250322 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 211 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 5987406.48872 | 2114540.6222 | 37.785397787832 | -122.487339695585 | (37.785397787832, -122.487339695585) | |||
29127 | 29127 | 250321 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 247 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5987414.73446 | 2114306.1636799998 | 37.7847545126541 | -122.487293940769 | (37.7847545126541, -122.487293940769) | |||
137903 | 137903 | 250320 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 255 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5987417.56987 | 2114243.0271099997 | 37.78458132302389 | -122.487279492276 | (37.7845813230239, -122.487279492276) | |||
68344 | 68344 | 250494 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 346 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5987480.35945 | 2115339.08253 | 37.7875944385888 | -122.487142792619 | (37.7875944385888, -122.487142792619) | |||
178352 | 178352 | 250493 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 346 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987501.66991 | 2115342.63083 | 37.787605423791106 | -122.48706932428499 | (37.7876054237911, -122.487069324285) | |||
66695 | 66695 | 250492 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 334 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987535.4917 | 2115340.76951 | 37.7876022851576 | -122.486952172315 | (37.7876022851576, -122.486952172315) | |||
177412 | 177412 | 250491 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 334 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5987543.5108900005 | 2115340.02768 | 37.7876007158561 | -122.48692437335698 | (37.7876007158561, -122.486924373357) | |||
151235 | 151235 | 250527 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 78 26th Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 5987724.29526 | 2115473.41293 | 37.787977492217294 | -122.48630869928002 | (37.7879774922173, -122.48630869928) | |||
27095 | 27095 | 250526 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 2 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 5987725.00409 | 2115456.85695 | 37.787932075559794 | -122.48630503096001 | (37.7879320755598, -122.48630503096) | |||
29466 | 29466 | 250525 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 80 26th Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 4ft | 5987725.71266 | 2115440.30097 | 37.7878866588866 | -122.486301363544 | (37.7878866588866, -122.486301363544) | |||
158544 | 158544 | 250490 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 246 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5987788.79254 | 2115350.25129 | 37.787643084702 | -122.486076508742 | (37.787643084702, -122.486076508742) | |||
36945 | 36945 | 250489 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 240 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5987807.77183 | 2115352.13466 | 37.7876493619664 | -122.48601098323499 | (37.7876493619664, -122.486010983235) | |||
48038 | 48038 | 176133 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5987205.94604 | 2086467.2590400001 | 37.708304151783295 | -122.48597211903099 | (37.7083041517833, -122.485972119031) | |||
62380 | 62380 | 176134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5987222.73644 | 2086464.9299599999 | 37.7082987351809 | -122.48591391940901 | (37.7082987351809, -122.485913919409) | |||
62089 | 62089 | 250488 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 236 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987839.39614 | 2115354.89245 | 37.787658776979704 | -122.48590177317 | (37.7876587769797, -122.48590177317) | |||
59353 | 59353 | 176135 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5987227.516530001 | 2086480.11804 | 37.7083407164149 | -122.485898513129 | (37.7083407164149, -122.485898513129) | |||
160483 | 160483 | 176136 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 4 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5987247.74108 | 2086476.2363 | 37.7083312366754 | -122.48582833093599 | (37.7083312366754, -122.485828330936) | |||
161785 | 161785 | 176137 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800 John Muir Dr | 5 | : 4 | Tree 1 | Private 1 | 11 | Width 0ft | 5987255.345 | 2086484.45942 | 37.708354258405 | -122.485802654386 | (37.708354258405, -122.485802654386) | |||
60030 | 60030 | 250487 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 222 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5987893.38095 | 2115356.6041900003 | 37.7876666226671 | -122.485715124257 | (37.7876666226671, -122.485715124257) | |||
129215 | 129215 | 250538 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 81 25th Ave | 1 | : 4 | Tree 1 | Private 1 | 14 | Width 5ft | 5987993.0307599995 | 2115480.02727 | 37.7880113130196 | -122.48537941992201 | (37.7880113130196, -122.485379419922) | |||
46715 | 46715 | 176139 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 0ft | 5987453.25598 | 2088569.38174 | 37.714090463565796 | -122.485271539962 | (37.7140904635658, -122.485271539962) | |||
49614 | 49614 | 176138 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 0ft | 5987453.76086 | 2088540.35852 | 37.714010802520704 | -122.485267666593 | (37.7140108025207, -122.485267666593) | |||
72073 | 72073 | 176140 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 3 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5987455.898580001 | 2088588.29538 | 37.7141425496068 | -122.48526379321501 | (37.7141425496068, -122.485263793215) | |||
45769 | 45769 | 176148 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 9 | : 4 | Tree 1 | Private 1 | 34 | Width 0ft | 5987583.49684 | 2090495.06547 | 37.7193854910228 | -122.484962576086 | (37.7193854910228, -122.484962576086) | |||
174101 | 174101 | 176141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 1 | : 4 | Tree 1 | Private 1 | 48 | Width 0ft | 5987562.65817 | 2089512.7313599999 | 37.7166870365437 | -122.484962576069 | (37.7166870365437, -122.484962576069) | |||
38808 | 38808 | 176142 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 2 | : 4 | Tree 1 | Private 1 | 38 | Width 0ft | 5987571.34971 | 2089706.0579 | 37.7172183686082 | -122.48494670935 | (37.7172183686082, -122.48494670935) | |||
149666 | 149666 | 176149 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 10 | : 4 | Tree 1 | Private 1 | 58 | Width 0ft | 5987588.89275 | 2090533.04242 | 37.7194900803794 | -122.48494670933998 | (37.7194900803794, -122.48494670934) | |||
67783 | 67783 | 176150 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 11 | : 4 | Tree 1 | Private 1 | 36 | Width 0ft | 5987592.48981 | 2090630.47985 | 37.7197578283347 | -122.484941420412 | (37.7197578283347, -122.484941420412) | |||
171157 | 171157 | 176146 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 7 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987590.810219999 | 2090334.9259400002 | 37.7189462144818 | -122.48492555458999 | (37.7189462144818, -122.48492555459) | |||
184095 | 184095 | 176151 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 12 | : 4 | Tree 1 | Private 1 | 28 | Width 0ft | 5987601.77319 | 2090779.60025 | 37.7201678157831 | -122.484920265686 | (37.7201678157831, -122.484920265686) | |||
136102 | 136102 | 176147 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 8 | : 4 | Tree 1 | Private 1 | 40 | Width 0ft | 5987595.02111 | 2090461.3006400003 | 37.7192934526127 | -122.484920265678 | (37.7192934526127, -122.484920265678) | |||
35639 | 35639 | 176145 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 6 | : 4 | Tree 1 | Private 1 | 41 | Width 0ft | 5987592.83524 | 2090286.1257900002 | 37.7188123395933 | -122.484914976763 | (37.7188123395933, -122.484914976763) | |||
44967 | 44967 | 176143 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 4 | : 4 | Tree 1 | Private 1 | 60 | Width 0ft | 5987585.53383 | 2089941.9294099999 | 37.7178668382624 | -122.48491497676201 | (37.7178668382624, -122.484914976762) | |||
71082 | 71082 | 176144 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Lake Merced Blvd | 5 | : 4 | Tree 1 | Private 1 | 39 | Width 0ft | 5987593.26623 | 2090234.31177 | 37.7186700965335 | -122.484909687836 | (37.7186700965335, -122.484909687836) | |||
49756 | 49756 | 178276 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 10 Lake Merced Blvd | 3 | : 4 | Tree 1 | Private 1 | 21 | Width 0ft | 5987587.7101300005 | 2089755.9926900002 | 37.7173564298339 | -122.4848938211 | (37.7173564298339, -122.4848938211) | |||
159493 | 159493 | 250556 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 130 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 5988132.65183 | 2115364.44627 | 37.787702093729 | -122.48488787927 | (37.787702093729, -122.48488787927) | |||
57488 | 57488 | 250555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | |||
164675 | 164675 | 250554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988163.80572 | 2115366.95271 | 37.7877107901693 | -122.484780278081 | (37.7877107901693, -122.484780278081) | |||
47371 | 47371 | 250553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.787713689594796 | -122.484739928202 | (37.7877136895948, -122.484739928202) | |||
51914 | 51914 | 250552 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 5988200.97229 | 2115369.68376 | 37.7877204533879 | -122.484651890886 | (37.7877204533879, -122.484651890886) | |||
42632 | 42632 | 250551 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 El Camino Del Mar | 6 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988203.798359999 | 2115369.62382 | 37.7877204533909 | -122.48464210894801 | (37.7877204533909, -122.484642108948) | |||
177086 | 177086 | 250550 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 El Camino Del Mar | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 4ft | 5988215.47064 | 2115370.08013 | 37.7877223860349 | -122.484601759078 | (37.7877223860349, -122.484601759078) | |||
182705 | 182705 | 250547 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 2 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5988224.27982 | 2115368.83764 | 37.7877194875147 | -122.484571190206 | (37.7877194875147, -122.484571190206) | |||
50112 | 50112 | 250548 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 4ft | 5988224.68514 | 2115371.29245 | 37.787726251325395 | -122.484569968025 | (37.7877262513254, -122.484569968025) | |||
184561 | 184561 | 250549 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 120 El Camino Del Mar | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988226.07592 | 2115370.2073 | 37.787723352804704 | -122.484565076625 | (37.7877233528047, -122.484565076625) | |||
163726 | 163726 | 250546 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 120 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 2 | Width 4ft | 5988227.83471 | 2115369.81789 | 37.7877223860179 | -122.484558963049 | (37.7877223860179, -122.484558963049) | |||
27602 | 27602 | 178277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5987671.03855 | 2088779.0413099998 | 37.7146788207357 | -122.484534178617 | (37.7146788207357, -122.484534178617) | |||
140124 | 140124 | 176152 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 2 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5987747.4162 | 2088772.85017 | 37.7146662689143 | -122.48426973566099 | (37.7146662689143, -122.484269735661) | |||
166286 | 166286 | 176153 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5987778.038380001 | 2088773.7248200001 | 37.7146704534554 | -122.484163958296 | (37.7146704534554, -122.484163958296) | |||
36171 | 36171 | 176154 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 4 | : 4 | Tree 1 | Private 1 | 20 | Width 0ft | 5987807.09848 | 2088773.10862 | 37.714670453457295 | -122.48406347077801 | (37.7146704534573, -122.484063470778) | |||
36862 | 36862 | 178278 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 5 | : 4 | Tree 1 | Private 1 | 17 | Width 0ft | 5987837.59148 | 2088767.8907 | 37.7146579016256 | -122.4839576934 | (37.7146579016256, -122.4839576934) | |||
62819 | 62819 | 178280 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5987975.063680001 | 2088757.9877099998 | 37.7146387127946 | -122.483481813546 | (37.7146387127946, -122.483481813546) | |||
64377 | 64377 | 178281 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 8 | : 4 | Tree 1 | Private 1 | 23 | Width 0ft | 5988022.78245 | 2088756.97622 | 37.71463871277071 | -122.483316805926 | (37.7146387127707, -122.483316805926) | |||
28511 | 28511 | 176155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 9 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5988052.58895 | 2088755.4955 | 37.71463638173179 | -122.48321367528798 | (37.7146363817318, -122.483213675288) | |||
40889 | 40889 | 176156 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 900 Brotherhood Way | 10 | : 4 | Tree 1 | Private 1 | 31 | Width 0ft | 5988097.715469999 | 2088752.8411700001 | 37.714631719660396 | -122.48305750709801 | (37.7146317196604, -122.483057507098) | |||
34161 | 34161 | 178282 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 0ft | 5988239.0242099995 | 2088743.05539 | 37.7146130722195 | -122.482568375746 | (37.7146130722195, -122.482568375746) | |||
158811 | 158811 | 178283 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 12 | : 4 | Tree 1 | Private 1 | 35 | Width 0ft | 5988286.6711 | 2088738.6503700002 | 37.714603748950296 | -122.482403368129 | (37.7146037489503, -122.482403368129) | |||
185854 | 185854 | 178284 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 13 | : 4 | Tree 1 | Private 1 | 25 | Width 0ft | 5988329.29529 | 2088738.596 | 37.7146060790912 | -122.482256039396 | (37.7146060790912, -122.482256039396) |
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");