Street_Tree_List

Data source: data.sfgov.org

3,645 rows where qSpecies = 41 sorted by PlotSize descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize ▲ PermitNotes XCoord YCoord Latitude Longitude Location
38163 38163 194192 Undocumented 2 Olea europaea :: Olive Tree 41 1601 Kansas St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   6011834.442419999 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487)
61235 61235 232868 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 9ft   6009077.45417 2095862.97856 37.735353165298 -122.41104460722401 (37.735353165298, -122.411044607224)
65963 65963 232871 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     14 Width 9ft   6009080.3789099995 2095903.22512 37.7354638376772 -122.411037337111 (37.7354638376772, -122.411037337111)
74510 74510 131861 Undocumented 2 Olea europaea :: Olive Tree 41 3640 Lyon St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   5998876.901959999 2121298.6839099997 37.8046158502946 -122.448142451919 (37.8046158502946, -122.448142451919)
76839 76839 210860 Undocumented 2 Olea europaea :: Olive Tree 41 458 Mangels Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 9ft   5998392.85645 2095276.6341799998 37.7331382439186 -122.447942868994 (37.7331382439186, -122.447942868994)
115432 115432 210682 DPW Maintained 3 Olea europaea :: Olive Tree 41 100x Idora Ave 6 Median : Yard 3 Tree 1 DPW 2     15 Width 9ft   5995339.29404 2099412.4410200003 37.7443191354124 -122.4587991034 (37.7443191354124, -122.4587991034)
152760 152760 232869 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 9ft   6009077.71064 2095875.53633 37.7353876606063 -122.411044607225 (37.7353876606063, -122.411044607225)
169278 169278 124176 Undocumented 2 Olea europaea :: Olive Tree 41 11 Almaden Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 9ft   5995826.0985199995 2112588.51087 37.7805252097548 -122.45806922812099 (37.7805252097548, -122.458069228121)
171948 171948 194193 Undocumented 2 Olea europaea :: Olive Tree 41 1601 Kansas St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 9ft   6011834.442419999 2100473.73914 37.748167551187 -122.401836621487 (37.748167551187, -122.401836621487)
184392 184392 232870 Undocumented 2 Olea europaea :: Olive Tree 41 301 Putnam St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 9ft   6009078.53533 2095890.1763799998 37.73542790527029 -122.411042789701 (37.7354279052703, -122.411042789701)
28137 28137 131814 Undocumented 2 Olea europaea :: Olive Tree 41 145 Capra Way 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 8ft   6001091.88484 2120522.1645299997 37.802610106719996 -122.440421585107 (37.80261010672, -122.440421585107)
38995 38995 177874 Undocumented 2 Olea europaea :: Olive Tree 41 1222 Naples St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 8ft   6001049.49395 2087346.60283 37.711515671269495 -122.43819029695801 (37.7115156712695, -122.438190296958)
46191 46191 210732 Undocumented 2 Olea europaea :: Olive Tree 41 486 Arch St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 8ft   5992756.333330001 2090404.7555 37.719437465534 -122.46707559208201 (37.719437465534, -122.467075592082)
65146 65146 210687 Undocumented 2 Olea europaea :: Olive Tree 41 270 Hearst Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 8ft   5999611.40538 2094395.78433 37.7307892138454 -122.443666775201 (37.7307892138454, -122.443666775201)
132478 132478 210873 Undocumented 2 Olea europaea :: Olive Tree 41 62 Marston Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 8ft   5998923.839269999 2093227.89544 37.7275432251404 -122.445959824297 (37.7275432251404, -122.445959824297)
152737 152737 124660 Undocumented 2 Olea europaea :: Olive Tree 41 199 Arguello Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 8ft   5995479.96756 2115219.29012 37.7877287300454 -122.45945723391 (37.7877287300454, -122.45945723391)
158328 158328 131846 Undocumented 2 Olea europaea :: Olive Tree 41 3265 Baker St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   5999287.02532 2120101.46569 37.801352048703706 -122.44663699491899 (37.8013520487037, -122.446636994919)
178519 178519 131813 Undocumented 2 Olea europaea :: Olive Tree 41 145 Capra Way 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   6001082.26232 2120520.90623 37.802606103860995 -122.440454793478 (37.802606103861, -122.440454793478)
187985 187985 177913 Undocumented 2 Olea europaea :: Olive Tree 41 2924 21st Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 8ft   5990007.1003 2095790.68963 37.7340668092368 -122.476971913545 (37.7340668092368, -122.476971913545)
189009 189009 210872 Undocumented 2 Olea europaea :: Olive Tree 41 371 Staples Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 8ft   5997627.30354 2093781.8331900002 37.72899008680061 -122.450481853864 (37.7289900868006, -122.450481853864)
30412 30412 131862 Undocumented 2 Olea europaea :: Olive Tree 41 3640 Lyon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 7ft   5998877.1278 2121309.5311 37.8046456466411 -122.448142451907 (37.8046456466411, -122.448142451907)
34104 34104 120838 Undocumented 2 Olea europaea :: Olive Tree 41 55 19th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 7ft   5989873.67504 2114823.8325 37.7863189706432 -122.47882478569299 (37.7863189706432, -122.478824785693)
39645 39645 120839 Undocumented 2 Olea europaea :: Olive Tree 41 55 19th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 7ft   5989874.45589 2114802.5830900003 37.7862606710831 -122.47882052946899 (37.7862606710831, -122.478820529469)
43471 43471 232438 Undocumented 2 Olea europaea :: Olive Tree 41 550 Florida St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 7ft   6009220.36399 2105639.7439 37.762206006125396 -122.41124093103399 (37.7622060061254, -122.411240931034)
44540 44540 194234 Undocumented 2 Olea europaea :: Olive Tree 41 21 Hillview Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 7ft   6016584.85791 2095721.5603900002 37.7353829994301 -122.385078629298 (37.7353829994301, -122.385078629298)
50639 50639 194235 Undocumented 2 Olea europaea :: Olive Tree 41 19 Hillview Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 7ft   6016602.67648 2095728.9552900002 37.7354042899791 -122.385017538329 (37.7354042899791, -122.385017538329)
51140 51140 232437 Undocumented 2 Olea europaea :: Olive Tree 41 550 Florida St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 7ft   6009218.18097 2105675.07688 37.762302899984796 -122.41125097736901 (37.7623028999848, -122.411250977369)
63902 63902 194236 Undocumented 2 Olea europaea :: Olive Tree 41 17 Hillview Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 7ft   6016647.59382 2095743.55851 37.7354468719595 -122.384863257848 (37.7354468719595, -122.384863257848)
65552 65552 232439 Undocumented 2 Olea europaea :: Olive Tree 41 550 Florida St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 7ft   6009231.6785699995 2105511.08607 37.761853375653 -122.41119270939801 (37.761853375653, -122.411192709398)
76502 76502 246528 Undocumented 2 Olea europaea :: Olive Tree 41 95 Laguna St 1 : 4 Tree 1 Private 1     13 Width 7ft   6005204.62433 2109172.65839 37.7716805104709 -122.425381286315 (37.7716805104709, -122.425381286315)
146815 146815 246518 Undocumented 2 Olea europaea :: Olive Tree 41 155 Laguna St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 7ft   6005162.55314 2109484.17323 37.7725334778669 -122.42554898739701 (37.7725334778669, -122.425548987397)
149795 149795 131874 Undocumented 2 Olea europaea :: Olive Tree 41 295 Marina Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 7ft   6002038.91196 2121849.60525 37.806308784479796 -122.43723950400299 (37.8063087844798, -122.437239504003)
170404 170404 120840 Undocumented 2 Olea europaea :: Olive Tree 41 55 19th Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 7ft   5989874.85476 2114772.97102 37.7861793878304 -122.47881698293399 (37.7861793878304, -122.478816982934)
172700 172700 194171 Undocumented 2 Olea europaea :: Olive Tree 41 740 Rhode Island St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 7ft   6011792.75247 2105015.27083 37.760635274505205 -122.40230005472601 (37.7606352745052, -122.402300054726)
173781 173781 246530 Undocumented 2 Olea europaea :: Olive Tree 41 95 Laguna St 3 : 4 Tree 1 Private 1     13 Width 7ft   6005220.62037 2109069.23024 37.7713974254703 -122.42531859367901 (37.7713974254703, -122.425318593679)
174685 174685 233118 Undocumented 2 Olea europaea :: Olive Tree 41 1803 Castro St 2 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     8 Width 7ft   6002653.14547 2100266.75628 37.7470825632048 -122.43357042294201 (37.7470825632048, -122.433570422942)
183369 183369 194238 Undocumented 2 Olea europaea :: Olive Tree 41 6 Hillview Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 7ft   6016710.45664 2095786.72783 37.735568882989796 -122.384648921526 (37.7355688829898, -122.384648921526)
30305 30305 131815 Undocumented 2 Olea europaea :: Olive Tree 41 149 Alhambra St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 6ft   6001582.80517 2120278.3225 37.8019685213769 -122.438705274832 (37.8019685213769, -122.438705274832)
30938 30938 232882 Undocumented 2 Olea europaea :: Olive Tree 41 877 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 6ft   6010202.299330001 2104146.86733 37.7581619248595 -122.407739504273 (37.7581619248595, -122.407739504273)
30993 30993 246520 Undocumented 2 Olea europaea :: Olive Tree 41 155 Laguna St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6005167.3236 2109440.76034 37.772414546119705 -122.42552939567601 (37.7724145461197, -122.425529395676)
35189 35189 246522 Undocumented 2 Olea europaea :: Olive Tree 41 155 Laguna St 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6005173.7301199995 2109399.79549 37.7723024285329 -122.425504318986 (37.7723024285329, -122.425504318986)
35405 35405 210862 Undocumented 2 Olea europaea :: Olive Tree 41 412 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9 Width 6ft   5999352.48487 2094990.83835 37.7324083217769 -122.444604653878 (37.7324083217769, -122.444604653878)
44923 44923 210863 Undocumented 2 Olea europaea :: Olive Tree 41 412 Joost Ave 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   5999336.30619 2094992.2158 37.7324111807223 -122.44466068613501 (37.7324111807223, -122.444660686135)
45691 45691 246525 Undocumented 2 Olea europaea :: Olive Tree 41 155 Laguna St 8 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6005186.06731 2109316.74693 37.772075094331605 -122.425455732201 (37.7720750943316, -122.425455732201)
53458 53458 233069 Undocumented 2 Olea europaea :: Olive Tree 41 774 Duncan St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 6ft   6001540.64018 2099730.3572 37.7455465535424 -122.43737896277901 (37.7455465535424, -122.437378962779)
54766 54766 117843 DPW Maintained 3 Olea europaea :: Olive Tree 41 620x 39th Ave 4 Median : Cutout 11 Tree 1 DPW 2     9 Width 6ft   5983810.12526 2111540.49138 37.776949922870294 -122.49956003685301 (37.7769499228703, -122.499560036853)
61673 61673 194226 Undocumented 2 Olea europaea :: Olive Tree 41 2 Jakey Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6016841.98922 2095417.85433 37.734563303344295 -122.38416847851101 (37.7345633033443, -122.384168478511)
64619 64619 210660 Undocumented 2 Olea europaea :: Olive Tree 41 181 San Pablo Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     1 Width 6ft   5994349.85178 2096588.9165400001 37.7365095190008 -122.462015646523 (37.7365095190008, -122.462015646523)
66050 66050 210866 Undocumented 2 Olea europaea :: Olive Tree 41 110 Monterey Blvd 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     1 Width 6ft   6001326.245569999 2094696.7194700001 37.7317131692257 -122.437759857137 (37.7317131692257, -122.437759857137)
69761 69761 117845 DPW Maintained 3 Olea europaea :: Olive Tree 41 620x 39th Ave 2 Median : Cutout 11 Tree 1 DPW 2     23 Width 6ft   5983812.70856 2111515.33399 37.7768809995382 -122.49954924088199 (37.7768809995382, -122.499549240882)
69915 69915 210852 Undocumented 2 Olea europaea :: Olive Tree 41 330 Baden St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 6ft   6000786.85539 2095109.56492 37.732816061802 -122.439654219669 (37.732816061802, -122.439654219669)
72071 72071 120356 Undocumented 2 Olea europaea :: Olive Tree 41 2350 Lake St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   5988131.96893 2114686.1280900002 37.78583958579971 -122.48484046088001 (37.7858395857997, -122.48484046088)
76029 76029 117836 DPW Maintained 3 Olea europaea :: Olive Tree 41 660x 39th Ave 3 Median : Cutout 11 Tree 1 DPW 2     11 Width 6ft   5983819.78589 2111279.0355 37.776232607542504 -122.499507291354 (37.7762326075425, -122.499507291354)
132250 132250 232474 Undocumented 2 Olea europaea :: Olive Tree 41 2759 22nd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 6ft   6009584.16394 2103339.51156 37.755910484699506 -122.409820303469 (37.7559104846995, -122.409820303469)
151109 151109 131816 Undocumented 2 Olea europaea :: Olive Tree 41 149 Alhambra St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6001591.27048 2120267.97849 37.8019406010393 -122.43867523929801 (37.8019406010393, -122.438675239298)
151281 151281 117924 Undocumented 2 Olea europaea :: Olive Tree 41 611 41st Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     18 Width 6ft   5983159.66185 2111615.2579900003 37.7771170231905 -122.501815685868 (37.7771170231905, -122.501815685868)
152408 152408 194227 Undocumented 2 Olea europaea :: Olive Tree 41 8 Jakey Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 6ft   6016817.60054 2095485.74545 37.7347483703482 -122.384257525772 (37.7347483703482, -122.384257525772)
154625 154625 117847 DPW Maintained 3 Olea europaea :: Olive Tree 41 640x 39th Ave 4 Median : Cutout 11 Tree 1 DPW 2     12 Width 6ft   5983816.430369999 2111419.8653700002 37.7766190887274 -122.49952930905701 (37.7766190887274, -122.499529309057)
155368 155368 210667 Undocumented 2 Olea europaea :: Olive Tree 41 461 Pacheco St 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 6ft   5993772.15723 2101783.21661 37.7507384818159 -122.46438998350901 (37.7507384818159, -122.464389983509)
161684 161684 210666 Undocumented 2 Olea europaea :: Olive Tree 41 461 Pacheco St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5993758.36783 2101793.87252 37.7507669453544 -122.46443844167901 (37.7507669453544, -122.464438441679)
163949 163949 232444 Undocumented 2 Olea europaea :: Olive Tree 41 146 27th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 6ft   6005545.814180001 2100237.4509799997 37.7471657990643 -122.423565720582 (37.7471657990643, -122.423565720582)
164138 164138 194195 Undocumented 2 Olea europaea :: Olive Tree 41 9 Pomona St 1 : 4 Tree 1 Private 1     2 Width 6ft   6014203.67115 2094680.19203 37.732391609687205 -122.393238495663 (37.7323916096872, -122.393238495663)
165406 165406 210867 Undocumented 2 Olea europaea :: Olive Tree 41 774 Joost Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10 Width 6ft   5996972.318969999 2095027.1901599998 37.7323720296365 -122.452836023577 (37.7323720296365, -122.452836023577)
166873 166873 232862 Undocumented 2 Olea europaea :: Olive Tree 41 1129 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 6ft   6010301.9887 2102418.59091 37.753422043492606 -122.407272901822 (37.7534220434926, -122.407272901822)
167503 167503 117838 DPW Maintained 3 Olea europaea :: Olive Tree 41 660x 39th Ave 1 Median : Cutout 11 Tree 1 DPW 2     8 Width 6ft   5983820.62988 2111252.49481 37.7761597840052 -122.499502409931 (37.7761597840052, -122.499502409931)
168379 168379 194241 Undocumented 2 Olea europaea :: Olive Tree 41 4 Mabrey Ct 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 6ft   6016531.12407 2095935.7497 37.735968147815704 -122.385279329202 (37.7359681478157, -122.385279329202)
176287 176287 210665 Undocumented 2 Olea europaea :: Olive Tree 41 461 Pacheco St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   5993745.33672 2101802.5185 37.7507899338305 -122.46448413175 (37.7507899338305, -122.46448413175)
184013 184013 194162 Undocumented 2 Olea europaea :: Olive Tree 41 1905 23rd St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2 Width 6ft   6012692.731819999 2102821.3503099997 37.7546614459721 -122.399033419356 (37.7546614459721, -122.399033419356)
185512 185512 177974 Undocumented 2 Olea europaea :: Olive Tree 41 5 Naples St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 6ft   6004875.55792 2093420.9047400001 37.7284112462806 -122.425398400422 (37.7284112462806, -122.425398400422)
186931 186931 232435 Undocumented 2 Olea europaea :: Olive Tree 41 1 Church St 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 6ft   6004121.39652 2108664.33355 37.7702235143292 -122.42909198802201 (37.7702235143292, -122.429091988022)
24652 24652 233126 Undocumented 2 Olea europaea :: Olive Tree 41 1411 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6003310.36641 2099907.98672 37.746134733540394 -122.431272203649 (37.7461347335404, -122.431272203649)
25449 25449 232967 Undocumented 2 Olea europaea :: Olive Tree 41 1350 Cole St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 5ft   5998278.03823 2105754.12772 37.7619003184538 -122.449094356436 (37.7619003184538, -122.449094356436)
25713 25713 210777 Undocumented 2 Olea europaea :: Olive Tree 41 1369 04th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 5ft   5994856.84062 2106234.38155 37.7630227056673 -122.46096165726401 (37.7630227056673, -122.460961657264)
27295 27295 124397 Undocumented 2 Olea europaea :: Olive Tree 41 3920 Washington St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   5995992.84838 2115560.19598 37.788694241850706 -122.45770745228998 (37.7886942418507, -122.45770745229)
27582 27582 131964 Undocumented 2 Olea europaea :: Olive Tree 41 2616 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   6006972.364130001 2121248.27564 37.8049368965806 -122.42012369407699 (37.8049368965806, -122.420123694077)
30318 30318 210592 Undocumented 2 Olea europaea :: Olive Tree 41 1260 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 5ft   5992092.3928 2106837.96884 37.764520536412604 -122.470566813334 (37.7645205364126, -122.470566813334)
30824 30824 233190 Undocumented 2 Olea europaea :: Olive Tree 41 109 Frederick St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   5999429.25241 2107693.46617 37.767291031990396 -122.445252213422 (37.7672910319904, -122.445252213422)
32752 32752 131891 Undocumented 2 Olea europaea :: Olive Tree 41 3211 Sacramento St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   5999369.54226 2115325.6644599997 37.788243679858205 -122.44600775276899 (37.7882436798582, -122.446007752769)
34368 34368 131798 Undocumented 2 Olea europaea :: Olive Tree 41 3550 Baker St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 5ft   5999217.12066 2121060.49219 37.8039812832582 -122.446947946285 (37.8039812832582, -122.446947946285)
35643 35643 131967 Undocumented 2 Olea europaea :: Olive Tree 41 2642 Hyde St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6006948.59932 2121422.85954 37.805414920417796 -122.420218333313 (37.8054149204178, -122.420218333313)
35828 35828 233702 Undocumented 2 Olea europaea :: Olive Tree 41 64 Vicksburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   6004074.63863 2102693.13969 37.7538253966311 -122.428827968645 (37.7538253966311, -122.428827968645)
38806 38806 131917 Undocumented 2 Olea europaea :: Olive Tree 41 1870 Sacramento St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   6005825.85678 2116265.4775799997 37.791190732123496 -122.423736805829 (37.7911907321235, -122.423736805829)
40992 40992 131854 Undocumented 2 Olea europaea :: Olive Tree 41 2561 Chestnut St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   5999582.7736599995 2119421.9193599997 37.7995030857465 -122.44556468468299 (37.7995030857465, -122.445564684683)
41116 41116 131906 Undocumented 2 Olea europaea :: Olive Tree 41 2300 Lyon St 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11 Width 5ft   5999332.61261 2116722.13595 37.7920759141309 -122.446236016002 (37.7920759141309, -122.446236016002)
42151 42151 194170 Undocumented 2 Olea europaea :: Olive Tree 41 719 Kansas St 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13 Width 5ft   6011587.08129 2104962.23844 37.7604781764565 -122.403007652101 (37.7604781764565, -122.403007652101)
42272 42272 131787 Undocumented 2 Olea europaea :: Olive Tree 41 2674 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 5ft   6000147.00101 2118531.04457 37.7970891758715 -122.44354823196801 (37.7970891758715, -122.443548231968)
42792 42792 194229 Undocumented 2 Olea europaea :: Olive Tree 41 7 Hawkins Ln 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 5ft   6016979.331809999 2095396.8970400002 37.734513351414705 -122.38369217597601 (37.7345133514147, -122.383692175976)
43542 43542 131868 Undocumented 2 Olea europaea :: Olive Tree 41 3328 Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 5ft   6001855.62122 2119606.6356099998 37.8001397625857 -122.43771307081998 (37.8001397625857, -122.43771307082)
43846 43846 232884 Undocumented 2 Olea europaea :: Olive Tree 41 800 Hampshire St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 5ft   6010144.194080001 2104517.0522 37.7591751163599 -122.407966563306 (37.7591751163599, -122.407966563306)
43860 43860 124668 Undocumented 2 Olea europaea :: Olive Tree 41 199 Arguello Blvd 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 5ft   5995484.347469999 2115002.47602 37.787133668893205 -122.4594263723 (37.7871336688932, -122.4594263723)
43906 43906 218171 Undocumented 2 Olea europaea :: Olive Tree 41 1434 Portola Dr 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 5ft   5992907.9663 2097391.6140400004 37.738630405454394 -122.46705915605101 (37.7386304054544, -122.467059156051)
44517 44517 210779 Undocumented 2 Olea europaea :: Olive Tree 41 323 Parnassus Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 5ft   5996561.8968400005 2106596.03993 37.7641136921075 -122.45509061943599 (37.7641136921075, -122.455090619436)
45011 45011 124669 Undocumented 2 Olea europaea :: Olive Tree 41 199 Arguello Blvd 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 5ft   5995485.80344 2114975.19112 37.7870588356326 -122.459419358244 (37.7870588356326, -122.459419358244)
46748 46748 131855 Undocumented 2 Olea europaea :: Olive Tree 41 2561 Chestnut St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6 Width 5ft   5999583.43559 2119428.0305 37.799519903091394 -122.445562833863 (37.7995199030914, -122.445562833863)
48644 48644 124648 Undocumented 2 Olea europaea :: Olive Tree 41 15 Arguello Blvd 3 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     22 Width 5ft   5995458.44608 2115807.32553 37.7893420787061 -122.459574299668 (37.7893420787061, -122.459574299668)
49037 49037 194154 Undocumented 2 Olea europaea :: Olive Tree 41 470 Carolina St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     5 Width 5ft   6012311.644719999 2105752.08257 37.762687347553296 -122.40055718926901 (37.7626873475533, -122.400557189269)
49307 49307 210742 Undocumented 2 Olea europaea :: Olive Tree 41 1231 02nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     23 Width 5ft   5995454.06251 2107177.64382 37.7656470074244 -122.458964384416 (37.7656470074244, -122.458964384416)
52099 52099 131902 Undocumented 2 Olea europaea :: Olive Tree 41 2030 Lyon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 5ft   5999445.57551 2115870.82509 37.7897448893511 -122.445783913296 (37.7897448893511, -122.445783913296)
52217 52217 131905 Undocumented 2 Olea europaea :: Olive Tree 41 2300 Lyon St 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 5ft   5999332.9847099995 2116712.83345 37.7920503931741 -122.446234059074 (37.7920503931741, -122.446234059074)
53099 53099 131907 Undocumented 2 Olea europaea :: Olive Tree 41 2300 Lyon St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 5ft   5999331.1857 2116735.12189 37.7921114886004 -122.446241887658 (37.7921114886004, -122.446241887658)

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