Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96198 | 96198 | 13301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 138487 | 138487 | 13304 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 141679 | 141679 | 13302 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 142098 | 142098 | 13303 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 9X Lyell St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 15 | 6003085.685949201 | 2094681.4720202 | 37.7317711908882 | -122.43167603243099 | (37.7317711908882, -122.431676032431) | |||
| 41263 | 41263 | 218719 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993701.46816 | 2100309.93296 | 37.7466891448909 | -122.464527467374 | (37.7466891448909, -122.464527467374) | |||
| 42882 | 42882 | 211250 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 33 | Width 5ft | 5993746.09289 | 2100276.06203 | 37.7465987162755 | -122.464370702046 | (37.7465987162755, -122.464370702046) | |||
| 43117 | 43117 | 219165 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993760.22324 | 2100276.5052799997 | 37.7466007478231 | -122.46432187335199 | (37.7466007478231, -122.464321873352) | |||
| 44102 | 44102 | 209213 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993777.82606 | 2100247.64237 | 37.7465225122089 | -122.46425891004101 | (37.7465225122089, -122.464258910041) | |||
| 47921 | 47921 | 211249 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 5ft | 5993726.26019 | 2100287.2096700002 | 37.74662818164779 | -122.464440090141 | (37.7466281816478, -122.464440090141) | |||
| 56613 | 56613 | 211254 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 31 | Width 5ft | 5993790.37609 | 2100225.91603 | 37.7464635805444 | -122.46421393671899 | (37.7464635805444, -122.464213936719) | |||
| 60137 | 60137 | 209212 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993771.94389 | 2100232.96399 | 37.746481870051106 | -122.4642781843 | (37.7464818700511, -122.4642781843) | |||
| 60262 | 60262 | 219167 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | |||
| 61181 | 61181 | 211251 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 14 | Width 5ft | 5993753.32003 | 2100266.28903 | 37.746572298679794 | -122.464345002125 | (37.7465722986798, -122.464345002125) | |||
| 74481 | 74481 | 218721 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993716.07745 | 2100297.78462 | 37.746656630797794 | -122.464476068412 | (37.7466566307978, -122.464476068412) | |||
| 75541 | 75541 | 209208 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993802.83706 | 2100253.03783 | 37.7465387683529 | -122.46417281704399 | (37.7465387683529, -122.464172817044) | |||
| 76824 | 76824 | 219162 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993732.15666 | 2100284.86554 | 37.74662208515711 | -122.46441953075501 | (37.7466220851571, -122.464419530755) | |||
| 123719 | 123719 | 209209 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993795.21392 | 2100243.94669 | 37.746513367011 | -122.464198516942 | (37.746513367011, -122.464198516942) | |||
| 134757 | 134757 | 209210 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 5ft | 5993788.41941 | 2100238.90873 | 37.746499142429705 | -122.464221645739 | (37.7464991424297, -122.464221645739) | |||
| 147824 | 147824 | 218720 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 99x San Marcos Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5993709.38363 | 2100297.55504 | 37.746655614559295 | -122.464499198102 | (37.7466556145593, -122.464499198102) | |||
| 153512 | 153512 | 219166 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993758.91368 | 2100249.51951 | 37.7465265762511 | -122.46432444273 | (37.7465265762511, -122.46432444273) | |||
| 154163 | 154163 | 219163 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993739.16637 | 2100264.73593 | 37.746567218412 | -122.46439383083599 | (37.746567218412, -122.464393830836) | |||
| 156535 | 156535 | 219164 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 5ft | 5993746.9601 | 2100281.9643 | 37.7466149724013 | -122.464368131807 | (37.7466149724013, -122.464368131807) | |||
| 157795 | 157795 | 209207 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 5993815.86849 | 2100254.24474 | 37.7465428332992 | -122.46412784372801 | (37.7465428332992, -122.464127843728) | |||
| 160858 | 160858 | 211253 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 25 | Width 5ft | 5993783.32 | 2100243.82658 | 37.7465123516796 | -122.46423963577 | (37.7465123516796, -122.46423963577) | |||
| 178018 | 178018 | 209211 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x San Marcos Ave | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 5993782.2667 | 2100229.04683 | 37.7464717095186 | -122.46424220511601 | (37.7464717095186, -122.464242205116) | |||
| 184665 | 184665 | 211252 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 99x San Marcos Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | Width 5ft | 5993772.95985 | 2100263.65639 | 37.7465662021668 | -122.464276899165 | (37.7465662021668, -122.464276899165) | |||
| 43528 | 43528 | 209215 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 15 | Width 5ft | 5993821.14503 | 2100240.07202 | 37.746504222711295 | -122.46410856948 | (37.7465042227113, -122.46410856948) | |||
| 134453 | 134453 | 209214 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 99x Castenada Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993812.322269999 | 2100226.93547 | 37.746467644571 | -122.464138123878 | (37.746467644571, -122.464138123878) | |||
| 180603 | 180603 | 206418 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 99x Castenada Ave | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 5ft | 5993828.80673 | 2100251.01259 | 37.7465347043225 | -122.464082870453 | (37.7465347043225, -122.464082870453) | |||
| 76348 | 76348 | 27944 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | |||
| 83420 | 83420 | 27948 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 91110 | 91110 | 27949 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 98325 | 98325 | 27947 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 106831 | 106831 | 27951 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 114665 | 114665 | 27950 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 116513 | 116513 | 27946 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 144240 | 144240 | 27945 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
| 9882 | 9882 | 173729 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 9906 | 9906 | 173728 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 994 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | 3x3 | 6012439.0 | 2103318.0 | 37.7560109950145 | -122.399945772243 | (37.7560109950145, -122.399945772243) | |||
| 77368 | 77368 | 25053 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 990X Dolores St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | ||
| 121202 | 121202 | 27482 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 990X Dolores St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/20/1999 12:00:00 AM | 20 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | ||
| 127082 | 127082 | 25055 | DPW Maintained 3 | Brahea edulis :: Guadalupe Palm 115 | 990X Dolores St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 6005038.29077 | 2102581.9809991 | 37.7535746757806 | -122.425487524624 | (37.7535746757806, -122.425487524624) | |||
| 99315 | 99315 | 3751 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 990 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 42 | 18 | 6012435.5557064 | 2103342.2152382 | 37.756077292734105 | -122.399959384248 | (37.7560772927341, -122.399959384248) | |||
| 111105 | 111105 | 91265 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 986x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | ||
| 80089 | 80089 | 91264 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 978X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.5214949995 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | ||
| 111728 | 111728 | 91263 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 970x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.42326893177601 | (37.7556426634019, -122.423268931776) | ||
| 76128 | 76128 | 10 | DPW Maintained 3 | Palm (unknown Genus) :: Palm Spp 161 | 97 12th St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 107073 | 107073 | 12 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 97 12th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 118070 | 118070 | 11 | DPW Maintained 3 | Palm (unknown Genus) :: Palm Spp 161 | 97 12th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 101290 | 101290 | 111777 | Undocumented 2 | Tree(s) :: 17 | 96 CRESTLINE DR | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5998960.0 | 2102304.0 | 37.7524661019794 | -122.446487505153 | (37.7524661019794, -122.446487505153) | ||||
| 78847 | 78847 | 91259 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 952x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | ||
| 58718 | 58718 | 22877 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
| 78560 | 78560 | 22874 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 951X Mansell St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
| 105143 | 105143 | 30138 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 951X Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6009107.481074 | 2089998.6414299998 | 37.7192526227275 | -122.410526818188 | (37.7192526227275, -122.410526818188) | ||||
| 108340 | 108340 | 22875 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 951X Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | |||
| 113957 | 113957 | 22878 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 951X Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 3 | 3X100 | 6009106.075933999 | 2090003.4402518997 | 37.7192657205166 | -122.410532013931 | (37.7192657205166, -122.410532013931) | ||
| 142285 | 142285 | 30137 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 951X Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 6009107.481074 | 2089998.6414299998 | 37.7192526227275 | -122.410526818188 | (37.7192526227275, -122.410526818188) | ||||
| 23703 | 23703 | 208278 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 5995821.66146 | 2098283.4994200002 | 37.7412470549149 | -122.457049545217 | (37.7412470549149, -122.457049545217) | |||
| 46084 | 46084 | 208281 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995743.57726 | 2098234.61643 | 37.7411083497847 | -122.45731599545401 | (37.7411083497847, -122.457315995454) | |||
| 57099 | 57099 | 208282 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995723.55413 | 2098221.53866 | 37.7410712913969 | -122.45738428187 | (37.7410712913969, -122.45738428187) | |||
| 63941 | 63941 | 208280 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995763.59231 | 2098247.3088599998 | 37.74114434962 | -122.45724770903799 | (37.74114434962, -122.457247709038) | |||
| 138026 | 138026 | 208274 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5995908.48685 | 2098342.99725 | 37.7414154070883 | -122.45675363769399 | (37.7414154070883, -122.456753637694) | |||
| 147387 | 147387 | 208273 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5996028.98695 | 2098420.3004400004 | 37.7416345808626 | -122.456342580972 | (37.7416345808626, -122.456342580972) | |||
| 167354 | 167354 | 208277 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995843.660130001 | 2098298.46411 | 37.741289407571294 | -122.45697456424601 | (37.7412894075713, -122.456974564246) | |||
| 169529 | 169529 | 208276 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 3ft | 5995860.94135 | 2098310.0569599997 | 37.7413222310459 | -122.456915650551 | (37.7413222310459, -122.456915650551) | |||
| 178847 | 178847 | 208279 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5995785.55074 | 2098260.3465 | 37.7411814088878 | -122.457172728052 | (37.7411814088878, -122.457172728052) | |||
| 179257 | 179257 | 208275 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 5995884.520690001 | 2098326.53098 | 37.741368818629 | -122.456835313194 | (37.741368818629, -122.456835313194) | |||
| 182909 | 182909 | 208283 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 950x Portola Dr | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 3ft | 5995702.361819999 | 2098208.0995400003 | 37.74103317363429 | -122.45745658465401 | (37.7410331736343, -122.457456584654) | |||
| 113330 | 113330 | 23300 | DPW Maintained 3 | Eucalyptus melliodora :: Yellow Box 416 | 950X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.42096625602301 | (37.7844601942992, -122.420966256023) | |||
| 116606 | 116606 | 23301 | DPW Maintained 3 | Eucalyptus melliodora :: Yellow Box 416 | 950X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006575.9602707 | 2113798.8129121 | 37.7844601942992 | -122.42096625602301 | (37.7844601942992, -122.420966256023) | |||
| 1361 | 1361 | 16698 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 950X Noriega St | 2 | Median : Cutout 11 | Landscaping 2 | DPW 2 | 12 | 8 | 5991017.9677099995 | 2103156.31666 | 37.7543495107367 | -122.47401428523999 | (37.7543495107367, -122.47401428524) | |||
| 18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
| 22280 | 22280 | 16692 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2016 08:08:00 AM | 3 | 8 | 5990985.786309999 | 2103156.72144 | 37.7543487579916 | -122.474125605135 | (37.7543487579916, -122.474125605135) | ||
| 101466 | 101466 | 91258 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 948x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005688.196047001 | 2103445.549621 | 37.755982533848794 | -122.423301390711 | (37.7559825338488, -122.423301390711) | ||
| 20585 | 20585 | 16345 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 946X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5995755.81545 | 2094589.49777 | 37.731100446724206 | -122.457010084748 | (37.7311004467242, -122.457010084748) | ||
| 21903 | 21903 | 16349 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 946X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995791.20776 | 2094597.86 | 37.731125439778204 | -122.45688833275699 | (37.7311254397782, -122.456888332757) | ||
| 108090 | 108090 | 91255 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 940x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | ||
| 118503 | 118503 | 91256 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 940X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | ||
| 9896 | 9896 | 3746 | DPW Maintained 3 | Melaleuca styphelliodes :: Paperbark Tree 239 | 935X Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012507.0 | 2103301.0 | 37.755968107630295 | -122.399709410552 | (37.7559681076303, -122.399709410552) | |||
| 120892 | 120892 | 3749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 934 Carolina St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6012421.507139799 | 2103592.6632765 | 37.756764184951 | -122.40002555654199 | (37.756764184951, -122.400025556542) | |||
| 138569 | 138569 | 3747 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 934 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 18 | 6012421.507139799 | 2103592.6632765 | 37.756764184951 | -122.40002555654199 | (37.756764184951, -122.400025556542) | |||
| 103676 | 103676 | 26760 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 930X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 5 | 5995872.4804074 | 2094645.0571617 | 37.731259698358 | -122.456610772668 | (37.731259698358, -122.456610772668) | ||
| 128795 | 128795 | 91254 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 928x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.9790819995 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | ||
| 9909 | 9909 | 173722 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 928 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6012423.0 | 2103596.0 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | |||
| 18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
| 19627 | 19627 | 16344 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.8098799998 | 37.7312858527477 | -122.45615279610901 | (37.7312858527477, -122.456152796109) | ||
| 19703 | 19703 | 16350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646602995 | -122.45627777310601 | (37.731261646603, -122.456277773106) | ||
| 9879 | 9879 | 173721 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 922 Carolina St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 9888 | 9888 | 173719 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 922 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 3x3 | 6012422.0 | 2103621.0 | 37.7568420188621 | -122.40002584196199 | (37.7568420188621, -122.400025841962) | |||
| 34340 | 34340 | 200271 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014518.22002 | 2089293.0618599998 | 37.7176170965211 | -122.391774477626 | (37.7176170965211, -122.391774477626) | |||
| 39056 | 39056 | 200272 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014501.14248 | 2089299.14768 | 37.7176328589541 | -122.39183393271401 | (37.7176328589541, -122.391833932714) | |||
| 41784 | 41784 | 194394 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 920x Jamestown Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 19 | Width 5ft | 6014490.42947 | 2089308.0420799998 | 37.717656686497506 | -122.39187158462799 | (37.7176566864975, -122.391871584628) | |||
| 49142 | 49142 | 200274 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014408.1626699995 | 2089360.68754 | 37.7177966731557 | -122.392159625791 | (37.7177966731557, -122.392159625791) | |||
| 73694 | 73694 | 188195 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014470.00417 | 2089321.4715900002 | 37.717692427352 | -122.391943124797 | (37.717692427352, -122.391943124797) | |||
| 132906 | 132906 | 198004 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 920x Jamestown Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 6014389.315880001 | 2089371.37328 | 37.7178249676301 | -122.39222551819401 | (37.7178249676301, -122.392225518194) | |||
| 159414 | 159414 | 188194 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014479.07323 | 2089312.06804 | 37.717667110539395 | -122.391911119697 | (37.7176671105394, -122.391911119697) | |||
| 163682 | 163682 | 188196 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014458.158419999 | 2089328.2197 | 37.7177102986816 | -122.39198454217698 | (37.7177102986816, -122.391984542177) | |||
| 164766 | 164766 | 200273 | DPW Maintained 3 | Liquidambar styraciflua :: American Sweet Gum 62 | 920x Jamestown Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 5ft | 6014418.93045 | 2089354.50359 | 37.7177802911084 | -122.392121973844 | (37.7177802911084, -122.392121973844) | |||
| 178207 | 178207 | 198003 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 920x Jamestown Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 6014527.01214 | 2089285.60779 | 37.7175971171782 | -122.391743566112 | (37.7175971171782, -122.391743566112) | |||
| 183163 | 183163 | 188197 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 920x Jamestown Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 5ft | 6014447.456130001 | 2089337.65595 | 37.717735614585294 | -122.39202219499501 | (37.7177356145853, -122.392022194995) |
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");