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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87541 | 87541 | 121665 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 100 Montalvo Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993653.0 | 2099666.0 | 37.7449182738718 | -122.46464831295299 | (37.7449182738718, -122.464648312953) | ||||
| 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 | ||||||||
| 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 | ||||||||
| 60171 | 60171 | 242791 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1001 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6005175.70924 | 2096892.8816200001 | 37.7379614744454 | -122.424607638258 | (37.7379614744454, -122.424607638258) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 60841 | 60841 | 215593 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 103 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5995757.42889 | 2087376.9000799998 | 37.7112964570463 | -122.45648314049801 | (37.7112964570463, -122.456483140498) | |||
| 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) | ||
| 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 | |||||||||
| 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) | |||||
| 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) | ||
| 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) | |||
| 94286 | 94286 | 19045 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 111 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5995778.761022701 | 2087391.1107423 | 37.7113367008986 | -122.45641043862801 | (37.7113367008986, -122.456410438628) | |||
| 166700 | 166700 | 180582 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1110 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 6003793.49913 | 2094480.4258 | 37.7312592588934 | -122.429214647441 | (37.7312592588934, -122.429214647441) | |||
| 74958 | 74958 | 180583 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1114 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6003761.56491 | 2094470.84041 | 37.731231131690706 | -122.42932436652599 | (37.7312311316907, -122.429324366526) | |||
| 75801 | 75801 | 180584 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1114 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6003732.95256 | 2094463.1481400002 | 37.7312083905422 | -122.42942273618601 | (37.7312083905422, -122.429422736186) | |||
| 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) | |||
| 72396 | 72396 | 180590 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1159 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6003628.44812 | 2094335.41976 | 37.7308517598817 | -122.429774919684 | (37.7308517598817, -122.429774919684) | |||
| 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) | |||
| 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) | ||||
| 124841 | 124841 | 11792 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1200X Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2 | 5991118.2706518 | 2089586.5464946998 | 37.7170961765154 | -122.472678089933 | (37.7170961765154, -122.472678089933) | |||
| 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) | |||
| 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) | ||||
| 170241 | 170241 | 180589 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1241 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6003010.99045 | 2094126.1928400001 | 37.7302422857354 | -122.431894635246 | (37.7302422857354, -122.431894635246) | |||
| 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) | |||
| 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) | |||
| 147734 | 147734 | 180580 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1282 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002752.91911 | 2094123.24132 | 37.7302195481937 | -122.432786610727 | (37.7302195481937, -122.432786610727) | |||
| 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) | |||
| 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) | |||
| 166993 | 166993 | 107483 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1306x Montgomery St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 6011458.52251 | 2119859.64432 | 37.8013757989196 | -122.404500953851 | (37.8013757989196, -122.404500953851) | ||||
| 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) | |||
| 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) | ||
| 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) | |||
| 113835 | 113835 | 5927 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1335 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/2016 12:00:00 AM | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 140555 | 140555 | 22541 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1396X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6002380.38751 | 2093819.80205 | 37.7293652374447 | -122.434052817677 | (37.7293652374447, -122.434052817677) | |||
| 170582 | 170582 | 242796 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 140 Belgrave Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 2ft | 5997883.8658300005 | 2104916.82278 | 37.7595787374877 | -122.450397275322 | (37.7595787374877, -122.450397275322) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 111027 | 111027 | 6274 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1420X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6003886.01337 | 2113219.41254 | 37.782717310542395 | -122.430231196525 | (37.7827173105424, -122.430231196525) | |||
| 106502 | 106502 | 6275 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1421X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003957.217759999 | 2113179.66455 | 37.782612205263796 | -122.429982023346 | (37.7826122052638, -122.429982023346) | |||
| 107061 | 107061 | 6276 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1421X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003957.217759999 | 2113179.66455 | 37.782612205263796 | -122.429982023346 | (37.7826122052638, -122.429982023346) | |||
| 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) | |||
| 58162 | 58162 | 180588 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1447 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6002392.55611 | 2093716.4847400002 | 37.729082242150795 | -122.434003367375 | (37.7290822421508, -122.434003367375) | |||
| 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) | |||
| 72604 | 72604 | 180587 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1473 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6002172.86661 | 2093413.1451700001 | 37.7282368704302 | -122.434741167586 | (37.7282368704302, -122.434741167586) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 99544 | 99544 | 6284 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 101312 | 101312 | 6282 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 115146 | 115146 | 26486 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 145390 | 145390 | 6278 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1475 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003892.9969 | 2113024.38483 | 37.7821822086902 | -122.43019311854601 | (37.7821822086902, -122.430193118546) | |||
| 107172 | 107172 | 4850 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1499X ALEMANY BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6x6 | 6002180.0 | 2093376.0 | 37.728135283202704 | -122.43471385212 | (37.7281352832027, -122.43471385212) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 48389 | 48389 | 182457 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1500 31st Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 0ft | 5986548.9803 | 2104732.6813 | 37.7584178970063 | -122.48958488521099 | (37.7584178970063, -122.489584885211) | |||
| 163752 | 163752 | 182456 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1500 31st Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 0ft | 5986548.9803 | 2104699.0505 | 37.758325556062104 | -122.489582412162 | (37.7583255560621, -122.489582412162) | |||
| 177920 | 177920 | 182454 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1500 31st Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 0ft | 5986553.619 | 2104615.5531 | 37.7580965659316 | -122.489560229786 | (37.7580965659316, -122.489560229786) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||||
| 94173 | 94173 | 117256 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||||
| 143144 | 143144 | 105784 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1570 31ST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 04/18/2014 12:00:00 AM | Permit Number 772914 | 5986686.8 | 2104596.0 | 37.7580506528461 | -122.489098201432 | (37.7580506528461, -122.489098201432) | |||
| 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) | |||
| 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) | ||||
| 186517 | 186517 | 199851 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1603 Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6014366.3226 | 2092462.8184 | 37.7263121847089 | -122.392521119846 | (37.7263121847089, -122.392521119846) | |||
| 175293 | 175293 | 199849 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1607 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 6014322.4694 | 2092498.1446 | 37.7264067479006 | -122.392675189528 | (37.7264067479006, -122.392675189528) | |||
| 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) | |||
| 131994 | 131994 | 199846 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1613 Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6014210.3999 | 2092579.1513 | 37.726622951149395 | -122.393068277245 | (37.7266229511494, -122.393068277245) | |||
| 57951 | 57951 | 199844 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1617 Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 0ft | 6014142.1837 | 2092625.4409 | 37.7267462633936 | -122.39330733792801 | (37.7267462633936, -122.393307337928) | |||
| 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) | |||
| 175491 | 175491 | 137081 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1627 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008775.75798 | 2118410.46159 | 37.7972464106437 | -122.413681983361 | (37.7972464106437, -122.413681983361) | |||
| 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) | |||
| 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) | |||
| 171388 | 171388 | 137079 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008755.558119999 | 2118570.22529 | 37.7976839479247 | -122.413763186745 | (37.7976839479247, -122.413763186745) | |||
| 179443 | 179443 | 137080 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008758.62885 | 2118554.07509 | 37.79763977591279 | -122.41375141818999 | (37.7976397759128, -122.41375141819) | |||
| 147002 | 147002 | 83273 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1639X Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 3 | 6008750.425980001 | 2118601.9970299997 | 37.797770897055294 | -122.413783193943 | (37.7977708970553, -122.413783193943) |
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");