Street_Tree_List

Data source: data.sfgov.org

99,669 rows where qLegalStatus = 2 sorted by qSiteInfo

View and edit SQL

These facets timed out: qLegalStatus

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo ▼ PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
4 207368 Undocumented 2 Ligustrum japonicum :: Japanese Privet 4 920 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 1ft   5992009.48044 2105269.9271 37.760210314285004 -122.47073935813 (37.760210314285, -122.47073935813)
9 203507 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 920 Kirkham St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 3ft   5991972.62617 2105259.8491700003 37.76018051163321 -122.470866084321 (37.7601805116332, -122.470866084321)
17 145278 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 730 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/20/2017 12:00:00 AM 0 Width 3ft Permit Number 779614 5992589.961569999 2110455.11477 37.774481011910204 -122.469109146279 (37.7744810119102, -122.469109146279)
18 96369 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 168 Cervantes Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/09/2011 12:00:00 AM 24 3x3 Permit Number 767919 6001162.44444 2121276.45677 37.8046852096195 -122.44023153767799 (37.8046852096195, -122.440231537678)
19 182260 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1471 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   5987398.0 2105276.0 37.759959232607606 -122.486688530832 (37.7599592326076, -122.486688530832)
22 203506 Undocumented 2 Agonis flexuosa :: Peppermint Willow 7 910 Kirkham St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5992059.0 2105289.0 37.760265546982495 -122.470569484113 (37.7602655469825, -122.470569484113)
34 240126 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 20 Lily St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6006399.28254 2110261.0751 37.7747364652596 -122.42132618837299 (37.7747364652596, -122.421326188373)
38 192589 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
40 222540 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002573.08856 2099992.67614 37.74632546084511 -122.433827665916 (37.7463254608451, -122.433827665916)
41 192590 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1390 Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008004.0 2110521.0 37.775540499151 -122.415793536261 (37.775540499151, -122.415793536261)
43 222539 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002564.39948 2099984.1142599997 37.7463014588556 -122.433857099823 (37.7463014588556, -122.433857099823)
52 233897 Undocumented 2 Araucaria heterophylla :: Norfolk Island Pine 24 1021 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6003182.0050800005 2102290.73647 37.75266992967379 -122.43188616810801 (37.7526699296738, -122.431886168108)
53 251187 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1 Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
62 239043 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 10 12th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6006946.59098 2109912.5632700003 37.773810376676295 -122.41940820332898 (37.7738103766763, -122.419408203329)
63 222541 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 1 Newburg St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft Permit Number 779491 6002580.9472199995 2099999.66602 37.7463450993615 -122.433800991143 (37.7463450993615, -122.433800991143)
64 138748 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1614 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000643.1477 2114229.9232 37.7853077023438 -122.441522641665 (37.7853077023438, -122.441522641665)
66 222538 Undocumented 2 Callistemon viminalis :: Weeping Bottlebrush 20 1 Newburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002556.19825 2099973.42317 37.746271638232 -122.43388469462201 (37.746271638232, -122.433884694622)
68 251188 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 1 Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6000800.0 2109063.0 37.771129578660705 -122.440609247553 (37.7711295786607, -122.440609247553)
71 251206 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 270 Trumbull St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6005145.0 2094297.0 37.7308320294825 -122.424529217878 (37.7308320294825, -122.424529217878)
81 221366 Undocumented 2 Callistemon citrinus :: Lemon Bottlebrush 28 55 Homestead St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/22/2017 12:00:00 AM 3 Width 3ft Permit Number 778991 6000992.93047 2101385.53728 37.750060130381605 -122.439391477336 (37.7500601303816, -122.439391477336)
83 130626 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 3660 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft Permit Number 779583 5996802.12344 2115996.768 37.789939408212206 -122.454939052208 (37.7899394082122, -122.454939052208)
88 251208 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4115 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5982071.0 2104840.0 37.758450113202294 -122.505079418654 (37.7584501132023, -122.505079418654)
94 201404 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 1051 Ingalls St 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1990 12:00:00 AM 14 Width 3ft   6018112.6185 2094686.77545 37.732626074632705 -122.379724665662 (37.7326260746327, -122.379724665662)
98 142074 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   6001183.1648 2110763.0502 37.7758193019084 -122.439405751925 (37.7758193019084, -122.439405751925)
101 192592 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
107 142075 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 1384X GROVE ST 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6001166.7226 2110758.8221 37.775806756879895 -122.439462326391 (37.7758067568799, -122.439462326391)
108 192593 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 1399X Mission St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6008031.0 2110483.0 37.775437677991796 -122.41569744526699 (37.7754376779918, -122.415697445267)
110 97646 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 1824 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 4x4   5988290.0 2103126.0 37.7541078738982 -122.48344595561899 (37.7541078738982, -122.483445955619)
125 119758 Undocumented 2 Maytenus boaria :: Mayten 22 151X Octavia St Frontage West 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1                    
133 218972 Undocumented 2 Fraxinus americana :: American Ash 23 742 Myra Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft Permit Number 779535 5997475.9556599995 2098006.28819 37.7405807633888 -122.451309623139 (37.7405807633888, -122.451309623139)
136 213016 Undocumented 2 Tree(s) :: 17 120 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/27/2017 12:00:00 AM 3 Width 2ft Permit Number 779661 5993626.83548 2102594.2327400004 37.7529569465285 -122.4649514087 (37.7529569465285, -122.4649514087)
142 251241 Undocumented 2 Cupressocyparis leylandii :: Leyland Cypress 34 2305 Golden Gate Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5998495.0 2111363.0 37.777313260379 -122.44874797929701 (37.777313260379, -122.448747979297)
145 111561 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 1498x Kansas St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:00:00 AM 3 3x3 Permit Number 779654 6011715.78319 2101470.3886700002 37.7508975116216 -122.40231700873699 (37.7508975116216, -122.402317008737)
155 251225 Undocumented 2 Jacaranda mimosifolia :: Jacaranda 52 1 Yukon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       12x2.5   6000238.0 2104757.0 37.7592743544717 -122.442244057145 (37.7592743544717, -122.442244057145)
161 142720 Undocumented 2 :: 54 1170 COLUMBUS AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 0ft   6007999.4825 2121188.7351 37.8048312311886 -122.416565007078 (37.8048312311886, -122.416565007078)
162 251231 Undocumented 2 Pinus radiata :: Monterey Pine 3 164 Serrano Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989598.0 2090848.0 37.7204716934452 -122.478025052476 (37.7204716934452, -122.478025052476)
166 251230 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
167 251232 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 99x Ogden Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007537.0 2096150.0 37.7360547576169 -122.416390866966 (37.7360547576169, -122.416390866966)
174 251226 Undocumented 2 Koelreuteria paniculata :: Golden Rain Tree 56 1 Yukon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       13x2.5   6000262.0 2104839.0 37.7595008741196 -122.442166940047 (37.7595008741196, -122.442166940047)
185 251243 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 299x Chapman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2       3x3   6008953.0 2098186.0 37.7417246968109 -122.411638974942 (37.7417246968109, -122.411638974942)
191 210495 Undocumented 2 Myoporum laetum :: Myoporum 1 365 San Leandro Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     21 Width 3ft Permit Number 779799 5992304.44524 2094447.3559700001 37.7305113566072 -122.468931622808 (37.7305113566072, -122.468931622808)
208 100305 Undocumented 2 Arbutus unedo :: Strawberry Tree 61 3701 Buchanan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 3x3   6003064.411830001 2121045.8637900003 37.804160163827206 -122.433633107497 (37.8041601638272, -122.433633107497)
233 121240 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 91 Commonwealth Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/07/2016 12:00:00 AM 3 3x5 Permit Number 778926 5996501.4108 2113948.5087 37.7842981813685 -122.45583135787399 (37.7842981813685, -122.455831357874)
245 251255 Undocumented 2 Tree(s) :: 17 4089x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086822.0 37.7095382490701 -122.47051450746099 (37.7095382490701, -122.470514507461)
253 251256 Undocumented 2 Gleditsia triacanthos :: Honey Locust 67 4091x Alemany Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991686.0 2086783.0 37.70943116445179 -122.470511668938 (37.7094311644518, -122.470511668938)
254 98489 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 1813 Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/2016 12:00:00 AM 3 4.5x5 Permit Number 777656 5999969.69733 2115286.35323 37.7881699939074 -122.443928497714 (37.7881699939074, -122.443928497714)
256 221894 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008618.9330400005 2101573.97925 37.75100859049479 -122.41303356944799 (37.7510085904948, -122.413033569448)
257 251260 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1163 South Van Ness Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6007684.87734 2102881.8281400003 37.754547168222295 -122.41635626045701 (37.7545471682223, -122.416356260457)
258 251259 Undocumented 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 1050x Sacramento St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6009753.0 2116795.0 37.7928655753561 -122.410186352148 (37.7928655753561, -122.410186352148)
259 141361 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
260 221893 Undocumented 2 Geijera parviflora :: Australian Willow 68 3164 25th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6008601.79804 2101572.78068 37.751004337584796 -122.41309273944599 (37.7510043375848, -122.413092739446)
261 141359 Undocumented 2 Olea europaea :: Olive Tree 41 1499X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
262 141360 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 1499X Hayes St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
263 141358 Undocumented 2 Myoporum laetum :: Myoporum 1 1499X Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6000919.0 2110350.0 37.77467013322371 -122.44028993459101 (37.7746701332237, -122.440289934591)
266 173827 Undocumented 2 Tree(s) :: 17 1200 04th St 12 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
267 175151 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Santa Rosa Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 Width 3ft Permit Number 779495 6000727.04119 2093604.3094 37.728679573387495 -122.43975313162399 (37.7286795733875, -122.439753131624)
271 175152 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 285 Santa Rosa Ave 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 Width 3ft Permit Number 779495 6000750.8705 2093589.3929700002 37.728639972642604 -122.43966968351002 (37.7286399726426, -122.43966968351)
274 173825 Undocumented 2 Tree(s) :: 17 1200 04th St 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
276 173808 Undocumented 2 Tree(s) :: 17 1201 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
280 194427 Undocumented 2 Pinus canariensis :: Canary Island Pine 71 905 Minna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
282 173829 Undocumented 2 Tree(s) :: 17 1200 04th St 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
283 173821 Undocumented 2 Tree(s) :: 17 1200 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
285 98003 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 1904 Filbert St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 4x12   6003782.57859 2119037.12075 37.7986853996597 -122.431004385541 (37.7986853996597, -122.431004385541)
287 173824 Undocumented 2 Tree(s) :: 17 1200 04th St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
289 173826 Undocumented 2 Tree(s) :: 17 1200 04th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
290 173809 Undocumented 2 Tree(s) :: 17 1201 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
298 173822 Undocumented 2 Tree(s) :: 17 1200 04th St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
299 196427 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 25 McLea Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6010117.0 2109248.0 37.772163696411795 -122.408394314545 (37.7721636964118, -122.408394314545)
301 173819 Undocumented 2 Tree(s) :: 17 1200 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
302 187663 Undocumented 2 Tree(s) :: 17 1155 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779411 6015039.0 2109715.0 37.77372037595529 -122.391401215397 (37.7737203759553, -122.391401215397)
303 196320 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 905 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
304 173811 Undocumented 2 Tree(s) :: 17 1201 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
305 191509 Undocumented 2 Ligustrum lucidum :: Glossy Privet 55 905 Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6008110.0 2110227.0 37.774739203286295 -122.415406037323 (37.7747392032863, -122.415406037323)
306 173816 Undocumented 2 Tree(s) :: 17 1200 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
307 173828 Undocumented 2 Tree(s) :: 17 1200 04th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
311 173810 Undocumented 2 Tree(s) :: 17 1201 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779410 6015204.0 2109228.0 37.772392338117704 -122.390796408976 (37.7723923381177, -122.390796408976)
314 173820 Undocumented 2 Tree(s) :: 17 1200 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/03/2017 12:00:00 AM 3 3x3 Permit Number 779409 6015021.0 2109379.0 37.7727967954964 -122.39143998666 (37.7727967954964, -122.39143998666)
327 191528 Undocumented 2 Liquidambar styraciflua :: American Sweet Gum 62 201 16th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/04/2017 12:00:00 AM 3 Width 5ft   6016052.47786 2107208.19392 37.76689343092 -122.38772046693501 (37.76689343092, -122.387720466935)
328 251272 Undocumented 2 Acer negundo :: Box Elder 74 1301X 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
333 242579 Undocumented 2 Ulmus parvifolia :: Chinese Elm 46 818 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2016 12:00:00 AM 11 Width 3ft Permit Number 778239 6001257.943419999 2101462.97247 37.7502878270446 -122.438480597209 (37.7502878270446, -122.438480597209)
334 246360 Undocumented 2 Washingtonia robusta :: Mexican Fan Palm 75 1932 Mission St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 0ft   6006755.8259 2107130.7038 37.76616130474321 -122.419870652653 (37.7661613047432, -122.419870652653)
339 251273 Undocumented 2 Acer negundo :: Box Elder 74 1301X 07th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5993949.0 2106317.0 37.7631972735035 -122.46410754142299 (37.7631972735035, -122.464107541423)
354 93479 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 113X Leroy Pl 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 1.5x3 Tree 4 on Leroy 6008317.250990001 2116630.80353 37.792334150853 -122.415142500331 (37.792334150853, -122.415142500331)
355 182552 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986555.5107 2105693.4321 37.7610562355745 -122.489632951355 (37.7610562355745, -122.489632951355)
357 181338 Undocumented 2 Quercus ilex :: Holly Oak 78 1220 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 0ft   5987427.0 2106942.0 37.7645353017913 -122.486710570648 (37.7645353017913, -122.486710570648)
364 182551 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986541.5452 2105693.4321 37.7610554202125 -122.489681251316 (37.7610554202125, -122.489681251316)
379 122497 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 31X 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6008445.21835 2111601.2724900004 37.7785314648928 -122.414343702699 (37.7785314648928, -122.414343702699)
383 181340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5988678.0351 2106085.8063 37.7622572799997 -122.48232089502501 (37.7622572799997, -122.482320895025)
411 154366 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 411 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   6006164.37856 2107202.76015 37.7663258166161 -122.42192147568899 (37.7663258166161, -122.421921475689)
423 109554 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300x Van Ness Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
429 142788 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 733 POLK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft Polk St Scape will replant 6007029.0497 2113497.6534 37.7836588132661 -122.419377346786 (37.7836588132661, -122.419377346786)
434 136390 Undocumented 2 Tree(s) :: 17 3395 Sacramento St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 Width 5ft Permit Number 779746 5998765.27001 2115243.09553 37.787982442971604 -122.448092477507 (37.7879824429716, -122.448092477507)
439 136984 Undocumented 2 Tree(s) :: 17 454 Walnut St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 Width 4ft Permit Number 779785 5998641.89853 2115102.68231 37.7875898520492 -122.448509202661 (37.7875898520492, -122.448509202661)
448 224849 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
450 142159 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 490X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
452 221749 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
454 251309 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2111 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
457 142162 Undocumented 2 Prunus spp :: Cherry 84 490X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
458 221750 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
460 142327 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1652 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)

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 3244.9ms · Data source: data.sfgov.org