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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19036 | 19036 | 11747 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 30 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.94649 | 2092660.64259 | 37.725546648332504 | -122.4723190326 | (37.7255466483325, -122.4723190326) | ||
| 19211 | 19211 | 19069 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 200 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5994992.35128 | 2087465.62621 | 37.711496124512 | -122.45913384457701 | (37.711496124512, -122.459133844577) | |||
| 19881 | 19881 | 19078 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 215 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3X3 | 5994825.043959999 | 2087387.37086 | 37.711271633946296 | -122.459706433929 | (37.7112716339463, -122.459706433929) | |||
| 20873 | 20873 | 19088 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 238 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5994602.312969999 | 2087471.0641 | 37.7114886250695 | -122.460482303322 | (37.7114886250695, -122.460482303322) | |||
| 21264 | 21264 | 19063 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 175 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995252.88797 | 2087382.67456 | 37.7112833332178 | -122.45822736752501 | (37.7112833332178, -122.458227367525) | |||
| 21339 | 21339 | 19071 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 203 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5994967.06362 | 2087386.6571400003 | 37.7112778401642 | -122.459215529972 | (37.7112778401642, -122.459215529972) | |||
| 21385 | 21385 | 19093 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 257 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994426.29409 | 2087392.8188099999 | 37.711263654258204 | -122.461084998394 | (37.7112636542582, -122.461084998394) | |||
| 23188 | 23188 | 25337 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2000 12:00:00 AM | 15 | 3X3 | 5994336.66394 | 2087473.55865 | 37.71148018854171 | -122.46140062985799 | (37.7114801885417, -122.461400629858) | ||
| 56269 | 56269 | 1048 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2029X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6000595.57615 | 2090275.75201 | 37.719532630863 | -122.439969044998 | (37.719532630863, -122.439969044998) | ||||
| 79844 | 79844 | 1477 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 245 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995501.2635699995 | 2114653.66128 | 37.7861768902412 | -122.45934257653799 | (37.7861768902412, -122.459342576538) | |||
| 85463 | 85463 | 1534 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 86707 | 86707 | 7464 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2599 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008286.46562 | 2103308.5385 | 37.7557526290701 | -122.41430599230301 | (37.7557526290701, -122.414305992303) | |||
| 87555 | 87555 | 19303 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2087X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6000281.49897 | 2089976.15715 | 37.7186921269443 | -122.44103321029101 | (37.7186921269443, -122.441033210291) | |||
| 89969 | 89969 | 1617 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 764 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 135 | 3X3 | 5995701.56639 | 2110898.08045 | 37.775876579407296 | -122.458377647589 | (37.7758765794073, -122.458377647589) | |||
| 91709 | 91709 | 1533 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 94286 | 94286 | 19045 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995778.761022701 | 2087391.1107423 | 37.7113367008986 | -122.45641043862801 | (37.7113367008986, -122.456410438628) | |||
| 95650 | 95650 | 7425 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2501 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008288.6679 | 2103807.30911 | 37.7571222633799 | -122.414333665067 | (37.7571222633799, -122.414333665067) | |||
| 96797 | 96797 | 1620 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.776037871937206 | -122.45860409582599 | (37.7760378719372, -122.458604095826) | |||
| 98239 | 98239 | 1470 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 215 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5995496.39039 | 2114788.7917299997 | 37.786547641872296 | -122.45936922598 | (37.7865476418723, -122.45936922598) | |||
| 99379 | 99379 | 1642 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 860 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 5995719.79795 | 2110383.37965 | 37.7744643941763 | -122.45827731837299 | (37.7744643941763, -122.458277318373) | |||
| 99894 | 99894 | 1541 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 100174 | 100174 | 1637 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 830 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5995713.25263 | 2110507.70954 | 37.7748053952412 | -122.45830896062701 | (37.7748053952412, -122.458308960627) | |||
| 107731 | 107731 | 1531 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 445 Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5995560.27463 | 2113085.81754 | 37.7818754042369 | -122.459024851411 | (37.7818754042369, -122.459024851411) | |||
| 108172 | 108172 | 1468 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 200 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5995558.6934 | 2114767.33782 | 37.786492317136606 | -122.459152120252 | (37.7864923171366, -122.459152120252) | |||
| 110227 | 110227 | 11741 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 900X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | |||
| 110485 | 110485 | 1001 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 6001471.07065 | 2092002.59485 | 37.724323951976 | -122.437066353202 | (37.724323951976, -122.437066353202) | |||
| 112240 | 112240 | 1060 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2059X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000457.1646300005 | 2090146.24433 | 37.7191691518296 | -122.440438198589 | (37.7191691518296, -122.440438198589) | |||
| 113834 | 113834 | 1543 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5995618.1476548 | 2113146.4510222 | 37.782045214262205 | -122.458829030078 | (37.7820452142622, -122.458829030078) | |||
| 114019 | 114019 | 1027 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1965X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1992 12:00:00 AM | 31 | 3X3 | 6000825.64245 | 2090608.45865 | 37.7204592623287 | -122.439197625247 | (37.7204592623287, -122.439197625247) | ||
| 114194 | 114194 | 1058 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2055X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6000480.4143 | 2090166.82631 | 37.719226989106005 | -122.440359308841 | (37.719226989106, -122.440359308841) | |||
| 114688 | 114688 | 1471 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 223 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 5995498.41446 | 2114753.58122 | 37.7864510796736 | -122.459359672388 | (37.7864510796736, -122.459359672388) | |||
| 118300 | 118300 | 1581 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 629 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995601.12395 | 2111917.66113 | 37.7786703056802 | -122.458798934123 | (37.7786703056802, -122.458798934123) | |||
| 119337 | 119337 | 1597 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 714 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995688.036 | 2111228.67679 | 37.7767835321697 | -122.458448388127 | (37.7767835321697, -122.458448388127) | |||
| 120708 | 120708 | 1551 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 530 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995634.85993 | 2112642.48366 | 37.7806624148094 | -122.458734717129 | (37.7806624148094, -122.458734717129) | |||
| 122792 | 122792 | 1056 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2049X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000499.53685 | 2090188.3269099998 | 37.7192871136702 | -122.440294750677 | (37.7192871136702, -122.440294750677) | |||
| 124950 | 124950 | 1010 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1840X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6001180.264280001 | 2091487.57144 | 37.722893280400704 | -122.438034753125 | (37.7228932804007, -122.438034753125) | |||
| 125285 | 125285 | 1054 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2045X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000521.13381 | 2090206.39855 | 37.7193379639287 | -122.440221393554 | (37.7193379639287, -122.440221393554) | |||
| 125401 | 125401 | 7486 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2679X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6008312.8272 | 2102836.8814 | 37.754459046451004 | -122.414181457232 | (37.754459046451, -122.414181457232) | |||
| 128855 | 128855 | 26823 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 5994408.88806 | 2087459.5005112998 | 37.711445744833796 | -122.461149987895 | (37.7114457448338, -122.461149987895) | |||
| 128940 | 128940 | 1540 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995618.147655 | 2113146.451022 | 37.7820452142616 | -122.458829030077 | (37.7820452142616, -122.458829030077) | |||
| 129303 | 129303 | 1061 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2061X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6000441.22371 | 2090128.4604599997 | 37.719119413653495 | -122.440492025318 | (37.7191194136535, -122.440492025318) | |||
| 138392 | 138392 | 1014 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1852X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6001135.54804 | 2091400.8212599999 | 37.7226525409555 | -122.438183116075 | (37.7226525409555, -122.438183116075) | |||
| 138406 | 138406 | 1052 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2039X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6000548.43841 | 2090229.36669 | 37.719402583767 | -122.44012865812 | (37.719402583767, -122.44012865812) | |||
| 140006 | 140006 | 1051 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2035X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6000572.81835 | 2090254.9074400002 | 37.7194741008396 | -122.44004621634599 | (37.7194741008396, -122.440046216346) | |||
| 140555 | 140555 | 22541 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1396X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6002380.38751 | 2093819.80205 | 37.7293652374447 | -122.434052817677 | (37.7293652374447, -122.434052817677) | |||
| 141047 | 141047 | 917 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1245 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003003.64796 | 2094102.5381599998 | 37.730176919086496 | -122.43191833078899 | (37.7301769190865, -122.431918330789) | |||
| 143670 | 143670 | 19065 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 179 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 5995218.7218404 | 2087397.9242615001 | 37.711323242006294 | -122.45834655658399 | (37.7113232420063, -122.458346556584) | |||
| 144014 | 144014 | 1218 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3575X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X3 | 5993629.70146 | 2087487.1964900002 | 37.711476919919 | -122.463845046869 | (37.711476919919, -122.463845046869) | |||
| 144278 | 144278 | 2933 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1834 California St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 7 | 3X3 | 6005503.04257 | 2115905.51621 | 37.7901841403418 | -122.424828114668 | (37.7901841403418, -122.424828114668) | ||
| 83287 | 83287 | 1622 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 781 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3X4 | 5995639.652530001 | 2110927.44628 | 37.7759536520848 | -122.45859394843201 | (37.7759536520848, -122.458593948432) | |||
| 94881 | 94881 | 19090 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 260 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X4 | 5994507.8215972 | 2087458.0224558997 | 37.7114473793836 | -122.460807943318 | (37.7114473793836, -122.460807943318) | |||
| 129442 | 129442 | 1529 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 451 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X4 | 5995566.01052 | 2113204.19125 | 37.7822007565611 | -122.45901358165001 | (37.7822007565611, -122.45901358165) | |||
| 11189 | 11189 | 914 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1233 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X5 | 6003058.45033 | 2094142.0195400002 | 37.730288432643796 | -122.431731689776 | (37.7302884326438, -122.431731689776) | |||
| 12243 | 12243 | 974 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1599 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X5 | 6001933.9280900005 | 2093061.6302200002 | 37.7272581220521 | -122.435542049851 | (37.7272581220521, -122.435542049851) | |||
| 117946 | 117946 | 1434 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X5 | 5995535.03638 | 2115411.50396 | 37.7882596635004 | -122.459280632339 | (37.7882596635004, -122.459280632339) | |||
| 9367 | 9367 | 884 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1100X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/2008 12:00:00 AM | 24 | 3X6 | 6003437.0 | 2094359.0 | 37.7309056628368 | -122.43043846836599 | (37.7309056628368, -122.430438468366) | ||
| 10846 | 10846 | 997 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1693 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X6 | 6001548.3914 | 2092219.7643099998 | 37.724924644828704 | -122.43681460581301 | (37.7249246448287, -122.436814605813) | |||
| 11385 | 11385 | 4849 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1469X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X6 | 6002249.52444 | 2093516.68285 | 37.7285255132222 | -122.43448355857402 | (37.7285255132222, -122.434483558574) | |||
| 12595 | 12595 | 1250 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3743 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X6 | 5993011.32335 | 2087550.57925 | 37.7116152990749 | -122.46598690787701 | (37.7116152990749, -122.465986907877) | |||
| 79283 | 79283 | 21830 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1419X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X6 | 6002361.46709 | 2093663.80125 | 37.7289358208429 | -122.43410707985599 | (37.7289358208429, -122.434107079856) | |||
| 83537 | 83537 | 1032 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | |||
| 88057 | 88057 | 883 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1100X ALEMANY BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X6 | 6003437.0 | 2094359.0 | 37.7309056628368 | -122.43043846836599 | (37.7309056628368, -122.430438468366) | |||
| 103661 | 103661 | 1035 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X6 | 6000752.12664 | 2090469.86783 | 37.7200745396752 | -122.439441815719 | (37.7200745396752, -122.439441815719) | |||
| 119227 | 119227 | 1030 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 34 | 3X6 | 6000847.46445 | 2090663.0926299999 | 37.7206105166164 | -122.43912610743799 | (37.7206105166164, -122.439126107438) | |||
| 120071 | 120071 | 1029 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1989X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X6 | 6000859.82003 | 2090688.3349 | 37.7206805292285 | -122.43908520635401 | (37.7206805292285, -122.439085206354) | |||
| 93568 | 93568 | 1421 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3x12 | 5995527.212040001 | 2115624.1968 | 37.7888432106719 | -122.459323111848 | (37.7888432106719, -122.459323111848) | |||
| 1048 | 1048 | 251423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5999946.0 | 2089791.0 | 37.718164612456604 | -122.44217960719999 | (37.7181646124566, -122.4421796072) | ||||
| 1790 | 1790 | 26629 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1099X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/2017 12:00:00 AM | 6 | 3x3 | 6011248.5682 | 2094191.84655 | 37.7308861005042 | -122.403420689108 | (37.7308861005042, -122.403420689108) | ||
| 8324 | 8324 | 106867 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1974 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6003576.11959 | 2118663.726 | 37.797648453467396 | -122.431692125901 | (37.7976484534674, -122.431692125901) | |||
| 10343 | 10343 | 978 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1601 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6001786.79947 | 2092741.5935099998 | 37.7263710164051 | -122.436027780876 | (37.7263710164051, -122.436027780876) | |||
| 18427 | 18427 | 19072 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 204 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 5994955.69063 | 2087466.73543 | 37.7114970625193 | -122.459260632792 | (37.7114970625193, -122.459260632792) | |||
| 19652 | 19652 | 99912 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3751X Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005509.050559999 | 2101091.11643 | 37.7495076933522 | -122.42375353501998 | (37.7495076933522, -122.42375353502) | ||||
| 19676 | 19676 | 7475 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 20889 | 20889 | 19100 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 281 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 5994272.63935 | 2087395.39368 | 37.7112618807995 | -122.46161625041 | (37.7112618807995, -122.46161625041) | |||
| 46257 | 46257 | 97505 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672.0 | 2110712.0 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | |
| 50637 | 50637 | 117189 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1335 Washington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008262.17379 | 2117224.41185 | 37.793960957890896 | -122.415375111785 | (37.7939609578909, -122.415375111785) | |||
| 54703 | 54703 | 39229 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1335 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 15 | 3x3 | Permit Number 40871 | 6008226.63206 | 2117220.6849599998 | 37.793948727108 | -122.41549782608699 | (37.793948727108, -122.415497826087) | |
| 77659 | 77659 | 7482 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 77976 | 77976 | 99913 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3751X Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 768933 | 6005509.050559999 | 2101091.11643 | 37.7495076933522 | -122.42375353501998 | (37.7495076933522, -122.42375353502) | |||
| 79845 | 79845 | 933 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1294X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6002802.17626 | 2094143.63343 | 37.7302783338422 | -122.432617778446 | (37.7302783338422, -122.432617778446) | |||
| 82113 | 82113 | 929 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1286X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6002834.53778 | 2094157.0386599998 | 37.73031697676271 | -122.432506857514 | (37.7303169767627, -122.432506857514) | |||
| 83779 | 83779 | 1867 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2555 Bay Shore Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010748.9210869 | 2086419.1045134 | 37.7095158271004 | -122.404601102054 | (37.7095158271004, -122.404601102054) | |||
| 84863 | 84863 | 1182 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3003 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) | |||
| 85915 | 85915 | 11690 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 86841 | 86841 | 7477 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 87254 | 87254 | 7476 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 88504 | 88504 | 19105 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 92672 | 92672 | 85425 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | |||
| 94466 | 94466 | 7473 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 94747 | 94747 | 114034 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 198x FONT BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 5990818.0 | 2089012.0 | 37.7155012267577 | -122.473674083302 | (37.7155012267577, -122.473674083302) | |||
| 95655 | 95655 | 29917 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 810 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | |||
| 102679 | 102679 | 19106 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3155X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5995592.56281 | 2086919.9321700002 | 37.7100322629968 | -122.457019923286 | (37.7100322629968, -122.457019923286) | |||
| 106471 | 106471 | 7479 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 109973 | 109973 | 99911 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 400 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005460.7 | 2101331.3 | 37.750164452601794 | -122.42393781012501 | (37.7501644526018, -122.423937810125) | ||||
| 111256 | 111256 | 104704 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3590X Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2014 12:00:00 AM | 3x3 | Permit Number 771748 | 5997841.875 | 2115466.23587 | 37.7885422986565 | -122.451303342479 | (37.7885422986565, -122.451303342479) | ||
| 112238 | 112238 | 7474 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 112345 | 112345 | 26171 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 03/01/2000 12:00:00 AM | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | ||
| 113884 | 113884 | 11686 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 114677 | 114677 | 7481 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | |||
| 116279 | 116279 | 1181 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3003 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996737.10872 | 2087300.2249 | 37.7111421206036 | -122.45309160658 | (37.7111421206036, -122.45309160658) |
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");