Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10259 | 10259 | 141190 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 1771 ELLIS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9999 | Width 0ft | 6002407.0405 | 2112959.471 | 37.781919696317296 | -122.43532920805599 | (37.7819196963173, -122.435329208056) | |||
| 140943 | 140943 | 120977 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 794x Gates St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3030 | 3x3 | 6008103.0 | 2095407.0 | 37.7340464539486 | -122.414381414226 | (37.7340464539486, -122.414381414226) | |||
| 134826 | 134826 | 133419 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3535 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1920 | Width 3ft | 5997881.22616 | 2115448.76842 | 37.788496590783794 | -122.451165933971 | (37.7884965907838, -122.451165933971) | |||
| 10796 | 10796 | 56697 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1835 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1530 | 3x4 | 5983784.1963 | 2102652.3274 | 37.752544024505895 | -122.498992883391 | (37.7525440245059, -122.498992883391) | |||
| 152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
| 85913 | 85913 | 12591 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 540 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 135 | 3X3 | 5993752.44537 | 2114880.64385 | 37.7866994199903 | -122.465409472784 | (37.7866994199903, -122.465409472784) | |||
| 78599 | 78599 | 12607 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 653 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 9x7 | 5993406.40366 | 2114819.71467 | 37.7865121620391 | -122.46660225402901 | (37.7865121620391, -122.466602254029) | |||
| 126700 | 126700 | 12581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 431 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3x3 | 5994092.89819 | 2114844.89484 | 37.7866208917825 | -122.46422900028 | (37.7866208917825, -122.46422900028) | |||
| 127418 | 127418 | 12606 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 651 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 125 | 3X3 | 5993439.12695 | 2114820.30449 | 37.786515669843205 | -122.466489083379 | (37.7865156698432, -122.466489083379) | |||
| 140148 | 140148 | 110856 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 199x HAWTHORNE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 123 | 3x3 | 6013721.0 | 2113357.0 | 37.7836472413673 | -122.39621571824699 | (37.7836472413673, -122.396215718247) | |||
| 156890 | 156890 | 249999 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 39 Darrell Pl | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 121 | Width 0ft | 6011509.9435 | 2120224.2158 | 37.8023796968334 | -122.404348688764 | (37.8023796968334, -122.404348688764) | |||
| 50438 | 50438 | 205639 | Undocumented 2 | Brugmansia spp :: Angel trumpet 137 | 212 Hearst Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 105 | 5999981.368430001 | 2094392.7205 | 37.7308018951744 | -122.442387538165 | (37.7308018951744, -122.442387538165) | ||||
| 186127 | 186127 | 131690 | Undocumented 2 | Musa spp :: Banana 371 | 407 Vallejo St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 105 | 6011485.14109 | 2119034.37122 | 37.7991112871264 | -122.40435072033199 | (37.7991112871264, -122.404350720332) | ||||
| 8809 | 8809 | 3076 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2901 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000369.0268 | 2115111.6254 | 37.7877130071917 | -122.442534340035 | (37.7877130071917, -122.442534340035) | |||
| 9140 | 9140 | 12661 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254004 | -122.47084652786002 | (37.786320036254, -122.47084652786) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 77970 | 77970 | 12741 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1638 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5990321.4540800005 | 2114762.4147099997 | 37.786176325151295 | -122.47727111168899 | (37.7861763251513, -122.477271111689) | |||
| 78188 | 78188 | 7673 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 290X LAKE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994618.0 | 2114909.0 | 37.7868271588239 | -122.46241694027701 | (37.7868271588239, -122.462416940277) | |||
| 100775 | 100775 | 107342 | Significant Tree 6 | Prunus laurocerasus :: English laurel 227 | 110 JULIAN AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 100 | 6006340.8 | 2107214.1 | 37.7663669011591 | -122.421312071366 | (37.7663669011591, -122.421312071366) | ||||
| 112742 | 112742 | 13155 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1871 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 6003453.14477 | 2119540.71202 | 37.8000494585448 | -122.43218031398199 | (37.8000494585448, -122.432180313982) | |||
| 114688 | 114688 | 1471 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | |||
| 118710 | 118710 | 105850 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 44 MENDOSA AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 100 | 6x15 | 5993395.1 | 2101192.7 | 37.7490953323683 | -122.465650972372 | (37.7490953323683, -122.465650972372) | |||
| 118883 | 118883 | 3331 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5330 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3x3 | 5991002.22066 | 2114113.47051 | 37.784433979884795 | -122.474868477503 | (37.7844339798848, -122.474868477503) | |||
| 128485 | 128485 | 12541 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 233 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5994692.63999 | 2114868.9307 | 37.7867214372248 | -122.462155798195 | (37.7867214372248, -122.462155798195) | |||
| 141688 | 141688 | 1614 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 757 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995631.63313 | 2111076.8894 | 37.7763635225537 | -122.458632510412 | (37.7763635225537, -122.458632510412) | |||
| 145511 | 145511 | 19288 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995247.58897 | 2114888.2393799997 | 37.7868063902482 | -122.46023721951599 | (37.7868063902482, -122.460237219516) | |||
| 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) | |||
| 24028 | 24028 | 186361 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1801 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984795.4735 | 2102590.7965 | 37.752434345234 | -122.495491228463 | (37.752434345234, -122.495491228463) | |||
| 25740 | 25740 | 187008 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2501 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984967.4388 | 2098043.05 | 37.739957538540295 | -122.49456132318899 | (37.7399575385403, -122.494561323189) | |||
| 77244 | 77244 | 185929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | |||
| 106826 | 106826 | 107037 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1060 Clayton St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 99 | 5998985.0 | 2106259.0 | 37.7633269800406 | -122.446685590868 | (37.7633269800406, -122.446685590868) | ||||
| 152584 | 152584 | 184346 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1251 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984686.7384 | 2106407.7493 | 37.7629082680796 | -122.49614883097901 | (37.7629082680796, -122.496148830979) | |||
| 153184 | 153184 | 185035 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2701 Sunset Blvd | 61 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985023.8956 | 2096287.7176 | 37.7351411700064 | -122.49423677323401 | (37.7351411700064, -122.494236773234) | |||
| 155847 | 155847 | 186256 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1701 Sunset Blvd | 67 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984812.6153 | 2103003.1364 | 37.7535675206606 | -122.49546235883498 | (37.7535675206606, -122.495462358835) | |||
| 163766 | 163766 | 185074 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2801 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984997.7254 | 2096135.7209 | 37.7347222961152 | -122.49431605154301 | (37.7347222961152, -122.494316051543) | |||
| 167561 | 167561 | 186155 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1700 Sunset Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984957.7478 | 2103324.5301 | 37.7544584761874 | -122.494984162752 | (37.7544584761874, -122.494984162752) | |||
| 171399 | 171399 | 184735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1301 Sunset Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5984680.1977 | 2106291.6891 | 37.7625892162308 | -122.496162889393 | (37.7625892162308, -122.496162889393) | |||
| 149618 | 149618 | 185710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2101 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 95 | Width 0ft | 5984848.6658 | 2100421.3565 | 37.7464807716884 | -122.495147319794 | (37.7464807716884, -122.495147319794) | |||
| 174141 | 174141 | 217519 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.72739593057529 | -122.447013334218 | (37.7273959305753, -122.447013334218) | |||
| 2016 | 2016 | 13112 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1601 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6004666.807 | 2119779.6281 | 37.800774197193796 | -122.42799761136001 | (37.8007741971938, -122.42799761136) | |||
| 4302 | 4302 | 13161 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1895 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6003359.5664 | 2119590.4223 | 37.8001806439695 | -122.432507683341 | (37.8001806439695, -122.432507683341) | |||
| 4904 | 4904 | 23927 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1715 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6003460.7841 | 2114695.1886 | 37.7867453258178 | -122.43180771362199 | (37.7867453258178, -122.431807713622) | |||
| 5411 | 5411 | 8150 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002846.3106 | 2111341.485 | 37.7775020483312 | -122.433693863913 | (37.7775020483312, -122.433693863913) | |||
| 6364 | 6364 | 13127 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1700 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004182.8465 | 2119787.4466 | 37.8007682730329 | -122.42967287413 | (37.8007682730329, -122.42967287413) | |||
| 8009 | 8009 | 8146 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1000 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002926.0085 | 2111351.5233 | 37.7775341328911 | -122.433418880148 | (37.7775341328911, -122.433418880148) | |||
| 8446 | 8446 | 11434 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6011450.63994 | 2118045.46213 | 37.7963940539012 | -122.404400461805 | (37.7963940539012, -122.404400461805) | |||
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 17317 | 17317 | 5713 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1629 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005337.04528 | 2098854.62727 | 37.743357094669705 | -122.424189297907 | (37.7433570946697, -122.424189297907) | |||
| 17549 | 17549 | 5699 | Permitted Site 1 | Cordyline australis :: Dracena Palm 141 | 1569 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6 | 6005313.38344 | 2099208.61144 | 37.7443277185515 | -122.424296285742 | (37.7443277185515, -122.424296285742) | |||
| 17955 | 17955 | 10276 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 215X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6004948.0554599995 | 2109498.71961 | 37.7725612966014 | -122.42629199289699 | (37.7725612966014, -122.426291992897) | |||
| 18207 | 18207 | 5631 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1234 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6005123.01487 | 2101119.88751 | 37.749564892610394 | -122.425090505838 | (37.7495648926104, -122.425090505838) | |||
| 19158 | 19158 | 5458 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 589 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2009 12:00:00 AM | 90 | 3x3 | 6004996.57492 | 2104960.58209 | 37.7601033992601 | -122.42580108085801 | (37.7601033992601, -122.425801080858) | ||
| 19320 | 19320 | 5332 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 125 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 6x7 | 6004849.91389 | 2107615.9681599997 | 37.7673861676625 | -122.42649738994601 | (37.7673861676625, -122.426497389946) | |||
| 19662 | 19662 | 10000 | Permitted Site 1 | Geijera parviflora :: Australian Willow 68 | 136 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X2 | 6005403.547780001 | 2108183.22689 | 37.7689750062251 | -122.424622801709 | (37.7689750062251, -122.424622801709) | |||
| 19679 | 19679 | 3246 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3934 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995332.1300099995 | 2114476.7036099997 | 37.785681286495794 | -122.45991490670299 | (37.7856812864958, -122.459914906703) | |||
| 20393 | 20393 | 1382 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 601X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995593.50257 | 2112100.09905 | 37.7791707937226 | -122.458838511201 | (37.7791707937226, -122.458838511201) | |||
| 20504 | 20504 | 10495 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1701 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5997835.7259 | 2108510.475 | 37.7694432404816 | -122.450822883239 | (37.7694432404816, -122.450822883239) | |||
| 20788 | 20788 | 14571 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1101 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 5x5 | 5999361.6418 | 2109001.7234 | 37.7708793165263 | -122.445580154944 | (37.7708793165263, -122.445580154944) | |||
| 21588 | 21588 | 5459 | DPW Maintained 3 | Schinus polygamus :: Chilean pepper tree 324 | 589 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 8X8 | 6004997.42906 | 2104935.20905 | 37.76003377915271 | -122.425796320748 | (37.7600337791527, -122.425796320748) | |||
| 21599 | 21599 | 1993 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 162 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6007301.508909999 | 2098085.20202 | 37.7413551489316 | -122.417342154839 | (37.7413551489316, -122.417342154839) | |||
| 22189 | 22189 | 24547 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007976.32415 | 2097161.8833 | 37.7388578628999 | -122.41494353791501 | (37.7388578628999, -122.414943537915) | |||
| 22218 | 22218 | 24546 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 704 Cortland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 6007961.02706 | 2097162.19636 | 37.7388578629053 | -122.414996450438 | (37.7388578629053, -122.414996450438) | |||
| 24663 | 24663 | 8164 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1108 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 6002345.91863 | 2111334.94694 | 37.7774556905463 | -122.435424415956 | (37.7774556905463, -122.435424415956) | |||
| 77343 | 77343 | 3327 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5300 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5991115.03763 | 2114114.39354 | 37.7844430513541 | -122.474478240984 | (37.7844430513541, -122.474478240984) | |||
| 77367 | 77367 | 12589 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 501 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993835.87193 | 2114839.30681 | 37.786590730818894 | -122.465117835634 | (37.7865907308189, -122.465117835634) | |||
| 90915 | 90915 | 8148 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 93458 | 93458 | 8147 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 6002886.962169999 | 2111360.68278 | 37.7775570672136 | -122.43355460906601 | (37.7775570672136, -122.433554609066) | |||
| 93568 | 93568 | 1421 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x12 | 5995527.212040001 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | |||
| 94766 | 94766 | 4593 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 100 Columbus Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6011460.12974 | 2118136.30046 | 37.7966440043551 | -122.40437402195299 | (37.7966440043551, -122.404374021953) | |||
| 95208 | 95208 | 3393 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6241 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988252.22536 | 2113941.19107 | 37.7838012036794 | -122.484369756511 | (37.7838012036794, -122.484369756511) | |||
| 97802 | 97802 | 3315 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5010 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5992011.64144 | 2114143.58423 | 37.7845751079649 | -122.471378457169 | (37.7845751079649, -122.471378457169) | |||
| 98768 | 98768 | 12732 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1619 Lake St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990481.52989 | 2114717.45643 | 37.7860621686584 | -122.476714011555 | (37.7860621686584, -122.476714011555) | |||
| 108881 | 108881 | 12603 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 645 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993471.58312 | 2114823.4545400003 | 37.7865261918162 | -122.466377023021 | (37.7865261918162, -122.466377023021) | |||
| 110028 | 110028 | 1584 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 653 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995606.55902 | 2111798.94869 | 37.7783446651954 | -122.458771535508 | (37.7783446651954, -122.458771535508) | |||
| 110333 | 110333 | 12601 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 637 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5993509.18858 | 2114827.45466 | 37.78653934484179 | -122.466247209305 | (37.7865393448418, -122.466247209305) | |||
| 112209 | 112209 | 1559 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 552 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995643.10859 | 2112475.92175 | 37.7802055542204 | -122.458694119583 | (37.7802055542204, -122.458694119583) | |||
| 117989 | 117989 | 175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5400X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | |||
| 118919 | 118919 | 1574 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 595 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995589.6988699995 | 2112254.70561 | 37.7795950836314 | -122.45886286632 | (37.7795950836314, -122.45886286632) | |||
| 122237 | 122237 | 1582 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 633 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995604.58017 | 2111830.53845 | 37.778431288562004 | -122.45878066865801 | (37.778431288562, -122.458780668658) | |||
| 124902 | 124902 | 12672 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1132 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X4 | 5991897.52815 | 2114823.03375 | 37.786434086563 | -122.47182278185 | (37.786434086563, -122.47182278185) | |||
| 126525 | 126525 | 3410 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6528 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5987293.52978 | 2113992.8320400002 | 37.7838871248275 | -122.48769023634199 | (37.7838871248275, -122.487690236342) | |||
| 140018 | 140018 | 12815 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2139 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988780.51636 | 2114651.15635 | 37.7857813149586 | -122.48259413097601 | (37.7857813149586, -122.482594130976) | |||
| 140497 | 140497 | 1636 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 827 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x3 | 5995647.41415 | 2110653.56158 | 37.7752020829683 | -122.458547268394 | (37.7752020829683, -122.458547268394) | |||
| 143328 | 143328 | 3408 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 6517 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 2X3 | 5987328.28355 | 2113919.47268 | 37.7836877279639 | -122.48756461184999 | (37.7836877279639, -122.48756461185) | |||
| 143481 | 143481 | 11367 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1351X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 6017270.42563 | 2093912.097264 | 37.730452470679005 | -122.38258247713001 | (37.730452470679, -122.38258247713) | |||
| 144868 | 144868 | 3336 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5414 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990748.9880099995 | 2114101.91513 | 37.7843875739705 | -122.475743722006 | (37.7843875739705, -122.475743722006) | |||
| 145960 | 145960 | 12526 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 45 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5995287.93021 | 2114888.84585 | 37.7868103758205 | -122.460097693179 | (37.7868103758205, -122.460097693179) | |||
| 145996 | 145996 | 12586 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 446 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4X4 | 5994034.10882 | 2114901.58036 | 37.78677314610329 | -122.46443651291 | (37.7867731461033, -122.46443651291) | |||
| 156364 | 156364 | 185965 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 90 | Width 0ft | 5984859.6467 | 2101291.1753 | 37.748869699536904 | -122.49517348139999 | (37.7488696995369, -122.4951734814) | |||
| 179874 | 179874 | 186060 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1901 Sunset Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 90 | Width 0ft | 5984837.0831 | 2102159.5408 | 37.7512526720721 | -122.49531553640101 | (37.7512526720721, -122.495315536401) | |||
| 32979 | 32979 | 61822 | Permitted Site 1 | Ficus macrophylla :: Morton Bay Fig 148 | 2749 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/1985 12:00:00 AM | 88 | Permit Number 21854 | 5999853.53427 | 2118084.4694 | 37.7958462579399 | -122.44453158308201 | (37.7958462579399, -122.444531583082) | ||
| 35692 | 35692 | 209045 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 300 Melrose Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 88 | 5998032.3562900005 | 2095523.6559099997 | 37.733795893852296 | -122.44920699922599 | (37.7337958938523, -122.449206999226) | ||||
| 149016 | 149016 | 185997 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 87 | Width 0ft | 5984874.4912 | 2100963.0377 | 37.7479695924465 | -122.495097956423 | (37.7479695924465, -122.495097956423) | |||
| 183441 | 183441 | 185627 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2100 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 87 | Width 0ft | 5985046.4186 | 2100324.9202 | 37.7462275593372 | -122.494456414967 | (37.7462275593372, -122.494456414967) | |||
| 34443 | 34443 | 186561 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 Sunset Blvd | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 85 | Width 0ft | 5984740.943 | 2104715.6846 | 37.758265506246296 | -122.495836533834 | (37.7582655062463, -122.495836533834) | |||
| 69733 | 69733 | 186694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984719.2741 | 2105229.7727 | 37.75967577978221 | -122.495949397724 | (37.7596757797822, -122.495949397724) | |||
| 76772 | 76772 | 185977 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2001 Sunset Blvd | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984864.6841 | 2101097.7224 | 37.7483388256863 | -122.495141798808 | (37.7483388256863, -122.495141798808) | |||
| 148127 | 148127 | 185306 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601 Sunset Blvd | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 0ft | 5984983.5934 | 2097312.6487 | 37.7379529982098 | -122.49445163979401 | (37.7379529982098, -122.494451639794) | |||
| 176677 | 176677 | 244012 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1327 Diamond St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 85 | Width 10ft | 6002018.1444 | 2100161.75754 | 37.7467582119217 | -122.43575868930799 | (37.7467582119217, -122.435758689308) | |||
| 55181 | 55181 | 187225 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2401 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 81 | Width 0ft | 5984926.1909 | 2098694.4361 | 37.741743654922296 | -122.494751951574 | (37.7417436549223, -122.494751951574) |
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");