Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlotSize, PermitNotes
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | |||
| 187415 | 187415 | 244374 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.42401292788901 | (37.7735554657504, -122.424012927889) | |||
| 186972 | 186972 | 244255 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005643.2766 | 2110040.2561 | 37.7740874977816 | -122.423925664351 | (37.7740874977816, -122.423925664351) | |||
| 185473 | 185473 | 242779 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.77169326466979 | -122.420703668659 | (37.7716932646698, -122.420703668659) | |||
| 184309 | 184309 | 244362 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005532.1079 | 2110378.8544 | 37.7750109299929 | -122.42433430414499 | (37.7750109299929, -122.424334304145) | |||
| 183804 | 183804 | 198502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 900x Carolina St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | 6012462.6007 | 2103568.62023 | 37.75670045906929 | -122.399881750743 | (37.7567004590693, -122.399881750743) | ||||
| 183718 | 183718 | 246549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6005737.248 | 2109452.9268900002 | 37.77248013816789 | -122.423558835368 | (37.7724801381679, -122.423558835368) | |||
| 182189 | 182189 | 244315 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005508.5005 | 2110550.2437 | 37.7754801903482 | -122.42442816055599 | (37.7754801903482, -122.424428160556) | |||
| 181312 | 181312 | 246539 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | |||
| 178300 | 178300 | 246552 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | |||
| 176821 | 176821 | 244373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.0227 | 2109867.6455 | 37.7736117862994 | -122.424021499783 | (37.7736117862994, -122.424021499783) | |||
| 176025 | 176025 | 244355 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005591.5984 | 2110402.9339 | 37.7750804055544 | -122.42413022622601 | (37.7750804055544, -122.424130226226) | |||
| 175443 | 175443 | 246555 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.772815290316295 | -122.423623602744 | (37.7728152903163, -122.423623602744) | |||
| 174364 | 174364 | 244465 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005629.1512 | 2109732.6732 | 37.773242151986 | -122.423952649806 | (37.773242151986, -122.423952649806) | |||
| 174240 | 174240 | 244360 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | |||
| 173743 | 173743 | 200597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.732969621897794 | -122.38526117126301 | (37.7329696218978, -122.385261171263) | |||
| 173527 | 173527 | 244256 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005639.4577 | 2110060.8783 | 37.7741439057581 | -122.423940341347 | (37.7741439057581, -122.423940341347) | |||
| 172378 | 172378 | 244353 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005598.6806 | 2110351.942 | 37.7749407940225 | -122.424102100187 | (37.7749407940225, -122.424102100187) | |||
| 170608 | 170608 | 244363 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6005533.5243 | 2110362.3292 | 37.7749656357807 | -122.42432822890801 | (37.7749656357807, -122.424328228908) | |||
| 169025 | 169025 | 244305 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.775320869598204 | -122.424177304818 | (37.7753208695982, -122.424177304818) | |||
| 168800 | 168800 | 180514 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1027 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 4ft | 6004210.581680001 | 2090053.8218900003 | 37.7191283865346 | -122.427457483699 | (37.7191283865346, -122.427457483699) | |||
| 166774 | 166774 | 242781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 95x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.42209948031099 | (37.771601160584, -122.422099480311) | |||
| 166112 | 166112 | 244308 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005570.3518 | 2110556.8538 | 37.7755018326332 | -122.424214672145 | (37.7755018326332, -122.424214672145) | |||
| 164702 | 164702 | 246548 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.772423585213794 | -122.423543772638 | (37.7724235852138, -122.423543772638) | |||
| 164108 | 164108 | 244401 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.7252 | 2110260.2263 | 37.7746897578806 | -122.424046993197 | (37.7746897578806, -122.424046993197) | |||
| 162148 | 162148 | 244410 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005558.4964 | 2110254.116 | 37.7746699186287 | -122.424234147092 | (37.7746699186287, -122.424234147092) | |||
| 161664 | 161664 | 244455 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | |||
| 161575 | 161575 | 244236 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005567.6618 | 2110181.5564 | 37.774471205054496 | -122.42419728060601 | (37.7744712050545, -122.424197280606) | |||
| 160927 | 160927 | 242373 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | |||
| 158186 | 158186 | 244477 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | |||
| 157190 | 157190 | 244329 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005667.8615 | 2109858.0536 | 37.773588601656996 | -122.423827662517 | (37.773588601657, -122.423827662517) | |||
| 156415 | 156415 | 244257 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005636.4025 | 2110083.7918 | 37.7742066482035 | -122.42395253955699 | (37.7742066482035, -122.423952539557) | |||
| 155394 | 155394 | 244400 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005615.7803 | 2110234.2576 | 37.774618626605296 | -122.42403457786301 | (37.7746186266053, -122.424034577863) | |||
| 155187 | 155187 | 244456 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.773319011501705 | -122.42397123777799 | (37.7733190115017, -122.423971237778) | |||
| 155019 | 155019 | 246537 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | |||
| 152904 | 152904 | 244425 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005682.2494 | 2109755.2828 | 37.7733072300695 | -122.423770583723 | (37.7733072300695, -122.423770583723) | |||
| 151969 | 151969 | 246544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 11 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | Width 8ft | 6005666.89387 | 2109521.5509099998 | 37.7726645918273 | -122.42380707793998 | (37.7726645918273, -122.42380707794) | |||
| 149777 | 149777 | 244283 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005579.1186 | 2110077.6816 | 37.7741866368779 | -122.424150260413 | (37.7741866368779, -122.424150260413) | |||
| 149269 | 149269 | 244421 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005693.2117 | 2109673.0661 | 37.773082101669296 | -122.423726816669 | (37.7730821016693, -122.423726816669) | |||
| 147182 | 147182 | 244399 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005618.8355 | 2110208.2889 | 37.7745474953334 | -122.424022162207 | (37.7745474953334, -122.424022162207) | |||
| 146320 | 146320 | 24651 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 399X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006472.6793353 | 2097605.2357322 | 37.739990602007204 | -122.420173907565 | (37.7399906020072, -122.420173907565) | |||
| 146259 | 146259 | 17527 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 349X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6002621.9363 | 2091050.61782 | 37.7217753855301 | -122.43301999486201 | (37.7217753855301, -122.433019994862) | |||
| 146043 | 146043 | 16445 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
| 146021 | 146021 | 22309 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5033 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6014806.53085 | 2094754.47288 | 37.732629043524206 | -122.391159442188 | (37.7326290435242, -122.391159442188) | |||
| 146012 | 146012 | 119781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 145668 | 145668 | 7601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3127 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2011 12:00:00 AM | 3 | 3x3 | 6008460.24171 | 2100469.91585 | 37.7479681699401 | -122.413504265914 | (37.7479681699401, -122.413504265914) | ||
| 145232 | 145232 | 119714 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 145037 | 145037 | 119787 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 144933 | 144933 | 119701 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||
| 144902 | 144902 | 17485 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 220X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002262.892318901 | 2091226.5881509997 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | |||
| 144605 | 144605 | 119782 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 144473 | 144473 | 17599 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 901X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3x3 | 6003845.6513541 | 2090290.9535450002 | 37.719758851010496 | -122.42873580329399 | (37.7197588510105, -122.428735803294) | |||
| 144437 | 144437 | 16423 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016393.65878 | 2094869.65123 | 37.73303324923471 | -122.385680326224 | (37.7330332492347, -122.385680326224) | |||
| 144022 | 144022 | 14865 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1399 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | ||
| 143969 | 143969 | 119822 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 143889 | 143889 | 119821 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 143592 | 143592 | 17509 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 209 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3x3 | 6002301.24651 | 2091251.1556 | 37.7223078217962 | -122.434142863321 | (37.7223078217962, -122.434142863321) | |||
| 143170 | 143170 | 17956 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2475 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.787519010566704 | -122.43649427747101 | (37.7875190105667, -122.436494277471) | |||
| 142978 | 142978 | 14864 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1399 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 5 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | ||
| 142143 | 142143 | 119825 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 141876 | 141876 | 119711 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 141612 | 141612 | 7593 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3065 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/1992 12:00:00 AM | 6 | 3X3 | 6008718.17 | 2100791.65733 | 37.748866079627206 | -122.41263509881 | (37.7488660796272, -122.41263509881) | ||
| 141469 | 141469 | 28264 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1100X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003899.2367 | 2111834.49982 | 37.7789154337837 | -122.43008662212601 | (37.7789154337837, -122.430086622126) | |||
| 141190 | 141190 | 17484 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 220X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002262.892318901 | 2091226.5881509997 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | |||
| 140858 | 140858 | 18525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 6x8 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
| 140379 | 140379 | 14496 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 345 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X4 | 5998988.10277 | 2111568.3775400002 | 37.7779053592654 | -122.44705696740499 | (37.7779053592654, -122.447056967405) | |||
| 140297 | 140297 | 16444 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 139652 | 139652 | 17941 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2445 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/23/2016 12:00:00 AM | 18 | 3x3 | 6002249.5312774 | 2115023.8576257 | 37.7875790308508 | -122.43602188230601 | (37.7875790308508, -122.436021882306) | ||
| 139616 | 139616 | 103743 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2011 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2014 12:00:00 AM | 3 | 3x3 | 6008128.1 | 2106710.2 | 37.7650839125599 | -122.415094442696 | (37.7650839125599, -122.415094442696) | ||
| 139301 | 139301 | 119823 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 138568 | 138568 | 17533 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 445X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002799.2909021 | 2090948.5412154999 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | |||
| 138143 | 138143 | 244478 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | |||
| 138030 | 138030 | 242370 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 10ft | 6006121.14049 | 2109126.61017 | 37.7716058118802 | -122.422207723609 | (37.7716058118802, -122.422207723609) | |||
| 137760 | 137760 | 244316 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005509.917 | 2110533.7186 | 37.7754348964248 | -122.424422084884 | (37.7754348964248, -122.424422084884) | |||
| 137478 | 137478 | 244312 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005504.7234 | 2110575.2675 | 37.7755486863335 | -122.424443006762 | (37.7755486863335, -122.424443006762) | |||
| 136512 | 136512 | 244331 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005661.6953 | 2109906.0133 | 37.7737199393103 | -122.423852403284 | (37.7737199393103, -122.423852403284) | |||
| 136228 | 136228 | 246554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.772739687913706 | -122.423612306376 | (37.7727396879137, -122.423612306376) | |||
| 135988 | 135988 | 242371 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 90x McCoppin St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 10ft | 6006102.65154 | 2109126.4322 | 37.771604280331005 | -122.42227166541001 | (37.771604280331, -122.42227166541) | |||
| 135438 | 135438 | 180544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 790 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | Width 3ft | 6003493.29821 | 2090458.5118900002 | 37.72019898087729 | -122.429965709077 | (37.7201989808773, -122.429965709077) | |||
| 132653 | 132653 | 244258 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005634.1112 | 2110100.5951 | 37.7742526566427 | -122.42396166072399 | (37.7742526566427, -122.423961660724) | |||
| 131483 | 131483 | 244307 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005574.129 | 2110533.2464 | 37.775437225714995 | -122.424199926569 | (37.775437225715, -122.424199926569) | |||
| 131030 | 131030 | 246540 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | |||
| 129691 | 129691 | 244344 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005605.8565 | 2109917.6606 | 37.773748767543104 | -122.424046387097 | (37.7737487675431, -122.424046387097) | |||
| 129150 | 129150 | 13324 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 435X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002777.3722738 | 2090962.3160143998 | 37.72154174394979 | -122.432476389775 | (37.7215417439498, -122.432476389775) | |||
| 128669 | 128669 | 18002 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2676 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001135.876759999 | 2114918.88378 | 37.7872274699544 | -122.439867367887 | (37.7872274699544, -122.439867367887) | |||
| 128570 | 128570 | 17523 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002491.8541480005 | 2091141.7505443 | 37.7220182361725 | -122.43347616382499 | (37.7220182361725, -122.433476163825) | |||
| 128531 | 128531 | 119710 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 128474 | 128474 | 119819 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 128093 | 128093 | 119709 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 127828 | 127828 | 18527 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3104X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.748176096662604 | -122.413748394121 | (37.7481760966626, -122.413748394121) | |||
| 127815 | 127815 | 119816 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 127520 | 127520 | 23744 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1111X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003857.72301 | 2111778.219 | 37.7787585493448 | -122.430226218205 | (37.7787585493448, -122.430226218205) | |||
| 127055 | 127055 | 17532 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 445X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6002799.2909021 | 2090948.5412154999 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | |||
| 126103 | 126103 | 23645 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 197 Virginia Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006675.2549665 | 2098483.0974626 | 37.7424124262119 | -122.41953574926201 | (37.7424124262119, -122.419535749262) | |||
| 126070 | 126070 | 109170 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 126046 | 126046 | 7647 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3302 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6008452.78429 | 2099390.30637 | 37.7450033836799 | -122.41345371210801 | (37.7450033836799, -122.413453712108) | |||
| 126009 | 126009 | 17576 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.72011720804429 | -122.429795147634 | (37.7201172080443, -122.429795147634) | |||
| 125886 | 125886 | 119679 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
| 125035 | 125035 | 2598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1738 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005142.528530001 | 2115146.44686 | 37.788079556998504 | -122.42602140794901 | (37.7880795569985, -122.426021407949) | |||
| 124784 | 124784 | 25189 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3733 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6000311.6199976 | 2102932.6354716998 | 37.754269290896104 | -122.44185850513901 | (37.7542692908961, -122.441858505139) |
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");