Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 127 | 127 | 18052 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2840 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6000317.799 | 2114808.7133 | 37.7868783690408 | -122.442689819484 | (37.7868783690408, -122.442689819484) | |||
| 189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
| 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) | |||
| 219 | 219 | 138804 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 6002587.4194 | 2115073.5588 | 37.787734687268795 | -122.43485641346001 | (37.7877346872688, -122.43485641346) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 1243 | 1243 | 242621 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | Width 3ft | 6008442.97152 | 2099602.35151 | 37.745585061615294 | -122.413502636934 | (37.7455850616153, -122.413502636934) | |||
| 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) | ||
| 6069 | 6069 | 17933 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2418 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002186.7609 | 2115068.0006 | 37.7876966699691 | -122.43624221533301 | (37.7876966699691, -122.436242215333) | |||
| 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) | |||
| 10554 | 10554 | 17590 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003668.70994 | 2090393.5126599998 | 37.720030439842 | -122.429354736658 | (37.720030439842, -122.429354736658) | |||
| 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) | |||
| 10729 | 10729 | 17592 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003646.11767 | 2090408.41073 | 37.7200700675728 | -122.42943389227699 | (37.7200700675728, -122.429433892277) | |||
| 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) | |||
| 10917 | 10917 | 17498 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101 Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 2X2 | 6002093.54294 | 2091384.31052 | 37.72266164479 | -122.43487036238501 | (37.72266164479, -122.434870362385) | |||
| 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) | |||
| 10999 | 10999 | 17515 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 245X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002425.76888 | 2091174.41595 | 37.7221041784351 | -122.433706937351 | (37.7221041784351, -122.433706937351) | |||
| 11095 | 11095 | 17586 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6003709.25966 | 2090367.0753099998 | 37.7199601443381 | -122.42921268601499 | (37.7199601443381, -122.429212686015) | |||
| 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) | |||
| 11249 | 11249 | 17536 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003012.06568 | 2090814.03767 | 37.72114791043521 | -122.431654537837 | (37.7211479104352, -122.431654537837) | |||
| 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) | ||
| 11325 | 11325 | 17624 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1101 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6004341.89656 | 2089971.87372 | 37.7189108009657 | -122.426997744874 | (37.7189108009657, -122.426997744874) | |||
| 11358 | 11358 | 17550 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 600 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6003170.84982 | 2090661.1447 | 37.7207370992233 | -122.431094760237 | (37.7207370992233, -122.431094760237) | |||
| 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) | |||
| 11525 | 11525 | 17537 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 501X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/1999 12:00:00 AM | 3 | 3x3 | 6002961.1307 | 2090844.1069599998 | 37.72122758676971 | -122.431832751099 | (37.7212275867697, -122.431832751099) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 15108 | 15108 | 117609 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1227 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6009518.3962 | 2110117.1687 | 37.774516691037505 | -122.41052633045099 | (37.7745166910375, -122.410526330451) |
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");