Street_Tree_List

Data source: data.sfgov.org

830 rows where qSpecies = 88 sorted by Location

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▼
47177 177448 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1022 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 4ft   6001291.58576 2086844.2282099999 37.7101500273691 -122.437317616421 (37.7101500273691, -122.437317616421)
165176 114986 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1028 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/29/2015 12:00:00 AM 1   Permit Number 770492 6001259.4385 2086848.65908 37.7101603659725 -122.437429040618 (37.7101603659725, -122.437429040618)
109947 120109 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 555 Ellington Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/03/2016 12:00:00 AM 3 3x3   5997970.0 2087042.0 37.7105036758619 -122.44881186315901 (37.7105036758619, -122.448811863159)
28727 177449 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 324 Cordova St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6001907.3749400005 2086972.3844599999 37.7105369040276 -122.43519848992901 (37.7105369040276, -122.435198489929)
97637 83771 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 924 Rutland St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/19/2008 12:00:00 AM 3 3x3 Permit Number 50981 6009720.30690757 2087000.33290755 37.7110542204407 -122.408197148869 (37.7110542204407, -122.408197148869)
43609 177447 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 762 Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002442.748380001 2087164.23323 37.711094066412294 -122.433361825211 (37.7110940664123, -122.433361825211)
156758 69419 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 168 Seville St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 9   Permit Number 33524 6001328.44378 2087365.87339 37.7115844451475 -122.437227553813 (37.7115844451475, -122.437227553813)
47863 177393 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1657 Sunnydale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4 Width 10ft   6006855.18138 2087491.9955900002 37.7122433757141 -122.41813457086599 (37.7122433757141, -122.418134570866)
60469 80737 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 186 Allison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/22/2003 12:00:00 AM 1     6000043.5525400005 2087718.3093599998 37.7124790304587 -122.44169374357 (37.7124790304587, -122.44169374357)
131019 177392 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1654 Sunnydale Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7 Width 10ft   6006773.14965 2087593.0806 37.7125163163365 -122.41842526053101 (37.7125163163365, -122.418425260531)
51443 105800 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 207 Raymond Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/27/2014 12:00:00 AM 3   Permit Number 769635 6010004.04754 2087785.0667299998 37.713224823850005 -122.407271751589 (37.71322482385, -122.407271751589)
53993 177425 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1764 Cayuga Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     14 Width 8ft   5997936.35064 2088551.93116 37.7146476772225 -122.44903686276301 (37.7146476772225, -122.449036862763)
82889 114908 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 281 LOBOS ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5994225.0 2088676.0 37.714775380268996 -122.461873702271 (37.714775380269, -122.461873702271)
146559 208848 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 281 Lobos St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5994210.24416 2088699.7294 37.7148396860693 -122.46192642387501 (37.7148396860693, -122.461926423875)
69630 177417 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1x Rolph St 1 Median : Cutout 11 Tree 1 DPW 2     7 Width 4ft   6000503.4246 2088653.73075 37.7150736797726 -122.440171325345 (37.7150736797726, -122.440171325345)
123330 84225 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1361 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50686 6011917.47723073 2088615.29524593 37.7156113688947 -122.400716532679 (37.7156113688947, -122.400716532679)
45146 177401 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 263 Dublin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6003956.36283 2088919.05641 37.7159981864394 -122.42825539008601 (37.7159981864394, -122.428255390086)
49439 83995 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 254 Dublin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/10/2008 12:00:00 AM 4 3x3 Permit Number 51873 6003949.050969999 2088987.2537599998 37.7161850277922 -122.428285520976 (37.7161850277922, -122.428285520976)
66636 82354 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 254 Dublin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/04/2008 12:00:00 AM   3x3 Permit Number 50649 6004015.90676212 2089097.25184538 37.716490841330106 -122.428062269463 (37.7164908413301, -122.428062269463)
187349 177394 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 833 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6003056.79218 2089215.7831299999 37.716761991458604 -122.431385897768 (37.7167619914586, -122.431385897768)
35817 83433 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 760 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/03/2005 12:00:00 AM 4     6000998.571 2089370.50235 37.7170699516967 -122.43851121642099 (37.7170699516967, -122.438511216421)
64511 177400 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1112 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003994.8137 2089359.3172799998 37.7172092225078 -122.428153843121 (37.7172092225078, -122.428153843121)
114640 108839 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1112 Russia Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 770758 6003955.6442 2089384.8090099997 37.7172770009516 -122.42829104937599 (37.7172770009516, -122.428291049376)
146771 88351 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 700 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM 5 3x3 Permit Number 51333 6002622.22718 2089414.5665400003 37.7172831683531 -122.432902166399 (37.7172831683531, -122.432902166399)
160548 177398 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 650 France Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6002590.58454 2089466.88592 37.7174250310079 -122.433015275935 (37.7174250310079, -122.433015275935)
62272 177397 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 650 France Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6002573.73742 2089477.3552599999 37.717452821874105 -122.433074256169 (37.7174528218741, -122.433074256169)
34070 177396 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 650 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6002554.32379 2089489.05378 37.7174838421787 -122.433142195459 (37.7174838421787, -122.433142195459)
106504 88322 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 645 France Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51311 6002646.5 2089495.7 37.717507319615706 -122.432824059512 (37.7175073196157, -122.432824059512)
125699 88320 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 645 France Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51311 6002646.5 2089495.7 37.717507319615706 -122.432824059512 (37.7175073196157, -122.432824059512)
44168 177405 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 688 Vienna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002677.6930599995 2089500.91725 37.71752341415829 -122.432716611994 (37.7175234141583, -122.432716611994)
10860 104506 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 631 France Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   3 3x3   6002582.75614 2089515.1433 37.7175570910528 -122.43304578096 (37.7175570910528, -122.43304578096)
121083 177404 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 688 Vienna St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002686.6432 2089516.6103299998 37.717567011481705 -122.432686795869 (37.7175670114817, -122.432686795869)
129025 88319 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 631 France Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51310 6002604.8 2089521.8 37.7175766192591 -122.43297006078501 (37.7175766192591, -122.432970060785)
36649 177403 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 688 Vienna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 2ft   6002695.8436900005 2089531.77748 37.7176091789075 -122.432656076817 (37.7176091789075, -122.432656076817)
11429 83565 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 647 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 3 3x3 Permit Number 769747 6003095.84203 2089582.30789 37.7177706009018 -122.43127706988199 (37.7177706009018, -122.431277069882)
168525 177402 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 670 Vienna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6002753.398469999 2089622.73249 37.7178621851574 -122.43246362908701 (37.7178621851574, -122.432463629087)
153491 177399 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 908 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6003531.7567 2089652.07353 37.7179868563895 -122.429775281212 (37.7179868563895, -122.429775281212)
41811 108815 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 474 Munich St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774652 6003779.44726 2089723.3814299998 37.7181966752665 -122.42892420414499 (37.7181966752665, -122.428924204145)
34177 177411 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 474 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003775.47727 2089725.4167 37.7182020389599 -122.42893807173 (37.7182020389599, -122.42893807173)
11033 83366 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 618 Athens St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52311 6003144.474669999 2089738.5573200001 37.718202383405206 -122.43112011482701 (37.7182023834052, -122.431120114827)
23545 177395 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 715 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6001937.656140001 2089768.77997 37.718216907458704 -122.435293726344 (37.7182169074587, -122.435293726344)
38105 177410 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 470 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6003782.11139 2089736.37793 37.718232511606296 -122.428915921448 (37.7182325116063, -122.428915921448)
10886 83673 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 618 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52311 6003154.7737300005 2089756.30482 37.7182516977425 -122.43108578140499 (37.7182516977425, -122.431085781405)
144343 108814 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 470 Munich St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 774651 6003792.96606 2089744.94608 37.7182566522639 -122.42887901198 (37.7182566522639, -122.42887901198)
98401 88306 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 575 Athens St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51300 6003350.0 2089985.0 37.718890705147 -122.43042727566299 (37.718890705147, -122.430427275663)
173639 177414 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 575 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 2ft   6003352.2884599995 2089985.19468 37.7188913693287 -122.430419379246 (37.7188913693287, -122.430419379246)
63292 177412 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 539 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 2ft   6003697.3420400005 2090030.0653 37.719034114214004 -122.42922986306401 (37.719034114214, -122.429229863064)
36589 177408 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 638 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6002397.88484 2090069.70643 37.71906931008821 -122.43372440936301 (37.7190693100882, -122.433724409363)
171641 177409 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 659 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6002137.168430001 2090084.38724 37.719094822944996 -122.434626653316 (37.719094822945, -122.434626653316)
112316 88332 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 659 Madrid St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51320 6002140.0 2090092.0 37.7191158866353 -122.434617409737 (37.7191158866353, -122.434617409737)
173626 177407 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 626 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 2ft   6002434.78266 2090132.2743 37.7192432011957 -122.433601337127 (37.7192432011957, -122.433601337127)
127266 95734 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 626 Edinburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767481 6002384.8 2090170.7 37.7193458734928 -122.43377685304199 (37.7193458734928, -122.433776853042)
71769 177406 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 618 Edinburgh St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6002461.15734 2090172.80832 37.7193559950662 -122.433513065093 (37.7193559950662, -122.433513065093)
103099 88326 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 559 Lisbon St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51315 6001911.0 2090236.0 37.7194982755804 -122.43541926902701 (37.7194982755804, -122.435419269027)
120151 88327 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 559 Lisbon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51315 6001911.0 2090236.0 37.7194982755804 -122.43541926902701 (37.7194982755804, -122.435419269027)
49891 177413 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 518 Athens St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6003506.69699 2090312.38662 37.719798511885706 -122.42990897621401 (37.7197985118857, -122.429908976214)
124961 88312 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 518 Athens St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51303 6003514.0 2090320.0 37.7198198301278 -122.42988427506201 (37.7198198301278, -122.429884275062)
29927 83659 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 559 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/03/2005 12:00:00 AM 6     6001685.54257 2090383.4533900002 37.7198903425557 -122.436209138162 (37.7198903425557, -122.436209138162)
71293 208847 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 422 Grafton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5995505.44933 2090582.5246599999 37.7200838784427 -122.457585828931 (37.7200838784427, -122.457585828931)
25005 177418 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 857 Dartmouth St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     6 Width 4ft   6009516.77243 2090302.7647799999 37.720110619797104 -122.409133494811 (37.7201106197971, -122.409133494811)
60907 50426 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 250 Howth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/12/2014 12:00:00 AM 3   Permit Number 773627 5997303.25557645 2090612.9654569 37.7202705700793 -122.45137364778 (37.7202705700793, -122.45137364778)
96004 95123 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 75 Oneida Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2010 12:00:00 AM   3x3 Permit Number 54050 6000595.4 2090675.6 37.720630512863295 -122.439998309146 (37.7206305128633, -122.439998309146)
13056 108448 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 90-98X Prague St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/22/2014 12:00:00 AM 3 3x3   6004670.84101 2090640.5659299998 37.7207654791334 -122.42590828635599 (37.7207654791334, -122.425908286356)
147335 95762 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 417 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM 2 3x3 Permit Number 767499 6004100.3891199995 2090668.84671 37.720810876907 -122.427882177716 (37.720810876907, -122.427882177716)
143274 122379 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 466 Vernon St 1 Front Yard : Cutout 8 Tree 1 Private 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
31130 177416 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 538 Madrid St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft   6002518.22292 2090772.4099400002 37.721005605292504 -122.433358634398 (37.7210056052925, -122.433358634398)
2517 178826 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 927 Brazil Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6004356.8834 2090741.4764900003 37.7210248094256 -122.427000725205 (37.7210248094256, -122.427000725205)
2512 178827 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 927 Brazil Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6004338.08735 2090755.04432 37.7210610008535 -122.427066663506 (37.7210610008535, -122.427066663506)
60143 72252 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 531 Madrid St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1996 12:00:00 AM 1     6002585.93283 2090796.9641 37.7210768666757 -122.43312633500601 (37.7210768666757, -122.433126335006)
139591 87070 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 395 Byxbee St 1 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
143622 87071 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 395 Byxbee St 2 Front Yard : Cutout 8 Tree 1 Private 1   12/18/2007 12:00:00 AM     Permit Number 50011 5991947.0 2091188.0 37.7215413135876 -122.469930130394 (37.7215413135876, -122.469930130394)
25430 113267 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 83 Exeter St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/16/2015 12:00:00 AM 2   Permit Number 774551 6012507.044369999 2090789.37208 37.7216138123142 -122.398831200496 (37.7216138123142, -122.398831200496)
3940 179536 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1880 Alemany Blvd 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2017 10:42:00 AM 3 Width 3ft   6000969.55481 2091096.3953200001 37.7218072142025 -122.438735113438 (37.7218072142025, -122.438735113438)
44581 177415 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 451 Edinburgh St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   6003094.686869999 2091098.4419099998 37.7219335042119 -122.431389232421 (37.7219335042119, -122.431389232421)
76764 108377 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 226 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1   1 3x3 Permit Number 773810 6004631.19295 2091083.0586299999 37.7219782266077 -122.42607682199801 (37.7219782266077, -122.426076821998)
10319 109211 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 819 Brussels St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/04/2015 12:00:00 AM 3 3x3 Permit Number 773413 6011187.7232800005 2090968.5283099997 37.722032138266 -122.403404362845 (37.722032138266, -122.403404362845)
3896 253542 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 10 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3899 253541 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 9 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3900 253543 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 11 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3902 253544 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 12 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3906 253540 DPW Maintained 3 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 1000 Cayuga Ave 8 Back Yard : Yard 13 Tree 1 DPW 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
71256 52791 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 955@ MOSCOW Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/25/2006 12:00:00 AM 1   Permit Number 48832 6004754.52241 2091271.3997400003 37.7225023397811 -122.425663900979 (37.7225023397811, -122.425663900979)
26519 115980 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
171742 115979 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011610.19593 2091240.25279 37.722801825729604 -122.401963063449 (37.7228018257296, -122.401963063449)
172623 115978 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
182061 115977 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011639.0005 2091249.90123 37.722829925953896 -122.40186416949 (37.7228299259539, -122.40186416949)
12646 115976 Planning Code 138.1 required 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 2x Olmstead St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
174665 177435 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 99 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010088.68836 2091439.3296700001 37.72326341446679 -122.407236642978 (37.7232634144668, -122.407236642978)
75167 177436 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 99 Karen Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010107.2934 2091444.47715 37.7232785896114 -122.40717269128099 (37.7232785896114, -122.407172691281)
110088 114688 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 231 Dwight St 1 Front Yard : Cutout 8 Tree 1 Private 1   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.723279336417704 -122.404549596707 (37.7232793364177, -122.404549596707)
36033 177437 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 93 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010115.68283 2091447.6223799998 37.72328769526371 -122.407143912081 (37.7232876952637, -122.407143912081)
171865 114755 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 89 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/04/2015 12:00:00 AM 1   Permit Number 777135 6010155.72688 2091460.8073900002 37.723326139481294 -122.407006415641 (37.7233261394813, -122.407006415641)
176355 177438 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 83 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010165.7616 2091462.99776 37.723332715313894 -122.406971881647 (37.7233327153139, -122.406971881647)
37487 177439 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 79 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010188.86492 2091471.00105 37.7233559834822 -122.406892581232 (37.7233559834822, -122.406892581232)
94923 88503 Permitted Site 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 7 Wheat St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51441 6012178.0 2091435.0 37.723368235520205 -122.400013942822 (37.7233682355202, -122.400013942822)
149083 177440 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 71 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010238.57006 2091486.2001099999 37.7234004981218 -122.406721829644 (37.7234004981218, -122.406721829644)
41960 177441 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 71 Karen Ct 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010258.66598 2091491.8701799999 37.7234171913236 -122.406652760812 (37.7234171913236, -122.406652760812)
160433 177442 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 67 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010267.21749 2091493.9064200001 37.723423260860706 -122.40662334309799 (37.7234232608607, -122.406623343098)
56518 177443 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 63 Karen Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 2ft   6010306.59987 2091507.00491 37.7234614298874 -122.40648812732799 (37.7234614298874, -122.406488127328)
129834 208845 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 277 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5995629.339 2091829.15928 37.7235139565963 -122.457247722532 (37.7235139565963, -122.457247722532)

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