Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qCaretaker, PlantDate, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6919 | 6919 | 8636 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2600 Geary Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999097.4445 | 2113192.4744 | 37.782370955794605 | -122.446795608488 | (37.7823709557946, -122.446795608488) | |||
20454 | 20454 | 11707 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 700X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991285.0756 | 2092761.86788 | 37.7258244795155 | -122.47233287588399 | (37.7258244795155, -122.472332875884) | ||
20519 | 20519 | 29614 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 900X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.98096 | 2090921.81223 | 37.720765307364395 | -122.47260702069599 | (37.7207653073644, -122.472607020696) | ||
35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
42056 | 42056 | 200548 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016205.9984 | 2095634.3174 | 37.7351224834655 | -122.38638241900699 | (37.7351224834655, -122.386382419007) | |||
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) | |||
46615 | 46615 | 180033 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001110.15786 | 2091253.57403 | 37.722246789330896 | -122.43826034064699 | (37.7222467893309, -122.438260340647) | |||
51994 | 51994 | 180057 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000730.46127 | 2090524.7556599998 | 37.7202240162157 | -122.439520637988 | (37.7202240162157, -122.439520637988) | |||
66442 | 66442 | 212308 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991201.47803 | 2090397.56088 | 37.7193278390954 | -122.47244957640801 | (37.7193278390954, -122.472449576408) | |||
83096 | 83096 | 205094 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991307.287769999 | 2092102.83038 | 37.7240162117682 | -122.47220807246599 | (37.7240162117682, -122.472208072466) | |||
83555 | 83555 | 458 | DPW Maintained 3 | Ficus rubiginosa :: Port Jackson Fig 188 | 760x 23rd Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5988831.51293 | 2110000.66067 | 37.7730153231025 | -122.482076888223 | (37.7730153231025, -122.482076888223) | ||||
87603 | 87603 | 30152 | DPW Maintained 3 | Eucalyptus lehmanni :: Bushy Yate 267 | 410X Mansell St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
89220 | 89220 | 30088 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | ||
100705 | 100705 | 122895 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
106081 | 106081 | 99140 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 24 | Median : Cutout 11 | Tree 1 | Private 1 | 12 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
110313 | 110313 | 106397 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
114644 | 114644 | 6532 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017378.72501 | 2097246.19501 | 37.739613223073796 | -122.38243995218599 | (37.7396132230738, -122.382439952186) | |||
116777 | 116777 | 5007 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 5300 Diamond Heights Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
117831 | 117831 | 30043 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | |||
130335 | 130335 | 176324 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 43 | Width 0ft | 6009336.81226 | 2089985.3560799998 | 37.719228998190204 | -122.409733166348 | (37.7192289981902, -122.409733166348) | |||
133610 | 133610 | 208216 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 3ft | 5992307.91679 | 2096752.65756 | 37.736841338265 | -122.46908733322701 | (37.736841338265, -122.469087333227) | |||
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) | |||
138329 | 138329 | 115329 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
148971 | 148971 | 215030 | DPW Maintained 3 | Sequoia sempervirens :: Coast Redwood 116 | 300x Marietta Dr | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 5999282.59402 | 2097567.7247599997 | 37.7394798538026 | -122.44503146673401 | (37.7394798538026, -122.445031466734) | |||
150184 | 150184 | 205117 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 5991421.73264 | 2093902.55265 | 37.7289644237558 | -122.471943567458 | (37.7289644237558, -122.471943567458) | |||
154731 | 154731 | 222787 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 6ft | 6010096.17882 | 2100593.44521 | 37.748399076272 | -122.40785594761499 | (37.748399076272, -122.407855947615) | |||
157694 | 157694 | 210557 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 5ft | 5993258.3817300005 | 2100285.93498 | 37.746597700037604 | -122.466057859008 | (37.7465977000376, -122.466057859008) | |||
180482 | 180482 | 217529 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 5996247.03619 | 2089001.7982400001 | 37.7157861460877 | -122.45490827471599 | (37.7157861460877, -122.454908274716) |
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");