Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26189 | 26189 | 83205 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3437 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52337 | 6002190.72031 | 2120034.66861 | 37.8013340766633 | -122.436584154541 | (37.8013340766633, -122.436584154541) | |
| 26324 | 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 | 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) | |
| 26976 | 26976 | 82736 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3219 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767127 | 5984285.2795 | 2103578.3364 | 37.755115968323395 | -122.49732843264 | (37.7551159683234, -122.49732843264) |
| 27407 | 27407 | 98851 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
| 28135 | 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) | |
| 30724 | 30724 | 92441 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1368 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52832 | 5982163.8853 | 2105798.2136 | 37.7610865595393 | -122.504829187778 | (37.7610865595393, -122.504829187778) |
| 31123 | 31123 | 88188 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43-25 Dore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008699.51281 | 2110034.52168 | 37.7742438193359 | -122.413353170509 | (37.7742438193359, -122.413353170509) | |
| 31529 | 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) | |
| 33050 | 33050 | 95911 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1845 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767612 | 5989071.1412 | 2105102.6181 | 37.7595805696676 | -122.480889318141 | (37.7595805696676, -122.480889318141) |
| 33778 | 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) | |
| 34436 | 34436 | 88394 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.78679857243979 | -122.485322676521 | (37.7867985724398, -122.485322676521) | ||
| 34687 | 34687 | 88066 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51066 | 6012463.39117 | 2096075.79817 | 37.736126817888 | -122.399353026719 | (37.736126817888, -122.399353026719) | |
| 35363 | 35363 | 98849 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768753 | 5986486.2 | 2103095.0 | 37.7539176067687 | -122.489681571094 | (37.7539176067687, -122.489681571094) | |
| 36288 | 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) | |
| 36879 | 36879 | 69182 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1371 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50160 | 5982122.5039 | 2105769.199 | 37.7610044592096 | -122.50497015556499 | (37.7610044592096, -122.504970155565) | |
| 38736 | 38736 | 100491 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3978 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770312 | 5995766.62837 | 2114872.73446 | 37.786793659691895 | -122.45844035359801 | (37.7867936596919, -122.458440353598) | |
| 39062 | 39062 | 88481 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014818.59944 | 2096228.0421 | 37.7366758342199 | -122.391220684988 | (37.7366758342199, -122.391220684988) | |
| 39095 | 39095 | 84344 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 581 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 7 | 3x3 | Permit Number 49738 | 5987802.4392099995 | 2112041.1140799997 | 37.778557929673205 | -122.485786324881 | (37.7785579296732, -122.485786324881) | |
| 40793 | 40793 | 78252 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 541 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/17/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776648 | 6003018.571219999 | 2090471.0211200002 | 37.7202064317688 | -122.43160757344299 | (37.7202064317688, -122.431607573443) | |
| 41516 | 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 | 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 | 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) | |
| 42969 | 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) | |
| 43685 | 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 | 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) | |
| 45203 | 45203 | 83910 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1515 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50152 | 5982467.7611 | 2104767.4351 | 37.7582742066085 | -122.50370189101801 | (37.7582742066085, -122.503701891018) | |
| 46553 | 46553 | 95899 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989072.0669 | 2103701.2996 | 37.7557329794721 | -122.480783524363 | (37.7557329794721, -122.480783524363) |
| 47267 | 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) | |
| 48341 | 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 | 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) | |
| 49141 | 49141 | 83685 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009407.14931 | 2117677.56911 | 37.7952695029448 | -122.411445397284 | (37.7952695029448, -122.411445397284) | |
| 49235 | 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 | 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 | 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 | 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) | |
| 53126 | 53126 | 83686 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52242 | 6009408.292880001 | 2117660.17543 | 37.795221808298294 | -122.411440210903 | (37.7952218082983, -122.411440210903) | |
| 53372 | 53372 | 82870 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 110 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 53934 | 6006630.3997599995 | 2094273.0498 | 37.730850041273996 | -122.41939224306401 | (37.730850041274, -122.419392243064) |
| 54143 | 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) | |||
| 55448 | 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 | 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 | 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 | 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) | |
| 56096 | 56096 | 65853 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3415 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51130 | 6000770.44597 | 2120073.90569 | 37.8013609996628 | -122.44150173651501 | (37.8013609996628, -122.441501736515) | |
| 56157 | 56157 | 95935 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 706 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767632 | 5987262.82019 | 2111075.2653 | 37.7758745231149 | -122.48758207690001 | (37.7758745231149, -122.4875820769) |
| 56854 | 56854 | 88482 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014826.8932300005 | 2096240.8429 | 37.7367114428676 | -122.391192904038 | (37.7367114428676, -122.391192904038) | |
| 57766 | 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) | |
| 59233 | 59233 | 108371 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.719605888781295 | -122.43642558878 | (37.7196058887813, -122.43642558878) | ||
| 59525 | 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 | 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) | ||
| 62889 | 62889 | 57239 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1525 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50154 | 5982470.2056 | 2104724.6567 | 37.7581568929674 | -122.503690268992 | (37.7581568929674, -122.503690268992) | |
| 64001 | 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) | |
| 66540 | 66540 | 83309 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1519 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/23/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50153 | 5982468.6778 | 2104743.2959 | 37.758207981102295 | -122.50369693305099 | (37.7582079811023, -122.503696933051) | |
| 66808 | 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) | |
| 67482 | 67482 | 92392 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2506 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52796 | 5986151.5297 | 2098152.0694 | 37.7403261082431 | -122.49047530282301 | (37.7403261082431, -122.490475302823) |
| 69248 | 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 | 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 | 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 | 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 | 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) | ||
| 73444 | 73444 | 34680 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1904 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52535 | 6003705.30059 | 2119372.14104 | 37.7996008996227 | -122.43129571912701 | (37.7996008996227, -122.431295719127) | |
| 73450 | 73450 | 82700 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1506-1508 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52505 | 6015020.9353 | 2093436.9104 | 37.729023178313106 | -122.390326164865 | (37.7290231783131, -122.390326164865) | |
| 74591 | 74591 | 82945 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 51 Princeton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52470 | 6007551.81764 | 2093700.90463 | 37.729330908280204 | -122.416166238177 | (37.7293309082802, -122.416166238177) |
| 75293 | 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) | |
| 75601 | 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) | |
| 76000 | 76000 | 83687 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1250-1262 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52242 | 6009414.651880001 | 2117634.8999400004 | 37.7951527646548 | -122.41141642115801 | (37.7951527646548, -122.411416421158) | |
| 76646 | 76646 | 46375 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2214 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/09/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51267 | 5982984.1214 | 2100027.2965 | 37.745289455195 | -122.501565454542 | (37.745289455195, -122.501565454542) | |
| 77789 | 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) | ||
| 77857 | 77857 | 84000 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991504.89622125 | 2099785.75892313 | 37.7451230278663 | -122.47208471659799 | (37.7451230278663, -122.472084716598) | |
| 78895 | 78895 | 81730 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2346 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/2016 12:00:00 AM | 3 | 3x3 | Permit Number 774950 | 5982707.54204511 | 2099147.52139682 | 37.7428575871403 | -122.502456702486 | (37.7428575871403, -122.502456702486) | |
| 78971 | 78971 | 51607 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 800 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/20/2005 12:00:00 AM | 5 | 3x3 | Permit Number 47904 | 5997656.30420255 | 2107807.08178851 | 37.7675016300781 | -122.45139275313 | (37.7675016300781, -122.45139275313) |
| 79007 | 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) | |||
| 79452 | 79452 | 54871 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 250 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778523 | 6005357.45103895 | 2109955.71553685 | 37.773839229349704 | -122.424908369576 | (37.7738392293497, -122.424908369576) | |
| 79989 | 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) | |
| 80279 | 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 | 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 | 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 | 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 | 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 | 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) | ||
| 84032 | 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 | 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 | 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 | 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 | 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 | 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) | |
| 85798 | 85798 | 42693 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 3 | 3x3 | Permit Number 42711 | 6006694.5506045995 | 2119774.0082852 | 37.8008732765742 | -122.42098036158701 | (37.8008732765742, -122.420980361587) | |
| 86290 | 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 | 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) | ||
| 87710 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");