Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1367 | 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) | |
24388 | 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) | ||
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) | ||
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) | |
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) | |
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) | |
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) | |
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) | |
102591 | 102591 | 49895 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 1411 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 4 | 3x3 | Permit Number 46669 | 6007945.54854347 | 2107355.95750477 | 37.7668467518318 | -122.41577157383699 | (37.7668467518318, -122.415771573837) |
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) | |
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) | |
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) | ||
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) |
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) | |
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) | |
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) | |
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) | |
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) | |
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) | |
24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
27087 | 27087 | 191234 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014153.116769999 | 2095403.12134 | 37.734373817081796 | -122.39346385049299 | (37.7343738170818, -122.393463850493) | |||
27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
28609 | 28609 | 227574 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 11 Beaver St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002707.53405 | 2106779.67068 | 37.764968555288 | -122.43384779545299 | (37.764968555288, -122.433847795453) | |||
29298 | 29298 | 191239 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 2ft | 6014110.40607 | 2095343.3649799998 | 37.7342073651799 | -122.39360733551399 | (37.7342073651799, -122.393607335514) | |||
35827 | 35827 | 227133 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5999502.6369199995 | 2100390.28597 | 37.7472424869628 | -122.44447345808999 | (37.7472424869628, -122.44447345809) | |||
38084 | 38084 | 207023 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997061.0236599995 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | |||
38228 | 38228 | 227149 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007719.361409999 | 2095678.5372900001 | 37.734770477458795 | -122.41572699582301 | (37.7347704774588, -122.415726995823) | |||
47223 | 47223 | 207040 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996029.169869999 | 2093727.8612799998 | 37.728750294270604 | -122.456002788314 | (37.7287502942706, -122.456002788314) | |||
48291 | 48291 | 227577 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 18 Dehon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6003773.27056 | 2106456.0684 | 37.7641404406581 | -122.43013859382299 | (37.7641404406581, -122.430138593823) | |||
54346 | 54346 | 227582 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000368.64642 | 2106819.9498400004 | 37.7649461504603 | -122.44194028911501 | (37.7649461504603, -122.441940289115) | |||
55628 | 55628 | 227559 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.2761699995 | 2104538.3206 | 37.758702584674204 | -122.44048780488001 | (37.7587025846742, -122.44048780488) | |||
56847 | 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) | ||
59198 | 59198 | 227086 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6009619.77164 | 2096165.8193400002 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) | |||
60676 | 60676 | 129381 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.41388359157699 | (37.7856101663154, -122.413883591577) | |||
61434 | 61434 | 227118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.743898754514106 | -122.42235811905701 | (37.7438987545141, -122.422358119057) | |||
64119 | 64119 | 227082 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4021 Mission St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6004538.86235 | 2095169.3396700001 | 37.7331930297319 | -122.426686831253 | (37.7331930297319, -122.426686831253) | |||
116434 | 116434 | 227156 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3458 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007201.92693 | 2104423.1326599997 | 37.758752066271704 | -122.41813569949801 | (37.7587520662717, -122.418135699498) | |||
129668 | 129668 | 207044 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 755 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | |||
130069 | 130069 | 84554 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 804 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/16/2006 12:00:00 AM | 4 | 5986976.65331 | 2110412.96099 | 37.7740393278808 | -122.488523300237 | (37.7740393278808, -122.488523300237) | ||
131491 | 131491 | 227124 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.74872258759179 | -122.435779604843 | (37.7487225875918, -122.435779604843) | |||
132209 | 132209 | 207033 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Quintara St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993145.27059 | 2101214.49823 | 37.74914077145029 | -122.46651646199301 | (37.7491407714503, -122.466516461993) | |||
133679 | 133679 | 207045 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998977.59415 | 2096753.4397599997 | 37.737226608721706 | -122.446027465895 | (37.7372266087217, -122.446027465895) | |||
134142 | 134142 | 191226 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2350 20th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 6011107.06002 | 2104648.42845 | 37.7595897074225 | -122.40464574203199 | (37.7595897074225, -122.404645742032) | |||
134344 | 134344 | 206998 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 223 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994252.21923 | 2105280.12164 | 37.7603677459862 | -122.462983582339 | (37.7603677459862, -122.462983582339) | |||
136194 | 136194 | 227101 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003382.77934 | 2099193.25446 | 37.744176348274294 | -122.43097080757799 | (37.7441763482743, -122.430970807578) | |||
137913 | 137913 | 176893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 La Grande Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005229.89136 | 2092027.9096099997 | 37.7246064008395 | -122.42407442931601 | (37.7246064008395, -122.424074429316) | |||
138092 | 138092 | 176895 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 70 La Grande Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005265.09064 | 2091962.62602 | 37.724429133675706 | -122.42394810962 | (37.7244291336757, -122.42394810962) | |||
143316 | 143316 | 102935 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 801X Church St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6004394.3 | 2104124.7 | 37.757774211767796 | -122.427824502367 | (37.7577742117678, -122.427824502367) | |||
153028 | 153028 | 129390 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 902 Vallejo St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6009192.86484 | 2118752.75452 | 37.798209676283 | -122.41226288822399 | (37.798209676283, -122.412262888224) | |||
153496 | 153496 | 227150 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008185.203290001 | 2095640.9266099997 | 37.7346933830922 | -122.41411375505301 | (37.7346933830922, -122.414113755053) | |||
157266 | 157266 | 207035 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993108.07657 | 2101214.12996 | 37.749137613916396 | -122.46664505153299 | (37.7491376139164, -122.466645051533) | |||
158616 | 158616 | 129380 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 730 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008321.927730001 | 2115014.63424 | 37.7878968077251 | -122.415011874722 | (37.7878968077251, -122.415011874722) | |||
160084 | 160084 | 191225 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2350 20th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011119.4005 | 2104649.28038 | 37.759592736331705 | -122.404603122242 | (37.7595927363317, -122.404603122242) | ||||
169335 | 169335 | 176907 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006492.037819999 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | |||
170816 | 170816 | 227585 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003798.52213 | 2108785.73673 | 37.7705385756322 | -122.430217470683 | (37.7705385756322, -122.430217470683) | |||
170920 | 170920 | 207016 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 409 Edna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5998750.98669 | 2094179.12135 | 37.7301451967391 | -122.446625784855 | (37.7301451967391, -122.446625784855) | |||
172822 | 172822 | 207034 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Quintara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993127.0368800005 | 2101215.11136 | 37.7491414027515 | -122.466579558421 | (37.7491414027515, -122.466579558421) | |||
172851 | 172851 | 129382 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008704.563080001 | 2112447.63135 | 37.7808699297471 | -122.41350640150401 | (37.7808699297471, -122.413506401504) | |||
174051 | 174051 | 176889 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.42694318119499 | (37.7235644112504, -122.426943181195) | |||
180458 | 180458 | 227096 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3639 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6006022.631569999 | 2104312.28056 | 37.7583812443163 | -122.422206375532 | (37.7583812443163, -122.422206375532) | |||
180853 | 180853 | 227108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007939.95228 | 2098099.81155 | 37.741431163228604 | -122.41513566820299 | (37.7414311632286, -122.415135668203) | |||
182506 | 182506 | 83202 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | |||
183197 | 183197 | 129383 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008721.10925 | 2112450.3341200002 | 37.7808782799549 | -122.413449351208 | (37.7808782799549, -122.413449351208) | |||
183878 | 183878 | 176896 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 70 La Grande Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6005242.33299 | 2091887.7351799998 | 37.7242222149627 | -122.424021456542 | (37.7242222149627, -122.424021456542) | |||
187240 | 187240 | 191224 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2350 20th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6011129.67031 | 2104650.44992 | 37.7595965215873 | -122.404567686256 | (37.7595965215873, -122.404567686256) | ||||
187437 | 187437 | 119231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4327 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5982159.48772 | 2110285.61161 | 37.7734074014784 | -122.505176976845 | (37.7734074014784, -122.505176976845) | |||
59010 | 59010 | 116551 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.43660856033199 | (37.713721490625, -122.436608560332) | |||
64250 | 64250 | 116547 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | |||
158984 | 158984 | 116549 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001562.82912 | 2088145.2407900002 | 37.713737736870705 | -122.43647320339599 | (37.7137377368707, -122.436473203396) | |||
171144 | 171144 | 176918 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6001604.803669999 | 2088215.9120200002 | 37.713934169489704 | -122.43633317895599 | (37.7139341694897, -122.436333178956) |
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");