Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 119155 | 119155 | 99894 | Significant Tree 6 | Ulmus pumila :: Siberian Elm 53 | 1636 Bush St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 07/11/2012 12:00:00 AM | Permit Number 768849 | 6005665.0 | 2115204.0 | 37.7882670981083 | -122.424217840789 | (37.7882670981083, -122.424217840789) | |||
| 160 | 160 | 175377 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5991371.46907 | 2088876.77956 | 37.715161983326794 | -122.471751215951 | (37.7151619833268, -122.471751215951) | |||
| 789 | 789 | 175382 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991305.518069999 | 2089124.29272 | 37.7158377779634 | -122.471997198511 | (37.7158377779634, -122.471997198511) | |||
| 798 | 798 | 175378 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | Width 3ft | 5991360.88178 | 2088922.0136900002 | 37.715285572641 | -122.471791104494 | (37.715285572641, -122.471791104494) | |||
| 806 | 806 | 177713 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 3ft | 5991322.37032 | 2089056.90035 | 37.715653710133296 | -122.471934040933 | (37.7156537101333, -122.471934040933) | |||
| 837 | 837 | 175374 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80x Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | Width 3ft | 5991412.70367 | 2088734.1730099998 | 37.714772806192606 | -122.47159830692699 | (37.7147728061926, -122.471598306927) | |||
| 846 | 846 | 175047 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | Width 3ft | 5991389.20246 | 2088805.53688 | 37.714967394312204 | -122.47168473357 | (37.7149673943122, -122.47168473357) | |||
| 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) | ||
| 2137 | 2137 | 124672 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | Width 4ft | 5995591.07711 | 2113866.14003 | 37.784019731735604 | -122.458974806266 | (37.7840197317356, -122.458974806266) | |||
| 5949 | 5949 | 19787 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 50ST | ||||||||
| 7781 | 7781 | 16359 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1306x Montgomery St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011459.70542 | 2119848.6083 | 37.8013455628052 | -122.404496083149 | (37.8013455628052, -122.404496083149) | |||
| 9045 | 9045 | 1066 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2075X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000333.402969999 | 2090026.65578 | 37.71883374095071 | -122.440857420165 | (37.7188337409507, -122.440857420165) | |||
| 10333 | 10333 | 899 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1161 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X5 | 6003541.15178 | 2094307.19105 | 37.7307693064514 | -122.43007470418002 | (37.7307693064514, -122.43007470418) | |||
| 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) | |||
| 10383 | 10383 | 16704 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1677X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 29 | 5x6 | 6001608.07304 | 2092347.28192 | 37.725278171049794 | -122.43661741688 | (37.7252781710498, -122.43661741688) | |||
| 10656 | 10656 | 970 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1599 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 38 | 4X4 | 6001869.51123 | 2092911.87236 | 37.7268432620915 | -122.435754028151 | (37.7268432620915, -122.435754028151) | |||
| 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) | |||
| 10978 | 10978 | 1259 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3821 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992830.40302 | 2087513.47902 | 37.7115029917542 | -122.46660951663601 | (37.7115029917542, -122.466609516636) | |||
| 11041 | 11041 | 16703 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1677X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 43 | 5x6 | 6001597.82921 | 2092328.38749 | 37.7252257090852 | -122.436651476894 | (37.7252257090852, -122.436651476894) | |||
| 11221 | 11221 | 938 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6002521.94299 | 2093864.9840400002 | 37.729497329615704 | -122.433566675476 | (37.7294973296157, -122.433566675476) | |||
| 11261 | 11261 | 936 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1309 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/09/2016 12:00:00 AM | 3 | 3X3 | 6002560.70092 | 2093898.0300900002 | 37.7295902655741 | -122.433435046188 | (37.7295902655741, -122.433435046188) | ||
| 11320 | 11320 | 1260 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3827 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992804.99866 | 2087505.2482200002 | 37.7114789258702 | -122.46669672210301 | (37.7114789258702, -122.466696722103) | |||
| 11419 | 11419 | 940 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1331 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 6002472.82123 | 2093812.78737 | 37.7293512221746 | -122.433732764948 | (37.7293512221746, -122.433732764948) | |||
| 11486 | 11486 | 1258 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3815 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5992861.70969 | 2087523.33873 | 37.7115318707666 | -122.466502029665 | (37.7115318707666, -122.466502029665) | |||
| 11782 | 11782 | 915 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1237 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003037.510530001 | 2094134.6631900002 | 37.7302670467787 | -122.431803556408 | (37.7302670467787, -122.431803556408) | |||
| 11932 | 11932 | 900 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1167 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003509.8986599995 | 2094295.64409 | 37.7307358309933 | -122.43018192766 | (37.7307358309933, -122.43018192766) | |||
| 12376 | 12376 | 979 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1601 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6001800.3284 | 2092768.49495 | 37.7264456502383 | -122.435982936161 | (37.7264456502383, -122.435982936161) | |||
| 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) | |||
| 12927 | 12927 | 1025 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1948 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6000854.43502 | 2090852.74185 | 37.7211316470959 | -122.439115597724 | (37.7211316470959, -122.439115597724) | |||
| 13931 | 13931 | 19779 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100 STAIRWAY19 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 50ST | ||||||||
| 16388 | 16388 | 115471 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 10X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | |||||||||
| 17067 | 17067 | 11708 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991296.5308 | 2092759.13423 | 37.7258176365683 | -122.472293077282 | (37.7258176365683, -122.472293077282) | ||
| 17204 | 17204 | 19082 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 227 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994691.4790199995 | 2087389.19966 | 37.7112689737437 | -122.460168197108 | (37.7112689737437, -122.460168197108) | |||
| 17410 | 17410 | 19053 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 141 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5995501.70307 | 2087378.49279 | 37.711286145417496 | -122.457367103015 | (37.7112861454175, -122.457367103015) | |||
| 17794 | 17794 | 19085 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 231 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994662.28634 | 2087388.8423799998 | 37.711266313550794 | -122.46026906776501 | (37.7112663135508, -122.460269067765) | |||
| 18280 | 18280 | 19057 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 155 Sagamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995437.65535 | 2087381.5397299998 | 37.7112908326789 | -122.45758868696801 | (37.7112908326789, -122.457588686968) | |||
| 18392 | 18392 | 19097 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 276 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X2 | 5994245.51556 | 2087475.81103 | 37.711481126537 | -122.46171582334298 | (37.711481126537, -122.461715823343) | |||
| 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) | |||
| 18615 | 18615 | 19086 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 235 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5994700.784889599 | 2087405.1340273 | 37.71131326103529 | -122.460137187577 | (37.7113132610353, -122.460137187577) | |||
| 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) | |||
| 19476 | 19476 | 11625 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 300X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | |||
| 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) | |||
| 19729 | 19729 | 11613 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 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) | |||
| 20933 | 20933 | 11752 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991283.50431 | 2092598.4954900001 | 37.7253758086322 | -122.47232640343799 | (37.7253758086322, -122.472326403438) | ||
| 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) | ||
| 38340 | 38340 | 11711 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 40857 | 40857 | 124637 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.787983889154205 | -122.459265995172 | (37.7879838891542, -122.459265995172) | ||||
| 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) | ||||
| 57260 | 57260 | 242793 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | Width 9ft | 6007083.58829 | 2099965.0449 | 37.746504513177 | -122.418228897148 | (37.746504513177, -122.418228897148) | |||
| 61015 | 61015 | 242794 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | ||||
| 72528 | 72528 | 392 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 2 | 5990516.36157 | 2090620.3648599999 | 37.7198999256056 | -122.47483399727899 | (37.7198999256056, -122.474833997279) | |||
| 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) | |||
| 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) | |||
| 79677 | 79677 | 10721 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 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) | |||
| 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) | |||
| 80029 | 80029 | 11626 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 300X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | |||
| 80768 | 80768 | 10719 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 81090 | 81090 | 6279 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003832.24761 | 2113162.85488 | 37.782558971887205 | -122.430413166544 | (37.7825589718872, -122.430413166544) | |||
| 82094 | 82094 | 1645 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 881 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 6X6 | 5995652.78213 | 2110475.54294 | 37.7747135991516 | -122.458515810277 | (37.7747135991516, -122.458515810277) | |||
| 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) | |||
| 82725 | 82725 | 11620 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 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) | |||
| 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) | |||
| 83607 | 83607 | 1433 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 100X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 5X5 | 5995535.85964 | 2115388.7214900004 | 37.7881971563264 | -122.459276133553 | (37.7881971563264, -122.459276133553) | |||
| 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) | |||
| 84012 | 84012 | 1042 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1999X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6000738.08152 | 2090455.78835 | 37.72003508127371 | -122.439489356062 | (37.7200350812737, -122.439489356062) | |||
| 84024 | 84024 | 11677 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 5991320.9947906 | 2093088.5989831001 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | |||
| 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) | |||
| 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) | |||
| 85887 | 85887 | 117255 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 86527 | 86527 | 397 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990474.691459999 | 2090771.6766099997 | 37.720312975301 | -122.474989074306 | (37.720312975301, -122.474989074306) | |||
| 86737 | 86737 | 1428 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.63795 | 2115574.8643900002 | 37.78870421691 | -122.459532573841 | (37.78870421691, -122.459532573841) | |||
| 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) | |||
| 87605 | 87605 | 1441 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 138 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 5X5 | 5995537.91826 | 2115271.42403 | 37.7878752075455 | -122.459260513654 | (37.7878752075455, -122.459260513654) | |||
| 87989 | 87989 | 395 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 2 | 5990486.24663 | 2090696.51982 | 37.720107283055604 | -122.474943649084 | (37.7201072830556, -122.474943649084) | |||
| 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) | |||
| 88210 | 88210 | 11676 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4x4 | 5991320.9947906 | 2093088.5989831001 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | |||
| 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) | |||
| 89099 | 89099 | 6281 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 89332 | 89332 | 391 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 2 | 5990530.65648 | 2090591.3498 | 37.7198210858115 | -122.474782468587 | (37.7198210858115, -122.474782468587) | |||
| 89901 | 89901 | 11849 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1401X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3 | 5991539.129622 | 2088082.4465586997 | 37.712990637147605 | -122.471113878415 | (37.7129906371476, -122.471113878415) | |||
| 89919 | 89919 | 1440 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 126 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5X5 | 5995572.08179 | 2115303.34583 | 37.7879648202564 | -122.459144627311 | (37.7879648202564, -122.459144627311) | |||
| 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) | |||
| 90284 | 90284 | 401 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5990481.9086 | 2090947.8037400001 | 37.7207969949539 | -122.474976977183 | (37.7207969949539, -122.474976977183) | |||
| 90643 | 90643 | 11668 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 700X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 5991320.9947906 | 2093088.5989831001 | 37.7267236805691 | -122.472232513363 | (37.7267236805691, -122.472232513363) | |||
| 90813 | 90813 | 26778 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 90931 | 90931 | 11627 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 300X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 5991444.7104442 | 2094652.0546396 | 37.7310236980815 | -122.471918736195 | (37.7310236980815, -122.471918736195) | |||
| 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) | |||
| 92480 | 92480 | 10715 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 92989 | 92989 | 26772 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 800X Junipero Serra Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
| 93750 | 93750 | 6280 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) |
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");