trees
2,365 rows where qSpecies_id = 31 sorted by qLegalStatus_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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21448 | 215545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5993953.28384 | 2097231.84575 | 37.7382520031164 | -122.463433382759 | (37.7382520031164, -122.463433382759) | 1 | 8 | 4 | 59 | 40 | |||
21528 | 242621 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3274 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | Width 3ft | 6008442.97152 | 2099602.35151 | 37.7455850616153 | -122.413502636934 | (37.7455850616153, -122.413502636934) | 2 | 7 | 7 | 28859 | 2 | |||
21714 | 242719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 853 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004377.23368 | 2103892.56966 | 37.7571358712273 | -122.427866984578 | (37.7571358712273, -122.427866984578) | 2 | 4 | 5 | 28862 | 3 | |||
21755 | 13324 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 435X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6002777.3722738 | 2090962.3160144 | 37.7215417439498 | -122.432476389775 | (37.7215417439498, -122.432476389775) | 9 | 7 | 6 | 28861 | 5 | |||
22011 | 198661 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | 14 | 3 | 9 | 310 | 20 | |||
22037 | 242534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2360 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008152.44131 | 2104693.50741 | 37.7595479078416 | -122.414867509238 | (37.7595479078416, -122.414867509238) | 2 | 4 | 7 | 28859 | 19 | |||
22234 | 242677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3933 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003560.02812 | 2102420.4138 | 37.753047415608 | -122.430588150548 | (37.753047415608, -122.430588150548) | 2 | 4 | 5 | 28862 | 22 | |||
22343 | 242556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2405 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6008229.8333 | 2104396.39289 | 37.7587364477383 | -122.414578823255 | (37.7587364477383, -122.414578823255) | 2 | 4 | 7 | 28859 | 19 | |||
22413 | 242733 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 177 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000262.66947 | 2105618.74767 | 37.7616419072768 | -122.442220599714 | (37.7616419072768, -122.442220599714) | 15 | 5 | 5 | 28862 | 3 | |||
22837 | 215572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 745 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999421.36042 | 2095348.4772 | 37.7333942440298 | -122.44439222862 | (37.7333942440298, -122.44439222862) | 9 | 7 | 4 | 59 | 40 | |||
22856 | 180559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 192 Dublin St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 5ft | 6004156.47541 | 2089333.3612 | 37.7171470982496 | -122.427593206665 | (37.7171470982496, -122.427593206665) | 9 | 7 | 6 | 28861 | 5 | |||
22908 | 32995 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 4 | Permit Number 37299 | 6013130.33001 | 2113657.26593 | 37.7844388182424 | -122.398280299215 | (37.7844388182424, -122.398280299215) | 6 | 2 | 9 | 28853 | 6 | |
23251 | 119710 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
23263 | 137056 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 430 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012005.94187 | 2118434.64519 | 37.7974936729554 | -122.402506368172 | (37.7974936729554, -122.402506368172) | 3 | 1 | 10 | 308 | 23 | |||
23318 | 112503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 645 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993489.26776 | 2113460.89025 | 37.7827859823771 | -122.46621678157 | (37.7827859823771, -122.46621678157) | 11 | 6 | 2 | 54 | 11 | |||
23349 | 242769 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 922 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002452.60513 | 2102826.48579 | 37.7540995936313 | -122.43444686085 | (37.7540995936313, -122.43444686085) | 2 | 4 | 5 | 28862 | 22 | |||
23356 | 258198 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003441 | 2115348 | 37.7885366590719 | -122.431922793308 | (37.7885366590719, -122.431922793308) | 13 | 9 | 1 | 29490 | 27 | ||||
23450 | 91035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010666.0508 | 2111208.1223 | 37.7775764693736 | -122.406633247496 | (37.7775764693736, -122.406633247496) | 14 | 2 | 9 | 28853 | 34 | ||
23472 | 242575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2019 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008104.80442 | 2106706.37062 | 37.7650720888176 | -122.415174745544 | (37.7650720888176, -122.415174745544) | 8 | 4 | 7 | 28859 | 19 | |||
23559 | 17486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
23560 | 198505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 743 Rhode Island St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6011863.14571 | 2104907.21276 | 37.7603425002176 | -122.402048998175 | (37.7603425002176, -122.402048998175) | 10 | 3 | 8 | 28856 | 29 | |||
23639 | 7466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2601 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6008295.31777 | 2103224.31145 | 37.7555218579731 | -122.41426941961 | (37.7555218579731, -122.41426941961) | 2 | 4 | 7 | 28859 | 19 | |||
23716 | 242547 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2470 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008189.29085 | 2104062.22691 | 37.7578166265547 | -122.414695389796 | (37.7578166265547, -122.414695389796) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
23867 | 215521 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1750 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5993133.83624 | 2103556.81567 | 37.755571512239 | -122.466726245046 | (37.755571512239, -122.466726245046) | 1 | 8 | 4 | 56 | 12 | |||
23894 | 200745 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6014683.7532 | 2094550.1103 | 37.7320610911002 | -122.391569635286 | (37.7320610911002, -122.391569635286) | 10 | 3 | 8 | 58 | 1 | |||
23988 | 198459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | 14 | 3 | 9 | 310 | 29 | |||
24002 | 198501 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900x Carolina St | 13 | Median : Yard | Tree | DPW 1 | 15 | 6012463.03254 | 2103576.30053 | 37.7567215715659 | -122.399880796574 | (37.7567215715659, -122.399880796574) | 10 | 3 | 8 | 28856 | 29 | ||||
24025 | 242641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007759.04259 | 2106432.24164 | 37.764299956994 | -122.416351235928 | (37.764299956994, -122.416351235928) | 8 | 4 | 7 | 28859 | 19 | |||
24238 | 215561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 240 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 5994051.56415 | 2096391.91316 | 37.7359514186289 | -122.463032656549 | (37.7359514186289, -122.463032656549) | 9 | 8 | 4 | 59 | 40 | |||
24270 | 242668 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3956 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003431.93143 | 2102453.4748 | 37.7531309356663 | -122.431033493027 | (37.7531309356663, -122.431033493027) | 2 | 4 | 5 | 28862 | 22 | |||
24576 | 248409 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 120 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998272.8596 | 2108056.6857 | 37.7682222644528 | -122.449278164682 | (37.7682222644528, -122.449278164682) | 15 | 5 | 11 | 29492 | 9 | |||
24615 | 242404 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010188.91419 | 2101663.03935 | 37.7513411372819 | -122.407610671899 | (37.7513411372819, -122.407610671899) | 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 | ||
24709 | 123166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 579 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5992807.48236 | 2111535.86844 | 37.7774610360275 | -122.468435352622 | (37.7774610360275, -122.468435352622) | 11 | 6 | 2 | 54 | 11 | ||||
24722 | 244306 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303 | (37.7753816404734, -122.42418868303) | 7 | 9 | 11 | 28852 | 10 | |||
24738 | 16679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 248 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002873.9908755 | 2106855.8321643 | 37.7651871206567 | -122.433277506161 | (37.7651871206567, -122.433277506161) | 15 | 5 | 5 | 28862 | 3 | |||
24769 | 198491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 907 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015266.77203 | 2104421.22514 | 37.7591974636091 | -122.390243388116 | (37.7591974636091, -122.390243388116) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||
25169 | 17576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 752X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6003542.00606 | 2090427.72603 | 37.7201172080443 | -122.429795147634 | (37.7201172080443, -122.429795147634) | 9 | 7 | 6 | 28861 | 5 | |||
25246 | 242379 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1217 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011152.0776 | 2102554.59258 | 37.7538430143636 | -122.40434267049 | (37.7538430143636, -122.40434267049) | 10 | 4 | 8 | 28859 | 19 | |||
25292 | 89024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2724 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2008 12:00:00 AM | 4 | 4x4 | Permit Number 51769 | 6000900.18903 | 2116892.91159 | 37.7926342186313 | -122.440824453501 | (37.7926342186313, -122.440824453501) | 13 | 6 | 1 | 29490 | 27 | |
25389 | 215519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1800 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993153.53472 | 2103109.22386 | 37.7543436777209 | -122.466625589315 | (37.7543436777209, -122.466625589315) | 1 | 8 | 4 | 56 | 12 | |||
25402 | 242705 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002352.40846 | 2104549.28931 | 37.7588243106064 | -122.434916564156 | (37.7588243106064, -122.434916564156) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
25624 | 138666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2721 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000819.0242 | 2114826.1264 | 37.7869547408882 | -122.440956950105 | (37.7869547408882, -122.440956950105) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
25685 | 242513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2948 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008340.21249 | 2101308.02712 | 37.7502626954836 | -122.413978604037 | (37.7502626954836, -122.413978604037) | 2 | 4 | 7 | 28859 | 19 | |||
25694 | 242395 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1772 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005651.81735 | 2107273.82605 | 37.7664920266105 | -122.423699384137 | (37.7664920266105, -122.423699384137) | 8 | 4 | 5 | 28853 | 19 | |||
25715 | 242409 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 214 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005416.645 | 2102345.79668 | 37.7529475387091 | -122.424162295755 | (37.7529475387091, -122.424162295755) | 2 | 4 | 5 | 28859 | 19 | |||
25726 | 215523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80 Northwood Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995460.48677 | 2094242.81923 | 37.7301315873058 | -122.458006001202 | (37.7301315873058, -122.458006001202) | 9 | 7 | 4 | 28861 | 40 | |||
25809 | 242477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2831 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008363.71798 | 2101936.55898 | 37.7519898227944 | -122.413941777714 | (37.7519898227944, -122.413941777714) | 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 | |||
25912 | 215526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 478 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994752.10675 | 2100066.65325 | 37.7460816699447 | -122.460876862898 | (37.7460816699447, -122.460876862898) | 1 | 8 | 4 | 29491 | 40 | |||
26005 | 137018 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2716 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001024.79883 | 2116912.49705 | 37.7926950910553 | -122.440394705264 | (37.7926950910553, -122.440394705264) | 13 | 6 | 1 | 29490 | 27 | |||
26225 | 244356 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005588.2934 | 2110426.5412 | 37.7751450388721 | -122.424143338216 | (37.7751450388721, -122.424143338216) | 7 | 9 | 11 | 28852 | 10 | |||
26267 | 198618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015853.85549 | 2108626.75005 | 37.770777472425 | -122.388506502268 | (37.770777472425, -122.388506502268) | 14 | 3 | 9 | 310 | 20 | ||||
26272 | 9765 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 827X Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6000964.4329 | 2111657.6469 | 37.7782631876883 | -122.440226567073 | (37.7782631876883, -122.440226567073) | 15 | 5 | 11 | 29490 | 41 | ||
26333 | 85767 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400X Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008747.4583 | 2109466.0696 | 37.7726856753072 | -122.41314711365 | (37.7726856753072, -122.41314711365) | 8 | 2 | 9 | 28853 | 34 | ||
26377 | 18527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008391.22062 | 2100547.0534 | 37.7481760966626 | -122.413748394121 | (37.7481760966626, -122.413748394121) | 2 | 4 | 7 | 28859 | 2 | |||
26388 | 244359 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6005522.1928 | 2110456.2865 | 37.7752229798737 | -122.424374111287 | (37.7752229798737, -122.424374111287) | 7 | 9 | 11 | 28852 | 10 | |||
26514 | 17556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003246.79786 | 2090613.71944 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
26663 | 85795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 985 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 12 | 3x3 | 6011121.9774 | 2111644.9134 | 37.7788012938106 | -122.405086799447 | (37.7788012938106, -122.405086799447) | 14 | 2 | 9 | 28856 | 34 | ||
26707 | 242697 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 264 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001741.09826 | 2104301.70162 | 37.7581097668584 | -122.437013028641 | (37.7581097668584, -122.437013028641) | 2 | 4 | 5 | 28862 | 3 | |||
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 | |||
26836 | 198657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013998.08453 | 2107337.5024 | 37.7671344699085 | -122.394835392165 | (37.7671344699085, -122.394835392165) | 14 | 3 | 9 | 310 | 20 | |||
26914 | 242771 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 930 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002454.1308 | 2102779.02186 | 37.7539693556059 | -122.434438191367 | (37.7539693556059, -122.434438191367) | 2 | 4 | 5 | 28862 | 22 | |||
26952 | 137023 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003036.9655 | 2117481.25366 | 37.7943711144001 | -122.433473197238 | (37.7943711144001, -122.433473197238) | 13 | 9 | 1 | 29490 | 27 | |||
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 | ||
27032 | 119717 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
27123 | 242567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2121 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008134.5513 | 2106113.05528 | 37.7634446540583 | -122.415029859359 | (37.7634446540583, -122.415029859359) | 8 | 4 | 7 | 28859 | 19 | |||
27268 | 16442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
27340 | 242558 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008208.12172 | 2104777.36989 | 37.7597813034931 | -122.414680872925 | (37.7597813034931, -122.414680872925) | 2 | 4 | 7 | 28859 | 19 | |||
27643 | 7457 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2577 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008281.25133 | 2103428.77827 | 37.7560824872415 | -122.414332532234 | (37.7560824872415, -122.414332532234) | 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 | |||
27897 | 242493 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2500 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008201.36551 | 2103826.65132 | 37.7571704681572 | -122.414636959936 | (37.7571704681572, -122.414636959936) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
28247 | 91339 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 829 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52060 | 6012087.196 | 2112565.923 | 37.7813840839391 | -122.401812466037 | (37.7813840839391, -122.401812466037) | 6 | 2 | 9 | 28856 | 34 | |
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 | |||
28443 | 198576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014783.08484 | 2114165.12178 | 37.7859251988423 | -122.392597828542 | (37.7859251988423, -122.392597828542) | 6 | 2 | 9 | 28855 | 6 | |||
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 | |||
28621 | 198494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015476.06266 | 2104658.66701 | 37.7598610346751 | -122.389536136987 | (37.7598610346751, -122.389536136987) | 10 | 3 | 8 | 28856 | 29 | |||
28726 | 242418 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6005476.19264 | 2102018.01843 | 37.7520508975422 | -122.423933062164 | (37.7520508975422, -122.423933062164) | 2 | 4 | 5 | 28859 | 19 | |||
28774 | 242588 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 660 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002106.32831 | 2102091.37064 | 37.7520614807656 | -122.435591781438 | (37.7520614807656, -122.435591781438) | 2 | 4 | 5 | 28862 | 22 | |||
28789 | 31076 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 8 | Permit Number 34816 | 6006020.69113 | 2107294.38947 | 37.7665693044606 | -122.422424975532 | (37.7665693044606, -122.422424975532) | 8 | 4 | 5 | 28853 | 19 | |
28829 | 123586 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 62 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5994279.04973 | 2115190.28174 | 37.787579957729 | -122.463610042193 | (37.787579957729, -122.463610042193) | 11 | 6 | 1 | 54 | 11 | |||
28840 | 137884 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1928 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003417.2048 | 2115384.0895 | 37.7886344027041 | -122.432007699107 | (37.7886344027041, -122.432007699107) | 13 | 9 | 1 | 29490 | 27 | |||
28907 | 113443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 742 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994762.07163 | 2110522.43311 | 37.7747911175465 | -122.461600336607 | (37.7747911175465, -122.461600336607) | 11 | 6 | 2 | 54 | 11 | |||
28962 | 136999 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2452 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6002307.2495 | 2116764.38372 | 37.7923613472576 | -122.435946778048 | (37.7923613472576, -122.435946778048) | 13 | 9 | 1 | 29490 | 27 | |||
29010 | 141480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2210 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998945.488 | 2111497.8751 | 37.7777093428916 | -122.447199310957 | (37.7777093428916, -122.447199310957) | 15 | 6 | 2 | 54 | 16 | |||
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 | |||
29360 | 201851 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1119 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010210.791 | 2110772.6508 | 37.7763552850367 | -122.408177430978 | (37.7763552850367, -122.408177430978) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
29420 | 244397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | 7 | 9 | 11 | 28852 | 10 | |||
29434 | 215512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5993946.59661 | 2096298.31331 | 37.7356883696217 | -122.463388778181 | (37.7356883696217, -122.463388778181) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
29698 | 242600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Surrey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002217.82403 | 2096159.00983 | 37.7357789394319 | -122.434782025597 | (37.7357789394319, -122.434782025597) | 2 | 7 | 5 | 63 | 7 |
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) );