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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117409 | 117409 | 227 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2X3 | 5990630.67566 | 2095430.1647700001 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | |||
| 86397 | 86397 | 239 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 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) | |||
| 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) | |||
| 113267 | 113267 | 393 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 2 | 5990507.18031 | 2090652.7596599997 | 37.7199883416446 | -122.47486809669701 | (37.7199883416446, -122.474868096697) | |||
| 115742 | 115742 | 394 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990492.73788 | 2090676.25296 | 37.720052011465896 | -122.474919732673 | (37.7200520114659, -122.474919732673) | |||
| 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) | |||
| 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) | |||
| 128658 | 128658 | 398 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 2 | 5990471.16794 | 2090846.61881 | 37.7205185437854 | -122.475006721555 | (37.7205185437854, -122.475006721555) | |||
| 112174 | 112174 | 400 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2 | 5990476.72602 | 2090904.23897 | 37.7206770765591 | -122.474991713144 | (37.7206770765591, -122.474991713144) | |||
| 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) | |||
| 114875 | 114875 | 415 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X6 | 5990878.963880001 | 2090116.60552 | 37.718537732694394 | -122.473543893183 | (37.7185377326944, -122.473543893183) | |||
| 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) | |||
| 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) | ||
| 9213 | 9213 | 885 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1100X ALEMANY BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003437.0 | 2094359.0 | 37.7309056628368 | -122.43043846836599 | (37.7309056628368, -122.430438468366) | ||||
| 9059 | 9059 | 896 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1155X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 4X4 | 6003365.90456 | 2094243.1413900002 | 37.730583513638294 | -122.43067599245 | (37.7305835136383, -122.43067599245) | |||
| 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) | |||
| 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) | |||
| 12842 | 12842 | 912 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1229 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003089.95028 | 2094152.4368200002 | 37.730318821659296 | -122.431623533692 | (37.7303188216593, -122.431623533692) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 11865 | 11865 | 939 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1325 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6002500.20649 | 2093846.32088 | 37.7294448514873 | -122.433640487323 | (37.7294448514873, -122.433640487323) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 123626 | 123626 | 1081 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2144 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5999999.92726 | 2089842.39347 | 37.718308800511 | -122.441996891163 | (37.718308800511, -122.441996891163) | |||
| 11990 | 11990 | 1085 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2156 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 5999963.70084 | 2089791.4898700002 | 37.7181669663093 | -122.442118458302 | (37.7181669663093, -122.442118458302) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 142032 | 142032 | 1248 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3731 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 5993002.942009999 | 2087547.889 | 37.711607428767294 | -122.466015680425 | (37.7116074287673, -122.466015680425) | |||
| 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) | |||
| 104642 | 104642 | 1257 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X3 | 5992919.7951 | 2087516.7094700001 | 37.7115170200575 | -122.46630079139099 | (37.7115170200575, -122.466300791391) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 145404 | 145404 | 1420 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3x3 | 5995529.5957 | 2115606.06371 | 37.7887935591586 | -122.45931355109501 | (37.7887935591586, -122.459313551095) | |||
| 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) | |||
| 104190 | 104190 | 1423 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x5 | 5995562.14611 | 2115577.70158 | 37.7887175558035 | -122.459198877421 | (37.7887175558035, -122.459198877421) | |||
| 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) | |||
| 95505 | 95505 | 1429 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 5 | 5995465.54596 | 2115556.4736099998 | 37.788653715516205 | -122.45953155962 | (37.7886537155162, -122.45953155962) | |||
| 120429 | 120429 | 1430 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 5 | 5995476.6114 | 2115563.93405 | 37.7886748361207 | -122.45949381562299 | (37.7886748361207, -122.459493815623) | |||
| 124439 | 124439 | 1431 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5 | 5995471.94905 | 2115498.24125 | 37.788494193386896 | -122.459505186902 | (37.7884941933869, -122.459505186902) | |||
| 145198 | 145198 | 1432 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 75X Arguello Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 5 | 5995472.27833 | 2115471.9588 | 37.7884220478225 | -122.45950214341002 | (37.7884220478225, -122.45950214341) | |||
| 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) | |||
| 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) | |||
| 91570 | 91570 | 1435 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 5 | 5995475.980819999 | 2115376.20265 | 37.7881593402184 | -122.459482395726 | (37.7881593402184, -122.459482395726) | |||
| 129385 | 129385 | 1437 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | 5 | 5995475.83232 | 2115319.03247 | 37.78800235781971 | -122.459478767425 | (37.7880023578197, -122.459478767425) | |||
| 87059 | 87059 | 1438 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 101X Arguello Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 5 | 5995477.38208 | 2115292.8933900003 | 37.787930676078794 | -122.45947151175501 | (37.7879306760788, -122.459471511755) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 140740 | 140740 | 1474 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 234 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x5 | 5995562.8915 | 2114652.7171099996 | 37.7861778408698 | -122.459129293157 | (37.7861778408698, -122.459129293157) | |||
| 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) | |||
| 139352 | 139352 | 1510 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 369 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 5995536.869969999 | 2113765.1567 | 37.7837393424086 | -122.45915502719102 | (37.7837393424086, -122.459155027191) | |||
| 107025 | 107025 | 1514 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 390 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 4X6 | 5995592.131 | 2113860.45299 | 37.7840041772291 | -122.458970748307 | (37.7840041772291, -122.458970748307) | |||
| 114366 | 114366 | 1525 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 439 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 5X7 | 5995548.96018 | 2113291.48375 | 37.7824394582911 | -122.459078890487 | (37.7824394582911, -122.459078890487) | |||
| 138620 | 138620 | 1526 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 440 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 5995608.48873 | 2113422.41383 | 37.782802379218296 | -122.458882431606 | (37.7828023792183, -122.458882431606) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 121917 | 121917 | 1542 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 470X Arguello Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5995618.1476548 | 2113146.4510222 | 37.782045214262205 | -122.458829030078 | (37.7820452142622, -122.458829030078) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");