trees
1,196 rows where SiteOrder = 1 and qSpecies_id = 31 sorted by qCaretaker_id
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
| 265 | 18017 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2713 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000875.2767 | 2114835.3915 | 37.7869833841555 | -122.440762994582 | (37.7869833841555, -122.440762994582) | 13 | 6 | 1 | 29490 | 27 | |||
| 1683 | 85790 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1125 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010146.2096 | 2110708.8868 | 37.776176587646 | -122.408396338404 | (37.776176587646, -122.408396338404) | 8 | 2 | 9 | 28853 | 34 | ||
| 2333 | 246547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 4ft | 6005744.74711 | 2109415.26549 | 37.7723771523117 | -122.423530217156 | (37.7723771523117, -122.423530217156) | 7 | 9 | 11 | 28852 | 10 | |||
| 2405 | 7621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3227 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 6x9 | 6008480.64653 | 2099830.22389 | 37.7462128639419 | -122.413388474314 | (37.7462128639419, -122.413388474314) | 2 | 7 | 7 | 28859 | 2 | |||
| 3271 | 260494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014820 | 2116826 | 37.7932334067411 | -122.392656317548 | (37.7932334067411, -122.392656317548) | 12 | 2 | 9 | 28855 | 6 | ||||
| 3814 | 23654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 228 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X6 | 6006768.61882 | 2098382.75486 | 37.742142166343 | -122.419205808214 | (37.742142166343, -122.419205808214) | 2 | 7 | 7 | 28859 | 2 | |||
| 4213 | 251107 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
| 4570 | 119828 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
| 4856 | 17502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 125 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002131.24887 | 2091360.19572 | 37.7225975717171 | -122.434738297838 | (37.7225975717171, -122.434738297838) | 9 | 7 | 6 | 28861 | 5 | |||
| 5574 | 259351 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 443 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010386.58434 | 2092559.48475 | 37.7263557946777 | -122.406285753959 | (37.7263557946777, -122.406285753959) | 10 | 3 | 7 | 309 | 28 | ||
| 6065 | 14837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1306 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002857.7118 | 2111688.5769 | 37.7784557229826 | -122.433679236224 | (37.7784557229826, -122.433679236224) | 15 | 5 | 11 | 29490 | 41 | ||
| 8918 | 119708 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 9914 | 259754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4041 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x9 | 6003639.19109 | 2100382.47433 | 37.7474561955544 | -122.430169014304 | (37.7474561955544, -122.430169014304) | 2 | 4 | 5 | 63 | 22 | ||||
| 10127 | 119793 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
| 11980 | 7531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2829 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008362.05512 | 2101958.45001 | 37.752049837241 | -122.413949076587 | (37.752049837241, -122.413949076587) | 2 | 4 | 7 | 28859 | 19 | |||
| 12068 | 26637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1998 12:00:00 AM | 6 | 3X3 | ||||||||||||
| 15738 | 119781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 17212 | 17525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 342 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6002628.09189 | 2091001.66682 | 37.7216413261572 | -122.432995221074 | (37.7216413261572, -122.432995221074) | 9 | 7 | 6 | 28861 | 5 | |||
| 17973 | 17607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 948X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003925.7500102 | 2090181.5613293 | 37.7194630169915 | -122.428451137586 | (37.7194630169915, -122.428451137586) | 9 | 7 | 6 | 28861 | 5 | |||
| 18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 18715 | 17618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
| 19592 | 23636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 112 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6006546.53068 | 2098501.49483 | 37.7424556897773 | -122.419982145278 | (37.7424556897773, -122.419982145278) | 2 | 7 | 7 | 28859 | 2 | |||
| 20556 | 18546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | 10 | 3 | 8 | 58 | 1 | |||
| 20748 | 18055 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.7868182138227 | -122.443122531996 | (37.7868182138227, -122.443122531996) | 13 | 6 | 1 | 29490 | 27 | |||
| 23746 | 7561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2921 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6008393.48132 | 2101389.94596 | 37.7504906178693 | -122.413800190239 | (37.7504906178693, -122.413800190239) | 2 | 4 | 7 | 28859 | 19 | |||
| 24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
| 25001 | 242526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1922 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008013.77103 | 2107241.1183 | 37.7665352651235 | -122.415527471335 | (37.7665352651235, -122.415527471335) | 8 | 4 | 7 | 28853 | 19 | ||
| 25513 | 17523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002491.854148 | 2091141.7505443 | 37.7220182361725 | -122.433476163825 | (37.7220182361725, -122.433476163825) | 9 | 7 | 6 | 28861 | 5 | |||
| 25646 | 7497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008270.16145 | 2102659.31707 | 37.753969098407 | -122.414316444274 | (37.753969098407, -122.414316444274) | 2 | 4 | 7 | 28859 | 19 | |||
| 25820 | 25189 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3733 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000311.6199976 | 2102932.6354717 | 37.7542692908961 | -122.441858505139 | (37.7542692908961, -122.441858505139) | 2 | 4 | 5 | 63 | 38 | |||
| 26629 | 7553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6008325.6957 | 2101595.54831 | 37.751051348746 | -122.41404914235 | (37.751051348746, -122.41404914235) | 2 | 4 | 7 | 28859 | 19 | |||
| 26729 | 7657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3334 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008459.10706 | 2099217.21001 | 37.7445284544392 | -122.413419609751 | (37.7445284544392, -122.413419609751) | 2 | 7 | 7 | 28859 | 2 | |||
| 26832 | 7543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2872 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008316.06064 | 2101754.32335 | 37.7514867681181 | -122.414093692993 | (37.7514867681181, -122.414093692993) | 2 | 4 | 7 | 28859 | 19 | |||
| 26996 | 242532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2140 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 3ft | 6008084.96302 | 2105937.52751 | 37.7629599086871 | -122.41518894402 | (37.7629599086871, -122.41518894402) | 8 | 4 | 7 | 28859 | 19 | ||
| 27279 | 7440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2528 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008209.2972 | 2103689.65921 | 37.7567947646774 | -122.414599835016 | (37.7567947646774, -122.414599835016) | 2 | 4 | 7 | 28859 | 19 | |||
| 27895 | 23744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1111X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003857.72301 | 2111778.219 | 37.7787585493448 | -122.430226218205 | (37.7787585493448, -122.430226218205) | 15 | 9 | 11 | 29492 | 41 | |||
| 27901 | 7664 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3348 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008462.72403 | 2099121.09112 | 37.7442647363292 | -122.413400306703 | (37.7442647363292, -122.413400306703) | 2 | 7 | 7 | 28859 | 2 | |||
| 28436 | 17602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | 9 | 7 | 6 | 28861 | 5 | |||
| 28588 | 17551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003191.74591 | 2090695.76954 | 37.7208333554501 | -122.431024998907 | (37.7208333554501, -122.431024998907) | 9 | 7 | 6 | 28861 | 5 | |||
| 29302 | 7646 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6008513.44624 | 2099397.67081 | 37.745027010685 | -122.413244473962 | (37.745027010685, -122.413244473962) | 2 | 7 | 7 | 28859 | 2 | |||
| 29404 | 23635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | 2 | 7 | 7 | 28859 | 2 | |||
| 29511 | 244254 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005646.3317 | 2110018.1063 | 37.7740268522621 | -122.423913520847 | (37.7740268522621, -122.423913520847) | 7 | 9 | 11 | 28852 | 10 | |||
| 30219 | 7647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3302 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6008452.78429 | 2099390.30637 | 37.7450033836799 | -122.413453712108 | (37.7450033836799, -122.413453712108) | 2 | 7 | 7 | 28859 | 2 | |||
| 33260 | 7579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2995 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4x4 | 6008416.03486 | 2101001.24422 | 37.7494245965646 | -122.41369470787 | (37.7494245965646, -122.41369470787) | 2 | 4 | 7 | 28859 | 19 | |||
| 34502 | 2598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1738 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005142.52853 | 2115146.44686 | 37.7880795569985 | -122.426021407949 | (37.7880795569985, -122.426021407949) | 13 | 9 | 11 | 28858 | 27 | |||
| 35000 | 244311 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005501.4183 | 2110598.8748 | 37.7756133196055 | -122.424456119453 | (37.7756133196055, -122.424456119453) | 7 | 9 | 11 | 28852 | 10 | |||
| 35263 | 17532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002799.2909021 | 2090948.5412155 | 37.7215051643266 | -122.432399639747 | (37.7215051643266, -122.432399639747) | 9 | 7 | 6 | 28861 | 5 | |||
| 35431 | 7550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2888 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008324.12517 | 2101635.93861 | 37.7511621632162 | -122.414057430518 | (37.7511621632162, -122.414057430518) | 2 | 4 | 7 | 28859 | 19 | |||
| 36034 | 18002 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2676 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001135.87676 | 2114918.88378 | 37.7872274699544 | -122.439867367887 | (37.7872274699544, -122.439867367887) | 13 | 6 | 1 | 29490 | 27 | |||
| 36270 | 7607 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3167 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008461.57901 | 2100237.08528 | 37.7473289441915 | -122.413483177404 | (37.7473289441915, -122.413483177404) | 2 | 7 | 7 | 28859 | 2 | |||
| 36724 | 7562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2924 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 5x5 | 6008336.41396 | 2101367.26054 | 37.7504251238168 | -122.413995929472 | (37.7504251238168, -122.413995929472) | 2 | 4 | 7 | 28859 | 19 | ||
| 36983 | 25188 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3741 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6000279.55164 | 2102883.22055 | 37.7541317821777 | -122.441965858665 | (37.7541317821777, -122.441965858665) | 2 | 4 | 5 | 63 | 38 | |||
| 37182 | 109162 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 1 | Median : Cutout | Tree | DPW 1 | 6 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | |||
| 37973 | 18057 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2882 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3X3 | 6000155.2064 | 2114785.6979 | 37.7868059046739 | -122.443250696948 | (37.7868059046739, -122.443250696948) | 13 | 6 | 1 | 29490 | 27 | |||
| 38457 | 85775 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1501 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008458.3046 | 2109095.9531 | 37.7716531852784 | -122.4141211414 | (37.7716531852784, -122.4141211414) | 8 | 2 | 9 | 28853 | 19 | ||
| 38890 | 17931 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2416 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002234.6053 | 2115077.8001 | 37.7877262951282 | -122.436077384684 | (37.7877262951282, -122.436077384684) | 13 | 6 | 1 | 29490 | 27 | |||
| 40235 | 17524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 311 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002598.14463 | 2091067.38518 | 37.7218200754046 | -122.433103433796 | (37.7218200754046, -122.433103433796) | 9 | 7 | 6 | 28861 | 5 | |||
| 40840 | 17595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 818 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6003715.34966 | 2090318.22231 | 37.7198263494989 | -122.429188153404 | (37.7198263494989, -122.429188153404) | 9 | 7 | 6 | 28861 | 5 | |||
| 41142 | 49606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1245 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2003 12:00:00 AM | 3 | 3x3 | Permit Number 46474 | 6009457.5009 | 2110055.1245 | 37.7743429180698 | -122.410732597335 | (37.7743429180698, -122.410732597335) | 8 | 2 | 9 | 28853 | 34 | |
| 41669 | 17530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 418 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002769.64699 | 2090910.44177 | 37.72139887074 | -122.432499390644 | (37.72139887074, -122.432499390644) | 9 | 7 | 6 | 28861 | 5 | |||
| 43307 | 7660 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3340 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/2015 01:35:00 PM | 3 | 4x4 | 6008461.08319 | 2099185.41304 | 37.7444412579547 | -122.413410528397 | (37.7444412579547, -122.413410528397) | 2 | 7 | 7 | 28859 | 2 | ||
| 45091 | 25175 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3066 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 9x9 | Permit Number 772559 | 6000144.4461106 | 2105441.7794376 | 37.7611492576992 | -122.442616778303 | (37.7611492576992, -122.442616778303) | 15 | 5 | 5 | 28862 | 3 | ||
| 46405 | 7637 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 4X4 | 6008436.96279 | 2099620.40725 | 37.7456343012777 | -122.413524691037 | (37.7456343012777, -122.413524691037) | 2 | 7 | 7 | 28859 | 2 | |||
| 47077 | 17528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002717.3851 | 2090942.27549 | 37.7214833152726 | -122.432682318148 | (37.7214833152726, -122.432682318148) | 9 | 7 | 6 | 28861 | 5 | |||
| 47292 | 18702 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3401 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x8 | 6008528.43414 | 2099029.73603 | 37.7440175846489 | -122.413166635838 | (37.7440175846489, -122.413166635838) | 2 | 7 | 7 | 28859 | 2 | |||
| 47938 | 85786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1211 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009596.5259 | 2110188.4047 | 37.7747166682516 | -122.410261094209 | (37.7747166682516, -122.410261094209) | 8 | 2 | 9 | 28853 | 34 | ||
| 50052 | 18015 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2712 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000819.3499 | 2114877.5272 | 37.7870958927498 | -122.440959512089 | (37.7870958927498, -122.440959512089) | 13 | 6 | 1 | 29490 | 27 | |||
| 50232 | 7528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2815 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008357.33424 | 2102016.55073 | 37.7522091035878 | -122.413969511892 | (37.7522091035878, -122.413969511892) | 2 | 4 | 7 | 28859 | 19 | |||
| 52055 | 85766 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/2012 12:00:00 AM | 3 | 3x3 | 6008764.4124 | 2109484.6384 | 37.7727376126497 | -122.413089780599 | (37.7727376126497, -122.413089780599) | 8 | 2 | 9 | 28853 | 34 | ||
| 52244 | 14861 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1372 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002599.36465 | 2111713.08201 | 37.7785083454918 | -122.434574707994 | (37.7785083454918, -122.434574707994) | 15 | 5 | 11 | 29490 | 41 | ||
| 53176 | 14843 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1320 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002817.8815 | 2111683.4502 | 37.7784393862348 | -122.433816657579 | (37.7784393862348, -122.433816657579) | 15 | 5 | 11 | 29490 | 41 | ||
| 53646 | 7509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2737 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008336.68586 | 2102472.1775 | 37.7534589921577 | -122.414073147974 | (37.7534589921577, -122.414073147974) | 2 | 4 | 7 | 28859 | 19 | |||
| 55547 | 7559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2915 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6008391.20659 | 2101423.19839 | 37.750581793832 | -122.413810408316 | (37.750581793832, -122.413810408316) | 2 | 4 | 7 | 28859 | 19 | |||
| 56457 | 23641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 10 | 3X3 | 6006567.62834 | 2098529.44793 | 37.7425336313356 | -122.419911178867 | (37.7425336313356, -122.419911178867) | 2 | 7 | 7 | 28859 | 2 | ||
| 57212 | 7663 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3343 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008519.81594 | 2099195.42015 | 37.744472032765 | -122.413208149458 | (37.744472032765, -122.413208149458) | 2 | 7 | 7 | 28859 | 2 | |||
| 58374 | 18022 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2726 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/06/1994 12:00:00 AM | 18 | 3X3 | 6000886.2670207 | 2114885.2948521 | 37.7871210317525 | -122.44072855159 | (37.7871210317525, -122.44072855159) | 13 | 6 | 1 | 29490 | 27 | ||
| 61681 | 7659 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3339 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008524.12376 | 2099222.60541 | 37.7445469193178 | -122.413195175821 | (37.7445469193178, -122.413195175821) | 2 | 7 | 7 | 28859 | 2 | |||
| 61874 | 17917 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2370 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002602.4145 | 2115123.2744 | 37.7878720449725 | -122.43480808996 | (37.7878720449725, -122.43480808996) | 13 | 9 | 1 | 29490 | 27 | |||
| 61943 | 94631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3359X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008508.32058 | 2099227.63825 | 37.7445598511663 | -122.413250176052 | (37.7445598511663, -122.413250176052) | 2 | 7 | 7 | 28859 | 2 | |||
| 62430 | 16676 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 241 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6002923.72472 | 2106883.15367 | 37.7652649601376 | -122.433107441172 | (37.7652649601376, -122.433107441172) | 15 | 5 | 5 | 28862 | 3 | |||
| 62456 | 7443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2534 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008210.94059 | 2103665.03858 | 37.7567272543663 | -122.414592409333 | (37.7567272543663, -122.414592409333) | 2 | 4 | 7 | 28859 | 19 | |||
| 62831 | 25173 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3062 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6000161.42067 | 2105438.61683 | 37.7611415415605 | -122.44255784368 | (37.7611415415605, -122.44255784368) | 15 | 5 | 5 | 28862 | 3 | |||
| 64330 | 85794 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1001 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010934.7813 | 2111463.5411 | 37.778292821216 | -122.405721608986 | (37.778292821216, -122.405721608986) | 14 | 2 | 9 | 28853 | 34 | ||
| 64445 | 17617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1042 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6004228.49613 | 2089992.79688 | 37.7189618383998 | -122.427391215355 | (37.7189618383998, -122.427391215355) | 9 | 7 | 6 | 28861 | 5 | |||
| 65181 | 26273 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 230 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1997 12:00:00 AM | 9 | 3X3 | 6006790.88974 | 2098369.36034 | 37.742106642199 | -122.419127852295 | (37.742106642199, -122.419127852295) | 2 | 7 | 7 | 28859 | 2 | ||
| 66323 | 17517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6002447.6310917 | 2091110.4885814 | 37.7219298886661 | -122.433626798632 | (37.7219298886661, -122.433626798632) | 9 | 7 | 6 | 28861 | 5 | |||
| 66328 | 14852 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1352 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002495.37076 | 2111698.57744 | 37.7784626155286 | -122.434933424277 | (37.7784626155286, -122.434933424277) | 15 | 5 | 11 | 29490 | 41 | ||
| 66876 | 85884 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2994 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2015 12:00:00 AM | 3 | 3x3 | 6008392 | 2100977 | 37.7493566776481 | -122.41377610663 | (37.7493566776481, -122.41377610663) | 2 | 4 | 7 | 28859 | 19 | ||
| 72750 | 7427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2507 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008260.80742 | 2103776.26176 | 37.7570354493563 | -122.414427820801 | (37.7570354493563, -122.414427820801) | 2 | 4 | 7 | 28859 | 19 | |||
| 73466 | 85777 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1355 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008992.8894 | 2109607.7576 | 37.7730884926028 | -122.412308154132 | (37.7730884926028, -122.412308154132) | 8 | 2 | 9 | 28853 | 34 | ||
| 73784 | 17543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 531 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002997.1960546 | 2090824.1673225 | 37.7211748813523 | -122.431706660652 | (37.7211748813523, -122.431706660652) | 9 | 7 | 6 | 28861 | 5 | |||
| 75183 | 7568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2941 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008397.77442 | 2101269.6431 | 37.7501605343002 | -122.413776835747 | (37.7501605343002, -122.413776835747) | 2 | 4 | 7 | 28859 | 19 | |||
| 76143 | 138805 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6002622.3069 | 2115079.2676 | 37.787752342886 | -122.434736117903 | (37.787752342886, -122.434736117903) | 13 | 9 | 11 | 29490 | 27 | |||
| 77425 | 85855 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1530 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 3 | 3x3 | 6008286.9019 | 2109012.2565 | 37.771413745293 | -122.414708111421 | (37.771413745293, -122.414708111421) | 8 | 2 | 9 | 28853 | 19 | ||
| 77462 | 7652 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3316 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008450.59192 | 2099314.52137 | 37.7447951717692 | -122.413455934253 | (37.7447951717692, -122.413455934253) | 2 | 7 | 7 | 28859 | 2 | |||
| 77742 | 7573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2969X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008400.46895 | 2101159.93411 | 37.7498594493293 | -122.413759758659 | (37.7498594493293, -122.413759758659) | 2 | 4 | 7 | 28859 | 19 | |||
| 78776 | 2242 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2799X PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000783 | 2114845 | 37.7870045110932 | -122.441082939895 | (37.7870045110932, -122.441082939895) | 13 | 6 | 1 | 29490 | 27 | |||
| 81012 | 18524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 6x9 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
| 82338 | 7451 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2550 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4 | 3X3 | 6008217.64578 | 2103538.04814 | 37.756378944247 | -122.414560234263 | (37.756378944247, -122.414560234263) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );