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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187121 | 187121 | 58124 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 527 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1978 12:00:00 AM | 1 | Permit Number 17106 | 5991241.869630001 | 2111793.32926 | 37.778077396785 | -122.473870058582 | (37.778077396785, -122.473870058582) | ||
| 184902 | 184902 | 95429 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1437 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767294 | 5988962.2823 | 2105532.8441 | 37.760755525792 | -122.48129730761801 | (37.760755525792, -122.481297307618) |
| 184622 | 184622 | 93188 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2010 12:00:00 AM | 10 | 3x3 | Permit Number 53196 | 6014934.44131 | 2097265.12572 | 37.73952988128521 | -122.39089262491001 | (37.7395298812852, -122.39089262491) | |
| 181980 | 181980 | 60927 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1506 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/13/1983 12:00:00 AM | 5 | Permit Number 20728 | 6010428.9415 | 2094674.9694599998 | 37.732166840331104 | -122.406288313254 | (37.7321668403311, -122.406288313254) | ||
| 179306 | 179306 | 95828 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 174 Langton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767563 | 6010564.55165 | 2110346.83579 | 37.775205897855 | -122.40692364921301 | (37.775205897855, -122.406923649213) |
| 178063 | 178063 | 83917 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1484 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50173 | 5981576.71105327 | 2104986.37444115 | 37.75882292099771 | -122.50679971705401 | (37.7588229209977, -122.506799717054) | |
| 178000 | 178000 | 95108 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 445 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 54037 | 6002085.32525 | 2093826.71651 | 37.7293674729177 | -122.435073368138 | (37.7293674729177, -122.435073368138) |
| 177014 | 177014 | 95521 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1510 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767313 | 5985302.4962 | 2104889.3961 | 37.7587753414156 | -122.49390726731899 | (37.7587753414156, -122.493907267319) |
| 176219 | 176219 | 88398 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51376 | 5987449.923219999 | 2113199.01189 | 37.7817166413541 | -122.48709085924 | (37.7817166413541, -122.48709085924) | |
| 176002 | 176002 | 95742 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 86 Ina Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767488 | 6004830.443109999 | 2091416.58174 | 37.7229052675357 | -122.42541178684799 | (37.7229052675357, -122.425411786848) |
| 175666 | 175666 | 49818 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 7 | 3x3 | Permit Number 46609 | 6012222.38132 | 2102319.17957 | 37.7532563730854 | -122.400624753529 | (37.7532563730854, -122.400624753529) |
| 174850 | 174850 | 60223 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1230 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52240 | 6009426.5919699995 | 2117542.6242 | 37.7949000677337 | -122.41136858440399 | (37.7949000677337, -122.411368584404) | |
| 174682 | 174682 | 31938 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1335 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50210 | 5981495.7067 | 2105969.8095 | 37.761518381611 | -122.507152818801 | (37.761518381611, -122.507152818801) | |
| 174335 | 174335 | 48448 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 238 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/2002 12:00:00 AM | 7 | Permit Number 45820 | 5997868.1487 | 2109737.2703 | 37.7728135614974 | -122.45079920226999 | (37.7728135614974, -122.45079920227) | ||
| 174068 | 174068 | 45661 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 315 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/03/2005 12:00:00 AM | 6 | Permit Number 44357 | 6002302.86118 | 2091870.5211200002 | 37.72400855223739 | -122.43418153744899 | (37.7240085522374, -122.434181537449) | |
| 171343 | 171343 | 83264 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 483 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52321 | 6001958.211069999 | 2090814.3138299999 | 37.721088877137795 | -122.43529742254 | (37.7210888771378, -122.43529742254) | |
| 171102 | 171102 | 41786 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 11 | Permit Number 42194 | 6011862.446140001 | 2107450.91483 | 37.767326897836206 | -122.40223026280898 | (37.7673268978362, -122.402230262809) | |
| 168844 | 168844 | 92401 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1215 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52801 | 5985169.7 | 2106911.6 | 37.764319978357896 | -122.494515603708 | (37.7643199783579, -122.494515603708) |
| 167979 | 167979 | 95712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 642 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767468 | 6003074.18539 | 2089625.7401 | 37.7178886288451 | -122.431355025819 | (37.7178886288451, -122.431355025819) |
| 167111 | 167111 | 92440 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1352 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 52830 | 5982162.933999999 | 2105885.2573 | 37.7613255007309 | -122.504838927947 | (37.7613255007309, -122.504838927947) |
| 166649 | 166649 | 50185 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/01/2007 12:00:00 AM | 6 | 3x3 | Permit Number 49870 | 5987999.15348 | 2115065.15007 | 37.7868725355783 | -122.485327781661 | (37.7868725355783, -122.485327781661) | |
| 166011 | 166011 | 83491 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1966 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50181 | 5981376.6636 | 2101684.6102 | 37.7497454310313 | -122.507246608859 | (37.7497454310313, -122.507246608859) | |
| 164036 | 164036 | 83364 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 319 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52323 | 6002520.66221 | 2091711.14442 | 37.7235832988126 | -122.43341725042102 | (37.7235832988126, -122.433417250421) | |
| 162953 | 162953 | 40073 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Thornton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014207.29735 | 2094114.30982 | 37.7308380137496 | -122.393186376362 | (37.7308380137496, -122.393186376362) | |
| 162744 | 162744 | 37654 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1108 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51611 | 5992123.06102 | 2110701.1817099997 | 37.775129656063 | -122.47074215707899 | (37.775129656063, -122.470742157079) | |
| 162634 | 162634 | 95938 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 770 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767634 | 5986967.37973 | 2110670.26469 | 37.774745270265605 | -122.48857429400101 | (37.7747452702656, -122.488574294001) |
| 162362 | 162362 | 96799 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 438 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/07/2012 12:00:00 AM | 2 | Permit Number 769004 | 5983479.2923099995 | 2112857.21489 | 37.780545845051705 | -122.500801866987 | (37.7805458450517, -122.500801866987) | ||
| 162299 | 162299 | 83558 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 483 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52321 | 6001949.50225 | 2090800.0636599998 | 37.7210492547906 | -122.435326507535 | (37.7210492547906, -122.435326507535) | |
| 159581 | 159581 | 52456 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 757 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/26/2013 12:00:00 AM | 1 | Permit Number 770898 | 5992550.20906 | 2110320.92766 | 37.774110273254706 | -122.46923688790599 | (37.7741102732547, -122.469236887906) | |
| 159233 | 159233 | 95677 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 231 Harvard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767429 | 6006245.60839 | 2092760.95718 | 37.726676485510204 | -122.420615232913 | (37.7266764855102, -122.420615232913) |
| 158472 | 158472 | 82807 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 130 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52471 | 6006613.173690001 | 2094127.5012599998 | 37.730449426586794 | -122.41944147464301 | (37.7304494265868, -122.419441474643) | |
| 158124 | 158124 | 52937 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 436@THERESA Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2006 12:00:00 AM | 9 | Permit Number 48924 | 6002078.69882 | 2093873.61529 | 37.729495870020706 | -122.43509962926599 | (37.7294958700207, -122.435099629266) | |
| 156738 | 156738 | 82909 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 51 Princeton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52470 | 6007555.60486 | 2093720.9952900002 | 37.729386285836796 | -122.416154567675 | (37.7293862858368, -122.416154567675) |
| 153522 | 153522 | 50036 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 73 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 9 | Permit Number 46766 | 6007832.621069999 | 2093714.43935 | 37.729383856755796 | -122.41519642998199 | (37.7293838567558, -122.415196429982) | |
| 153309 | 153309 | 88186 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51193 | 6008751.52799 | 2109978.60624 | 37.774093208961204 | -122.41316928526001 | (37.7740932089612, -122.41316928526) | |
| 153240 | 153240 | 95898 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767603 | 5989073.1619 | 2103670.6386 | 37.755648856222 | -122.48077749293999 | (37.755648856222, -122.48077749294) |
| 153201 | 153201 | 98850 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1795X 31st Ave | 3 | 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) | |
| 152533 | 152533 | 51411 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1578 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51340 | 5989038.1128 | 2104597.9638 | 37.7581930050331 | -122.48096659569299 | (37.7581930050331, -122.480966595693) | |
| 151807 | 151807 | 64570 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1624 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51014 | 6000044.7870000005 | 2110256.6597 | 37.7743640319269 | -122.44330729771099 | (37.7743640319269, -122.443307297711) | |
| 151310 | 151310 | 64568 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1888 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51776 | 6000584.4368 | 2111720.2430000002 | 37.7784134187795 | -122.441545602938 | (37.7784134187795, -122.441545602938) | |
| 150847 | 150847 | 52442 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2310 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/22/2005 12:00:00 AM | 5 | Permit Number 48553 | 6003588.30454 | 2116614.49532 | 37.7920224826905 | -122.43150359293301 | (37.7920224826905, -122.431503592933) | |
| 150268 | 150268 | 49761 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 366@ REY Leland Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2003 12:00:00 AM | 4 | Permit Number 46555 | 6008949.54261 | 2087928.8807700002 | 37.713560633393 | -122.41092664676 | (37.713560633393, -122.41092664676) | |
| 150199 | 150199 | 88615 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 521 03rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.63478 | 2111950.42136 | 37.7787241118896 | -122.46097548106701 | (37.7787241118896, -122.460975481067) | |
| 150165 | 150165 | 88483 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51432 | 6014835.95113 | 2096251.5284900002 | 37.7367412859786 | -122.39116233337201 | (37.7367412859786, -122.391162333372) | |
| 149498 | 149498 | 65594 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1221 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/1990 12:00:00 AM | 7 | Permit Number 28496 | 6014809.91986 | 2096215.04668 | 37.7366396697686 | -122.391249786165 | (37.7366396697686, -122.391249786165) | ||
| 148929 | 148929 | 63095 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1314 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/04/2016 12:00:00 AM | 1 | Permit Number 775034 | 5982157.61974918 | 2106142.20642168 | 37.7620306969809 | -122.504876348182 | (37.7620306969809, -122.504876348182) | ||
| 148658 | 148658 | 40072 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Thornton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/19/1999 12:00:00 AM | 10 | Permit Number 41298 | 6014219.27435 | 2094112.15212 | 37.73083275450529 | -122.393144818701 | (37.7308327545053, -122.393144818701) | |
| 147945 | 147945 | 52071 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 939 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2005 12:00:00 AM | 7 | Permit Number 48265 | 6009677.58908 | 2117754.14875 | 37.7954949369081 | -122.41051503874701 | (37.7954949369081, -122.410515038747) | ||
| 146911 | 146911 | 79199 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 409 Laurel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/2015 12:00:00 AM | 1 | Permit Number 777130 | 5998120.56156 | 2115036.84682 | 37.7873792631851 | -122.450308169597 | (37.7873792631851, -122.450308169597) | |
| 146605 | 146605 | 41785 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 101 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 13 | Permit Number 42194 | 6011884.29769 | 2107452.29856 | 37.7673319169518 | -122.402154778231 | (37.7673319169518, -122.402154778231) | |
| 145967 | 145967 | 96065 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 168 Richland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767690 | 6005459.8 | 2096128.8 | 37.7358795176789 | -122.423571087421 | (37.7358795176789, -122.423571087421) | |
| 145721 | 145721 | 95900 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1700 23rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767603 | 5989092.0 | 2103686.6 | 37.7556937768723 | -122.48071351405399 | (37.7556937768723, -122.480713514054) | |
| 145696 | 145696 | 47037 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 714 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2015 12:00:00 AM | Permit Number 776491 | 6002280.60768666 | 2108833.96933031 | 37.770584918853395 | -122.435471392977 | (37.7705849188534, -122.435471392977) | ||
| 145610 | 145610 | 45368 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 201x OGDEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/28/2001 12:00:00 AM | Permit Number 44193 | 6007843.0 | 2096159.0 | 37.7360966727045 | -122.415333535238 | (37.7360966727045, -122.415333535238) | ||
| 145553 | 145553 | 94670 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 1 | 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) | |
| 145537 | 145537 | 104730 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.5479200003 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | |
| 145049 | 145049 | 52944 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 20 Paulding St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2006 12:00:00 AM | Permit Number 48931 | 6000207.27773758 | 2093260.71462594 | 37.727706542786 | -122.44152533408399 | (37.727706542786, -122.441525334084) | |||
| 144940 | 144940 | 88723 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51659 | 6001771.0 | 2109412.0 | 37.772143091507296 | -122.43727552323799 | (37.7721430915073, -122.437275523238) | ||
| 144821 | 144821 | 47551 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1689 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45415 | 6003395.23441175 | 2098403.20907691 | 37.7420077721371 | -122.430871369414 | (37.7420077721371, -122.430871369414) | ||
| 144399 | 144399 | 104731 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 440X Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | Permit Number 771053 | 5991576.41061 | 2099773.5479200003 | 37.7450936377729 | -122.471836544912 | (37.7450936377729, -122.471836544912) | |
| 144304 | 144304 | 88645 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 2500x Larkin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2008 12:00:00 AM | 3x3 | Permit Number 51618 | 6006882.7 | 2119972.1 | 37.8014277902223 | -122.420343352043 | (37.8014277902223, -122.420343352043) | |||
| 144080 | 144080 | 47592 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 143883 | 143883 | 88733 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 56 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51668 | 6004334.0 | 2108794.0 | 37.7705915794801 | -122.428365836994 | (37.7705915794801, -122.428365836994) | ||
| 143579 | 143579 | 46893 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1383 11th Ave | 2 | 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) | ||
| 142118 | 142118 | 115183 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3610 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | Permit Number 774488 | 5982230.3 | 2100857.8 | 37.747525483427296 | -122.50423350924 | (37.7475254834273, -122.50423350924) | |||
| 142052 | 142052 | 69101 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1672 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773502 | 5992502.12347703 | 2104077.04435662 | 37.756963447375796 | -122.468948742276 | (37.7569634473758, -122.468948742276) |
| 141540 | 141540 | 115381 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1657X York St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 775521 | 6010720.61658 | 2099977.2132599996 | 37.7467419766429 | -122.405653246985 | (37.7467419766429, -122.405653246985) | ||
| 141295 | 141295 | 59241 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 138 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | Permit Number 18570 | 5998056.20401336 | 2105984.36092392 | 37.762519790788396 | -122.449878183328 | (37.7625197907884, -122.449878183328) | ||
| 141159 | 141159 | 113139 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1799x 25TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5988397.0 | 2103119.0 | 37.754094880795606 | -122.48307541499399 | (37.7540948807956, -122.483075414994) | ||||
| 140964 | 140964 | 108825 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 146-150X Gillette Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 773819 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | |
| 140250 | 140250 | 50524 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3651 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2003 12:00:00 AM | Permit Number 47164 | 6005968.07304834 | 2104305.31315666 | 37.758359035924 | -122.42239456826401 | (37.758359035924, -122.422394568264) | ||
| 140129 | 140129 | 52129 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2008 12:00:00 AM | 3x3 | Permit Number 51660 | 6002806.0471415995 | 2109304.34219127 | 37.7719062747483 | -122.433687517115 | (37.7719062747483, -122.433687517115) | ||
| 140085 | 140085 | 44279 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1588 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 3x3 | Permit Number 767652 | 6014189.45600011 | 2095460.4720273998 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | |
| 139815 | 139815 | 47598 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | Permit Number 45435 | 6009710.93340167 | 2096438.06354235 | 37.7369677288425 | -122.408894986555 | (37.7369677288425, -122.408894986555) | ||
| 139293 | 139293 | 38921 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 749 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/02/1998 12:00:00 AM | Permit Number 40731 | 5994544.80644489 | 2089901.89590816 | 37.718159804985795 | -122.460857119734 | (37.7181598049858, -122.460857119734) | ||
| 139012 | 139012 | 102200 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 579 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769774 | 6002583.2 | 2103808.0 | 37.7568020093443 | -122.43406539067301 | (37.7568020093443, -122.434065390673) |
| 138846 | 138846 | 115174 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1234 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2016 12:00:00 AM | Permit Number 777353 | 5981842.5 | 2106688.0 | 37.7635107458641 | -122.506006674694 | (37.7635107458641, -122.506006674694) | |||
| 138459 | 138459 | 83961 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 180 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2008 12:00:00 AM | 3x3 | Permit Number 50859 | 5997460.19616594 | 2106774.33360384 | 37.7646547355545 | -122.451996543237 | (37.7646547355545, -122.451996543237) | ||
| 138235 | 138235 | 87031 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 50 05th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52524 | 5994278.21944 | 2115255.72364 | 37.787759595502294 | -122.463617666169 | (37.7877595955023, -122.463617666169) | |
| 137957 | 137957 | 88614 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 521 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51567 | 5994972.3051 | 2111963.78431 | 37.7787607840169 | -122.460977590338 | (37.7787607840169, -122.460977590338) | |
| 137213 | 137213 | 94098 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 7 Colby St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2010 12:00:00 AM | 4 | Permit Number 53474 | 6007925.01702 | 2094192.51392 | 37.7307017385741 | -122.414910830466 | (37.7307017385741, -122.414910830466) | ||
| 136775 | 136775 | 88187 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 43 Dore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51193 | 6008740.44285 | 2109989.37217 | 37.774122147347796 | -122.413208392271 | (37.7741221473478, -122.413208392271) | |
| 135797 | 135797 | 51532 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 3155 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | 2 | Permit Number 47834 | 5999712.30266 | 2115373.4309400003 | 37.78839440084 | -122.44482529806001 | (37.78839440084, -122.44482529806) | ||
| 134834 | 134834 | 84816 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 736 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2009 12:00:00 AM | 4 | 3x3 | Permit Number 53031 | 6008319.9304599995 | 2115035.61847 | 37.7879543130824 | -122.415020270782 | (37.7879543130824, -122.415020270782) | |
| 134106 | 134106 | 94712 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 119 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53849 | 5993940.39408 | 2114713.66519 | 37.7862517797866 | -122.46474709013 | (37.7862517797866, -122.46474709013) |
| 133327 | 133327 | 43975 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4527 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2000 12:00:00 AM | 2 | Permit Number 43537 | 5981491.7088 | 2110943.54345 | 37.7751745750496 | -122.50753570575 | (37.7751745750496, -122.50753570575) | ||
| 132512 | 132512 | 68546 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 707 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767769 | 5982568.02637 | 2110928.64305 | 37.775197008277296 | -122.503811440592 | (37.7751970082773, -122.503811440592) |
| 132114 | 132114 | 96082 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 448 43rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767705 | 5982547.81502 | 2112777.5539599997 | 37.7802723877651 | -122.50401833246299 | (37.7802723877651, -122.504018332463) | |
| 129402 | 129402 | 88096 | 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) | |||
| 129114 | 129114 | 88495 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 27 Reddy St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2008 12:00:00 AM | 3x3 | Permit Number 51437 | 6013659.0 | 2094063.0 | 37.7306666521666 | -122.39507835000201 | (37.7306666521666, -122.395078350002) | |||
| 129031 | 129031 | 102064 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52559 | 6007929.8 | 2098099.2 | 37.7414289135067 | -122.415170728099 | (37.7414289135067, -122.415170728099) | |
| 128684 | 128684 | 48661 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1300 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/2005 12:00:00 AM | Permit Number 45949 | 5992726.08644889 | 2106595.37916826 | 37.76389107150929 | -122.468357408335 | (37.7638910715093, -122.468357408335) | ||
| 128406 | 128406 | 109744 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 4307 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772150 | 5981459.9 | 2104819.9 | 37.758358950394395 | -122.507191346523 | (37.7583589503944, -122.507191346523) |
| 128401 | 128401 | 27026 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1380X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2005 12:00:00 AM | 3 | 3X3 | 6009629.1666 | 2094382.2025400002 | 37.7313181942464 | -122.409032675373 | (37.7313181942464, -122.409032675373) | ||
| 128274 | 128274 | 94410 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 63 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2010 12:00:00 AM | 3x3 | Permit Number 53650 | 6001682.9 | 2108449.6 | 37.7694955715896 | -122.43751133674101 | (37.7694955715896, -122.437511336741) | ||
| 127494 | 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) | |
| 127325 | 127325 | 95684 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 334 Oxford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2011 12:00:00 AM | 3x3 | Permit Number 767433 | 6006626.2 | 2092405.9 | 37.72572301772 | -122.41927436138599 | (37.72572301772, -122.419274361386) | |
| 126920 | 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) | |||
| 126643 | 126643 | 27080 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 799X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/29/2009 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 125857 | 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) |
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");