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) | |||
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) | |||
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 | ||||||||
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 | |||||||||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | ||||
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) | |||
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) | ||
46257 | 46257 | 97505 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 20X 10th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/2011 12:00:00 AM | 12 | 3x3 | Permit Number 768079 | 6007672.0 | 2110712.0 | 37.7760462700595 | -122.416955543158 | (37.7760462700595, -122.416955543158) | |
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) | |||
52532 | 52532 | 124686 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 460 Arguello Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5995607.11329 | 2113402.43136 | 37.7827474336358 | -122.458885742796 | (37.7827474336358, -122.458885742796) | |||
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) | |
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) | ||||
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) | |||
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) | |||
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) | |||
66690 | 66690 | 137069 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 7 Laurel St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997939.35301 | 2116349.8609700003 | 37.7909740791344 | -122.45102982968099 | (37.7909740791344, -122.451029829681) | |||
66806 | 66806 | 123958 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 295 07th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5993672.37881 | 2113557.39213 | 37.7830615134244 | -122.46559031264799 | (37.7830615134244, -122.465590312648) | |||
66816 | 66816 | 124642 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 50 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5995529.95307 | 2115590.13506 | 37.7887498439417 | -122.459311160683 | (37.7887498439417, -122.459311160683) | |||
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) | ||
69626 | 69626 | 180591 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 1804 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6001183.24158 | 2091479.89441 | 37.72287237033329 | -122.438023911598 | (37.7228723703333, -122.438023911598) | |||
69819 | 69819 | 180585 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 177 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6001325.27813 | 2093179.51545 | 37.7275472199251 | -122.43765458428999 | (37.7275472199251, -122.43765458429) | |||
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) | |||
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) | |||
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) | |||
74903 | 74903 | 215591 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 233 Sagamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5994635.3694400005 | 2087388.76073 | 37.711264541001206 | -122.460362092762 | (37.7112645410012, -122.460362092762) | |||
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) | |||
77659 | 77659 | 7482 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2650X Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) |
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");