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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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 | |||||||||
| 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) | |
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 47125 | 47125 | 123486 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5995665.690219999 | 2111872.7664900003 | 37.7785507478592 | -122.458572325088 | (37.7785507478592, -122.458572325088) | ||||
| 52498 | 52498 | 123489 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5995672.03179 | 2111788.60232 | 37.7783200198099 | -122.458544293173 | (37.7783200198099, -122.458544293173) | ||||
| 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) | ||||
| 61015 | 61015 | 242794 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2x Coso Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 30 | 6007112.52178 | 2099889.35747 | 37.746298321115 | -122.418123483128 | (37.746298321115, -122.418123483128) | ||||
| 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) | ||
| 77875 | 77875 | 106884 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 6 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 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) | |||||
| 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) | |||
| 94026 | 94026 | 29916 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 810 Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | ||||
| 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) | |||||
| 94262 | 94262 | 106880 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 3 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 5 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 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) | |||
| 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) | |||
| 99073 | 99073 | 108311 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 439x ARLINGTON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003949.9 | 2096014.9 | 37.7354814316621 | -122.42878329168998 | (37.7354814316621, -122.42878329169) | |||||
| 101162 | 101162 | 87591 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3840 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 5990782.62319 | 2090250.3116099997 | 37.7188992769151 | -122.473886649335 | (37.7188992769151, -122.473886649335) | ||||
| 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) | |||
| 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) | ||||
| 125523 | 125523 | 106883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 180X SAN MARCOS AVE | 4 | Median : Cutout 11 | Tree 1 | Private 1 | DPW 4 | 4 | 5993452.8 | 2100406.9 | 37.746941053663505 | -122.46539437233801 | (37.7469410536635, -122.465394372338) | |||
| 126369 | 126369 | 29915 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 810 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | ||||
| 128580 | 128580 | 82168 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 60 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5995525.66671462 | 2115618.09435692 | 37.7888263661678 | -122.45932801632 | (37.7888263661678, -122.45932801632) | |||||
| 135449 | 135449 | 123482 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | 5995660.39644 | 2111993.63742 | 37.7788823231397 | -122.458599390427 | (37.7788823231397, -122.458599390427) | ||||
| 139259 | 139259 | 29914 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 810 Junipero Serra Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | ||||
| 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) | |||
| 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) | ||||
| 145740 | 145740 | 123490 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5995673.905040001 | 2111757.95548 | 37.7782359793629 | -122.45853559389299 | (37.7782359793629, -122.458535593893) | ||||
| 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) | ||
| 152798 | 152798 | 123480 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5995658.308019999 | 2112054.06112 | 37.7790481105637 | -122.458610990374 | (37.7790481105637, -122.458610990374) | ||||
| 158560 | 158560 | 123481 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5995659.669480001 | 2112025.6512 | 37.7789701827075 | -122.458604223385 | (37.7789701827075, -122.458604223385) | ||||
| 162620 | 162620 | 123479 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5995657.67406 | 2112077.16899 | 37.7791115222078 | -122.458614856747 | (37.7791115222078, -122.458614856747) | ||||
| 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) | ||||
| 171899 | 171899 | 123484 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | 5995663.25844 | 2111930.13675 | 37.778708131625294 | -122.458584891633 | (37.7787081316253, -122.458584891633) | ||||
| 172911 | 172911 | 105883 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5997608.20664 | 2115530.35123 | 37.7887049601136 | -122.452116422945 | (37.7887049601136, -122.452116422945) | ||||
| 173805 | 173805 | 123488 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5995672.61976 | 2111816.69318 | 37.7783971836602 | -122.458544293173 | (37.7783971836602, -122.458544293173) | ||||
| 177374 | 177374 | 123487 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 600 Arguello Blvd | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5995668.73883 | 2111844.87781 | 37.778474348143895 | -122.45855975947599 | (37.7784743481439, -122.458559759476) | ||||
| 189005 | 189005 | 105881 | Undocumented 2 | Ulmus pumila :: Siberian Elm 53 | 250 Locust St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 5997617.52659 | 2115483.20836 | 37.788576052199396 | -122.452080774722 | (37.7885760521994, -122.452080774722) | ||||
| 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) | |||
| 104642 | 104642 | 1257 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3801 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 1X3 | 5992919.7951 | 2087516.7094700001 | 37.7115170200575 | -122.46630079139099 | (37.7115170200575, -122.466300791391) | |||
| 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) | |||
| 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) | |||
| 86527 | 86527 | 397 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990474.691459999 | 2090771.6766099997 | 37.720312975301 | -122.474989074306 | (37.720312975301, -122.474989074306) | |||
| 87989 | 87989 | 395 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 2 | 5990486.24663 | 2090696.51982 | 37.720107283055604 | -122.474943649084 | (37.7201072830556, -122.474943649084) | |||
| 89332 | 89332 | 391 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 2 | 5990530.65648 | 2090591.3498 | 37.7198210858115 | -122.474782468587 | (37.7198210858115, -122.474782468587) | |||
| 90284 | 90284 | 401 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2 | 5990481.9086 | 2090947.8037400001 | 37.7207969949539 | -122.474976977183 | (37.7207969949539, -122.474976977183) | |||
| 112174 | 112174 | 400 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2 | 5990476.72602 | 2090904.23897 | 37.7206770765591 | -122.474991713144 | (37.7206770765591, -122.474991713144) | |||
| 113267 | 113267 | 393 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 23 | 2 | 5990507.18031 | 2090652.7596599997 | 37.7199883416446 | -122.47486809669701 | (37.7199883416446, -122.474868096697) | |||
| 115742 | 115742 | 394 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 2 | 5990492.73788 | 2090676.25296 | 37.720052011465896 | -122.474919732673 | (37.7200520114659, -122.474919732673) | |||
| 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) | |||
| 128658 | 128658 | 398 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3790X 19th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 2 | 5990471.16794 | 2090846.61881 | 37.7205185437854 | -122.475006721555 | (37.7205185437854, -122.475006721555) | |||
| 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) | |||
| 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) | |||
| 82725 | 82725 | 11620 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 104574 | 104574 | 11619 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 129272 | 129272 | 11614 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2X2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 117409 | 117409 | 227 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 2968 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 2X3 | 5990630.67566 | 2095430.1647700001 | 37.7331130547028 | -122.474789735965 | (37.7331130547028, -122.474789735965) | |||
| 114875 | 114875 | 415 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 3862 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 2X6 | 5990878.963880001 | 2090116.60552 | 37.718537732694394 | -122.473543893183 | (37.7185377326944, -122.473543893183) | |||
| 94750 | 94750 | 11616 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 122262 | 122262 | 11737 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 900X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2x2 | 5991216.9689233005 | 2091217.0890623 | 37.7215789580388 | -122.472455744827 | (37.7215789580388, -122.472455744827) | |||
| 122715 | 122715 | 11615 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 80X Junipero Serra Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 2x2 | 5991396.1674726 | 2095410.2239213001 | 37.7331026312309 | -122.472141799028 | (37.7331026312309, -122.472141799028) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) |
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");