Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 131 | 131 | 237033 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 7 | : 4 | Tree 1 | DPW 2 | 6 | Width 4ft | 6005718.98472 | 2109769.85153 | 37.7733493059578 | -122.423644547079 | (37.7733493059578, -122.423644547079) | |||
| 135 | 135 | 237030 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 100 Octavia St | 4 | : 4 | Tree 1 | DPW 2 | 5 | Width 4ft | 6005725.94025 | 2109733.85532 | 37.773250861665204 | -122.423617927146 | (37.7732508616652, -122.423617927146) | |||
| 2141 | 2141 | 18982 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2920 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000616.67404 | 2115546.70514 | 37.7889217363036 | -122.44170876675699 | (37.7889217363036, -122.441708766757) | |||
| 4328 | 4328 | 28085 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2255 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6002770.4091 | 2114749.1272 | 37.786854268374796 | -122.43420010239201 | (37.7868542683748, -122.434200102392) | |||
| 7952 | 7952 | 17354 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2200 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6005542.87933 | 2117567.08542 | 37.7947486417029 | -122.424808539584 | (37.7947486417029, -122.424808539584) | |||
| 8875 | 8875 | 2624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1822 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004615.6699 | 2115060.0567 | 37.7878125608959 | -122.427838089219 | (37.7878125608959, -122.427838089219) | |||
| 11602 | 11602 | 27093 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006091.0826900005 | 2093593.66537 | 37.7289542101608 | -122.421208528251 | (37.7289542101608, -122.421208528251) | |||
| 11924 | 11924 | 27095 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 711 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X3 | 6006067.91108 | 2093593.9714799998 | 37.7289537443201 | -122.421288656069 | (37.7289537443201, -122.421288656069) | |||
| 12282 | 12282 | 17504 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002139.261969999 | 2091310.46109 | 37.7224614665061 | -122.43470704369 | (37.7224614665061, -122.43470704369) | |||
| 12793 | 12793 | 13368 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 900 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X50 | 6009218.46856 | 2090025.7710400003 | 37.719333336630896 | -122.410145089137 | (37.7193333366309, -122.410145089137) | |||
| 12903 | 12903 | 28302 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3410 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6012014.9954 | 2089805.7813099998 | 37.7188856424495 | -122.40046303743799 | (37.7188856424495, -122.400463037438) | |||
| 19906 | 19906 | 1353 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 284 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999905.46078 | 2099295.02318 | 37.7442581344216 | -122.44300188482401 | (37.7442581344216, -122.443001884824) | |||
| 20923 | 20923 | 1370 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 41 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 5999037.99816 | 2100015.3023099997 | 37.7461863501203 | -122.446053170314 | (37.7461863501203, -122.446053170314) | |||
| 21078 | 21078 | 1362 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 17 Amethyst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X1 | 5999159.03773 | 2100010.23642 | 37.7461793516141 | -122.445634267927 | (37.7461793516141, -122.445634267927) | |||
| 21550 | 21550 | 27620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1149 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010601.0802 | 2102491.1542599997 | 37.7536380210979 | -122.40624368710199 | (37.7536380210979, -122.406243687102) | |||
| 21590 | 21590 | 22829 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 88 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5999388.64339 | 2099036.75019 | 37.743519498737896 | -122.44477036118299 | (37.7435194987379, -122.444770361183) | |||
| 23069 | 23069 | 4182 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3830 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004950.59619 | 2100495.54046 | 37.747840838281796 | -122.42564230465 | (37.7478408382818, -122.42564230465) | |||
| 24090 | 24090 | 238060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Montezuma St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 3ft | 6007260.48935 | 2099759.47356 | 37.7459500163869 | -122.417602623671 | (37.7459500163869, -122.417602623671) | |||
| 37982 | 37982 | 237111 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2x Coso Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6007125.29232 | 2099860.06971 | 37.7462186223039 | -122.418077248072 | (37.7462186223039, -122.418077248072) | ||||
| 38785 | 38785 | 136006 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 10 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007669.82361 | 2118117.1353700003 | 37.7963788445653 | -122.417488005977 | (37.7963788445653, -122.417488005977) | ||||
| 71827 | 71827 | 196444 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1200x Kansas St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 5ft | 6011674.76736 | 2102721.10758 | 37.7543294225845 | -122.402546786399 | (37.7543294225845, -122.402546786399) | |||
| 73837 | 73837 | 103051 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400X Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6005072.0 | 2110257.0 | 37.774650355650394 | -122.42591724231501 | (37.7746503556504, -122.425917242315) | |||
| 79188 | 79188 | 103042 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | |||
| 80642 | 80642 | 26729 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 82021 | 82021 | 104249 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8 Octavia St Frontage East | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 84875 | 84875 | 4071 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3148 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6008736.4549488 | 2100618.4445096003 | 37.748391502035204 | -122.41255962658701 | (37.7483915020352, -122.412559626587) | |||
| 90605 | 90605 | 104256 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 92143 | 92143 | 21664 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1759 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4X4 | 6004187.7527688 | 2114598.9985399 | 37.786522394554794 | -122.429285712666 | (37.7865223945548, -122.429285712666) | |||
| 97015 | 97015 | 10703 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 130X Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 5993684.4832438 | 2089860.5757616002 | 37.717996809726 | -122.46382786766 | (37.717996809726, -122.46382786766) | |||
| 97257 | 97257 | 104250 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8x Octavia St Frontage East | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 97758 | 97758 | 21655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1700 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004345.5648 | 2114673.53748 | 37.7867359926545 | -122.42874503768101 | (37.7867359926545, -122.428745037681) | |||
| 101459 | 101459 | 98790 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 950x CLAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | Permit Number 768771 | 6010160.0 | 2117472.0 | 37.7947472579955 | -122.408825891367 | (37.7947472579955, -122.408825891367) | ||
| 101983 | 101983 | 16450 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1395 Newcomb Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 103092 | 103092 | 4069 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3120 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008908.10494 | 2100619.1862301 | 37.7484031705039 | -122.411966114964 | (37.7484031705039, -122.411966114964) | |||
| 103123 | 103123 | 103040 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 450X Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005621.8 | 2110912.7 | 37.7764818047314 | -122.424062011758 | (37.7764818047314, -122.424062011758) | |||
| 108756 | 108756 | 104252 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 110120 | 110120 | 101655 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200X Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5994672.4771300005 | 2099264.801 | 37.7438754024487 | -122.461094099214 | (37.7438754024487, -122.461094099214) | |||
| 110260 | 110260 | 28780 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6918 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5985532.54019 | 2112610.11302 | 37.7799877082801 | -122.493680597714 | (37.7799877082801, -122.493680597714) | |||
| 112605 | 112605 | 103080 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005464.0 | 2110963.0 | 37.7766110057417 | -122.42461146641399 | (37.7766110057417, -122.424611466414) | |||
| 114197 | 114197 | 11071 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1769 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6007332.0 | 2118349.0 | 37.7969964730533 | -122.418673401001 | (37.7969964730533, -122.418673401001) | |||
| 116546 | 116546 | 103081 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005464.0 | 2110963.0 | 37.7766110057417 | -122.42461146641399 | (37.7766110057417, -122.424611466414) | |||
| 119256 | 119256 | 103078 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005464.0 | 2110963.0 | 37.7766110057417 | -122.42461146641399 | (37.7766110057417, -122.424611466414) | |||
| 119998 | 119998 | 13086 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 122784 | 122784 | 26727 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 710 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6008944.94841 | 2120470.5671200003 | 37.8029124483908 | -122.413242294464 | (37.8029124483908, -122.413242294464) | |||
| 123262 | 123262 | 104251 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 124060 | 124060 | 104255 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 124785 | 124785 | 103049 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400X Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005072.0 | 2110257.0 | 37.774650355650394 | -122.42591724231501 | (37.7746503556504, -122.425917242315) | |||
| 130339 | 130339 | 92531 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1298X Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | 6011695.143180001 | 2102366.06354 | 37.75335568701529 | -122.40245135756201 | (37.7533556870153, -122.402451357562) | ||||
| 139217 | 139217 | 103052 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 400X Octavia St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 3x3 | 6005072.0 | 2110257.0 | 37.774650355650394 | -122.42591724231501 | (37.7746503556504, -122.425917242315) | |||
| 140726 | 140726 | 104254 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 141865 | 141865 | 103079 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 445 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005464.0 | 2110963.0 | 37.7766110057417 | -122.42461146641399 | (37.7766110057417, -122.424611466414) | |||
| 142091 | 142091 | 22527 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 6600 03rd St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6012847.5284056 | 2089784.7633558998 | 37.7188743244909 | -122.39758380657601 | (37.7188743244909, -122.397583806576) | |||
| 143027 | 143027 | 104253 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 8X Octavia St Frontage East | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 4x4 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 158887 | 158887 | 121620 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1300x Kansas St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 6011700.392659999 | 2102280.30315 | 37.7531205008135 | -122.402427173876 | (37.7531205008135, -122.402427173876) | |||
| 164473 | 164473 | 136005 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1237x Robert C Levy Tunl | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6007661.46268 | 2118150.4985 | 37.7964699809712 | -122.417519302367 | (37.7964699809712, -122.417519302367) | ||||
| 166035 | 166035 | 214700 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 200x Vasquez Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 6ft | 5994642.56982 | 2099211.09063 | 37.7437262061113 | -122.461193618499 | (37.7437262061113, -122.461193618499) | |||
| 88119 | 88119 | 86581 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2547 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/2007 12:00:00 AM | 3 | 3x3 | 5987979.82634 | 2097967.749244 | 37.7399266315394 | -122.48414034443701 | (37.7399266315394, -122.484140344437) | ||
| 20594 | 20594 | 4060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3017 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3X3 | 6009461.72254 | 2100536.5932400003 | 37.7482074334345 | -122.410045879537 | (37.7482074334345, -122.410045879537) | ||
| 107701 | 107701 | 18240 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1790X Post St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003623.876054401 | 2114224.0660337 | 37.785460985782706 | -122.431209813682 | (37.7854609857827, -122.431209813682) | ||
| 77375 | 77375 | 86070 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2115 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987568.946045 | 2100884.101082 | 37.7479102288924 | -122.485774970523 | (37.7479102288924, -122.485774970523) | ||
| 80739 | 80739 | 86034 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1284 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987415.003943 | 2106546.656914 | 37.763449099217404 | -122.486723028948 | (37.7634490992174, -122.486723028948) | ||
| 81351 | 81351 | 85991 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2222 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987633.933236 | 2100153.700526 | 37.7459085303186 | -122.48549665823 | (37.7459085303186, -122.48549665823) | ||
| 81410 | 81410 | 85988 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2258 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987642.054438 | 2099919.450203 | 37.7452658143921 | -122.48545138958299 | (37.7452658143921, -122.485451389583) | ||
| 84503 | 84503 | 86007 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1742 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987522.322672 | 2103422.5340299997 | 37.7548773659795 | -122.48612250342899 | (37.7548773659795, -122.486122503429) | ||
| 129008 | 129008 | 86060 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1869 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987511.195169 | 2102571.5912409998 | 37.7525402584661 | -122.486098523179 | (37.7525402584661, -122.486098523179) | ||
| 144160 | 144160 | 86065 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1939 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2007 12:00:00 AM | 3 | 3x3 | 5987527.802452 | 2102087.3075490003 | 37.7512115136965 | -122.486005547987 | (37.7512115136965, -122.486005547987) | ||
| 109447 | 109447 | 86018 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1550 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5987476.600405 | 2104728.077894 | 37.758459369903605 | -122.48637646604901 | (37.7584593699036, -122.486376466049) | ||
| 120189 | 120189 | 86101 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2600X 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988963.56832 | 2097622.4377 | 37.7390357226089 | -122.48071374038 | (37.7390357226089, -122.48071374038) | ||
| 124769 | 124769 | 86219 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2643 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988933.146151001 | 2097346.5203529997 | 37.7382763570454 | -122.48079873027201 | (37.7382763570454, -122.480798730272) | ||
| 126105 | 126105 | 86220 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/16/2007 12:00:00 AM | 3 | 3x3 | 5988937.695499 | 2097215.793619 | 37.7379176798007 | -122.480773433176 | (37.7379176798007, -122.480773433176) | ||
| 100006 | 100006 | 86109 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2548 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/17/2007 12:00:00 AM | 3 | 3x3 | 5988950.841471 | 2097988.149582 | 37.7400391325334 | -122.480784510326 | (37.7400391325334, -122.480784510326) | ||
| 106913 | 106913 | 12834 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2240 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2005 12:00:00 AM | 16 | 5 | 5988481.054959999 | 2114714.7558 | 37.785938514796705 | -122.483634834967 | (37.7859385147967, -122.483634834967) | ||
| 88699 | 88699 | 86200 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988870.37374 | 2099150.307919 | 37.743225438056605 | -122.481147807758 | (37.7432254380566, -122.481147807758) | ||
| 145745 | 145745 | 86213 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2487 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2007 12:00:00 AM | 3 | 3x3 | 5988895.867106 | 2098417.748537 | 37.74121550369679 | -122.481006033613 | (37.7412155036968, -122.481006033613) | ||
| 117924 | 117924 | 91900 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1450X Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/2015 01:07:00 PM | 3 | 3x3 | 5991277.7628190005 | 2106586.1574709998 | 37.763781990932 | -122.47336600159201 | (37.763781990932, -122.473366001592) | ||
| 12039 | 12039 | 28243 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3230 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 8 | 2X3 | 6011870.75873 | 2090643.72462 | 37.7211784199346 | -122.401020454343 | (37.7211784199346, -122.401020454343) | ||
| 23228 | 23228 | 28259 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3562 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2004 12:00:00 AM | 10 | 3x3 | 6012127.60331 | 2089140.68412 | 37.717065698801 | -122.400027111788 | (37.717065698801, -122.400027111788) | ||
| 107372 | 107372 | 86078 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2253 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987600.724922 | 2099957.1059939996 | 37.7453667992034 | -122.485597061296 | (37.7453667992034, -122.485597061296) | ||
| 112294 | 112294 | 86074 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2237 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987597.115499 | 2100061.217249 | 37.74565245070821 | -122.48561718118499 | (37.7456524507082, -122.485617181185) | ||
| 138906 | 138906 | 86075 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2241 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2007 12:00:00 AM | 3 | 3x3 | 5987598.017854 | 2100035.189447 | 37.7455810378659 | -122.48561215120199 | (37.7455810378659, -122.485612151202) | ||
| 111406 | 111406 | 27310 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2140 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/23/2014 12:00:00 AM | 5 | 5 | 5988795.04874 | 2114709.3 | 37.7859418063725 | -122.4825481157 | (37.7859418063725, -122.4825481157) | ||
| 18070 | 18070 | 4052 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2900 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 3X3 | 6010072.48365 | 2100637.4543 | 37.7485185889697 | -122.407940988391 | (37.7485185889697, -122.407940988391) | ||
| 90041 | 90041 | 23487 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2500X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/25/2008 12:00:00 AM | 3 | 9 | 6005837.0202043 | 2118942.4447679003 | 37.79854163961021 | -122.42388861727899 | (37.7985416396102, -122.423888617279) | ||
| 22114 | 22114 | 10208 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1286 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/1991 12:00:00 AM | 3 | 2X2 | 6005769.15445 | 2101526.21369 | 37.750717050048706 | -122.422885005752 | (37.7507170500487, -122.422885005752) | ||
| 18298 | 18298 | 10022 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 282 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/2003 12:00:00 AM | 3 | 2x2 | 6005445.78054 | 2107378.48496 | 37.766767762334794 | -122.42441947400499 | (37.7667677623348, -122.424419474005) | ||
| 97771 | 97771 | 28352 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3170 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008602.0157948 | 2100617.8635816 | 37.748382361007295 | -122.413024474721 | (37.7483823610073, -122.413024474721) | ||
| 117470 | 117470 | 28355 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3188 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 4x4 | 6008491.5836326 | 2100617.3863908 | 37.7483748509345 | -122.413406314174 | (37.7483748509345, -122.413406314174) | ||
| 140218 | 140218 | 28356 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3188 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008491.5836326 | 2100617.3863908 | 37.7483748509345 | -122.413406314174 | (37.7483748509345, -122.413406314174) | ||
| 142451 | 142451 | 28354 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3182 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2001 12:00:00 AM | 3 | 3X3 | 6008528.194294999 | 2100617.5445899 | 37.7483773408239 | -122.413279726103 | (37.7483773408239, -122.413279726103) | ||
| 120658 | 120658 | 12826 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2212 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2010 12:00:00 AM | 3 | 3X3 | 5988595.84675 | 2114702.3275900004 | 37.785911071486396 | -122.48323678034299 | (37.7859110714864, -122.483236780343) | ||
| 78561 | 78561 | 14625 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 15 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 12 | 3X4 | 6017974.7726653 | 2094204.2737729999 | 37.7312936151853 | -122.380167719121 | (37.7312936151853, -122.380167719121) | ||
| 88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
| 145234 | 145234 | 14624 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 14 Matthew Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018000.3078284 | 2094247.4364445 | 37.7314135402286 | -122.38008243669701 | (37.7314135402286, -122.380082436697) | ||
| 102400 | 102400 | 6398 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 4X Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/1998 12:00:00 AM | 12 | 3X3 | 6018041.9202743 | 2094226.9871977002 | 37.7313596862419 | -122.379937152762 | (37.7313596862419, -122.379937152762) | ||
| 106414 | 106414 | 8449 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1850X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2016 05:20:00 AM | 3 | 3X3 | 6002863.14639 | 2113881.31105 | 37.7844767282199 | -122.433817202745 | (37.7844767282199, -122.433817202745) | ||
| 110109 | 110109 | 90547 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 838 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/14/2008 12:00:00 AM | 3 | 3x3 | 5992984.817980001 | 2110733.73619 | 37.775268838699 | -122.467763542143 | (37.775268838699, -122.467763542143) | ||
| 117047 | 117047 | 90579 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2050X Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5989191.56818 | 2110598.34198 | 37.774677325483 | -122.480875193908 | (37.774677325483, -122.480875193908) | ||
| 22030 | 22030 | 4104 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3330 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3X3 | 6007482.20732 | 2100611.45835 | 37.7483018487579 | -122.416896303343 | (37.7483018487579, -122.416896303343) | ||
| 141034 | 141034 | 4148 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 3631 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1999 12:00:00 AM | 3 | 3X3 | She would like to be kept in the loop on what happens with this. | 6006082.4281665 | 2100506.5376626 | 37.7479349243864 | -122.421729258843 | (37.7479349243864, -122.421729258843) | |
| 19447 | 19447 | 2552 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 59 Burnside Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 25 | 3X3 | 6001211.45267 | 2095788.41504 | 37.7347041848314 | -122.43823489701799 | (37.7347041848314, -122.438234897018) |
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");