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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9676 | 9676 | 114117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9678 | 9678 | 114134 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9679 | 9679 | 114122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9680 | 9680 | 173618 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9719 | 9719 | 173651 | Planning Code 138.1 required 4 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 80 Entrada Ct | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.456569999 | 2092194.59394 | 37.7243327619491 | -122.46835290122299 | (37.7243327619491, -122.468352901223) | ||
| 9720 | 9720 | 173652 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 ZIRCON PL | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6002398.2 | 2098694.7 | 37.7427515964219 | -122.43433962698201 | (37.7427515964219, -122.434339626982) | |||||
| 9723 | 9723 | 173650 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80 Entrada Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12/21/2016 12:00:00 AM | 3 | 4x10 | 5992424.456569999 | 2092194.59394 | 37.7243327619491 | -122.46835290122299 | (37.7243327619491, -122.468352901223) | ||
| 9867 | 9867 | 118924 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 855 La Playa | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.772014669966396 | -122.510057198601 | (37.7720146699664, -122.510057198601) | ||
| 9989 | 9989 | 173658 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9997 | 9997 | 173656 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10001 | 10001 | 173622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10003 | 10003 | 173619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10009 | 10009 | 173621 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10013 | 10013 | 173624 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10017 | 10017 | 173623 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10018 | 10018 | 173657 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10022 | 10022 | 173620 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10024 | 10024 | 173625 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1200X Junipero Serra Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10034 | 10034 | 109404 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 355 CHRISTOPHER DR | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5995347.2 | 2103110.3 | 37.7544729812167 | -122.45903946490299 | (37.7544729812167, -122.459039464903) | ||||
| 10116 | 10116 | 173859 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10119 | 10119 | 173856 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 118 Saint Mary's Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10123 | 10123 | 173857 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10125 | 10125 | 173858 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 118 Saint Mary's Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
| 10206 | 10206 | 173904 | Undocumented 2 | Juniperus californica :: California juniper 226 | 60 Crestline Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999017.0 | 2101826.0 | 37.7511568864894 | -122.446256008608 | (37.7511568864894, -122.446256008608) | ||||
| 10208 | 10208 | 173903 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 675 Corbett Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999984.0 | 2103563.0 | 37.7559814441149 | -122.44303676104799 | (37.7559814441149, -122.443036761048) | |||||
| 11273 | 11273 | 102842 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1101X Portola Dr | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 14567 | 14567 | 98839 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1101X Portola Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 16111 | 16111 | 102843 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101X Portola Dr | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 18889 | 18889 | 106642 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4540X 17TH ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5999139.0 | 2105833.0 | 37.762166086231204 | -122.446122313424 | (37.7621660862312, -122.446122313424) | ||||
| 20864 | 20864 | 112443 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | ||||
| 22299 | 22299 | 179788 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6004749.24947 | 2094369.67329 | 37.731009216793296 | -122.425902563064 | (37.7310092167933, -122.425902563064) | ||||
| 22366 | 22366 | 186103 | Undocumented 2 | Acacia spp :: Acacia Spp 176 | 1901 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984851.1704 | 2101686.0599 | 37.7499534482555 | -122.495231908653 | (37.7499534482555, -122.495231908653) | |||
| 22809 | 22809 | 125505 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 45 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6007613.99229 | 2119386.63886 | 37.799861442220895 | -122.41777122496 | (37.7998614422209, -122.41777122496) | ||||
| 22814 | 22814 | 184050 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1600 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984953.7413 | 2103846.6967 | 37.755891966793605 | -122.495036518918 | (37.7558919667936, -122.495036518918) | |||
| 22819 | 22819 | 220400 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 30 Harry St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 10ft | 6003253.97405 | 2097694.59557 | 37.7400540781348 | -122.431309231431 | (37.7400540781348, -122.431309231431) | |||
| 22890 | 22890 | 247970 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 159 Faith St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 8ft | 6010298.66575 | 2099104.3209599997 | 37.744321600460296 | -122.407050801679 | (37.7443216004603, -122.407050801679) | |||
| 22892 | 22892 | 251144 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22896 | 22896 | 251145 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 200X Clarendon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5996559.0 | 2104265.0 | 37.7577130831875 | -122.454932197022 | (37.7577130831875, -122.454932197022) | ||||
| 22915 | 22915 | 189301 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1345 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6013913.31542 | 2104750.9131 | 37.76002754956421 | -122.394947417095 | (37.7600275495642, -122.394947417095) | |||
| 22917 | 22917 | 137507 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1920 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | Width 6ft | 6001011.3931599995 | 2121024.3810099997 | 37.803984475874294 | -122.44073617154801 | (37.8039844758743, -122.440736171548) | |||
| 22918 | 22918 | 191269 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 538 Delancey St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6015147.69888 | 2113724.07494 | 37.7847344271845 | -122.391305511737 | (37.7847344271845, -122.391305511737) | ||||
| 22990 | 22990 | 181530 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1300 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984880.8681 | 2105758.2753 | 37.761136363415105 | -122.495429511191 | (37.7611363634151, -122.495429511191) | |||
| 23391 | 23391 | 126083 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 3651 Baker St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 5999112.99946 | 2121376.93874 | 37.804844210643104 | -122.44733105300199 | (37.8048442106431, -122.447331053002) | |||
| 23410 | 23410 | 184354 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1251 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984645.6432 | 2106661.7256 | 37.7636032084053 | -122.496309703367 | (37.7636032084053, -122.496309703367) | |||
| 23412 | 23412 | 194471 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 84 Whitney Young Cir | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6016756.75905 | 2095047.7627400002 | 37.733542392957794 | -122.38443738208001 | (37.7335423929578, -122.38443738208) | ||||
| 23418 | 23418 | 186415 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1601 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984728.3813 | 2104210.7037 | 37.756878233428004 | -122.49584272637699 | (37.756878233428, -122.495842726377) | |||
| 23441 | 23441 | 218859 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1251 Funston Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 5992039.2755 | 2106763.98784 | 37.7643143326521 | -122.470745140778 | (37.7643143326521, -122.470745140778) | |||
| 23443 | 23443 | 248249 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 98 Lundy's Ln | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6006859.99776 | 2099020.88579 | 37.743899476678706 | -122.418935096973 | (37.7438994766787, -122.418935096973) | |||
| 23446 | 23446 | 177294 | Undocumented 2 | Magnolia doltsopa :: Himalayan Magnolia 187 | 570 Edinburgh St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6002574.43441 | 2090375.15322 | 37.7199180155891 | -122.433135958685 | (37.7199180155891, -122.433135958685) | |||
| 23449 | 23449 | 202104 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 1828 Egbert Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 8ft | 6012020.3729 | 2092885.5297599998 | 37.727342303098204 | -122.400660684147 | (37.7273423030982, -122.400660684147) | |||
| 23460 | 23460 | 184061 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1600 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984938.2864 | 2103922.4099 | 37.7560989495084 | -122.49509554904499 | (37.7560989495084, -122.495095549045) | |||
| 23462 | 23462 | 130586 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 4 Charlton Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 4ft | 6003663.86314 | 2118487.9182599997 | 37.7971707039232 | -122.431375953045 | (37.7971707039232, -122.431375953045) | |||
| 23463 | 23463 | 185056 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 82 Crestlake Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5988580.6885 | 2096305.5585 | 37.735397653561 | -122.481941107831 | (37.735397653561, -122.481941107831) | |||
| 23498 | 23498 | 176772 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 937 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 5ft | 6007351.78047 | 2093548.13266 | 37.72890017978 | -122.41684696742901 | (37.72890017978, -122.416846967429) | |||
| 23504 | 23504 | 222733 | Undocumented 2 | Ceanothus Sps :: California lilac 270 | 1335 Douglass St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6001395.73584 | 2099802.9643099997 | 37.745737676549204 | -122.437885218135 | (37.7457376765492, -122.437885218135) | |||
| 23510 | 23510 | 209272 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 843 Detroit St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 5999418.82606 | 2095617.22879 | 37.7341320280635 | -122.444420298265 | (37.7341320280635, -122.444420298265) | |||
| 23516 | 23516 | 201490 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 404 Hawes St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6018801.89872 | 2095027.62617 | 37.7335999801502 | -122.37736527181299 | (37.7335999801502, -122.377365271813) | ||||
| 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) | |||
| 23525 | 23525 | 187316 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 2200 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985075.4607 | 2099608.8478 | 37.744263118481705 | -122.494303219592 | (37.7442631184817, -122.494303219592) | |||
| 23529 | 23529 | 185014 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2701 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985039.8071 | 2096458.9756 | 37.73561232989871 | -122.494194380975 | (37.7356123298987, -122.494194380975) | |||
| 23535 | 23535 | 207712 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 579 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997579.44084 | 2094367.86788 | 37.730596459453395 | -122.450689553205 | (37.7305964594534, -122.450689553205) | ||||
| 23542 | 23542 | 176768 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 955 Silver Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6007502.25565 | 2093569.5745700002 | 37.7289675174267 | -122.416328280725 | (37.7289675174267, -122.416328280725) | |||
| 23551 | 23551 | 181443 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1400 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 35 | Width 0ft | 5984892.2857 | 2105061.2409 | 37.759223169955796 | -122.495338616437 | (37.7592231699558, -122.495338616437) | |||
| 23587 | 23587 | 132909 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2430 Vallejo St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6001915.5631099995 | 2117743.24076 | 37.7950267759276 | -122.437372144115 | (37.7950267759276, -122.437372144115) | |||
| 23588 | 23588 | 142397 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 MAYFAIR DR | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5997908.5687 | 2114561.3906 | 37.7860616516624 | -122.45100731899299 | (37.7860616516624, -122.451007318993) | |||
| 23596 | 23596 | 179735 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004922.43107 | 2094357.6156 | 37.7309858946841 | -122.42530298683701 | (37.7309858946841, -122.425302986837) | |||
| 23609 | 23609 | 125847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1752 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008754.651330001 | 2118947.56933 | 37.7987199902862 | -122.413793029843 | (37.7987199902862, -122.413793029843) | |||
| 23612 | 23612 | 177049 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 5998733.2334 | 2090880.1248400002 | 37.721085906663106 | -122.44644991615299 | (37.7210859066631, -122.446449916153) | |||
| 23613 | 23613 | 177549 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 1212 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 6008302.63413 | 2087080.3017900002 | 37.7111943147388 | -122.41310263557502 | (37.7111943147388, -122.413102635575) | |||
| 23620 | 23620 | 181419 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1500 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984925.1463 | 2104758.8121 | 37.758394708580205 | -122.495202668104 | (37.7583947085802, -122.495202668104) | |||
| 23623 | 23623 | 120846 | Undocumented 2 | Archontophoenix cunninghamiana :: King Palm 210 | 295 19th Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 5989915.56794 | 2113413.68819 | 37.7824495421017 | -122.47857668805901 | (37.7824495421017, -122.478576688059) | |||
| 23646 | 23646 | 197780 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1809 19th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6012306.168880001 | 2105129.4527 | 37.760977438687206 | -122.40053238956999 | (37.7609774386872, -122.40053238957) | |||
| 23660 | 23660 | 237962 | Undocumented 2 | Prunus laurocerasus :: English laurel 227 | 177 Grand View Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | 6000813.89685 | 2103347.44097 | 37.7554368540311 | -122.44015125339199 | (37.7554368540311, -122.440151253392) | ||||
| 23688 | 23688 | 208664 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 462 Hearst Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5998358.74509 | 2094413.2873 | 37.730765747833296 | -122.44799866202699 | (37.7307657478333, -122.447998662027) | ||||
| 23690 | 23690 | 126012 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 2600 Lyon St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 5999234.571959999 | 2117780.83993 | 37.7949772349663 | -122.446651443424 | (37.7949772349663, -122.446651443424) | |||
| 23701 | 23701 | 203433 | Undocumented 2 | Acer saccharinum :: Silver Maple 273 | 15 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6000916.87895 | 2094326.94897 | 37.730674579052796 | -122.439148624412 | (37.7306745790528, -122.439148624412) | |||
| 23707 | 23707 | 250588 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 2201 Golden Gate Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 49 | 5997756.4661 | 2111264.0896400004 | 37.7769994185268 | -122.45129565939399 | (37.7769994185268, -122.451295659394) | ||||
| 23719 | 23719 | 206443 | Undocumented 2 | Cotoneaster SPP :: Cotoneaster 234 | 581 Head St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5993478.4128 | 2089802.60481 | 37.7178257581409 | -122.464535950688 | (37.7178257581409, -122.464535950688) | |||
| 23721 | 23721 | 220632 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 18 Kronquist Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 6002213.33941 | 2100174.25358 | 37.746803608795396 | -122.43508461868299 | (37.7468036087954, -122.435084618683) | |||
| 23730 | 23730 | 219413 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 845 Detroit St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5999418.48835 | 2095681.2919599998 | 37.734307911173204 | -122.444426068323 | (37.7343079111732, -122.444426068323) | |||
| 23743 | 23743 | 185183 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2500 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985128.0455 | 2097828.1066 | 37.7393767603936 | -122.493990182941 | (37.7393767603936, -122.493990182941) | |||
| 23749 | 23749 | 181585 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200 Sunset Blvd | 98 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984843.0144 | 2106607.1528 | 37.7634649266844 | -122.49562304315201 | (37.7634649266844, -122.495623043152) | |||
| 23770 | 23770 | 186402 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984820.6527 | 2102319.266 | 37.7516902715465 | -122.495384132242 | (37.7516902715465, -122.495384132242) | |||
| 23779 | 23779 | 213682 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 305 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6000730.9848 | 2095013.8875 | 37.7325501736469 | -122.43984052053801 | (37.7325501736469, -122.439840520538) | |||
| 23780 | 23780 | 126447 | Undocumented 2 | Casuarina cunninghamiana :: Horsetail pine 123 | 2656 Broderick St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6000161.293869999 | 2117775.76551 | 37.795016194482706 | -122.44344449519 | (37.7950161944827, -122.44344449519) | |||
| 23781 | 23781 | 250570 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 600 Parker Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5997272.199569999 | 2111059.97973 | 37.7764112457195 | -122.452956141515 | (37.7764112457195, -122.452956141515) | ||||
| 23810 | 23810 | 186321 | Undocumented 2 | Rhaphiolepis indica :: India Hawthorn 144 | 1800 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984997.3777 | 2102873.7956 | 37.7532232033747 | -122.494813884029 | (37.7532232033747, -122.494813884029) | |||
| 23819 | 23819 | 125569 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 2843 Larkin St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 5ft | 6006460.46289 | 2121010.84559 | 37.8042561187834 | -122.421878311841 | (37.8042561187834, -122.421878311841) | |||
| 23844 | 23844 | 192384 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Illinois St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 9ft | 6015929.33713 | 2106466.90045 | 37.7648511775542 | -122.38809465775 | (37.7648511775542, -122.38809465775) | |||
| 23847 | 23847 | 226860 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 99 Elk St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 2ft | 6000812.22961 | 2096323.57705 | 37.7361509008315 | -122.43965349751801 | (37.7361509008315, -122.439653497518) | |||
| 23856 | 23856 | 223819 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 1201 Vermont St | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6011464.41366 | 2102201.65675 | 37.75289137874 | -122.40323770855 | (37.75289137874, -122.40323770855) | |||
| 23867 | 23867 | 232408 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 387 Beacon St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6002395.6787 | 2098158.1545599997 | 37.7412782244979 | -122.43430999392099 | (37.7412782244979, -122.434309993921) | |||
| 23870 | 23870 | 214333 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 312 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5999316.02125 | 2094400.93218 | 37.7307864969836 | -122.44468833131901 | (37.7307864969836, -122.444688331319) | |||
| 23880 | 23880 | 187141 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2301 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 52 | Width 0ft | 5984898.7676 | 2099479.6664 | 37.7438980796356 | -122.494904654416 | (37.7438980796356, -122.494904654416) | |||
| 23881 | 23881 | 129298 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1287 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 6006767.5192599995 | 2119403.73147 | 37.799860702966 | -122.420701557924 | (37.799860702966, -122.420701557924) | |||
| 23882 | 23882 | 125253 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 20 Reed St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6008205.34429 | 2117069.05453 | 37.793531190756205 | -122.41556074355101 | (37.7935311907562, -122.415560743551) | ||||
| 23889 | 23889 | 202154 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 1937 Armstrong Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6013078.37637 | 2093416.60548 | 37.728859480065104 | -122.397040363418 | (37.7288594800651, -122.397040363418) | |||
| 23905 | 23905 | 207996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5999475.26279 | 2094946.5125 | 37.732293618635396 | -122.44417699929 | (37.7322936186354, -122.44417699929) | |||
| 23916 | 23916 | 177744 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 65 Ocean Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6001008.85116 | 2091721.5574 | 37.7235260030036 | -122.438644049011 | (37.7235260030036, -122.438644049011) | ||||
| 23919 | 23919 | 194457 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2001 25th St | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 30 | 6012708.71911 | 2101842.22219 | 37.7519738634013 | -122.398909414543 | (37.7519738634013, -122.398909414543) |
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");