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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4979 | 4979 | 8629 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 20 | 5999229.0905 | 2113208.3802 | 37.78242214856029 | -122.44634131765899 | (37.7824221485603, -122.446341317659) | |||
13219 | 13219 | 24279 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 350X Winding Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6000809.6312 | 2086798.35513 | 37.709996659695 | -122.43898005820299 | (37.709996659695, -122.438980058203) | |||
15309 | 15309 | 6525 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/14/2006 12:00:00 AM | 3 | 15 | 6017423.67126 | 2097218.66072 | 37.7395401020993 | -122.382282630765 | (37.7395401020993, -122.382282630765) | ||
17215 | 17215 | 29296 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 400X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5997789.65443 | 2099947.6050400003 | 37.745929104439796 | -122.450364887145 | (37.7459291044398, -122.450364887145) | ||
18063 | 18063 | 11685 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.62257 | 2092826.93511 | 37.726003458970105 | -122.472318441739 | (37.7260034589701, -122.472318441739) | ||
18901 | 18901 | 29590 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991297.67299 | 2091930.7639 | 37.723543203431504 | -122.47222877213301 | (37.7235432034315, -122.472228772133) | ||
19688 | 19688 | 29608 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 900X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991185.36807 | 2091033.22274 | 37.721072277433 | -122.472551581098 | (37.721072277433, -122.472551581098) | ||
20786 | 20786 | 29273 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998795.79674 | 2100195.7409 | 37.746667956864705 | -122.446903651091 | (37.7466679568647, -122.446903651091) | ||
21414 | 21414 | 29328 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1250X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5993805.9299800005 | 2097861.77346 | 37.7399731364485 | -122.463988569318 | (37.7399731364485, -122.463988569318) | ||
21937 | 21937 | 29584 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 500X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 3 | 3X3 | 5991345.88941 | 2093701.3780900002 | 37.728407659786 | -122.47219110225299 | (37.728407659786, -122.472191102253) | ||
23080 | 23080 | 18562 | DPW Maintained 3 | Prunus persica :: Peach 330 | 1700X Quesada Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | 19 | 6014525.2512300005 | 2095171.8151599998 | 37.7337593670062 | -122.392161079069 | (37.7337593670062, -122.392161079069) | |||
36746 | 36746 | 180279 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1204x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6002763.71136 | 2094082.1093 | 37.7301072210706 | -122.43274636337699 | (37.7301072210706, -122.432746363377) | |||
40990 | 40990 | 234003 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 500x 27th St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 4ft | 6002888.7683 | 2100065.98913 | 37.7465446697175 | -122.432741319957 | (37.7465446697175, -122.432741319957) | |||
44888 | 44888 | 176341 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | |||
49543 | 49543 | 175621 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6009441.92296 | 2090030.92164 | 37.7193600015446 | -122.409373050849 | (37.7193600015446, -122.409373050849) | |||
52662 | 52662 | 205115 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 5991409.19346 | 2093717.97139 | 37.728456884165 | -122.471973468125 | (37.728456884165, -122.471973468125) | |||
55159 | 55159 | 180314 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1604x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6001581.90285 | 2092391.7220299998 | 37.7253987062729 | -122.436711064184 | (37.7253987062729, -122.436711064184) | |||
63471 | 63471 | 206034 | DPW Maintained 3 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 700x Monterey Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 4ft | 5996882.83192 | 2094722.4323900002 | 37.731530109506295 | -122.453123407313 | (37.7315301095063, -122.453123407313) | |||
76652 | 76652 | 180026 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001216.73931 | 2091454.85144 | 37.72280551295 | -122.437906324334 | (37.72280551295, -122.437906324334) | |||
82879 | 82879 | 2302 | DPW Maintained 3 | Cupressus arizonica :: Arizona Cypress 475 | 800X Brotherhood Way | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 14M | 5990276.209646201 | 2088591.5343604 | 37.7143153385926 | -122.47551605113199 | (37.7143153385926, -122.475516051132) | |||
84115 | 84115 | 30162 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
85419 | 85419 | 5000 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5300 Diamond Heights Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 12 | 6001419.5409281 | 2098992.5811716 | 37.743513909519294 | -122.437744874344 | (37.7435139095193, -122.437744874344) | |||
87679 | 87679 | 107117 | DPW Maintained 3 | Pseudotsuga menziesii :: Douglas Fir 231 | 300X LIBERTY ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 6004270.1 | 2103982.4 | 37.757376462852704 | -122.42824389606199 | (37.7573764628527, -122.428243896062) | ||||
89782 | 89782 | 122888 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | ||||
94915 | 94915 | 465 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 760x 23rd Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8-HOA | 5988826.12619 | 2110109.25362 | 37.773313175965 | -122.482103478364 | (37.773313175965, -122.482103478364) | |||
105689 | 105689 | 115322 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2601X Sunset Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 40 | 5985098.343425 | 2097506.3093477003 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | ||||
108467 | 108467 | 30082 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 410X Brotherhood Way | 17 | 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) | ||
115393 | 115393 | 99134 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 302X Pacheco St | 17 | Median : Cutout 11 | Tree 1 | Private 1 | 3 | 5994341.5 | 2100725.2 | 37.747866238402096 | -122.46234443277001 | (37.7478662384021, -122.46234443277) | ||||
117891 | 117891 | 8351 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1300 Geary Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 6 | 6005496.3592183 | 2114176.6024527 | 37.785436596276796 | -122.424728193484 | (37.7854365962768, -122.424728193484) | |||
119369 | 119369 | 16364 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 1300X Montgomery St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6011500.916866099 | 2119743.0722499 | 37.8010580895294 | -122.404346040012 | (37.8010580895294, -122.404346040012) | |||
120863 | 120863 | 4981 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 5200X Diamond Heights Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 12 | 6000724.3855206 | 2099633.2111664 | 37.7452333754909 | -122.440194472866 | (37.7452333754909, -122.440194472866) | |||
133613 | 133613 | 200541 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1400x La Salle Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6016186.7948 | 2095652.8098 | 37.7351721968582 | -122.386450102344 | (37.7351721968582, -122.386450102344) | |||
135350 | 135350 | 222791 | DPW Maintained 3 | Ceiba speciosa :: Silk floss 335 | 2800x Cesar Chavez St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 6ft | 6010227.86602 | 2100646.66118 | 37.7485525671486 | -122.40740432517 | (37.7485525671486, -122.40740432517) | |||
136903 | 136903 | 181233 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 2000x Bay Shore Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6011973.9880099995 | 2087758.6255 | 37.7132622770132 | -122.400461065249 | (37.7132622770132, -122.400461065249) | |||
139855 | 139855 | 11845 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
140162 | 140162 | 29351 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1500X Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/16/2006 12:00:00 AM | 3 | 3X3 | 5992236.5627249 | 2096694.9403025003 | 37.7366787380665 | -122.469329833584 | (37.7366787380665, -122.469329833584) | ||
140404 | 140404 | 114835 | DPW Maintained 3 | Syzygium paniculatum :: Brush Cherry 198 | 251x TRUMBULL ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6004998.0 | 2094336.0 | 37.7309308121175 | -122.425040194756 | (37.7309308121175, -122.425040194756) | ||||
142776 | 142776 | 106390 | DPW Maintained 3 | Tree(s) :: 17 | 182x Lower Ter | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10x10 | 6000081.12192 | 2106216.81045 | 37.763273691074204 | -122.442891445737 | (37.7632736910742, -122.442891445737) | ||||
144679 | 144679 | 106811 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 3500X MISSION ST | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
152790 | 152790 | 208209 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1600x Portola Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 3ft | 5992165.902840001 | 2096610.6536299998 | 37.7364432245654 | -122.469567999258 | (37.7364432245654, -122.469567999258) | |||
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) | |||
161257 | 161257 | 176304 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011109.46654 | 2090529.17456 | 37.7208213917675 | -122.403643980895 | (37.7208213917675, -122.403643980895) | |||
169128 | 169128 | 210094 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5996151.37066 | 2089000.9708099999 | 37.715778385846896 | -122.45523887719801 | (37.7157783858469, -122.455238877198) | |||
173119 | 173119 | 211243 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50x Santa Rita Ave | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 5ft | 5993495.594269999 | 2100380.49402 | 37.746871017502706 | -122.46524447706999 | (37.7468710175027, -122.46524447707) | |||
179210 | 179210 | 180051 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1900x Alemany Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 2ft | 6000819.2999599995 | 2090695.20934 | 37.7206970991836 | -122.43922576376801 | (37.7206970991836, -122.439225763768) | |||
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) | |||
179776 | 179776 | 205767 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 5ft | 5999244.31767 | 2097578.6483400003 | 37.7395076626552 | -122.445164594286 | (37.7395076626552, -122.445164594286) | |||
183528 | 183528 | 219372 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 400x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999397.86314 | 2097051.08053 | 37.7380678498474 | -122.444595794674 | (37.7380678498474, -122.444595794674) | |||
184198 | 184198 | 212301 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 5991188.84719 | 2090215.0879099998 | 37.7188260821255 | -122.47247994019199 | (37.7188260821255, -122.472479940192) |
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");