Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus ▲ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11534 | 11534 | 17549 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 600 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6003191.593230001 | 2090648.1169 | 37.7207025031963 | -122.431022127369 | (37.7207025031963, -122.431022127369) | |||
| 11538 | 11538 | 17585 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003724.8526 | 2090366.56287 | 37.71995962001 | -122.429158750084 | (37.71995962001, -122.429158750084) | |||
| 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) | ||
| 11558 | 11558 | 17522 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 307 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002546.66743 | 2091098.28956 | 37.7219020117492 | -122.433283584179 | (37.7219020117492, -122.433283584179) | |||
| 11596 | 11596 | 17497 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002079.41309 | 2091392.13948 | 37.7226823390961 | -122.43491976573401 | (37.7226823390961, -122.434919765734) | |||
| 11600 | 11600 | 17581 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003766.7866400005 | 2090331.9281799998 | 37.7198668945342 | -122.429011330508 | (37.7198668945342, -122.429011330508) | |||
| 11611 | 11611 | 17597 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 844 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003772.37846 | 2090279.5258799999 | 37.71972332585371 | -122.428988267402 | (37.7197233258537, -122.428988267402) | |||
| 11682 | 11682 | 17519 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 3x3 | 6002513.47081 | 2091072.78557 | 37.721830100172504 | -122.433396514735 | (37.7218301001725, -122.433396514735) | |||
| 11871 | 11871 | 17518 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002537.724219999 | 2091058.53445 | 37.72179234573429 | -122.433311659211 | (37.7217923457343, -122.433311659211) | |||
| 11883 | 11883 | 17495 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6002027.05349 | 2091378.7208900002 | 37.722642521627996 | -122.43509980193001 | (37.722642521628, -122.43509980193) | |||
| 11929 | 11929 | 17621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1100 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 6004336.281690001 | 2089926.3148400001 | 37.7187853887157 | -122.42701391015899 | (37.7187853887157, -122.427013910159) | |||
| 11996 | 11996 | 17591 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 30 | 3x3 | 6003659.63671 | 2090407.2266799998 | 37.7200675818369 | -122.42938707716299 | (37.7200675818369, -122.429387077163) | |||
| 12017 | 12017 | 17554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 620 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003227.93089 | 2090625.05216 | 37.7206412314956 | -122.43089487419901 | (37.7206412314956, -122.430894874199) | |||
| 12027 | 12027 | 17535 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003034.530590001 | 2090798.32089 | 37.721106028988295 | -122.431575761713 | (37.7211060289883, -122.431575761713) | |||
| 12076 | 12076 | 17583 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003749.1517199995 | 2090342.6567099998 | 37.7198953544779 | -122.429073052804 | (37.7198953544779, -122.429073052804) | |||
| 12120 | 12120 | 17542 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 525 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/29/2011 12:00:00 AM | 3 | 3x3 | 6003053.24569 | 2090786.85001 | 37.7210755932558 | -122.43151025062099 | (37.7210755932558, -122.431510250621) | ||
| 12133 | 12133 | 17594 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 808 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6003660.5889 | 2090352.7029799998 | 37.719917925661 | -122.42937989966002 | (37.719917925661, -122.42937989966) | |||
| 12305 | 12305 | 17584 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.42910467385201 | (37.7199371612464, -122.429104673852) | |||
| 12309 | 12309 | 17496 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/23/2003 12:00:00 AM | 3 | 2X2 | 6002048.59392 | 2091411.2062099997 | 37.7227329421421 | -122.43502766371401 | (37.7227329421421, -122.435027663714) | ||
| 12432 | 12432 | 17625 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1132 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6004425.094930001 | 2089870.4961599999 | 37.7186371444562 | -122.426702945308 | (37.7186371444562, -122.426702945308) | |||
| 12439 | 12439 | 17499 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 106 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6002048.76612 | 2091365.2856599998 | 37.722606864403296 | -122.435023785838 | (37.7226068644033, -122.435023785838) | ||
| 12487 | 12487 | 17616 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1030 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004194.38835 | 2090014.0443400003 | 37.719018250172 | -122.42751062553499 | (37.719018250172, -122.427510625535) | |||
| 12573 | 12573 | 17588 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003687.80932 | 2090380.0219599998 | 37.7199944786431 | -122.429287755146 | (37.7199944786431, -122.429287755146) | |||
| 12598 | 12598 | 17596 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 822 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3X3 | 6003747.6295300005 | 2090297.4937 | 37.719771260609996 | -122.429075096066 | (37.71977126061, -122.429075096066) | |||
| 12681 | 12681 | 17608 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1000X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1999 12:00:00 AM | 40 | 6x9 | 6004130.9636 | 2090056.2016 | 37.7191304172171 | -122.427732862395 | (37.7191304172171, -122.427732862395) | ||
| 12693 | 12693 | 17579 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003783.82433 | 2090321.42028 | 37.7198390065544 | -122.428951688396 | (37.7198390065544, -122.428951688396) | |||
| 12701 | 12701 | 17544 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 537 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003083.60804 | 2090766.94886 | 37.7210226699524 | -122.431403876997 | (37.7210226699524, -122.431403876997) | |||
| 12769 | 12769 | 17578 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003799.63122 | 2090323.6743700001 | 37.7198460905006 | -122.428897210135 | (37.7198460905006, -122.428897210135) | |||
| 12852 | 12852 | 17587 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 35 | 3X3 | 6003703.481380001 | 2090378.19842 | 37.7199903588363 | -122.42923345225901 | (37.7199903588363, -122.429233452259) | |||
| 12929 | 12929 | 17531 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 444 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002851.30461 | 2090860.81338 | 37.72126723246829 | -122.43221358070299 | (37.7212672324683, -122.432213580703) | |||
| 12993 | 12993 | 19985 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100 STAIRWAY46 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | ||||||||
| 13029 | 13029 | 17562 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 645 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003332.52001 | 2090606.8773 | 37.72059725284729 | -122.43053204633001 | (37.7205972528473, -122.43053204633) | |||
| 13058 | 13058 | 17513 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002376.23219 | 2091204.63173 | 37.7221843332317 | -122.433880332025 | (37.7221843332317, -122.433880332025) | |||
| 13153 | 13153 | 17626 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004454.014359999 | 2089904.4684 | 37.718732059816205 | -122.42660540034099 | (37.7187320598162, -122.426605400341) | |||
| 13173 | 13173 | 17514 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002400.99383 | 2091189.1997099998 | 37.7221433654964 | -122.433793634664 | (37.7221433654964, -122.433793634664) | |||
| 13231 | 13231 | 17623 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6004371.84322 | 2089954.8563599999 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | |||
| 13417 | 13417 | 85790 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | ||
| 13491 | 13491 | 85780 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009172.9261 | 2109780.9319 | 37.7735740897245 | -122.41169762032699 | (37.7735740897245, -122.411697620327) | ||
| 13679 | 13679 | 100568 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 868 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6011788.1802 | 2112369.4793 | 37.780828003664 | -122.40283310111 | (37.780828003664, -122.40283310111) | |||
| 13722 | 13722 | 91035 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.40663324749599 | (37.7775764693736, -122.406633247496) | ||
| 13882 | 13882 | 85775 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1501 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008458.3046 | 2109095.9531 | 37.771653185278396 | -122.41412114139999 | (37.7716531852784, -122.4141211414) | ||
| 13974 | 13974 | 97229 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 15x200 | 6016636.9425099995 | 2094930.8404400002 | 37.7332147213866 | -122.38484348356701 | (37.7332147213866, -122.384843483567) | |||
| 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) | |||
| 14176 | 14176 | 49606 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | |
| 14203 | 14203 | 85766 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/2012 12:00:00 AM | 3 | 3x3 | 6008764.4124 | 2109484.6384 | 37.772737612649706 | -122.41308978059901 | (37.7727376126497, -122.413089780599) | ||
| 14251 | 14251 | 85786 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | ||
| 14305 | 14305 | 85794 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | ||
| 14375 | 14375 | 85777 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1355 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008992.8894 | 2109607.7576 | 37.773088492602795 | -122.412308154132 | (37.7730884926028, -122.412308154132) | ||
| 14561 | 14561 | 7568 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2941 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6008397.77442 | 2101269.6431 | 37.7501605343002 | -122.413776835747 | (37.7501605343002, -122.413776835747) | |||
| 14696 | 14696 | 85756 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 956 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011236.2364 | 2111841.2613 | 37.779346806168704 | -122.404705356954 | (37.7793468061687, -122.404705356954) | ||
| 14758 | 14758 | 85855 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008286.9019 | 2109012.2565 | 37.771413745293 | -122.41470811142099 | (37.771413745293, -122.414708111421) | ||
| 14760 | 14760 | 91037 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.40649877417499 | (37.7776845332645, -122.406498774175) | ||
| 14902 | 14902 | 85761 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1228 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009463.2457 | 2110145.8929 | 37.7745924689532 | -122.41071913644501 | (37.7745924689532, -122.410719136445) | ||
| 15023 | 15023 | 97221 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 15x200 | 6016689.53805 | 2094986.8063299998 | 37.733371301443 | -122.38466554190701 | (37.733371301443, -122.384665541907) | |||
| 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) | ||
| 15095 | 15095 | 85799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 951 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011299.4671 | 2111813.5286 | 37.779274192475796 | -122.404484661651 | (37.7792741924758, -122.404484661651) | ||
| 15191 | 15191 | 28961 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 207 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/02/2011 12:00:00 AM | 3 | 3x3 | 6008851.69192 | 2110257.83982 | 37.77486554133821 | -122.412842545373 | (37.7748655413382, -122.412842545373) | ||
| 15203 | 15203 | 91033 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010628.8889 | 2111172.6244 | 37.777476921213605 | -122.40675930128401 | (37.7774769212136, -122.406759301284) | ||
| 15259 | 15259 | 85857 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008243.2994 | 2108951.1128 | 37.771243409160206 | -122.414854606958 | (37.7712434091602, -122.414854606958) | ||
| 15284 | 15284 | 91036 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | ||
| 15402 | 15402 | 85743 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 850 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011909.0687 | 2112486.2465 | 37.7811553685168 | -122.402423099291 | (37.7811553685168, -122.402423099291) | ||
| 15416 | 15416 | 85854 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 858 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6011861.9039 | 2112442.745 | 37.7810332904479 | -122.40258320702299 | (37.7810332904479, -122.402583207023) | ||
| 15524 | 15524 | 85858 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1608 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 8 | 3x3 | 6008131.7874 | 2108761.9182 | 37.770717658851396 | -122.41522693781499 | (37.7707176588514, -122.415226937815) | ||
| 15530 | 15530 | 85744 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 868 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011811.5337 | 2112389.6274 | 37.780884629613 | -122.402753726875 | (37.780884629613, -122.402753726875) | ||
| 15618 | 15618 | 49607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1245 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009479.3313 | 2110073.508 | 37.7743946188288 | -122.41065838012199 | (37.7743946188288, -122.410658380122) | |
| 15742 | 15742 | 85781 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1285 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2012 12:00:00 AM | 3 | 3x3 | 6009302.3903 | 2109906.9077 | 37.773927251443205 | -122.411258683374 | (37.7739272514432, -122.411258683374) | ||
| 15785 | 15785 | 85778 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009142.6509 | 2109745.8127 | 37.7734759622446 | -122.41179986511601 | (37.7734759622446, -122.411799865116) | ||
| 15899 | 15899 | 22327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.39177919347401 | (37.7313174804906, -122.391779193474) | |||
| 15940 | 15940 | 97233 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300X Newcomb Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 15x200 | 6016357.8982 | 2094854.1147 | 37.7329886101989 | -122.385802878589 | (37.7329886101989, -122.385802878589) | |||
| 15989 | 15989 | 7405 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1065 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/1998 12:00:00 AM | 6 | 3X3 | 6010535.4473 | 2111084.5056 | 37.7772297388865 | -122.407076335552 | (37.7772297388865, -122.407076335552) | ||
| 16092 | 16092 | 85760 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1196 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009690.0521 | 2110363.0901 | 37.7752015556324 | -122.40994990092399 | (37.7752015556324, -122.409949900924) | ||
| 16136 | 16136 | 85809 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 875 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 4 | 3x3 | 6011790.9277 | 2112282.0183 | 37.78058800949079 | -122.402817443224 | (37.7805880094908, -122.402817443224) | ||
| 16163 | 16163 | 26637 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X3 | |||||||
| 16241 | 16241 | 91032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010616.6864 | 2111159.8673 | 37.777441210433395 | -122.40680061468099 | (37.7774412104334, -122.406800614681) | ||
| 16302 | 16302 | 85797 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 969 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011197.4105 | 2111716.4639 | 37.779001971452395 | -122.40483088408399 | (37.7790019714524, -122.404830884084) | ||
| 16370 | 16370 | 85856 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1530 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008268.3583 | 2108979.6799 | 37.7713232557148 | -122.414769948978 | (37.7713232557148, -122.414769948978) | ||
| 16507 | 16507 | 85757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 960 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011195.1919 | 2111802.9901 | 37.7792394282463 | -122.404844652616 | (37.7792394282463, -122.404844652616) | ||
| 16587 | 16587 | 103753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1615 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008187.9193 | 2108722.8263 | 37.7706134761345 | -122.415030008645 | (37.7706134761345, -122.415030008645) | ||
| 16597 | 16597 | 97225 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1301X Newcomb Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.9135099999 | 37.7332595687675 | -122.38479997523599 | (37.7332595687675, -122.384799975236) | ||
| 16758 | 16758 | 85768 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1400X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008662.6876 | 2109384.932 | 37.772458131185104 | -122.41343460643999 | (37.7724581311851, -122.41343460644) | ||
| 16759 | 16759 | 26628 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | ||
| 16950 | 16950 | 25174 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.761125030928895 | -122.44266313540199 | (37.7611250309289, -122.442663135402) | |||
| 17012 | 17012 | 7531 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2829 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008362.05512 | 2101958.45001 | 37.752049837241 | -122.41394907658702 | (37.752049837241, -122.413949076587) | |||
| 17173 | 17173 | 7598 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3106 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6008393.64019 | 2100437.22493 | 37.7478746680801 | -122.41373225995702 | (37.7478746680801, -122.413732259957) | |||
| 17189 | 17189 | 7579 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2995 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4x4 | 6008416.03486 | 2101001.24422 | 37.7494245965646 | -122.41369470787 | (37.7494245965646, -122.41369470787) | |||
| 17190 | 17190 | 7561 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2921 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 4X4 | 6008393.481319999 | 2101389.9459599997 | 37.750490617869296 | -122.41380019023899 | (37.7504906178693, -122.413800190239) | |||
| 17202 | 17202 | 7497 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008270.16145 | 2102659.31707 | 37.753969098407005 | -122.41431644427401 | (37.753969098407, -122.414316444274) | |||
| 17228 | 17228 | 23635 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | |||
| 17323 | 17323 | 7553 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2896 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6008325.6957 | 2101595.54831 | 37.751051348745996 | -122.41404914235001 | (37.751051348746, -122.41404914235) | |||
| 17325 | 17325 | 7646 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3301 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 21 | 3x3 | 6008513.44624 | 2099397.67081 | 37.745027010685 | -122.413244473962 | (37.745027010685, -122.413244473962) | |||
| 17333 | 17333 | 7543 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6008316.06064 | 2101754.32335 | 37.7514867681181 | -122.41409369299299 | (37.7514867681181, -122.414093692993) | |||
| 17390 | 17390 | 25188 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3741 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000279.55164 | 2102883.22055 | 37.7541317821777 | -122.44196585866501 | (37.7541317821777, -122.441965858665) | |||
| 17404 | 17404 | 7550 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2888 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6008324.12517 | 2101635.93861 | 37.75116216321621 | -122.414057430518 | (37.7511621632162, -122.414057430518) | |||
| 17424 | 17424 | 7562 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2924 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2013 12:00:00 AM | 3 | 5x5 | 6008336.41396 | 2101367.26054 | 37.7504251238168 | -122.41399592947201 | (37.7504251238168, -122.413995929472) | ||
| 17450 | 17450 | 7664 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3348 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008462.72403 | 2099121.09112 | 37.7442647363292 | -122.413400306703 | (37.7442647363292, -122.413400306703) | |||
| 17454 | 17454 | 7657 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3334 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6008459.10706 | 2099217.21001 | 37.7445284544392 | -122.41341960975099 | (37.7445284544392, -122.413419609751) | |||
| 17555 | 17555 | 7607 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3167 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6008461.5790099995 | 2100237.0852799998 | 37.7473289441915 | -122.413483177404 | (37.7473289441915, -122.413483177404) | |||
| 17556 | 17556 | 7440 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2528 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6008209.2972 | 2103689.6592099997 | 37.7567947646774 | -122.414599835016 | (37.7567947646774, -122.414599835016) | |||
| 17654 | 17654 | 7660 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3340 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/23/2015 01:35:00 PM | 3 | 4x4 | 6008461.083190001 | 2099185.41304 | 37.744441257954705 | -122.41341052839701 | (37.7444412579547, -122.413410528397) | ||
| 17682 | 17682 | 23641 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 131 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/1997 12:00:00 AM | 10 | 3X3 | 6006567.62834 | 2098529.44793 | 37.742533631335604 | -122.419911178867 | (37.7425336313356, -122.419911178867) |
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");