Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48 sorted by DBH

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1364 251507 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1365 251509 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1372 251508 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1375 251506 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5996476.0 2114178.0 37.784926844945396 -122.45593586593901 (37.7849268449454, -122.455935865939)
1835 251742 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 300 Naylor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002771.0 2086560.0 37.7094535905361 -122.432184185389 (37.7094535905361, -122.432184185389)
1836 251749 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 601 Prague St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6002875.0 2087693.0 37.7125704580966 -122.43190559156 (37.7125704580966, -122.43190559156)
1848 251743 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 143 Cordova St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6001773.0 2087479.0 37.7119203272299 -122.43569914014999 (37.7119203272299, -122.43569914015)
2122 252898 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 501x Mount Vernon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5997879.0 2089997.0 37.7186122227881 -122.44933914222901 (37.7186122227881, -122.449339142229)
2676 253162 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 323 Moscow St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6004481.0 2091226.0 37.7223622223708 -122.42660617515699 (37.7223622223708, -122.426606175157)
13879 50774 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
20472 89331 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4658 18th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/31/2008 12:00:00 AM   3x3 Permit Number 51984 6000201.0 2105201.0 37.760491360371596 -122.4424038966 (37.7604913603716, -122.4424038966)
42969 95722 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 950 Avalon Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
49235 39895 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 290 Douglass St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/11/2008 12:00:00 AM   3x3 Permit Number 50795 6001095.73329197 2104700.06064199 37.7591668603211 -122.439273525739 (37.7591668603211, -122.439273525739)
49602 92857 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1101 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2009 12:00:00 AM     Permit Number 53074 6001966.0 2100891.0 37.748757577125204 -122.435991171851 (37.7487575771252, -122.435991171851)
54143 88190 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1118 Harrison St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51195 6010631.0 2110372.0 37.7752787109316 -122.406695562022 (37.7752787109316, -122.406695562022)
70838 69919 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 95 Mercedes Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.728618246103295 -122.470591251084 (37.7286182461033, -122.470591251084)
72527 50111 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 250 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM     Permit Number 46832 5992489.27392501 2099148.73533454 37.7434308389356 -122.468634598074 (37.7434308389356, -122.468634598074)
75293 95998 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1682 Newcomb Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/2011 12:00:00 AM   3x3 Permit Number 767649 6014786.9 2096088.7 37.7362914700729 -122.39132054683998 (37.7362914700729, -122.39132054684)
77789 88712 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 500 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/07/2008 12:00:00 AM   3x3 Permit Number 51654 6004166.0 2109783.0 37.773297624540895 -122.429017475211 (37.7732976245409, -122.429017475211)
77937 106193 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 3040 TARAVAL ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5983698.2 2098878.7 37.742177638003994 -122.499011481047 (37.742177638004, -122.499011481047)
79719 112585 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 6 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
79989 95720 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 950 Avalon Ave 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
80742 114691 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 391 Girard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)
81387 83396 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4058 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50820 6002600.50899636 2105341.51117361 37.761013644342604 -122.43411515125 (37.7610136443426, -122.43411515125)
81515 94694 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 12 Dehon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM   3x3 Permit Number 53832 6003771.0 2106542.0 37.7643762595393 -122.430152577782 (37.7643762595393, -122.430152577782)
82028 82433 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 235 Rutledge St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/11/2008 12:00:00 AM   3x3 Permit Number 50249 6010057.43217179 2099484.04645755 37.745350741274 -122.40791171221599 (37.745350741274, -122.407911712216)
83196 71841 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 95 Mercedes Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/29/2015 12:00:00 AM     Permit Number 776113 5991810.08250882 2093768.29366569 37.728618246103295 -122.470591251084 (37.7286182461033, -122.470591251084)
83380 101252 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 1290X 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5992716.9 2106688.9 37.764147324412605 -122.46839598557699 (37.7641473244126, -122.468395985577)
84032 92858 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1101 Diamond St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2009 12:00:00 AM   3x3 Permit Number 53074 6001966.0 2100891.0 37.748757577125204 -122.435991171851 (37.7487575771252, -122.435991171851)
84200 98848 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1795X 31st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2012 12:00:00 AM   3x3 Permit Number 768753 5986486.2 2103095.0 37.7539176067687 -122.489681571094 (37.7539176067687, -122.489681571094)
84274 87855 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2537 Larkin St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/06/2008 12:00:00 AM   3x3 Permit Number 50783 6006632.0 2119882.0 37.8011662683494 -122.421204486113 (37.8011662683494, -122.421204486113)
85189 39614 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 577 Frederick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM     Permit Number 42206 5996839.91957309 2107330.11638831 37.7661452244472 -122.454182049235 (37.7661452244472, -122.454182049235)
85422 88095 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1795 40th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51099 5983752.7 2102993.7 37.7534794912156 -122.49912702260201 (37.7534794912156, -122.499127022602)
85631 95404 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 395 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/24/2011 12:00:00 AM   3x3 Permit Number 767278 6003403.3 2099172.9 37.7441216223731 -122.430898399301 (37.7441216223731, -122.430898399301)
86290 40470 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 43 Lakeview Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/1999 12:00:00 AM     Permit Number 41555 5997449.10168169 2089159.83978526 37.7162889747674 -122.450764790718 (37.7162889747674, -122.450764790718)
87710 88139 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 523 Teresita Blvd   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2008 12:00:00 AM   3x3 Permit Number 51168 5998937.5 2097522.9 37.7393370734625 -122.446221422912 (37.7393370734625, -122.446221422912)
88126 92664 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 791 San Bruno Ave 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.759644317200106 -122.404916188138 (37.7596443172001, -122.404916188138)
88455 81333 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1607 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/15/2010 12:00:00 AM   3x3 Permit Number 53535 5993364.90659405 2104537.49939321 37.7582775482109 -122.46599839571999 (37.7582775482109, -122.46599839572)
89138 88206 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 187 Beaumont Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51211 5996832.5 2111680.5 37.7780898241501 -122.45452201468201 (37.7780898241501, -122.454522014682)
92779 88094 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1474 40th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/30/2008 12:00:00 AM   3x3 Permit Number 51098 5983765.2 2105129.7 37.759345083267796 -122.499241618892 (37.7593450832678, -122.499241618892)
92798 115268 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2275 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/21/2016 12:00:00 AM     Permit Number 775658 5987276.1 2099806.2 37.744933531932794 -122.486708467871 (37.7449335319328, -122.486708467871)
92854 38913 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 70 Borica St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/02/1998 12:00:00 AM     Permit Number 40725 5992519.41888039 2091685.55807474 37.722940558785794 -122.46798762393101 (37.7229405587858, -122.467987623931)
93530 88397 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 405 27th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51376 5987436.1 2113196.8 37.781709762111795 -122.487138517946 (37.7817097621118, -122.487138517946)
93834 116736 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1799x 25TH AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5988397.0 2103119.0 37.754094880795606 -122.48307541499399 (37.7540948807956, -122.483075414994)
94109 102385 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 33 Buena Vista Ter 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM   3x3 Permit Number 774895 6001524.4 2108057.6 37.768410224110205 -122.438031497558 (37.7684102241102, -122.438031497558)
94167 88256 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 436 Belvedere St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51241 5998536.0 2106665.0 37.76441609532 -122.44826776566099 (37.76441609532, -122.448267765661)
94415 103118 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 443 Vernon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/21/2013 12:00:00 AM     Permit Number 769638 5992399.1 2090786.9 37.72046611452 -122.46833819147801 (37.72046611452, -122.468338191478)
94537 83344 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4443-4445 18th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/12/2008 12:00:00 AM   3x3 Permit Number 50816 6001265.82005399 2105215.83153824 37.760592718857495 -122.43872224382 (37.7605927188575, -122.43872224382)
95133 105013 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 330 Townsend St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132)
96116 94672 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 658 Joost Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53808 5997731.1 2095032.6 37.732430335747 -122.45021314346901 (37.732430335747, -122.450213143469)
96133 105012 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 330 Townsend St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132)
96167 94695 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 12 Dehon St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/28/2010 12:00:00 AM   3x3 Permit Number 53832 6003771.0 2106542.0 37.7643762595393 -122.430152577782 (37.7643762595393, -122.430152577782)
97094 37052 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 156 Duncan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49822 6005524.96145532 2099948.44891125 37.746371088402704 -122.423617283508 (37.7463710884027, -122.423617283508)
97343 95721 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 950 Avalon Ave 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767471 6005194.4 2092000.5 37.7245291361369 -122.424195170047 (37.7245291361369, -122.424195170047)
97731 92226 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 587 Shotwell St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2009 12:00:00 AM   3x3 Permit Number 52664 6008031.3 2104525.5 37.7590797904057 -122.41527458403401 (37.7590797904057, -122.415274584034)
98150 43741 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 840 Mount Vernon Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
98766 104736 Significant Tree 6 Lagunaria patersonii :: Primrose Tree 48 1499X 44th Ave 1 Front Yard : Yard 7 Tree 1 Private 1         Permit Number 770763 5982473.05016 2105245.16297 37.7595862228156 -122.50371897878901 (37.7595862228156, -122.503718978789)
99545 88108 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1935 47th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/01/2008 12:00:00 AM   3x3 Permit Number 51112 5981615.2 2101901.1 37.7503538981052 -122.50643780728001 (37.7503538981052, -122.50643780728)
99795 43061 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 3050 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/04/2005 12:00:00 AM     Permit Number 53563 5983775.74745702 2098849.58098564 37.7421022336559 -122.498741199638 (37.7421022336559, -122.498741199638)
101190 51233 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1130 Stanyan St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2004 12:00:00 AM     Permit Number 47596 5997360.62073029 2106430.86661879 37.763705958456704 -122.45231616044599 (37.7637059584567, -122.452316160446)
101532 46892 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1383 11th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2002 12:00:00 AM     Permit Number 44948 5992692.47897134 2106059.86172468 37.7624187406256 -122.46843468168501 (37.7624187406256, -122.468434681685)
102266 88244 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4330 17th St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51231 6000585.0 2105809.0 37.7621826583789 -122.441119442302 (37.7621826583789, -122.441119442302)
102285 102092 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 19 Stoneman St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/18/2012 12:00:00 AM   3x3 Permit Number 769735 6008292.3 2099391.0 37.744996275991504 -122.414008688761 (37.7449962759915, -122.414008688761)
102671 94671 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 654 Joost Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53807 5997755.7 2095032.2 37.7324306451966 -122.450128067067 (37.7324306451966, -122.450128067067)
103046 43742 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 840 Mount Vernon Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
103063 51232 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1130 Stanyan St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2004 12:00:00 AM     Permit Number 47596 5997360.62073029 2106430.86661879 37.763705958456704 -122.45231616044599 (37.7637059584567, -122.452316160446)
103150 51230 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1130 Stanyan St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2004 12:00:00 AM     Permit Number 47596 5997360.62073029 2106430.86661879 37.763705958456704 -122.45231616044599 (37.7637059584567, -122.452316160446)
104034 82079 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1648 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50227 6009276.07844564 2099765.78028808 37.7460805446245 -122.410633408071 (37.7460805446245, -122.410633408071)
104847 74157 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 195 Gates St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/08/2011 12:00:00 AM     Permit Number 768269 6008310.54477322 2097714.64471242 37.740394399357 -122.413827044611 (37.740394399357, -122.413827044611)
105096 106607 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1392 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/12/2014 12:00:00 AM     Permit Number 770777 5989327.7 2105878.6 37.761726116308104 -122.48005880990699 (37.7617261163081, -122.480058809907)
105236 116735 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1799x 25TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5988397.0 2103119.0 37.754094880795606 -122.48307541499399 (37.7540948807956, -122.483075414994)
105336 102384 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 33 Buena Vista Ter 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2016 12:00:00 AM   3x3 Permit Number 774895 6001524.4 2108057.6 37.768410224110205 -122.438031497558 (37.7684102241102, -122.438031497558)
105500 92859 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1101 Diamond St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/14/2009 12:00:00 AM   3x3 Permit Number 53074 6001966.0 2100891.0 37.748757577125204 -122.435991171851 (37.7487575771252, -122.435991171851)
106448 88732 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1732 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51666 6003104.1 2114241.2 37.7854785624412 -122.433009307654 (37.7854785624412, -122.433009307654)
106923 88527 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1501 06th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/2008 12:00:00 AM   3x3 Permit Number 51477 5994255.6 2105256.2 37.7603022580943 -122.462970154312 (37.7603022580943, -122.462970154312)
107208 67239 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 115 Fillmore St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/08/1992 12:00:00 AM   3x9 Permit Number 30703 6003792.49486353 2108815.33294247 37.770619498227 -122.430240430849 (37.770619498227, -122.430240430849)
107437 95999 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1682 Newcomb Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/16/2011 12:00:00 AM   3x3 Permit Number 767649 6014786.9 2096088.7 37.7362914700729 -122.39132054683998 (37.7362914700729, -122.39132054684)
107833 87640 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2300X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/24/2008 12:00:00 AM   3x3   6012975.96285 2096322.27153 37.7368321371284 -122.397598127165 (37.7368321371284, -122.397598127165)
108159 41826 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2517 Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/2000 12:00:00 AM     Permit Number 42212 5998421.57666404 2111723.27260806 37.7782982768263 -122.449027932684 (37.7782982768263, -122.449027932684)
108178 112584 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 5 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
108202 92665 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 791 San Bruno Ave 3 Sidewalk: Property side : Cutout 5 Tree 1 Private 1   09/11/2009 12:00:00 AM     Permit Number 52939 6011029.3 2104669.9 37.759644317200106 -122.404916188138 (37.7596443172001, -122.404916188138)
109287 50035 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 73 University St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM     Permit Number 46766 6007848.45417861 2093691.5625558 37.7293219318135 -122.41514007459801 (37.7293219318135, -122.415140074598)
110202 84332 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 804 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/08/2008 12:00:00 AM   3x3 Permit Number 51851 5986981.94009984 2110441.32651783 37.7741175201244 -122.488507097746 (37.7741175201244, -122.488507097746)
110281 116789 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 530 CRESCENT AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6007719.0 2095661.0 37.7347223035732 -122.415727003996 (37.7347223035732, -122.415727003996)
110297 88724 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1009 Page St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/11/2008 12:00:00 AM   3x3 Permit Number 51659 6001742.0 2109408.0 37.7721304598957 -122.437375549988 (37.7721304598957, -122.437375549988)
111070 49802 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 MISSISSIPPI ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/2003 12:00:00 AM     Permit Number 46598 6014071.0 2106574.0 37.765042114519 -122.39452971790399 (37.765042114519, -122.394529717904)
111186 105014 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 330 Townsend St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3X3   6013709.8 2110877.9 37.7768395752266 -122.396080672132 (37.7768395752266, -122.396080672132)
111314 106608 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1392 22nd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/12/2014 12:00:00 AM     Permit Number 770777 5989327.7 2105878.6 37.761726116308104 -122.48005880990699 (37.7617261163081, -122.480058809907)
111831 94654 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 494 Arlington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2010 12:00:00 AM   3x3 Permit Number 53793 6003689.0 2095884.0 37.73510724004171 -122.429675988088 (37.7351072400417, -122.429675988088)
112359 82755 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1646 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50226 6009275.52393785 2099776.98643755 37.746111283151 -122.410636116717 (37.746111283151, -122.410636116717)
112382 43739 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 840 Mount Vernon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
112446 83301 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2194 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/09/2008 12:00:00 AM   3x3 Permit Number 50729 5982670.93030487 2100194.17282904 37.7457292516177 -122.502660748962 (37.7457292516177, -122.502660748962)
112698 88255 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 115 Belvedere St   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2008 12:00:00 AM   3x3 Permit Number 51240 5998220.0 2108137.0 37.7684397634087 -122.44946678758998 (37.7684397634087, -122.44946678759)
113001 115239 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 863 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/2016 12:00:00 AM     Permit Number 775147 5981970.6 2109880.3 37.7722834181785 -122.505800301349 (37.7722834181785, -122.505800301349)
113043 115237 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 867 42nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/20/2016 12:00:00 AM     Permit Number 775536 5982900.6 2109891.1 37.772367765473795 -122.502584200594 (37.7723677654738, -122.502584200594)
113705 112586 Section 143 8 Lagunaria patersonii :: Primrose Tree 48 3400x WAWONA ST 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       4x4   5982411.0 2096792.0 37.7363725426512 -122.50330767262899 (37.7363725426512, -122.503307672629)
114348 43740 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 840 Mount Vernon Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/25/2000 12:00:00 AM     Permit Number 43376 5997079.36624225 2090505.78650323 37.7199634590291 -122.45213982606899 (37.7199634590291, -122.452139826069)
114352 110718 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 201x OGDEN AVE 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1         6007843.0 2096159.0 37.7360966727045 -122.415333535238 (37.7360966727045, -122.415333535238)
114553 84680 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 230 Brighton Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/03/2007 12:00:00 AM   3x3 Permit Number 49721 5996259.49937321 2091420.61840977 37.722428372357 -122.45503987717 (37.722428372357, -122.45503987717)
114566 114692 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 391 Girard St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9 Private 3 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)

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