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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67404 | 67404 | 177922 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990625.846609999 | 2089245.25322 | 37.7161305522573 | -122.474355255986 | (37.7161305522573, -122.474355255986) | |||
| 72659 | 72659 | 177921 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 0 Cambon Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5990636.51581 | 2089256.00468 | 37.7161606912434 | -122.47431916261499 | (37.7161606912434, -122.474319162615) | |||
| 57235 | 57235 | 175648 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | |||
| 67405 | 67405 | 175650 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990453.87404 | 2090277.7472299999 | 37.718955561137705 | -122.475024995517 | (37.7189555611377, -122.475024995517) | |||
| 180905 | 180905 | 175649 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | |||
| 185753 | 185753 | 175651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008001 | (37.7189698369625, -122.47492674008) | |||
| 24871 | 24871 | 178331 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5990248.62782 | 2090529.4940400003 | 37.719634898219205 | -122.47575281776001 | (37.7196348982192, -122.47575281776) | ||||
| 39653 | 39653 | 178330 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5990231.62588 | 2090527.9032400001 | 37.7196295445501 | -122.47581147062 | (37.7196295445501, -122.47581147062) | ||||
| 154609 | 154609 | 178329 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5990213.26487 | 2090523.74185 | 37.719617053850996 | -122.47587463361 | (37.719617053851, -122.47587463361) | ||||
| 69647 | 69647 | 123935 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 08th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5993304.58921 | 2114931.5281 | 37.786813295089296 | -122.466962635679 | (37.7868132950893, -122.466962635679) | |||
| 178667 | 178667 | 123936 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1 08th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 3ft | 5993306.8177 | 2114889.70076 | 37.786698577308705 | -122.466951883723 | (37.7866985773087, -122.466951883723) | |||
| 24194 | 24194 | 122139 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5991116.38675 | 2114975.72508 | 37.7868081061645 | -122.474536454895 | (37.7868081061645, -122.474536454895) | ||||
| 34798 | 34798 | 122131 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.120209999 | 2115013.7594 | 37.786912464412104 | -122.47454361357 | (37.7869124644121, -122.47454361357) | ||||
| 44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
| 46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | ||||
| 155404 | 155404 | 122134 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991116.74625 | 2115003.65081 | 37.78688480325761 | -122.4745372499 | (37.7868848032576, -122.4745372499) | ||||
| 159062 | 159062 | 122138 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.47453486398899 | (37.7868169072323, -122.474534863989) | ||||
| 167000 | 167000 | 122135 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.47454122766099 | (37.78686657212, -122.474541227661) | ||||
| 167324 | 167324 | 122130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5991115.18782 | 2115016.9633400002 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | ||||
| 182203 | 182203 | 122137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083001 | (37.786826966306, -122.47453884083) | ||||
| 186663 | 186663 | 122136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 5991117.00305 | 2114994.0290099997 | 37.786858399358294 | -122.47453565898 | (37.7868583993583, -122.47453565898) | ||||
| 32406 | 32406 | 194091 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6011263.07589 | 2097812.25269 | 37.7408277801759 | -122.403625166174 | (37.7408277801759, -122.403625166174) | ||||
| 49273 | 49273 | 194089 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6011234.191000001 | 2097831.41118 | 37.740878771736 | -122.403726387581 | (37.740878771736, -122.403726387581) | ||||
| 180143 | 180143 | 194090 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Apparel Way | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6011245.93679 | 2097821.82718 | 37.740853112271 | -122.403685100604 | (37.740853112271, -122.403685100604) | ||||
| 38919 | 38919 | 201349 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012827.9931 | 2092586.2696 | 37.7265656062986 | -122.39784774058998 | (37.7265656062986, -122.39784774059) | |||
| 44637 | 44637 | 201345 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012754.450780001 | 2092609.0590599999 | 37.726624085606396 | -122.398103573427 | (37.7266240856064, -122.398103573427) | |||
| 45889 | 45889 | 201340 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Bitting Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012714.10336 | 2092626.0861900002 | 37.7266685912663 | -122.39824424808901 | (37.7266685912663, -122.398244248089) | ||||
| 54396 | 54396 | 201357 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1 Bitting Ave | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012930.1032300005 | 2092562.90102 | 37.7265071269946 | -122.397493109117 | (37.7265071269946, -122.397493109117) | ||||
| 131124 | 131124 | 201347 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012791.8631 | 2092596.6146799999 | 37.7265919996064 | -122.397973366875 | (37.7265919996064, -122.397973366875) | |||
| 131673 | 131673 | 201354 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6012921.134769999 | 2092559.31371 | 37.726496777601795 | -122.39752386145099 | (37.7264967776018, -122.397523861451) | |||
| 135032 | 135032 | 201351 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 8ft | 6012866.15074 | 2092573.2448900002 | 37.7265319680523 | -122.397714917004 | (37.7265319680523, -122.397714917004) | |||
| 149362 | 149362 | 201356 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1 Bitting Ave | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012930.00772 | 2092558.19115 | 37.7264941893332 | -122.39749310912201 | (37.7264941893332, -122.397493109122) | ||||
| 149516 | 149516 | 201350 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012847.3383 | 2092578.90387 | 37.726546458834896 | -122.397780348078 | (37.7265464588349, -122.397780348078) | |||
| 154484 | 154484 | 201353 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012904.00238 | 2092563.8073 | 37.7265081621175 | -122.39758340285101 | (37.7265081621175, -122.397583402851) | |||
| 166848 | 166848 | 201346 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6012773.9855 | 2092601.68911 | 37.7266049372574 | -122.39803552533199 | (37.7266049372574, -122.398035525332) | |||
| 168141 | 168141 | 201342 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1 Bitting Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6012732.15495 | 2092620.2542299998 | 37.7266535833942 | -122.398181434938 | (37.7266535833942, -122.398181434938) | ||||
| 168356 | 168356 | 201352 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 8ft | 6012884.58431 | 2092567.5936099999 | 37.7265174772786 | -122.397650796243 | (37.7265174772786, -122.397650796243) | |||
| 173712 | 173712 | 201343 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6012739.9825 | 2092614.2530099999 | 37.72663754126479 | -122.39815395433399 | (37.7266375412648, -122.398153954334) | ||||
| 177390 | 177390 | 201348 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Bitting Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6012808.60563 | 2092591.5632900002 | 37.7265790619707 | -122.397915133977 | (37.7265790619707, -122.397915133977) | |||
| 179063 | 179063 | 201355 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1 Bitting Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6012932.38695 | 2092554.1850700001 | 37.726483321929706 | -122.397484603332 | (37.7264833219297, -122.397484603332) | ||||
| 23519 | 23519 | 221267 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6004128.17602 | 2108566.81538 | 37.7699561368912 | -122.429061583748 | (37.7699561368912, -122.429061583748) | |||
| 26440 | 26440 | 221264 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6004131.74855 | 2108500.27281 | 37.7697736293789 | -122.42904448133801 | (37.7697736293789, -122.429044481338) | |||
| 37610 | 37610 | 221268 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6004125.636519999 | 2108603.52146 | 37.7700567791189 | -122.42907298535 | (37.7700567791189, -122.42907298535) | |||
| 42372 | 42372 | 221263 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6004132.36771 | 2108477.00924 | 37.769709788311296 | -122.429040680782 | (37.7697097883113, -122.429040680782) | |||
| 44290 | 44290 | 221270 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 6004122.63808 | 2108644.61348 | 37.7701694380901 | -122.429086287217 | (37.7701694380901, -122.429086287217) | |||
| 62561 | 62561 | 221271 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6004119.92385 | 2108672.84338 | 37.7702467968906 | -122.429097688827 | (37.7702467968906, -122.429097688827) | |||
| 68774 | 68774 | 221266 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6004128.33059 | 2108547.6647 | 37.7699035625247 | -122.429059683463 | (37.7699035625247, -122.429059683463) | |||
| 161763 | 161763 | 221269 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6004124.2935 | 2108618.32017 | 37.7700973367576 | -122.429078686141 | (37.7700973367576, -122.429078686141) | |||
| 170882 | 170882 | 221265 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6004128.718640001 | 2108513.19121 | 37.7698089286584 | -122.429055882918 | (37.7698089286584, -122.429055882918) | |||
| 186931 | 186931 | 232435 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1 Church St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 6ft | 6004121.39652 | 2108664.33355 | 37.7702235143292 | -122.42909198802201 | (37.7702235143292, -122.429091988022) | |||
| 83901 | 83901 | 99609 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 1 Entrada Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||||
| 89582 | 89582 | 99611 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Entrada Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||||
| 93540 | 93540 | 99608 | Permitted Site 1 | Tree(s) :: 17 | 1 Entrada Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768939 | 5992743.0 | 2092489.0 | 37.7251595224946 | -122.46727314778099 | (37.7251595224946, -122.467273147781) | |||
| 49954 | 49954 | 100848 | Undocumented 2 | Leptospermum scoparium 'Ruby Glow' :: New Zealand Ruby Glow Tea Tree 264 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 79153 | 79153 | 100847 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 83229 | 83229 | 100849 | Undocumented 2 | Taxus baccata :: Irish Yew 241 | 1 Estero Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 105655 | 105655 | 100846 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1 Estero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 109239 | 109239 | 100845 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1 Estero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 113536 | 113536 | 100844 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 1 Estero Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 122520 | 122520 | 100850 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 124585 | 124585 | 100843 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1 Estero Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5992057.7 | 2091642.6 | 37.7227959320346 | -122.469580550695 | (37.7227959320346, -122.469580550695) | |||||
| 26975 | 26975 | 129323 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Florence St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008475.1891 | 2118345.56468 | 37.7970513368976 | -122.414717435764 | (37.7970513368976, -122.414717435764) | ||||
| 130701 | 130701 | 125385 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1 Florence St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6008475.364159999 | 2118338.8656900004 | 37.7970329529656 | -122.414716355687 | (37.7970329529656, -122.414716355687) | ||||
| 167099 | 167099 | 126287 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Florence St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6008482.5431699995 | 2118328.02028 | 37.797003577504604 | -122.41469074658998 | (37.7970035775046, -122.41469074659) | ||||
| 148347 | 148347 | 194063 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1 Flower St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 6010838.1657 | 2098339.02807 | 37.7422504473898 | -122.40513143798599 | (37.7422504473898, -122.405131437986) | |||
| 63937 | 63937 | 176847 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005714.45632 | 2093496.12065 | 37.7286651338862 | -122.422503626641 | (37.7286651338862, -122.422503626641) | |||
| 130258 | 130258 | 176848 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005711.542330001 | 2093506.49571 | 37.728693457131 | -122.422514437416 | (37.728693457131, -122.422514437416) | |||
| 174196 | 174196 | 176849 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Gambier St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6005708.05423 | 2093517.46622 | 37.7287233829612 | -122.422527275231 | (37.7287233829612, -122.422527275231) | |||
| 181142 | 181142 | 208857 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5997408.7613699995 | 2093610.5667299998 | 37.7285073190505 | -122.451225020336 | (37.7285073190505, -122.451225020336) | |||
| 59764 | 59764 | 132675 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Heather Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 5997331.41397 | 2114381.51283 | 37.7855346961081 | -122.45299111975201 | (37.7855346961081, -122.452991119752) | |||
| 168624 | 168624 | 132674 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Heather Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5997331.30843 | 2114427.41928 | 37.7856607370015 | -122.452994799771 | (37.7856607370015, -122.452994799771) | ||||
| 74388 | 74388 | 226884 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Hidalgo Ter | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 2ft | 6005071.43074 | 2107486.3006599997 | 37.7670426518224 | -122.425721963013 | (37.7670426518224, -122.425721963013) | |||
| 57046 | 57046 | 202062 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 9ft | 6012907.59941 | 2090167.98565 | 37.7199299208095 | -122.397403024054 | (37.7199299208095, -122.397403024054) | |||
| 69873 | 69873 | 202066 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 9ft | 6012981.8772 | 2090193.58175 | 37.7200043379011 | -122.39714806353001 | (37.7200043379011, -122.39714806353) | |||
| 132787 | 132787 | 202063 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 9ft | 6012938.96015 | 2090178.7208200002 | 37.7199611434755 | -122.3972953725 | (37.7199611434755, -122.3972953725) | |||
| 138133 | 138133 | 202067 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 1 Hwy 101 S On Ramp | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 9ft | 6013024.681059999 | 2090205.86512 | 37.720040448378704 | -122.397000965021 | (37.7200404483787, -122.397000965021) | |||
| 172236 | 172236 | 202064 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1 Hwy 101 S On Ramp | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 9ft | 6012962.66083 | 2090186.66523 | 37.7199842767271 | -122.39721400364401 | (37.7199842767271, -122.397214003644) | |||
| 181603 | 181603 | 202065 | Undocumented 2 | Heteromeles arbutifolia :: Toyon 322 | 1 Hwy 101 S On Ramp | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6012968.073469999 | 2090188.26026 | 37.7199889576912 | -122.39719540566601 | (37.7199889576912, -122.397195405666) | |||
| 93609 | 93609 | 124569 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1 Jordan Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5996154.91779 | 2114511.96286 | 37.785825384071394 | -122.457070865676 | (37.7858253840714, -122.457070865676) | |||
| 26099 | 26099 | 202241 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013196.57345 | 2093194.11858 | 37.728255155426 | -122.396616155019 | (37.728255155426, -122.396616155019) | |||
| 29584 | 29584 | 202251 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013208.3513 | 2093289.05623 | 37.728516490324395 | -122.396582090505 | (37.7285164903244, -122.396582090505) | |||
| 31449 | 31449 | 202248 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 6013204.66207 | 2093259.83536 | 37.72843605046 | -122.396592796933 | (37.72843605046, -122.396592796933) | |||
| 31950 | 31950 | 202214 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013163.74677 | 2092935.74492 | 37.727543887034294 | -122.396711533513 | (37.7275438870343, -122.396711533513) | |||
| 36563 | 36563 | 202259 | Undocumented 2 | Prunus x yedoensis :: Yoshino Cherry 237 | 1 Kalmanovitz St | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6013218.01399 | 2093376.8881599999 | 37.7287581966316 | -122.396554840154 | (37.7287581966316, -122.396554840154) | ||||
| 41936 | 41936 | 202255 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6013211.70344 | 2093322.48938 | 37.728608477487604 | -122.396572844555 | (37.7286084774876, -122.396572844555) | |||
| 42017 | 42017 | 202232 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013184.92926 | 2093105.76578 | 37.7280119086008 | -122.396650218641 | (37.7280119086008, -122.396650218641) | |||
| 42368 | 42368 | 202256 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6013218.75497 | 2093350.94152 | 37.7286869936936 | -122.39655046045701 | (37.7286869936936, -122.396550460457) | |||
| 44645 | 44645 | 202250 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013206.90035 | 2093279.9745 | 37.7284914729969 | -122.39658647018999 | (37.7284914729969, -122.39658647019) | |||
| 47951 | 47951 | 202233 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6013185.992269999 | 2093116.5375599999 | 37.728041544874294 | -122.39664729856001 | (37.7280415448743, -122.39664729856) | |||
| 49456 | 49456 | 202243 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013198.7947 | 2093213.4173 | 37.7283082693961 | -122.39660982829399 | (37.7283082693961, -122.396609828294) | |||
| 51187 | 51187 | 202223 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013174.84825 | 2093025.0903 | 37.72778982911289 | -122.396679416033 | (37.7277898291129, -122.396679416033) | |||
| 54110 | 54110 | 202228 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013179.65142 | 2093067.6055 | 37.7279068345108 | -122.396665790418 | (37.7279068345108, -122.396665790418) | |||
| 56626 | 56626 | 202219 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6013170.94879 | 2092985.5006 | 37.7276809068355 | -122.396690122445 | (37.7276809068355, -122.396690122445) | |||
| 57838 | 57838 | 202215 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013165.33275 | 2092944.54355 | 37.72756813455079 | -122.396706667284 | (37.7275681345508, -122.396706667284) | |||
| 60161 | 60161 | 202236 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013189.66424 | 2093144.91801 | 37.728119676166294 | -122.396636593026 | (37.7281196761663, -122.396636593026) | |||
| 60370 | 60370 | 202253 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6013211.002830001 | 2093308.76677 | 37.7285707590106 | -122.396574305077 | (37.7285707590106, -122.396574305077) | |||
| 62847 | 62847 | 202234 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013186.88595 | 2093125.91095 | 37.7280673320297 | -122.396644865872 | (37.7280673320297, -122.396644865872) | |||
| 70409 | 70409 | 202220 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6013171.59545 | 2092996.56118 | 37.7277113129249 | -122.396688661969 | (37.7277113129249, -122.396688661969) | |||
| 75305 | 75305 | 202252 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6013209.67836 | 2093298.98157 | 37.728543817137705 | -122.396578198225 | (37.7285438171377, -122.396578198225) | |||
| 75390 | 75390 | 202239 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1 Kalmanovitz St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6013193.35893 | 2093174.4194599998 | 37.7282008867581 | -122.396625887476 | (37.7282008867581, -122.396625887476) |
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");