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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||||
| 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) | ||
| 9461 | 9461 | 22540 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1441X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 12X6 | 6002335.8535400005 | 2093628.68187 | 37.728837937275 | -122.43419311802099 | (37.728837937275, -122.434193118021) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 19243 | 19243 | 39175 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 750 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/2002 12:00:00 AM | 10 | Permit Number 40836 | 6007492.94598473 | 2105289.21429212 | 37.7611465023321 | -122.417190590059 | (37.7611465023321, -122.417190590059) | |
| 19674 | 19674 | 11652 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 699X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 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) | |||
| 45548 | 45548 | 45657 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1330 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | 18 | Permit Number 44353 | 6006609.23369 | 2119082.98627 | 37.798971095388396 | -122.421226497612 | (37.7989710953884, -122.421226497612) | ||
| 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) | |
| 69286 | 69286 | 58907 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 354 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 29 | Permit Number 18182 | 6012260.63611 | 2086890.34143 | 37.7108941228427 | -122.39940938545601 | (37.7108941228427, -122.399409385456) | ||
| 79297 | 79297 | 11696 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 88173 | 88173 | 6271 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004021.46971 | 2113238.82139 | 37.782778273754104 | -122.429763959937 | (37.7827782737541, -122.429763959937) | |||
| 88227 | 88227 | 51907 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 157 Day St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.42559837996599 | (37.7428856098168, -122.425598379966) | |||
| 88556 | 88556 | 11694 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 89521 | 89521 | 6272 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003992.005369999 | 2113234.0209999997 | 37.782763424573005 | -122.429865551596 | (37.782763424573, -122.429865551596) | |||
| 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) | |||
| 91904 | 91904 | 11692 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 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) | |||
| 93005 | 93005 | 7472 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 2637 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 4X4 | 6008329.443080001 | 2103061.47825 | 37.75507667179011 | -122.41413988378599 | (37.7550766717901, -122.414139883786) | |||
| 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) | |||
| 94783 | 94783 | 39243 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3934 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/1998 12:00:00 AM | Permit Number 40874 | 5995936.27284071 | 2115227.33652665 | 37.7877770492494 | -122.457879097389 | (37.7877770492494, -122.457879097389) | |||
| 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) | |||
| 95703 | 95703 | 6273 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6003962.5783400005 | 2113230.61655 | 37.78275241032 | -122.42996711374701 | (37.78275241032, -122.429967113747) | |||
| 98822 | 98822 | 51906 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 157 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/2005 12:00:00 AM | Permit Number 48113 | 6004926.17092668 | 2098691.36646376 | 37.7428856098168 | -122.42559837996599 | (37.7428856098168, -122.425598379966) | |||
| 100073 | 100073 | 11656 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 699X Junipero Serra Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991405.981861901 | 2093130.1790735 | 37.7268427672434 | -122.47194174766199 | (37.7268427672434, -122.471941747662) | |||
| 106977 | 106977 | 11873 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 108076 | 108076 | 11722 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
| 109658 | 109658 | 11633 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 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) | ||
| 111277 | 111277 | 11695 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
| 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) | ||
| 113163 | 113163 | 11689 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 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) | |||
| 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) | |||
| 118796 | 118796 | 11718 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
| 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) | |||
| 121533 | 121533 | 93024 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 3 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
| 121766 | 121766 | 85427 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | |||
| 125399 | 125399 | 11871 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 141240 | 141240 | 11874 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 1499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 30 | 3 | 5991566.5284818 | 2087248.8358641004 | 37.7107033285334 | -122.470958490818 | (37.7107033285334, -122.470958490818) | |||
| 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) | |||
| 144992 | 144992 | 93023 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 394 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Tree 2 on 25th St | 6005476.0 | 2101410.0 | 37.750381408432204 | -122.42389049729601 | (37.7503814084322, -122.423890497296) | ||||
| 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) | |||
| 3284 | 3284 | 253385 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1100 Golden Gate Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004275.0 | 2112509.0 | 37.780788718892204 | -122.428834805692 | (37.7807887188922, -122.428834805692) | |||||
| 3375 | 3375 | 253429 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2198 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x7 | 5992046.0 | 2112030.0 | 37.7787737730441 | -122.471105555235 | (37.7787737730441, -122.471105555235) | ||||
| 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) | |||
| 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) | ||||
| 23924 | 23924 | 215624 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 66 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991139.11135 | 2090614.21248 | 37.7199191010706 | -122.47268094048201 | (37.7199191010706, -122.472680940482) | |||
| 24510 | 24510 | 142976 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 392 CHESTNUT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6009963.6556 | 2120937.6931 | 37.80425219968421 | -122.409750018417 | (37.8042521996842, -122.409750018417) | |||
| 25535 | 25535 | 180581 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1394 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6002394.23037 | 2093854.8065099998 | 37.72946213735921 | -122.434007462878 | (37.7294621373592, -122.434007462878) | |||
| 26083 | 26083 | 123491 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 30 | 5995674.45752 | 2111730.9534 | 37.77816187055421 | -122.458531727532 | (37.7781618705542, -122.458531727532) | ||||
| 26368 | 26368 | 137075 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 Hayes St | 1 | : 4 | Tree 1 | Private 1 | 24 | Width 5ft | 6004617.552730001 | 2110839.21576 | 37.776223284701 | -122.42753075415001 | (37.776223284701, -122.42753075415) | |||
| 28271 | 28271 | 215581 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5991373.01779 | 2092318.20321 | 37.7246113758903 | -122.471996546509 | (37.7246113758903, -122.471996546509) | |||
| 29922 | 29922 | 215600 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 67 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5991265.7011400005 | 2092317.6532400001 | 37.724603655215894 | -122.472367482699 | (37.7246036552159, -122.472367482699) | |||
| 30170 | 30170 | 180579 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2500 Bay Shore Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6010790.74354 | 2086511.28723 | 37.7097712796836 | -122.404463040238 | (37.7097712796836, -122.404463040238) | |||
| 30230 | 30230 | 199847 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1611 Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6014254.2532 | 2092550.5249 | 37.7265467847844 | -122.392914674805 | (37.7265467847844, -122.392914674805) | |||
| 31393 | 31393 | 123644 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 445 Arguello Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995555.16132 | 2113176.03479 | 37.78212282277371 | -122.45904907539101 | (37.7821228227737, -122.459049075391) | |||
| 33957 | 33957 | 137078 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008753.16727 | 2118586.36158 | 37.7977281199218 | -122.413772601749 | (37.7977281199218, -122.413772601749) | |||
| 34555 | 34555 | 180593 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2136 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6000017.35738 | 2089840.46995 | 37.718304512220605 | -122.44193650477699 | (37.7183045122206, -122.441936504777) | |||
| 34624 | 34624 | 142237 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 689 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004726.9033 | 2110859.9695 | 37.7762864537737 | -122.42715395911101 | (37.7762864537737, -122.427153959111) | |||
| 34747 | 34747 | 123483 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5995662.44998 | 2111958.25695 | 37.7787852957742 | -122.458589724568 | (37.7787852957742, -122.458589724568) | ||||
| 34942 | 34942 | 215575 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 95 Kirkham St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 3ft | 5994715.1652 | 2105292.6604299997 | 37.76042882975 | -122.461383388048 | (37.76042882975, -122.461383388048) | |||
| 36173 | 36173 | 137082 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1627 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008777.375519999 | 2118389.76877 | 37.7971896841052 | -122.413674921875 | (37.7971896841052, -122.413674921875) | |||
| 36497 | 36497 | 215645 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 88 | : 4 | Tree 1 | Private 1 | 15 | Width 0ft | 5991139.08964 | 2090556.8339200001 | 37.7197615524271 | -122.47267683419099 | (37.7197615524271, -122.472676834191) | |||
| 36799 | 36799 | 123470 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 778 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5995383.59468 | 2110411.0672400002 | 37.7745210919414 | -122.45944230753099 | (37.7745210919414, -122.459442307531) | |||
| 36822 | 36822 | 215590 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 501 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 3ft | 5991474.9385 | 2093941.2931 | 37.729073873942795 | -122.47176245478701 | (37.7290738739428, -122.471762454787) | |||
| 37126 | 37126 | 124641 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5995529.17868 | 2115583.09769 | 37.7887304767053 | -122.459313330112 | (37.7887304767053, -122.459313330112) | |||
| 37233 | 37233 | 105882 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 5997612.13513 | 2115509.12693 | 37.78864690886571 | -122.45210129905001 | (37.7886469088657, -122.45210129905) | ||||
| 37355 | 37355 | 124688 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5995612.537930001 | 2113341.5687 | 37.782580632849395 | -122.458862568059 | (37.7825806328494, -122.458862568059) | |||
| 37961 | 37961 | 185716 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 2101 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984901.6243 | 2100400.4346 | 37.746426426174395 | -122.49496265549601 | (37.7464264261744, -122.494962655496) | |||
| 38027 | 38027 | 215623 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 65 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991145.2526 | 2090614.88415 | 37.7199213008035 | -122.472659761464 | (37.7199213008035, -122.472659761464) | |||
| 38177 | 38177 | 215644 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 87 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991153.983659999 | 2090558.88602 | 37.7197680491356 | -122.472625500878 | (37.7197680491356, -122.472625500878) | |||
| 38271 | 38271 | 215583 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5991379.44831 | 2092444.8187099998 | 37.7249594027384 | -122.471983541404 | (37.7249594027384, -122.471983541404) | |||
| 38305 | 38305 | 116138 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1601X Armstrong Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 30 | 6014404.0852 | 2092434.1919 | 37.7262356791342 | -122.39238857399599 | (37.7262356791342, -122.392388573996) | ||||
| 39237 | 39237 | 215650 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 101 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991145.973069999 | 2090449.2056 | 37.7194664300225 | -122.472645197812 | (37.7194664300225, -122.472645197812) | |||
| 39462 | 39462 | 215649 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 93 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5991151.37081 | 2090546.73366 | 37.7197345305043 | -122.472633646933 | (37.7197345305043, -122.472633646933) | |||
| 39612 | 39612 | 215615 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 57 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991138.24471 | 2090632.0819 | 37.719968115927 | -122.472685238326 | (37.719968115927, -122.472685238326) | |||
| 40956 | 40956 | 242792 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1200 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6003987.76148 | 2095934.3227099997 | 37.7352623274905 | -122.42864664822399 | (37.7352623274905, -122.428646648224) | ||||
| 41079 | 41079 | 215635 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 78 | : 4 | Tree 1 | Private 1 | 3 | Width 0ft | 5991140.257019999 | 2090584.0200099999 | 37.7198362663069 | -122.47267478013 | (37.7198362663069, -122.47267478013) | |||
| 41864 | 41864 | 215599 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 700 Junipero Serra Blvd | 52 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991273.40065 | 2092440.71249 | 37.724941990971395 | -122.47234983348999 | (37.7249419909714, -122.47234983349) | |||
| 42957 | 42957 | 137072 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 3598 Clay St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5997679.8137 | 2115460.2442400004 | 37.788516566519604 | -122.451863614513 | (37.7885165665196, -122.451863614513) | |||
| 43417 | 43417 | 215627 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 900 Junipero Serra Blvd | 69 | : 4 | Tree 1 | Private 1 | 13 | Width 0ft | 5991161.91923 | 2090597.1686900002 | 37.7198736232612 | -122.472600860338 | (37.7198736232612, -122.472600860338) | |||
| 44014 | 44014 | 215580 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 751 Junipero Serra Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 3ft | 5991366.74972 | 2092229.04743 | 37.7243662135233 | -122.47201171896499 | (37.7243662135233, -122.472011718965) | |||
| 44608 | 44608 | 215594 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 246 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994531.01193 | 2087471.53389 | 37.7114858129011 | -122.46072877062299 | (37.7114858129011, -122.460728770623) |
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");