Street_Tree_List

Data source: data.sfgov.org

4,665 rows where qSiteInfo = 11

View and edit SQL

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
213 28640 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1300 Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003714.7015 2113244.5448 37.782776612799296 -122.430825656777 (37.7827766127993, -122.430825656777)
215 17196 DPW Maintained 3 Magnolia grandiflora :: Southern Magnolia 21 2235X Octavia St 5 Median : Cutout 11 Tree 1 DPW 2     24 20   6004629.787409999 2116932.39582 37.792954330542 -122.42792271466601 (37.792954330542, -122.427922714666)
223 23789 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     20 20   6003791.7059 2112684.1999 37.7812424081927 -122.43051925893299 (37.7812424081927, -122.430519258933)
248 23733 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 800X Webster St 8 Median : Cutout 11 Tree 1 DPW 2     35 20   6003923.026000001 2111743.9893 37.7786682616238 -122.429997867276 (37.7786682616238, -122.429997867276)
497 14419 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 7 Median : Cutout 11 Tree 1 DPW 2     35     5998835.1676 2113089.5942 37.7820734871416 -122.447695558807 (37.7820734871416, -122.447695558807)
503 8533 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2100 Geary Blvd 4 Median : Cutout 11 Tree 1 DPW 2     18 6   6001504.6387 2113566.4305 37.783534963845 -122.43849459602801 (37.783534963845, -122.438494596028)
605 23903 DPW Maintained 3 Prunus serrulata :: Ornamental Cherry 35 1600X Webster St 6 Median : Cutout 11 Tree 1 DPW 2     3 6   6003560.4697 2114360.5617 37.7858321751093 -122.431438928251 (37.7858321751093, -122.431438928251)
656 23200 DPW Maintained 3 Eucalyptus globulus :: Blue Gum 103 520X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2     30 9   6006725.22564 2112390.29825 37.7806011691535 -122.420349841196 (37.7806011691535, -122.420349841196)
724 25734 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 4 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
727 221435 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:58:00 AM 1 Width 3ft   6005438.10251 2108158.21074 37.768908269319795 -122.424501499347 (37.7689082693198, -122.424501499347)
733 221433 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 6 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:32:00 AM 1 Width 3ft   6005435.4614 2108218.9893400003 37.7690750036386 -122.42451495861201 (37.7690750036386, -122.424514958612)
737 221436 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 9 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:05:00 AM 1 Width 3ft   6005440.21619 2108132.10005 37.768836694985396 -122.424492330751 (37.7688366949854, -122.424492330751)
745 221429 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 2 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:39:00 AM 1 Width 3ft   6005428.96653 2108339.30361 37.76940499098671 -122.424545983407 (37.7694049909867, -122.424545983407)
754 221432 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 5 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:53:00 AM 1 Width 3ft   6005434.00046 2108253.10785 37.769168602384205 -122.42452243915301 (37.7691686023842, -122.424522439153)
759 221434 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 7 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:56:00 AM 1 Width 3ft   6005437.11129 2108190.56795 37.7689970584876 -122.42450722982001 (37.7689970584876, -122.42450722982)
766 221431 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:43:00 AM 1 Width 3ft   6005433.2519 2108280.1340799998 37.769242767658 -122.424526951068 (37.769242767658, -122.424526951068)
772 221430 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:19:00 AM 1 Width 3ft   6005430.67341 2108312.23866 37.7693307735195 -122.424538153922 (37.7693307735195, -122.424538153922)
773 221437 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:48:00 AM 1 Width 3ft   6005441.98545 2108105.3361400003 37.7687633076137 -122.424484307027 (37.7687633076137, -122.424484307027)
787 221428 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100x Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:47:00 AM 1 Width 3ft   6005427.7802 2108362.05998 37.769467407522896 -122.424551705821 (37.7694674075229, -122.424551705821)
815 8534 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2100 Geary Blvd 5 Median : Cutout 11 Tree 1 DPW 2   06/10/1994 12:00:00 AM 6 6   6001381.7916 2113512.2830000003 37.78337929999999 -122.43891571692801 (37.7833793, -122.438915716928)
828 8634 DPW Maintained 3 Myoporum laetum :: Myoporum 1 2600 Geary Blvd 22 Median : Cutout 11 Tree 1 DPW 2     6 20   5999136.363 2113194.1665 37.7823778250539 -122.44666108993299 (37.7823778250539, -122.446661089933)
890 23729 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 800X Webster St 4 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 6   6003943.6522 2111620.2321 37.7783296231018 -122.42991768322901 (37.7783296231018, -122.429917683229)
1116 8576 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 2200 Geary Blvd 3 Median : Cutout 11 Tree 1 DPW 2     48 6   6001010.5429 2113459.32 37.7832127479531 -122.440196288881 (37.7832127479531, -122.440196288881)
1149 19194 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 150 Sanchez St 1 Median : Cutout 11 Tree 1 DPW 2     25 3X3   6003510.8594 2107438.4604 37.7668229855288 -122.43111632094801 (37.7668229855288, -122.431116320948)
1183 119797 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1185 119832 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1187 119794 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1189 119798 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1191 119838 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1192 119753 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1194 119795 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1196 119750 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1199 119799 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1201 119839 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1202 119754 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1203 119796 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1204 119749 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1206 119801 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1207 119793 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1208 119803 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1209 119800 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 201x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1211 119836 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1212 119828 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1213 119747 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1219 119829 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1222 119837 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1223 119752 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1226 119830 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1227 119736 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1228 119831 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1230 119834 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1231 119833 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 301x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1233 119757 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 119748 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 119756 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1293 87727 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2238X Van Ness Ave 5 Median : Cutout 11 Tree 1 DPW 2   01/25/2008 12:00:00 AM 3 3x3   6005927.4039 2118140.07713 37.7963436433 -122.42351878677799 (37.7963436433, -122.423518786778)
1312 25735 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 500X The Embarcadero 5 Median : Cutout 11 Tree 1 Port 9   08/15/1996 12:00:00 AM 16 10   6013816.07307 2118422.78251 37.7975619881486 -122.396241959692 (37.7975619881486, -122.396241959692)
1347 251504 DPW Maintained 3 Pinus radiata :: Monterey Pine 3 620x Noriega St 1 Median : Cutout 11 Tree 1 DPW 2       3x3   5992030.0 2103590.0 37.7555988620986 -122.470546036282 (37.7555988620986, -122.470546036282)
1355 29680 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1900X Van Ness Ave 3 Median : Cutout 11 Tree 1 DPW 2     3     6006072.343230001 2117086.04016 37.7934577026643 -122.422942314134 (37.7934577026643, -122.422942314134)
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)
1379 25668 Permitted Site 1 Phoenix canariensis :: Canary Island Date Palm 100 450X The Embarcadero 1 Median : Cutout 11 Tree 1 Port 9   12/18/2000 12:00:00 AM 36 15   6014174.0749699995 2117868.41683 37.796059744425996 -122.394964320767 (37.796059744426, -122.394964320767)
1392 29683 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1900X Van Ness Ave 6 Median : Cutout 11 Tree 1 DPW 2   02/11/2012 12:00:00 AM 5     6006051.34304 2117188.93929 37.793739052873704 -122.423022293545 (37.7937390528737, -122.423022293545)
1473 23922 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1700X Webster St 4 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 12x1   6003506.5026 2114704.4246 37.786773277055204 -122.431650198179 (37.7867732770552, -122.431650198179)
1529 251578 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 6 Median : Cutout 11 Tree 1 DPW 2                    
1535 28642 DPW Maintained 3 Prunus cerasifera :: Cherry Plum 16 1300 Webster St 4 Median : Cutout 11 Tree 1 DPW 2     10 20   6003705.0759 2113297.4854 37.782921429068395 -122.430862736641 (37.7829214290684, -122.430862736641)
1548 8472 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 9 Median : Cutout 11 Tree 1 DPW 2     6 8   6002074.2026 2113678.2789 37.7838744530021 -122.436532136471 (37.7838744530021, -122.436532136471)
1561 8580 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2200 Geary Blvd 7 Median : Cutout 11 Tree 1 DPW 2   06/01/1994 12:00:00 AM 6 6   6000778.3855 2113430.8926 37.783121473536795 -122.44099741813 (37.7831214735368, -122.44099741813)
1594 4731 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1175X Columbus Ave 2 Median : Cutout 11 Tree 1 DPW 2     14 3x3   6007886.219880001 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043)
1597 4669 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 600X Columbus Ave 4 Median : Cutout 11 Tree 1 DPW 2   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711)
1653 14428 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 4 Median : Cutout 11 Tree 1 DPW 2     70 12   5998837.5365 2113112.2684 37.782135879985205 -122.447688996293 (37.7821358799852, -122.447688996293)
1703 29682 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 1900X Van Ness Ave 5 Median : Cutout 11 Tree 1 DPW 2     3     6006057.50051 2117137.8264200003 37.7935990572132 -122.422997353566 (37.7935990572132, -122.422997353566)
1722 23787 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 2 Median : Cutout 11 Tree 1 DPW 2   04/21/2008 12:00:00 AM 3 20   6003801.3315 2112607.883 37.781033406276705 -122.430480512141 (37.7810334062767, -122.430480512141)
1760 14433 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 2X Masonic Ave 5 Median : Cutout 11 Tree 1 DPW 2     50 3X3   5998837.1981 2113100.4237 37.7821033381799 -122.447689314061 (37.7821033381799, -122.447689314061)
1776 8585 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2200 Geary Blvd 12 Median : Cutout 11 Tree 1 DPW 2   06/01/1994 12:00:00 AM 6 6   6000465.007 2113386.3901 37.78298142730029 -122.442078382069 (37.7829814273003, -122.442078382069)
1796 29783 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2000X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2   04/18/2008 12:00:00 AM 3     6006016.33701 2117432.70817 37.794406405577 -122.423160753176 (37.794406405577, -122.423160753176)
1851 4718 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1000X Columbus Ave 5 Median : Cutout 11 Tree 1 DPW 2     80 3   6008205.1504 2120957.4944 37.804207866952204 -122.415836885075 (37.8042078669522, -122.415836885075)
1879 221463 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 300x Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   06/08/2017 12:00:00 AM 3 Width 3ft   6005505.30672 2106900.54865 37.7654588242817 -122.42417958883301 (37.7654588242817, -122.424179588833)
1901 23857 DPW Maintained 3 Platanus x hispanica :: Sycamore: London Plane 15 1400X Webster St 2 Median : Cutout 11 Tree 1 DPW 2     20 3X3   6003664.511 2113605.5032 37.7837648703142 -122.431025065183 (37.7837648703142, -122.431025065183)
1958 23757 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 900X Webster St 3 Median : Cutout 11 Tree 1 DPW 2     25 20   6003900.3372 2111922.0621 37.7791559204238 -122.43008906318701 (37.7791559204238, -122.430089063187)
1982 118349 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 4 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:43:00 AM 3              
2009 16358 DPW Maintained 3 Populus tremuloides :: Quaking aspen 166 1306X Montgomery St 2 Median : Cutout 11 Tree 1 DPW 2     42 8   6011461.03473 2119844.77729 37.8013351180737 -122.40449121329901 (37.8013351180737, -122.404491213299)
2125 117673 DPW Maintained 3 Metrosideros excelsa :: New Zealand Xmas Tree 2 7600x Geary Blvd 2 Median : Cutout 11 Tree 1 DPW 2     23 Width 6ft   5983555.0 2112529.0 37.779649107322506 -122.50051568716002 (37.7796491073225, -122.50051568716)
2139 23790 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 1100X Webster St 5 Median : Cutout 11 Tree 1 DPW 2     20 20   6003786.8931 2112715.8268 37.7813289751352 -122.43053816621901 (37.7813289751352, -122.430538166219)
2168 118346 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 1 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:47:00 AM 3              
2263 22364 Landmark tree 9 Schinus terebinthifolius :: Brazilian Pepper 25 5490X 03rd St 1 Median : Cutout 11 Tree 1 DPW 2     48 40TR   6014151.6099 2093070.9929 37.7279701830365 -122.393305916851 (37.7279701830365, -122.393305916851)
2284 23758 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 900X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     25 20   6003894.1493 2111953.6889 37.7792424093118 -122.43011272647199 (37.7792424093118, -122.430112726472)
2297 23709 DPW Maintained 3 Liquidambar styraciflua :: American Sweet Gum 62 700X Webster St 4 Median : Cutout 11 Tree 1 DPW 2     16 20   6003970.4427 2111382.6873 37.7776789009548 -122.429808057223 (37.7776789009548, -122.429808057223)
2531 8603 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 2400 Geary Blvd 3 Median : Cutout 11 Tree 1 DPW 2     36 6   5999987.1554 2113318.7057 37.782768340075606 -122.443726682203 (37.7827683400756, -122.443726682203)
2581 107490 DPW Maintained 3 Prunus spp :: Cherry 84 1306x Montgomery St 19 Median : Cutout 11 Tree 1 DPW 2     12     6011447.18476 2119974.7633599997 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963)
2620 23170 DPW Maintained 3 Corymbia ficifolia :: Red Flowering Gum 60 202X Van Ness Ave 2 Median : Cutout 11 Tree 1 DPW 2     30 9   6006871.78386 2111296.65749 37.7776065535391 -122.41976520271601 (37.7776065535391, -122.419765202716)
2677 23213 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 602X Van Ness Ave 1 Median : Cutout 11 Tree 1 DPW 2   06/09/2005 12:00:00 AM 6 3X3   6006690.71989 2112642.67217 37.7812921821228 -122.42048713258998 (37.7812921821228, -122.42048713259)
2766 118353 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 8 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 05:58:00 AM 3              
2871 16699 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 900 Noriega St 3 Median : Cutout 11 Tree 1 DPW 2   08/10/2017 12:00:00 AM 3 8   5991131.39821 2103159.65216 37.7543652389679 -122.473622260865 (37.7543652389679, -122.473622260865)
3104 23477 DPW Maintained 3 Lophostemon confertus :: Brisbane Box 11 2400X Van Ness Ave 4 Median : Cutout 11 Tree 1 DPW 2     32 9   6005826.46835 2118791.49543 37.7981265753418 -122.423914390454 (37.7981265753418, -122.423914390454)
3111 118355 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 10 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:48:00 AM 3              
3232 253369 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 449X Trumbull St 1 Median : Cutout 11 Tree 1 Private 1       Width 10ft   6005840.0 2094317.0 37.730926169648 -122.42212790794599 (37.730926169648, -122.422127907946)
3394 118348 DPW Maintained 3 Acacia stenophylla :: Shoestring Acacia 109 100X Guerrero St 3 Median : Cutout 11 Tree 1 DPW 2   07/15/2016 06:19:00 AM 3              
3445 16362 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 1306X Montgomery St 14 Median : Cutout 11 Tree 1 DPW 2     18 8   6011452.97865 2119928.00722 37.801563196957204 -122.40452495315901 (37.8015631969572, -122.404524953159)
3463 25005 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 400X Dolores St 11 Median : Cutout 11 Tree 1 DPW 2     60 20   6004909.6221900005 2105744.1135299997 37.7622498768445 -122.426157591005 (37.7622498768445, -122.426157591005)
3479 8471 DPW Maintained 3 Pinus canariensis :: Canary Island Pine 71 1900 Geary Blvd 8 Median : Cutout 11 Tree 1 DPW 2   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.783879157642104 -122.43635890448 (37.7838791576421, -122.43635890448)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 1744.586ms · Data source: data.sfgov.org