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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) |
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");