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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 207 | 207 | 138805 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | |||
| 555 | 555 | 242524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1902 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008008.060219999 | 2107332.79337 | 37.7667866624906 | -122.415553715331 | (37.7667866624906, -122.415553715331) | ||
| 625 | 625 | 242532 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2140 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 3ft | 6008084.96302 | 2105937.52751 | 37.7629599086871 | -122.41518894402 | (37.7629599086871, -122.41518894402) | ||
| 1003 | 1003 | 14837 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1306 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002857.7118 | 2111688.5769 | 37.7784557229826 | -122.43367923622401 | (37.7784557229826, -122.433679236224) | ||
| 1207 | 1207 | 119793 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
| 1212 | 1212 | 119828 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1227 | 1227 | 119736 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 1241 | 1241 | 242526 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1922 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008013.77103 | 2107241.1183 | 37.7665352651235 | -122.415527471335 | (37.7665352651235, -122.415527471335) | ||
| 1266 | 1266 | 242525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1916 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008012.49588 | 2107266.03409 | 37.7666036064 | -122.415533646066 | (37.7666036064, -122.415533646066) | ||
| 1270 | 1270 | 18055 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.786818213822706 | -122.443122531996 | (37.7868182138227, -122.443122531996) | |||
| 2076 | 2076 | 14859 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1368 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002639.2367 | 2111656.2394 | 37.7783545332764 | -122.434432710417 | (37.7783545332764, -122.434432710417) | ||
| 2806 | 2806 | 18057 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6000155.2064 | 2114785.6979 | 37.7868059046739 | -122.443250696948 | (37.7868059046739, -122.443250696948) | |||
| 4036 | 4036 | 242541 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2430 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/22/2007 12:00:00 AM | 5 | Width 4ft | 6008178.84704 | 2104258.05912 | 37.758353750252105 | -122.41474536781901 | (37.7583537502521, -122.414745367819) | ||
| 4237 | 4237 | 14843 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1320 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002817.8815 | 2111683.4502 | 37.7784393862348 | -122.433816657579 | (37.7784393862348, -122.433816657579) | ||
| 4598 | 4598 | 18015 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2712 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000819.3499 | 2114877.5272 | 37.7870958927498 | -122.44095951208901 | (37.7870958927498, -122.440959512089) | |||
| 4811 | 4811 | 17931 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2416 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x6 | 6002234.6053 | 2115077.8001 | 37.7877262951282 | -122.43607738468398 | (37.7877262951282, -122.436077384684) | |||
| 5698 | 5698 | 17917 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2370 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002602.4145 | 2115123.2744 | 37.7878720449725 | -122.43480808996 | (37.7878720449725, -122.43480808996) | |||
| 6048 | 6048 | 14856 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1360 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002668.0249 | 2111660.9717 | 37.7783691610679 | -122.434333459849 | (37.7783691610679, -122.434333459849) | ||
| 6216 | 6216 | 18017 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2713 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000875.2767 | 2114835.3915 | 37.786983384155505 | -122.440762994582 | (37.7869833841555, -122.440762994582) | |||
| 6867 | 6867 | 18000 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2670 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6001175.0601 | 2114930.6744 | 37.7872620743104 | -122.43973264788299 | (37.7872620743104, -122.439732647883) | |||
| 8034 | 8034 | 17992 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2619 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/14/2012 12:00:00 AM | 3 | 3X3 | 6001295.2434 | 2114888.6615 | 37.787153557687795 | -122.439313827621 | (37.7871535576878, -122.439313827621) | ||
| 8226 | 8226 | 18032 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2801 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000470.3136 | 2114777.4747 | 37.7868012889701 | -122.44215991241501 | (37.7868012889701, -122.442159912415) | |||
| 8354 | 8354 | 14848 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1341 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002736.8406 | 2111618.9725 | 37.778257747549894 | -122.434092397831 | (37.7782577475499, -122.434092397831) | ||
| 8552 | 8552 | 14851 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1350 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002705.0947 | 2111666.0984 | 37.778385341741206 | -122.434205588327 | (37.7783853417412, -122.434205588327) | ||
| 8639 | 8639 | 18001 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2673 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001165.7528 | 2114873.8019 | 37.7871053873216 | -122.439760770078 | (37.7871053873216, -122.439760770078) | |||
| 9754 | 9754 | 25175 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.44261677830299 | (37.7611492576992, -122.442616778303) | ||
| 9789 | 9789 | 91811 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2685 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 02:45:00 PM | 3 | 3x3 | 6008942.770855 | 2102838.050886 | 37.754497621185 | -122.412003022866 | (37.754497621185, -122.412003022866) | ||
| 10349 | 10349 | 17525 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6002628.09189 | 2091001.6668200002 | 37.721641326157204 | -122.43299522107401 | (37.7216413261572, -122.432995221074) | |||
| 10351 | 10351 | 17502 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002131.248869999 | 2091360.1957200002 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | |||
| 10537 | 10537 | 17602 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | |||
| 10722 | 10722 | 17551 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6003191.74591 | 2090695.7695400002 | 37.720833355450104 | -122.43102499890699 | (37.7208333554501, -122.431024998907) | |||
| 10866 | 10866 | 17524 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | |||
| 10894 | 10894 | 17530 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6002769.64699 | 2090910.4417700002 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | |||
| 10940 | 10940 | 17528 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002717.3851 | 2090942.2754900001 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | |||
| 10968 | 10968 | 17595 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6003715.34966 | 2090318.2223099999 | 37.719826349498895 | -122.42918815340401 | (37.7198263494989, -122.429188153404) | |||
| 11164 | 11164 | 17617 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | |||
| 11281 | 11281 | 1166 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.1618700002 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | ||
| 11476 | 11476 | 17503 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 131 Persia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002145.061290001 | 2091350.8283900002 | 37.7225726352947 | -122.434689881929 | (37.7225726352947, -122.434689881929) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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 | |||||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) |
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");