Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 225 | 225 | 138808 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/06/2015 11:29:00 AM | 5 | Width 0ft | 6002680.0299 | 2115089.4167 | 37.787783486631206 | -122.434537133485 | (37.7877834866312, -122.434537133485) | ||
| 229 | 229 | 138803 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.787719421164496 | -122.434937251329 | (37.7877194211645, -122.434937251329) | |||
| 1203 | 1203 | 119796 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1204 | 1204 | 119749 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1228 | 1228 | 119831 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 7478 | 7478 | 46291 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/31/2002 12:00:00 AM | Permit Number 44564 | |||||||||
| 10957 | 10957 | 17580 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003780.63082 | 2090335.5596900003 | 37.719877649504205 | -122.428963734788 | (37.7198776495042, -122.428963734788) | |||
| 11540 | 11540 | 17520 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/20/1998 12:00:00 AM | 18 | 3x3 | 6002494.3085199995 | 2091085.91322 | 37.721865058601296 | -122.433463691421 | (37.7218650586013, -122.433463691421) | ||
| 14093 | 14093 | 97435 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.732951043415206 | -122.385341956131 | (37.7329510434152, -122.385341956131) | |||
| 14682 | 14682 | 85769 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008582.3574 | 2109309.4458 | 37.7722463531305 | -122.413707137147 | (37.7722463531305, -122.413707137147) | ||
| 15087 | 15087 | 91034 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010653.2937 | 2111194.8106 | 37.7775392048064 | -122.406676440472 | (37.7775392048064, -122.406676440472) | ||
| 15403 | 15403 | 98861 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 145 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6008516.35298 | 2110609.93053 | 37.7758134708437 | -122.414027470493 | (37.7758134708437, -122.414027470493) | |||
| 20811 | 20811 | 7600 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008389.36019 | 2100484.75835 | 37.748004943889605 | -122.413750421747 | (37.7480049438896, -122.413750421747) | |||
| 25444 | 25444 | 198476 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6015193.91802 | 2104744.93458 | 37.7600822588968 | -122.390517973622 | (37.7600822588968, -122.390517973622) | |||
| 27464 | 27464 | 215498 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 95 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993979.5407 | 2097285.08347 | 37.7383996933922 | -122.46334646239201 | (37.7383996933922, -122.463346462392) | |||
| 28363 | 28363 | 198495 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 950 Tennessee St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6015477.3225 | 2104627.00235 | 37.7597741601603 | -122.389529568345 | (37.7597741601603, -122.389529568345) | |||
| 29153 | 29153 | 244356 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.775145038872104 | -122.424143338216 | (37.7751450388721, -122.424143338216) | |||
| 32913 | 32913 | 198472 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 704 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6015328.96766 | 2105817.04022 | 37.7630335209151 | -122.390125796375 | (37.7630335209151, -122.390125796375) | |||
| 33160 | 33160 | 215550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5994032.03336 | 2096692.14483 | 37.7367746553097 | -122.463121959218 | (37.7367746553097, -122.463121959218) | |||
| 34532 | 34532 | 244424 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005686.3603 | 2109729.9326 | 37.7732378565997 | -122.42375456071301 | (37.7732378565997, -122.423754560713) | |||
| 37468 | 37468 | 198678 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010359.47982 | 2111557.78745 | 37.7785194112705 | -122.407718445767 | (37.7785194112705, -122.407718445767) | |||
| 45102 | 45102 | 110636 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 631 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6013480.9365 | 2113896.4407 | 37.785115060457294 | -122.397084089074 | (37.7851150604573, -122.397084089074) | |||
| 48729 | 48729 | 242737 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 115 Corbett Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6000767.45695 | 2105648.39413 | 37.7617520652142 | -122.44047687542201 | (37.7617520652142, -122.440476875422) | |||
| 50390 | 50390 | 246538 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | |||
| 50663 | 50663 | 215561 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 5994051.56415 | 2096391.9131599998 | 37.7359514186289 | -122.46303265654899 | (37.7359514186289, -122.463032656549) | |||
| 55185 | 55185 | 198604 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6016296.79375 | 2108651.46445 | 37.7708698687766 | -122.386976080084 | (37.7708698687766, -122.386976080084) | ||||
| 55305 | 55305 | 137015 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2795 Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000234.59127 | 2117454.54255 | 37.7941383806269 | -122.44316779448201 | (37.7941383806269, -122.443167794482) | |||
| 55928 | 55928 | 198630 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015737.06642 | 2108741.11663 | 37.7710850252717 | -122.38891846733401 | (37.7710850252717, -122.388918467334) | ||||
| 56583 | 56583 | 242500 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2618 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008242.75082 | 2103068.59943 | 37.7550913551842 | -122.414440195464 | (37.7550913551842, -122.414440195464) | |||
| 57539 | 57539 | 137063 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 462 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011730.01399 | 2118396.8785 | 37.797374566725104 | -122.403458498435 | (37.7973745667251, -122.403458498435) | |||
| 58320 | 58320 | 242530 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2020 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008043.54028 | 2106645.81867 | 37.7649023840706 | -122.415382356711 | (37.7649023840706, -122.415382356711) | |||
| 58522 | 58522 | 242604 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1311 Clayton St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 5999041.21728 | 2105197.03695 | 37.7604143056979 | -122.446414751759 | (37.7604143056979, -122.446414751759) | |||
| 59511 | 59511 | 198436 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6015560.81783 | 2106295.35578 | 37.7643597286383 | -122.389357302304 | (37.7643597286383, -122.389357302304) | |||
| 61347 | 61347 | 198555 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1700 Newcomb Ave | 4 | : 4 | Tree 1 | Private 1 | 6 | Width 0ft | 6014573.3931599995 | 2096202.10779 | 37.7365910128673 | -122.39206666287 | (37.7365910128673, -122.39206666287) | |||
| 61411 | 61411 | 198456 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014956.8644900005 | 2106266.70489 | 37.76424755710789 | -122.391444222274 | (37.7642475571079, -122.391444222274) | |||
| 63175 | 63175 | 74494 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2233 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 5 | 6010764.33667 | 2106446.7054 | 37.7645082103165 | -122.40595773775699 | (37.7645082103165, -122.405957737757) | ||
| 66098 | 66098 | 138290 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2410 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002291.6728 | 2115085.2938 | 37.78775011285121 | -122.435880478729 | (37.7877501128512, -122.435880478729) | |||
| 69495 | 69495 | 242430 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 300 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005000.31444 | 2109901.75025 | 37.773670874737206 | -122.42613992112801 | (37.7736708747372, -122.426139921128) | |||
| 70303 | 70303 | 198576 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6014783.084840001 | 2114165.1217799997 | 37.7859251988423 | -122.39259782854201 | (37.7859251988423, -122.392597828542) | |||
| 71156 | 71156 | 242480 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2675 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008314.577269999 | 2102856.3741900004 | 37.754512667537 | -122.41417678403 | (37.754512667537, -122.41417678403) | |||
| 74806 | 74806 | 180534 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002734.62326 | 2090983.4567 | 37.7215973673155 | -122.43262567073299 | (37.7215973673155, -122.432625670733) | |||
| 76377 | 76377 | 137050 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1221 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008520.18365 | 2116745.46008 | 37.7926603718421 | -122.41444846295 | (37.7926603718421, -122.41444846295) | |||
| 76901 | 76901 | 242715 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3880 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002516.607890001 | 2103579.90107 | 37.7561719248109 | -122.43427938369899 | (37.7561719248109, -122.434279383699) | |||
| 77041 | 77041 | 198584 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013716.83628 | 2107143.63605 | 37.7665865138841 | -122.39579460903299 | (37.7665865138841, -122.395794609033) | |||
| 80370 | 80370 | 102181 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1800X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | Permit Number 37814 | 6003496.6 | 2114956.8 | 37.7874656747779 | -122.431702484378 | (37.7874656747779, -122.431702484378) | ||
| 82805 | 82805 | 44113 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/22/2000 12:00:00 AM | Permit Number 43622 | 6008701.91833416 | 2101542.01473417 | 37.7509254812099 | -122.41274433750601 | (37.7509254812099, -122.412744337506) | |||
| 84727 | 84727 | 35673 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 490 Pacific Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.797386378640496 | -122.403547515196 | (37.7973863786405, -122.403547515196) | |
| 91533 | 91533 | 119820 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 92279 | 92279 | 17516 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002342.1367820995 | 2091235.8408171001 | 37.7222680914982 | -122.434000421261 | (37.7222680914982, -122.434000421261) | |||
| 94920 | 94920 | 14841 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1315X McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002861.06587 | 2111639.14836 | 37.7783201948721 | -122.43366409969101 | (37.7783201948721, -122.433664099691) | ||
| 95164 | 95164 | 101950 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/07/2012 12:00:00 AM | 11 | 3x3 | Permit Number 769636 | 6008537.0 | 2110562.0 | 37.775683024565296 | -122.413952655551 | (37.7756830245653, -122.413952655551) | |
| 95900 | 95900 | 17538 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 4x7.5 | 6002931.4135505 | 2090865.5085081002 | 37.721284666021106 | -122.43193700213101 | (37.7212846660211, -122.431937002131) | |||
| 96498 | 96498 | 5928 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1335 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | |||
| 97204 | 97204 | 109171 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 97750 | 97750 | 16441 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 100873 | 100873 | 119784 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 101710 | 101710 | 7631 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3255 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008510.8607 | 2099758.97829 | 37.746018935721104 | -122.413278959756 | (37.7460189357211, -122.413278959756) | |||
| 103275 | 103275 | 17572 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 749X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003493.5133628 | 2090512.2555079 | 37.720346561187796 | -122.42996879704799 | (37.7203465611878, -122.429968797048) | |||
| 104002 | 104002 | 198466 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 707 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6015361.95352 | 2105766.3430000003 | 37.7628961467725 | -122.390008166863 | (37.7628961467725, -122.390008166863) | |||
| 105072 | 105072 | 7584 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3000X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
| 105397 | 105397 | 17951 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2475 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.787519010566704 | -122.43649427747101 | (37.7875190105667, -122.436494277471) | |||
| 105883 | 105883 | 87307 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2895 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.751057068106206 | -122.40782691465401 | (37.7510570681062, -122.407826914654) | |||
| 110000 | 110000 | 16421 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016475.459559999 | 2094869.09162 | 37.7330362386527 | -122.385397477745 | (37.7330362386527, -122.385397477745) | |||
| 111207 | 111207 | 17921 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2397X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002488.019783099 | 2115056.9941341 | 37.787683560918495 | -122.435199131446 | (37.7876835609185, -122.435199131446) | |||
| 115516 | 115516 | 108236 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 RUSS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x4 | 6010302.0 | 2111707.0 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | |||
| 116163 | 116163 | 103420 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 700X 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015432.6 | 2105817.0 | 37.7630391577767 | -122.389767361571 | (37.7630391577767, -122.389767361571) | ||||
| 118014 | 118014 | 98273 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 990X York St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.40858435969801 | (37.7562208239384, -122.408584359698) | |
| 123916 | 123916 | 107053 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 450 Walnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.44856229739901 | (37.7875132600186, -122.448562297399) | |||||
| 124132 | 124132 | 17486 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 220X Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6002262.892318901 | 2091226.5881509997 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | |||
| 124318 | 124318 | 107994 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 4410x 23RD ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000358.0 | 2102265.0 | 37.7524387685866 | -122.441650202415 | (37.7524387685866, -122.441650202415) | ||||
| 125787 | 125787 | 45653 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3001 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/13/2001 12:00:00 AM | Permit Number 44350 | 6000345.05114977 | 2116113.5186525 | 37.790462578374 | -122.442689257593 | (37.790462578374, -122.442689257593) | |||
| 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) | |||
| 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) | |||
| 130578 | 130578 | 198566 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 01st St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6014751.35168 | 2114157.00483 | 37.785901149169 | -122.392707049386 | (37.785901149169, -122.392707049386) | |||
| 131811 | 131811 | 242626 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 295 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6008396.65877 | 2100364.68656 | 37.747675663414604 | -122.413716691781 | (37.7476756634146, -122.413716691781) | |||
| 132842 | 132842 | 141751 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2 HOLLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6004006.177999999 | 2113246.4013 | 37.782798220366104 | -122.429817403625 | (37.7827982203661, -122.429817403625) | |||
| 136282 | 136282 | 242614 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 195 Virginia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 8 | Width 3ft | 6006648.68245 | 2098490.72536 | 37.7424318739254 | -122.419628170307 | (37.7424318739254, -122.419628170307) | ||
| 137312 | 137312 | 137022 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2201 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6003025.71137 | 2117483.5061 | 37.794376660507396 | -122.433512298867 | (37.7943766605074, -122.433512298867) | |||
| 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) | |||
| 139417 | 139417 | 23644 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 197 Virginia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 8 | 3X3 | 6006643.75963 | 2098486.4882900002 | 37.7424199625796 | -122.41964489142 | (37.7424199625796, -122.41964489142) | ||
| 139746 | 139746 | 11878 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1501X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 3X3 | 5991566.1252788 | 2087212.7603742 | 37.7106042506249 | -122.470957258061 | (37.7106042506249, -122.470957258061) | |||
| 140198 | 140198 | 97835 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 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) | |||||
| 143024 | 143024 | 109165 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 51x OCTAVIA ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649005 | -122.42385688843399 | (37.772384002649, -122.423856888434) | ||||
| 144741 | 144741 | 46506 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 165 08th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.41227567097201 | (37.7768559207247, -122.412275670972) | |||
| 149125 | 149125 | 138408 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002094.095 | 2115002.411 | 37.787511312327794 | -122.43655812450199 | (37.7875113123278, -122.436558124502) | |||
| 151576 | 151576 | 198645 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6016201.48613 | 2108765.95621 | 37.7711789603748 | -122.387313742229 | (37.7711789603748, -122.387313742229) | ||||
| 154327 | 154327 | 137009 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 3099 Washington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5999994.90207 | 2116065.86366 | 37.790311763526795 | -122.443897321805 | (37.7903117635268, -122.443897321805) | |||
| 155018 | 155018 | 141757 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 10 HOLLIS ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003947.6557 | 2113327.5266 | 37.7830176559931 | -122.430025655042 | (37.7830176559931, -122.430025655042) | |||
| 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) | |||
| 157557 | 157557 | 137643 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1313 McAllister St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6002875.8523 | 2111640.465 | 37.778324649023105 | -122.43361304212 | (37.7783246490231, -122.43361304212) | |||
| 158636 | 158636 | 137008 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2110 Broderick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6000406.08095 | 2115938.23713 | 37.7899847799168 | -122.44246550938999 | (37.7899847799168, -122.44246550939) | |||
| 159257 | 159257 | 242724 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 291 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004457.43787 | 2103936.7513200003 | 37.7572617205612 | -122.427592755209 | (37.7572617205612, -122.427592755209) | |||
| 160075 | 160075 | 31075 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 7 | Permit Number 34816 | 6005979.98097 | 2107292.47987 | 37.76656176455071 | -122.422565649286 | (37.7665617645507, -122.422565649286) | |
| 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) | |||
| 162282 | 162282 | 215543 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 90 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993948.48206 | 2097274.4923 | 37.738368823268296 | -122.46345307882 | (37.7383688232683, -122.46345307882) | |||
| 164166 | 164166 | 180550 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 200 Persia Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002268.14618 | 2091228.5970299998 | 37.7222440023296 | -122.43425567127899 | (37.7222440023296, -122.434255671279) | |||
| 164804 | 164804 | 242572 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2075 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008125.16647 | 2106366.43702 | 37.7641398542804 | -122.415080254657 | (37.7641398542804, -122.415080254657) | |||
| 166094 | 166094 | 32995 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.2659299998 | 37.7844388182424 | -122.39828029921499 | (37.7844388182424, -122.398280299215) | |
| 168772 | 168772 | 198485 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6015200.26669 | 2104562.53753 | 37.7595817879946 | -122.3904832715 | (37.7595817879946, -122.3904832715) |
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");