Street_Tree_List

Data source: data.sfgov.org

977 rows where qSpecies = 48 sorted by PlotSize

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
147 58021 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4026 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/28/2017 12:07:00 PM 3   Permit Number 16988 5983218.6194 2106316.5419 37.7625717348083 -122.50121971656999 (37.7625717348083, -122.50121971657)
1367 36152 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 51 Commonwealth Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/1998 12:00:00 AM 4   Permit Number 39237 5996489.9045 2114249.7041 37.7851245233187 -122.455892946486 (37.7851245233187, -122.455892946486)
4697 60547 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 507 35th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/19/2017 09:50:00 AM 3   Permit Number 20157 5984999.38205 2112385.8100400004 37.779340631831495 -122.49550845523501 (37.7793406318315, -122.495508455235)
11819 115757 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1718 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/24/2016 12:00:00 AM 3   Permit Number 772425 5998122.34061 2088716.2129099998 37.715109392747294 -122.44840583185899 (37.7151093927473, -122.448405831859)
11861 117431 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 730 Excelsior Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776696 6004211.115780001 2091567.32576 37.7232841663055 -122.42756340763901 (37.7232841663055, -122.427563407639)
12904 117426 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 395 Athens St 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 775297 6003998.920059999 2091015.17385 37.7217560742586 -122.428257595231 (37.7217560742586, -122.428257595231)
13144 108829 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 545 Lathrop Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/06/2015 12:00:00 AM 3   Permit Number 773819 6012931.90275 2086607.7470099998 37.7101555653976 -122.397069513169 (37.7101555653976, -122.397069513169)
13879 50774 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 47304          
22968 115802 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1218 48th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/24/2016 12:00:00 AM 3   Permit Number 774518 5981226.5 2106751.9 37.7636499175412 -122.50814192748999 (37.7636499175412, -122.50814192749)
24388 63507 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 574 Paris St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/08/1987 12:00:00 AM 4   Permit Number 24113 6001588.8915 2090307.92108 37.7196774559426 -122.43653782327401 (37.7196774559426, -122.436537823274)
24816 47267 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1386 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM 1   Permit Number 45208 5988680.1995 2105896.4201 37.7617374028544 -122.48229953296001 (37.7617374028544, -122.48229953296)
26324 50815 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 131 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/13/2004 12:00:00 AM 4   Permit Number 47338 5993943.23893 2114634.67726 37.7860350644754 -122.464731509757 (37.7860350644754, -122.464731509757)
26796 47678 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 536 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/21/2002 12:00:00 AM 9   Permit Number 45462 6014348.84456 2104603.39752 37.7596467118443 -122.393430795897 (37.7596467118443, -122.393430795897)
28135 41812 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100 Anzavista Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 3   Permit Number 42201 5999993.4162 2112171.4558 37.7796186440476 -122.44362258073 (37.7796186440476, -122.44362258073)
30642 176917 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 1002x Naples St 9 Median : Yard 3 Tree 1 DPW 2     3     6001514.03799 2088123.65893 37.7136757052349 -122.436640299224 (37.7136757052349, -122.436640299224)
31529 52954 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 975 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2006 12:00:00 AM 5   Permit Number 48941 6000767.51384 2091342.1163299999 37.7224704120511 -122.43945112037399 (37.7224704120511, -122.439451120374)
33343 227094 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 100 Alemany Blvd 35 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     2     6009153.630890001 2095762.56962 37.7350817355269 -122.410774146024 (37.7350817355269, -122.410774146024)
33778 52557 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1671 39th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 5   Permit Number 48653 5984052.4061 2103791.5706 37.7556877987927 -122.498149511058 (37.7556877987927, -122.498149511058)
36288 31158 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 600 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2001 12:00:00 AM 1   Permit Number 34860 5993522.80361 2089878.90243 37.71803781197371 -122.464388049089 (37.7180378119737, -122.464388049089)
41516 46433 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2St. Ankeny St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011103.47209 2089684.5822599998 37.718501979072 -122.403605308234 (37.718501979072, -122.403605308234)
41560 41808 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100 Anzavista Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 3   Permit Number 42201 5999945.6987 2112165.7027 37.7796001259133 -122.44378724216601 (37.7796001259133, -122.443787242166)
41903 73594 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 780 Post St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/12/2014 12:00:00 AM 3   Permit Number 772812 6008453.79298 2114896.74793 37.787580529660794 -122.41454729843399 (37.7875805296608, -122.414547298434)
43685 46431 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2St. Ankeny St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/15/2002 12:00:00 AM 1   Permit Number 44652 6011089.42189 2089718.35805 37.7185939356546 -122.40365624942899 (37.7185939356546, -122.403656249429)
44865 46434 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2St. Ankeny St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/30/2003 12:00:00 AM 1   Permit Number 47151 6011096.25435 2089701.2859 37.7185474406786 -122.40363143174 (37.7185474406786, -122.40363143174)
47267 47826 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4350 Cabrillo St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/13/2002 12:00:00 AM 2   Permit Number 45588 5982100.44481 2110341.3807200002 37.773557052971704 -122.50538534555099 (37.7735570529717, -122.505385345551)
47585 176883 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 96 Alpha St 4 Front Yard : Yard 7 Tree 1 Private 1     1     6011048.63475 2088252.8219299999 37.7145675926038 -122.40369417294501 (37.7145675926038, -122.403694172945)
48341 41809 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100 Anzavista Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 2   Permit Number 42201 5999967.3577 2112168.7485 37.779609724261896 -122.443712533479 (37.7796097242619, -122.443712533479)
48823 39959 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 492 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/25/2000 12:00:00 AM 2   Permit Number 43327 5993771.39961 2112170.75464 37.7792598926327 -122.465146995833 (37.7792598926327, -122.465146995833)
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)
50407 52070 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 939 Jackson St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/04/2005 12:00:00 AM 7   Permit Number 48265 6009656.25559 2117750.5131099997 37.7954837583147 -122.410588599703 (37.7954837583147, -122.410588599703)
51384 41787 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 15th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 11   Permit Number 42194 6011846.53611 2107450.83181 37.7673257817889 -122.402285287842 (37.7673257817889, -122.402285287842)
53294 79640 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 168 Orsi Cir 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/07/2002 12:00:00 AM 9     6012982.50067 2092948.34875 37.727568405236 -122.397338990501 (37.727568405236, -122.397338990501)
55448 60297 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1101 16th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/19/1998 12:00:00 AM 7   Permit Number 19862 6013032.9382 2107035.865 37.7662525295396 -122.39815254670201 (37.7662525295396, -122.398152546702)
55670 41784 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 15th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 13   Permit Number 42194 6011899.9957 2107451.97946 37.7673319169733 -122.40210045827 (37.7673319169733, -122.40210045827)
55763 52885 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2500@ JACKSON Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/10/2006 12:00:00 AM 7   Permit Number 48890 6002243.8338 2116804.81477 37.792468757764794 -122.436169092224 (37.7924687577648, -122.436169092224)
55777 49803 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 101 Mississippi St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/11/2003 12:00:00 AM 8   Permit Number 46598 6014016.82872 2106570.58674 37.7650297307661 -122.394716845308 (37.7650297307661, -122.394716845308)
56847 71337 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 734 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/20/1996 12:00:00 AM 4     5982620.59121 2110750.54443 37.7747110919712 -122.503616418137 (37.7747110919712, -122.503616418137)
57766 60816 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2110 21st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2005 12:00:00 AM 4   Permit Number 20494 5989779.2235 2100978.3623 37.748297591050296 -122.47813890470199 (37.7482975910503, -122.478138904702)
59525 83657 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 7 Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/27/2012 12:00:00 AM 7   Permit Number 769748 6003905.60089 2093401.9190599998 37.728304266518 -122.42875023574499 (37.728304266518, -122.428750235745)
61295 42963 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 560 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/05/2000 12:00:00 AM 9   Permit Number 42852 5981647.94996 2111905.75128 37.7778257173711 -122.50706663602502 (37.7778257173711, -122.507066636025)
64001 69398 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1174 Munich St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/1994 12:00:00 AM 6   Permit Number 33502 6001210.49529 2087131.4410400002 37.7109340401325 -122.43761843606 (37.7109340401325, -122.43761843606)
66808 52362 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1438ASHINGTON Leavenworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/14/2005 12:00:00 AM 9   Permit Number 48498 6007994.9364599995 2117377.7611599998 37.7943669936906 -122.416310648633 (37.7943669936906, -122.416310648633)
68994 83834 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 2300X Silver Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/04/2005 12:00:00 AM 7     6013045.53048 2096356.5558 37.736930148098295 -122.397360003177 (37.7369301480983, -122.397360003177)
69248 39552 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1101 16th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/28/1998 12:00:00 AM 10   Permit Number 40979 6013009.1617 2107035.865 37.7662512051775 -122.39823478562401 (37.7662512051775, -122.398234785624)
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)
71350 41807 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100 Anzavista Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/20/2000 12:00:00 AM 3   Permit Number 42201 5999913.2102 2112161.3032 37.7795861928813 -122.443899317319 (37.7795861928813, -122.443899317319)
71687 50032 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 33 Tulane St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM 5   Permit Number 46764 6007353.74197 2093754.84576 37.729467879523895 -122.416854825683 (37.7294678795239, -122.416854825683)
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)
75601 47840 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4400 Cabrillo St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/14/2002 12:00:00 AM 4   Permit Number 45601 5981916.04684 2110333.3944099997 37.7735242722092 -122.506022602317 (37.7735242722092, -122.506022602317)
77242 81630 Undocumented 2 Lagunaria patersonii :: Primrose Tree 48 50 Paulding St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/06/2005 12:00:00 AM 7     5999996.8419 2093367.66723 37.7279882186648 -122.44226048643 (37.7279882186648, -122.44226048643)
79007 107987 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 233 Laidley St   Sidewalk: Property side : Yard 9 Tree 1 Private 1   11/10/2014 12:00:00 AM 3   Permit Number 771182 6004231.95883 2097050.3446 37.7383404878499 -122.427881865747 (37.7383404878499, -122.427881865747)
80279 108768 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 500X Lathrop Ave 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
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)
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)
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)
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)
86531 54968 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 526 09th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/08/2015 12:00:00 AM 3   Permit Number 775624 5993160.60664 2111866.07895 37.7783880954675 -122.46723780492201 (37.7783880954675, -122.467237804922)
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)
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)
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)
95419 117055 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 762 34th Ave   Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/18/2016 12:00:00 AM 3   Permit Number 778404 5985439.6 2110687.7 37.7747038750392 -122.49386040463101 (37.7747038750392, -122.493860404631)
95544 58020 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 4020 Irving St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/19/2016 11:16:00 AM 3   Permit Number 16987 5983299.23983496 2106318.86318391 37.7625828423592 -122.500941055889 (37.7625828423592, -122.500941055889)
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)
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)
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)
103563 108764 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 500X Lathrop Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
103975 108778 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 500X Lathrop Ave 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
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)
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)
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)
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)
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)
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)
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)
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)
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)
115109 87558 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 3906 Judah St 7 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   03/23/2015 05:19:00 PM 3     5982438.0 2105598.0 37.7605529521075 -122.50386633030199 (37.7605529521075, -122.503866330302)
115536 50120 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 243 Vicente St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/14/2012 12:00:00 AM     Permit Number 769150 5992346.75268289 2097836.73381964 37.7398201819052 -122.469031933295 (37.7398201819052, -122.469031933295)
115794 108772 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 500X Lathrop Ave 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
117507 38914 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 70 Borica St 2 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)
118548 48663 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 1300 11th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2002 12:00:00 AM     Permit Number 45949 5992726.08644889 2106595.37916826 37.76389107150929 -122.468357408335 (37.7638910715093, -122.468357408335)
120284 52292 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 100 Tiffany Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/29/2005 12:00:00 AM     Permit Number 48451 6006201.82590602 2099532.89904471 37.7452682661505 -122.421247257698 (37.7452682661505, -122.421247257698)
122625 59404 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 129 Rousseau St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/05/2016 12:00:00 AM     Permit Number 770892 6003547.68037437 2095024.45734525 37.732739127589895 -122.43010328255899 (37.7327391275899, -122.430103282559)
122641 98557 DPW Maintained 3 Lagunaria patersonii :: Primrose Tree 48 3906 Judah St 4 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   09/07/2012 12:00:00 AM 3     5982438.0 2105598.0 37.7605529521075 -122.50386633030199 (37.7605529521075, -122.503866330302)
124292 43060 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 3054 TARAVAL ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/07/2000 12:00:00 AM     Permit Number 53563 5983697.0 2098912.0 37.7422690003261 -122.499018090006 (37.7422690003261, -122.499018090006)
125423 92663 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 791 San Bruno Ave 1 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)
125737 50110 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 250 Taraval St 1 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)
125857 39613 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 577 Frederick St 1 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)
126920 41825 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 2511 Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/20/2000 12:00:00 AM     Permit Number 42211 5998436.39026341 2111725.32035622 37.77830474661771 -122.44897683474 (37.7783047466177, -122.44897683474)
127494 108775 Permitted Site 1 Lagunaria patersonii :: Primrose Tree 48 500X Lathrop Ave 14 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)

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