Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3617 | 3617 | 196400 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 380x Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6011308.09655 | 2111275.91215 | 37.7777985048225 | -122.404416956276 | (37.7777985048225, -122.404416956276) | |||
| 24086 | 24086 | 178876 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 852 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6000760.9108 | 2088982.59449 | 37.7159913219087 | -122.439304903221 | (37.7159913219087, -122.439304903221) | |||
| 24617 | 24617 | 181947 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1651 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988027.6673 | 2098939.5018 | 37.7425975937033 | -122.484046173892 | (37.7425975937033, -122.484046173892) | |||
| 24750 | 24750 | 182725 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1734 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987217.2069 | 2103447.5916 | 37.7549283802803 | -122.487179505586 | (37.7549283802803, -122.487179505586) | |||
| 25806 | 25806 | 214442 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991187.94391 | 2101152.05769 | 37.7488561836758 | -122.47328030175801 | (37.7488561836758, -122.473280301758) | |||
| 26149 | 26149 | 142789 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 625 LARKIN ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007523.6751 | 2113458.738 | 37.783579806807296 | -122.417663367701 | (37.7835798068073, -122.417663367701) | |||
| 27753 | 27753 | 178904 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 10x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6011792.88406 | 2090769.7339700002 | 37.7215200714836 | -122.401298496839 | (37.7215200714836, -122.401298496839) | |||
| 28014 | 28014 | 138798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1827 Broderick St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000492.2704 | 2114959.4269 | 37.7873021338531 | -122.44209701285101 | (37.7873021338531, -122.442097012851) | |||
| 29283 | 29283 | 95438 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2186 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767300 | 5986698.9662 | 2100381.1584 | 37.746478551124504 | -122.48874631833598 | (37.7464785511245, -122.488746318336) |
| 29296 | 29296 | 244956 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 298 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005155.9394 | 2109820.0209 | 37.77345526051 | -122.42559577205 | (37.77345526051, -122.42559577205) | |||
| 29397 | 29397 | 38753 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Shipley St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/20/1998 12:00:00 AM | 1 | Permit Number 40630 | 6012187.7155 | 2112376.5476 | 37.780869712107396 | -122.40145140226002 | (37.7808697121074, -122.40145140226) | ||
| 30952 | 30952 | 182628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1890 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988800.9853 | 2102469.1319999998 | 37.7523340169161 | -122.48163075760901 | (37.7523340169161, -122.481630757609) | |||
| 32754 | 32754 | 138797 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1823 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000490.7856 | 2114966.8512 | 37.7873224344393 | -122.442102683059 | (37.7873224344393, -122.442102683059) | |||
| 32814 | 32814 | 214424 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 732 Shields St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992045.199469999 | 2089870.8873400001 | 37.7179305201634 | -122.469494855606 | (37.7179305201634, -122.469494855606) | |||
| 32988 | 32988 | 196389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013924.26567 | 2112893.70041 | 37.7823864349182 | -122.395480022606 | (37.7823864349182, -122.395480022606) | |||
| 35621 | 35621 | 181328 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1749 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987757.6067 | 2098927.9954 | 37.742550273655 | -122.484979108902 | (37.742550273655, -122.484979108902) | |||
| 35756 | 35756 | 218355 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993521.424240001 | 2100014.7209799998 | 37.7458681870785 | -122.465128597612 | (37.7458681870785, -122.465128597612) | |||
| 36002 | 36002 | 38898 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 127 Parker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/2003 12:00:00 AM | 1 | Permit Number 40712 | 5996846.0934 | 2113584.1977 | 37.78331765575871 | -122.45461255567301 | (37.7833176557587, -122.454612555673) | |
| 36062 | 36062 | 96607 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1655 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/04/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768135 | 5988818.1686 | 2103045.0516 | 37.7539163374898 | -122.48161351303601 | (37.7539163374898, -122.481613513036) | |
| 37315 | 37315 | 68135 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1640 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/2011 12:00:00 AM | 1 | Permit Number 767463 | 6000632.1236 | 2114329.1398 | 37.7855794974585 | -122.44156790404699 | (37.7855794974585, -122.441567904047) | ||
| 37902 | 37902 | 60819 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1607 Pacheco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 1 | Permit Number 20497 | 5989955.2951 | 2101733.4508 | 37.7503810843418 | -122.477585243781 | (37.7503810843418, -122.477585243781) | |
| 37946 | 37946 | 244981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 200 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6005180.5539 | 2109687.8318 | 37.7730936920725 | -122.425501217452 | (37.7730936920725, -122.425501217452) | |||
| 38035 | 38035 | 92473 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2408 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52855 | 5988531.9158 | 2098337.111 | 37.7409729307865 | -122.482258526052 | (37.7409729307865, -122.482258526052) |
| 38525 | 38525 | 182391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1555 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5988367.831 | 2104720.8488 | 37.7584914283371 | -122.48329370054199 | (37.7584914283371, -122.483293700542) | |||
| 38600 | 38600 | 237996 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 741 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001915.60449 | 2101837.36295 | 37.7513532016953 | -122.436233155455 | (37.7513532016953, -122.436233155455) | |||
| 38634 | 38634 | 138786 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1844 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6001549.1292 | 2114811.3044 | 37.7869555995023 | -122.43842989547701 | (37.7869555995023, -122.438429895477) | |||
| 38667 | 38667 | 140316 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2118 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997686.3851 | 2109923.9689 | 37.7733157811634 | -122.451441408617 | (37.7733157811634, -122.451441408617) | |||
| 39287 | 39287 | 31050 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.195830001 | 2087448.13614 | 37.711895858785894 | -122.432025692555 | (37.7118958587859, -122.432025692555) | |
| 39971 | 39971 | 218354 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 365 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5993503.7358800005 | 2100017.05504 | 37.745873575808794 | -122.46518993049801 | (37.7458735758088, -122.465189930498) | |||
| 40255 | 40255 | 51768 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982945.3427 | 2104265.0097 | 37.756922756494106 | -122.50201305526699 | (37.7569227564941, -122.502013055267) |
| 43246 | 43246 | 247776 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 228 30th St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6005091.07435 | 2098463.74529 | 37.7422699303121 | -122.425011997728 | (37.7422699303121, -122.425011997728) | |||
| 43582 | 43582 | 214394 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 191 Granville Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994343.40984 | 2098666.78046 | 37.742214445742896 | -122.46218856725201 | (37.7422144457429, -122.462188567252) | |||
| 43735 | 43735 | 50229 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1346 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | 1 | Permit Number 46937 | 5987742.4672 | 2106112.8615 | 37.76227710092729 | -122.485558616267 | (37.7622771009273, -122.485558616267) | |
| 44345 | 44345 | 181814 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2169 Santiago St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986311.3611 | 2099566.4282 | 37.7442188936716 | -122.49002668010799 | (37.7442188936716, -122.490026680108) | |||
| 44756 | 44756 | 97495 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988364.44571 | 2111930.92454 | 37.778288112362 | -122.483834071993 | (37.778288112362, -122.483834071993) | |
| 44762 | 44762 | 48666 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1715REVISED Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/13/2003 12:00:00 AM | 1 | Permit Number 45950 | 6004823.677 | 2115363.4456 | 37.7886573555281 | -122.42714004151699 | (37.7886573555281, -122.427140041517) | |
| 45248 | 45248 | 184305 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1562 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5984382.3056 | 2104532.0637 | 37.757740324240295 | -122.497063286444 | (37.7577403242403, -122.497063286444) | |||
| 46496 | 46496 | 92773 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 135 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52993 | 5997556.9484 | 2112845.9305 | 37.7813313140415 | -122.452100007845 | (37.7813313140415, -122.452100007845) | |
| 46911 | 46911 | 95592 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985769.8829 | 2100165.3986 | 37.7458318703149 | -122.491943057318 | (37.7458318703149, -122.491943057318) |
| 47858 | 47858 | 142823 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006601.0091 | 2116911.6099 | 37.79300857718 | -122.421100695716 | (37.79300857718, -122.421100695716) | |||
| 48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
| 48076 | 48076 | 44724 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1970 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 1 | Permit Number 43843 | 5989436.9907 | 2101937.2229 | 37.750910497817294 | -122.479392462675 | (37.7509104978173, -122.479392462675) | |
| 48508 | 48508 | 183557 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1606 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987960.4417 | 2097637.0195 | 37.7390174057998 | -122.48418311934999 | (37.7390174057998, -122.48418311935) | |||
| 48579 | 48579 | 178918 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993792.015380001 | 2086765.64003 | 37.709505048900496 | -122.46323172778 | (37.7095050489005, -122.46323172778) | ||||
| 48718 | 48718 | 97494 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3300@ Anza Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2011 12:00:00 AM | 1 | 3x3 | Permit Number 768251 | 5988382.76278 | 2111930.5362 | 37.778288112363796 | -122.483770678777 | (37.7782881123638, -122.483770678777) | |
| 49057 | 49057 | 142822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1742 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 0ft | 6006604.1049 | 2116897.4579 | 37.7929698938345 | -122.421088978741 | (37.7929698938345, -122.421088978741) | |||
| 49341 | 49341 | 138118 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1700 SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004348.6538 | 2114674.3634 | 37.7867384352501 | -122.42873440937201 | (37.7867384352501, -122.428734409372) | |||
| 49418 | 49418 | 104126 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1330 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 8x6 | Permit Number 770527 | 6001460.4923 | 2110454.7269 | 37.774988502255 | -122.438424312648 | (37.774988502255, -122.438424312648) | ||
| 50845 | 50845 | 214391 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 181 Granville Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5994381.282869999 | 2098640.67197 | 37.742144938946204 | -122.462055722089 | (37.7421449389462, -122.462055722089) | |||
| 51252 | 51252 | 214403 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2140 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993695.41418 | 2101124.7709 | 37.7489261338491 | -122.464607559198 | (37.7489261338491, -122.464607559198) | |||
| 51415 | 51415 | 182275 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3150 Kirkham St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985063.5912 | 2105018.8618 | 37.7591168373077 | -122.49474304376001 | (37.7591168373077, -122.49474304376) | |||
| 52291 | 52291 | 214402 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 75 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993211.39069 | 2093578.01882 | 37.728176729173796 | -122.465733068822 | (37.7281767291738, -122.465733068822) | |||
| 52388 | 52388 | 178914 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993788.47929 | 2086756.5816799998 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | ||||
| 53380 | 53380 | 214420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 466 Victoria St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 5993273.262130001 | 2090266.31835 | 37.7190871751261 | -122.465278724129 | (37.7190871751261, -122.465278724129) | |||
| 54846 | 54846 | 196390 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013936.7797 | 2112901.90047 | 37.7824096464379 | -122.39543730389799 | (37.7824096464379, -122.395437303898) | |||
| 54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
| 55665 | 55665 | 178881 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 631 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002458.40291 | 2090087.03952 | 37.7191203367176 | -122.433516460014 | (37.7191203367176, -122.433516460014) | |||
| 56141 | 56141 | 120887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | |||
| 56991 | 56991 | 214441 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 720 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5991205.26954 | 2101153.09908 | 37.748860046264205 | -122.473220466273 | (37.7488600462642, -122.473220466273) | |||
| 57720 | 57720 | 196392 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 93 Stillman St | 4 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6013963.537140001 | 2112927.48749 | 37.7824813907387 | -122.39534652723499 | (37.7824813907387, -122.395346527235) | |||
| 59178 | 59178 | 182739 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1755 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5985933.2204 | 2103292.5347 | 37.7544276818477 | -122.491608417213 | (37.7544276818477, -122.491608417213) | |||
| 59581 | 59581 | 138813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1605 BAKER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6000066.1969 | 2114526.3397 | 37.7860886985052 | -122.44354001020399 | (37.7860886985052, -122.443540010204) | |||
| 60297 | 60297 | 182224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1599 35th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985275.2811 | 2104383.8376 | 37.7573856255252 | -122.493964129886 | (37.7573856255252, -122.493964129886) | |||
| 61059 | 61059 | 182221 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2830 Lawton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5985427.0921 | 2104352.0968 | 37.7573073554199 | -122.493436776332 | (37.7573073554199, -122.493436776332) | |||
| 61322 | 61322 | 120888 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009826.3305 | 2087573.9471 | 37.7126351844606 | -122.40787112709101 | (37.7126351844606, -122.407871127091) | |||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 61537 | 61537 | 71798 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2126 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1995 12:00:00 AM | 1 | 5997657.8233 | 2109919.8494 | 37.7733028345136 | -122.451539910128 | (37.7733028345136, -122.451539910128) | ||
| 62754 | 62754 | 214473 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 766 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997009.81636 | 2095018.0676900002 | 37.732349130199296 | -122.452705728912 | (37.7323491301993, -122.452705728912) | |||
| 63044 | 63044 | 196410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009614.35227 | 2111076.8827400003 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | |||
| 63435 | 63435 | 214440 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1746 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992520.380580001 | 2103558.15623 | 37.7555397706536 | -122.468847844656 | (37.7555397706536, -122.468847844656) | |||
| 63534 | 63534 | 120891 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009886.0438 | 2087551.2204 | 37.71257612443421 | -122.407663136759 | (37.7125761244342, -122.407663136759) | |||
| 64105 | 64105 | 142765 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 730 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007516.0375 | 2113852.9835 | 37.784661879382604 | -122.417717744325 | (37.7846618793826, -122.417717744325) | |||
| 64291 | 64291 | 140313 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2104 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997741.5862 | 2109932.7571 | 37.77334307210079 | -122.45125109527001 | (37.7733430721008, -122.45125109527) | |||
| 64861 | 64861 | 238007 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 150 Saint Germain Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997631.46598 | 2104146.92887 | 37.757450353356795 | -122.45121467184099 | (37.7574503533568, -122.451214671841) | |||
| 65590 | 65590 | 178916 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.46323686739599 | (37.7094935276652, -122.463236867396) | ||||
| 66527 | 66527 | 178915 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993789.8911 | 2086758.89685 | 37.70948641134179 | -122.46323858062 | (37.7094864113418, -122.46323858062) | ||||
| 67795 | 67795 | 178907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.46329046790501 | (37.7094983462303, -122.463290467905) | ||||
| 67840 | 67840 | 183942 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1805 Quintara St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987837.1544 | 2100978.5872 | 37.748185287488496 | -122.484854460213 | (37.7481852874885, -122.484854460213) | |||
| 68429 | 68429 | 185590 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2086 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986989.5241 | 2101082.1958 | 37.748420363683294 | -122.487793111063 | (37.7484203636833, -122.487793111063) | |||
| 68703 | 68703 | 178875 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 190 Foote Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998646.9675199995 | 2088361.56482 | 37.7141655911394 | -122.446567002474 | (37.7141655911394, -122.446567002474) | |||
| 68995 | 68995 | 214386 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2658 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991781.74675 | 2097342.53415 | 37.7384305734182 | -122.470949475734 | (37.7384305734182, -122.470949475734) | |||
| 69519 | 69519 | 142769 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 684 LARKIN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6007544.7694 | 2113646.7684 | 37.7840972796264 | -122.41760372057101 | (37.7840972796264, -122.417603720571) | |||
| 70066 | 70066 | 96023 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 668 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767664 | 6007549.8611 | 2113603.1249 | 37.783977731681496 | -122.417583010796 | (37.7839777316815, -122.417583010796) |
| 70597 | 70597 | 30894 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 133 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/1995 12:00:00 AM | 1 | Permit Number 34721 | 5996515.6245 | 2113531.2346 | 37.783153273367205 | -122.45575201055 | (37.7831532733672, -122.45575201055) | ||
| 70605 | 70605 | 83551 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1430 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52747 | 5989003.7874 | 2105594.4433 | 37.7609270735028 | -122.481158272381 | (37.7609270735028, -122.481158272381) |
| 72225 | 72225 | 103482 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 560 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6003141.00472 | 2090240.25972 | 37.719579750897104 | -122.431167899382 | (37.7195797508971, -122.431167899382) | |||
| 72387 | 72387 | 178871 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 276 Foote Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5998313.518130001 | 2088706.56781 | 37.7150938380738 | -122.44774434904801 | (37.7150938380738, -122.447744349048) | |||
| 73029 | 73029 | 61076 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2611 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 1 | Permit Number 20913 | 5999537.3607 | 2113600.286 | 37.783515821739705 | -122.445303028393 | (37.7835158217397, -122.445303028393) | |
| 73533 | 73533 | 196401 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 403 06th St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6011437.38165 | 2110998.36777 | 37.7770436561708 | -122.40395017576701 | (37.7770436561708, -122.403950175767) | |||
| 74407 | 74407 | 95447 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2210 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767309 | 5985770.3096 | 2100149.6093 | 37.745788542103206 | -122.49194041962099 | (37.7457885421032, -122.491940419621) |
| 74598 | 74598 | 135903 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 8 Marion Pl | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 6008339.85894 | 2119440.03353 | 37.8000488717233 | -122.41526322892 | (37.8000488717233, -122.41526322892) | ||||
| 74957 | 74957 | 120889 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 201 Leland Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 1 | 3x3 | 6009853.959 | 2087561.9153 | 37.71260369432971 | -122.407774785999 | (37.7126036943297, -122.407774785999) | |||
| 76456 | 76456 | 178908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | ||||
| 77100 | 77100 | 214458 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001469.66795 | 2094911.1287900002 | 37.73231004206529 | -122.437279364672 | (37.7323100420653, -122.437279364672) | |||
| 109056 | 109056 | 51769 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 3638 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52851 | 5982925.7859 | 2104266.232 | 37.7569249636711 | -122.50208077934201 | (37.7569249636711, -122.502080779342) |
| 122552 | 122552 | 60243 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1241 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/11/1982 12:00:00 AM | 1 | Permit Number 19795 | 5987983.8428 | 2106825.6856 | 37.7642483811973 | -122.48477609309201 | (37.7642483811973, -122.484776093092) | |
| 130134 | 130134 | 67100 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2612 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/1992 12:00:00 AM | 1 | Permit Number 30512 | 5999985.5896 | 2114062.5405 | 37.7848106287969 | -122.443785555927 | (37.7848106287969, -122.443785555927) | ||
| 130212 | 130212 | 92294 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2666 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52739 | 5989910.1386 | 2097230.9793 | 37.7380158497087 | -122.477412366526 | (37.7380158497087, -122.477412366526) |
| 130682 | 130682 | 44716 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1879 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 1 | Permit Number 43838 | 5989679.8369 | 2102593.1522 | 37.7527256083507 | -122.47860064969299 | (37.7527256083507, -122.478600649693) | |
| 132439 | 132439 | 138008 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1803 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6003906.6028 | 2114561.528 | 37.7864035892695 | -122.430255747535 | (37.7864035892695, -122.430255747535) |
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");