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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9720 | 242385 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005896.47931 | 2107288.01777 | 37.7665448015394 | -122.422854150009 | (37.7665448015394, -122.422854150009) | 8 | 4 | 5 | 28853 | 19 | |||
9860 | 261981 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 853 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6004377.23368 | 2103892.56966 | 37.7571358712273 | -122.427866984578 | (37.7571358712273, -122.427866984578) | 2 | 4 | 5 | 28862 | 3 | ||||
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 | ||||
9921 | 220013 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 58 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6005865.66076 | 2102301.94093 | 37.7528524632741 | -122.42260639579 | (37.7528524632741, -122.42260639579) | 2 | 4 | 5 | 28859 | 19 | |||
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) | ||||||||||
10187 | 242636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3357 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6008524.39622 | 2099125.83566 | 37.7442812262921 | -122.413187392191 | (37.7442812262921, -122.413187392191) | 2 | 7 | 7 | 28859 | 2 | |||
10263 | 119836 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
10264 | 137022 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6003025.71137 | 2117483.5061 | 37.7943766605074 | -122.433512298867 | (37.7943766605074, -122.433512298867) | 13 | 9 | 1 | 29490 | 27 | |||
10265 | 242383 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005959.30946 | 2107292.9046 | 37.7665617645426 | -122.422637178672 | (37.7665617645426, -122.422637178672) | 8 | 4 | 5 | 28853 | 19 | |||
10305 | 98993 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1919 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 768862 | 6003810 | 2118645 | 37.7976102909597 | -122.430881499482 | (37.7976102909597, -122.430881499482) | 13 | 9 | 1 | 57 | 17 | |
10327 | 198443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015407.0439 | 2106284.70526 | 37.7643219580036 | -122.389888423915 | (37.7643219580036, -122.389888423915) | 14 | 3 | 9 | 310 | 29 | |||
10535 | 258146 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1048 Folsom St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010642.12041 | 2111257.36423 | 37.7777103373451 | -122.406719502289 | (37.7777103373451, -122.406719502289) | 14 | 2 | 9 | 28853 | 34 | ||||
11086 | 242374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006546.0037 | 2109148.19709 | 37.7716890396519 | -122.420739627149 | (37.7716890396519, -122.420739627149) | 8 | 2 | 9 | 28853 | 19 | |||
11128 | 198446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015345.15707 | 2106282.18607 | 37.7643116086136 | -122.390102298884 | (37.7643116086136, -122.390102298884) | 14 | 3 | 9 | 310 | 29 | |||
11178 | 200944 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1595 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6008285.8995 | 2108891.4726 | 37.771082044751 | -122.41470302964 | (37.771082044751, -122.41470302964) | 8 | 2 | 9 | 28853 | 19 | |||
11525 | 119754 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
11729 | 244288 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005589.8116 | 2110006.6495 | 37.7739922036556 | -122.424108218812 | (37.7739922036556, -122.424108218812) | 7 | 9 | 11 | 28852 | 10 | |||
11968 | 242397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1784 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 4x8 | 6005589.03646 | 2107271.34136 | 37.7664816601377 | -122.423916355479 | (37.7664816601377, -122.423916355479) | 8 | 4 | 5 | 28853 | 19 | |||
11978 | 7458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2576 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2019 12:00:00 AM | 3 | 5x5 | 6008224.65711 | 2103426.0166 | 37.7560717250334 | -122.41452805924 | (37.7560717250334, -122.41452805924) | 2 | 4 | 7 | 28859 | 19 | ||
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 | |||
12015 | 242657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 502 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001803.26335 | 2102879.5886 | 37.7542085204161 | -122.436696239741 | (37.7542085204161, -122.436696239741) | 2 | 4 | 5 | 28862 | 22 | |||
12027 | 258891 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
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 | ||||||||||||
12246 | 119784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
12506 | 105953 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 54 05th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/10/2014 12:00:00 AM | 4 | Permit Number 771133 | 5994277.8794 | 2115232.96253 | 37.7876970801078 | -122.463617190077 | (37.7876970801078, -122.463617190077) | 11 | 6 | 1 | 54 | 11 | ||
12738 | 72412 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997617.1015 | 2116066.53919 | 37.7901776988858 | -122.452124350462 | (37.7901776988858, -122.452124350462) | 11 | 6 | 1 | 54 | 31 | |||
13245 | 17573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 750 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3x3 | 6003469.36772 | 2090473.15538 | 37.7202378333854 | -122.430049472832 | (37.7202378333854, -122.430049472832) | 9 | 7 | 6 | 28861 | 5 | |||
13324 | 119752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
13803 | 74944 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6010701.03805 | 2106443.01503 | 37.7644945370101 | -122.406176411522 | (37.7644945370101, -122.406176411522) | 8 | 4 | 8 | 28859 | 19 | |||
14091 | 65135 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 29 16th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1989 12:00:00 AM | 24 | 6x25 | Permit Number 27110 | 5990777 | 2114840 | 37.7864157730855 | -122.475700726719 | (37.7864157730855, -122.475700726719) | 11 | 6 | 1 | 54 | 33 | |
14105 | 180573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 515 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009834.24274 | 2093058.41578 | 37.7276948418209 | -122.408230355163 | (37.7276948418209, -122.408230355163) | 10 | 3 | 7 | 309 | 28 | |||
14201 | 138412 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2445 PINE ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002175.9998 | 2115015.7118 | 37.7875524868912 | -122.436275703068 | (37.7875524868912, -122.436275703068) | 13 | 6 | 11 | 29490 | 27 | |||
14245 | 242715 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3880 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002516.60789 | 2103579.90107 | 37.7561719248109 | -122.434279383699 | (37.7561719248109, -122.434279383699) | 2 | 4 | 5 | 28862 | 3 | |||
14547 | 119749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
14897 | 242642 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 952 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6007375.48933 | 2101738.08123 | 37.7513892968874 | -122.417345160358 | (37.7513892968874, -122.417345160358) | 2 | 4 | 7 | 28859 | 19 | |||
14903 | 91162 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 525 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2009 12:00:00 AM | 4 | 3x3 | Permit Number 52035 | 6007112.34702 | 2112584.78934 | 37.7811570014217 | -122.419024399678 | (37.7811570014217, -122.419024399678) | 7 | 9 | 9 | 28852 | 36 | |
15104 | 16448 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
15181 | 137040 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009716.37448 | 2116806.11676 | 37.7928940462749 | -122.410313864011 | (37.7928940462749, -122.410313864011) | 3 | 1 | 10 | 28857 | 21 | ||
15262 | 73760 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3485 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 5997597.70095 | 2116065.74811 | 37.7901744154595 | -122.452191417426 | (37.7901744154595, -122.452191417426) | 11 | 6 | 1 | 54 | 31 | |||
15421 | 242745 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4048 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 7x4 | 6001990.5336 | 2105890.39532 | 37.762486108974 | -122.436264069635 | (37.762486108974, -122.436264069635) | 15 | 5 | 5 | 28862 | 3 | |||
15550 | 32997 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013196.81609 | 2113721.08426 | 37.784617751847 | -122.398054757315 | (37.784617751847, -122.398054757315) | 6 | 2 | 9 | 28853 | 6 | |
15578 | 119832 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
15645 | 137035 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 128 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008088.76932 | 2112909.47489 | 37.7821034452579 | -122.415669449996 | (37.7821034452579, -122.415669449996) | 7 | 10 | 9 | 28852 | 36 | |||
15703 | 74054 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 194X Russ St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 5x5 | 6010549.99954 | 2111279.17691 | 37.7777650752333 | -122.407039719318 | (37.7777650752333, -122.407039719318) | 14 | 2 | 9 | 28853 | 34 | |||
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) | ||||||||||
15764 | 258890 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
16029 | 198662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013921.99886 | 2107418.77263 | 37.7673533891782 | -122.395104256175 | (37.7673533891782, -122.395104256175) | 14 | 3 | 9 | 310 | 20 | |||
16049 | 258892 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003970 | 2113206 | 37.7826852397237 | -122.429939681443 | (37.7826852397237, -122.429939681443) | 7 | 9 | 11 | 29490 | 41 | ||||
16163 | 32994 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013107.84928 | 2113632.60044 | 37.7843698402516 | -122.398356344087 | (37.7843698402516, -122.398356344087) | 6 | 2 | 9 | 28853 | 6 | |
16269 | 198600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1050 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013090.52825 | 2107110.01033 | 37.7664593236741 | -122.397958554166 | (37.7664593236741, -122.397958554166) | 14 | 3 | 8 | 28856 | 20 | |||
16396 | 242589 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 662 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6002102 | 2102108 | 37.7521068951849 | -122.435607938928 | (37.7521068951849, -122.435607938928) | 2 | 4 | 5 | 28862 | 22 | |||
16481 | 242572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2075 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6008125.16647 | 2106366.43702 | 37.7641398542804 | -122.415080254657 | (37.7641398542804, -122.415080254657) | 8 | 4 | 7 | 28859 | 19 | |||
16688 | 137060 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 462 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011807.58318 | 2118407.27 | 37.7974074315733 | -122.403190818824 | (37.7974074315733, -122.403190818824) | 3 | 1 | 10 | 308 | 23 | |||
16699 | 97434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380x Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
16709 | 215479 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 85 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992627.2877 | 2096233.38868 | 37.7354340044744 | -122.467945378584 | (37.7354340044744, -122.467945378584) | 1 | 8 | 4 | 59 | 40 | |||
16945 | 180528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 445 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6002899 | 2090905 | 37.7213912632755 | -122.432051865162 | (37.7213912632755, -122.432051865162) | 9 | 7 | 6 | 28861 | 5 | |||
17062 | 198453 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015012.52649 | 2106269.21439 | 37.7642575368696 | -122.391251877095 | (37.7642575368696, -122.391251877095) | 14 | 3 | 9 | 310 | 29 | |||
17081 | 17955 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2475 Pine St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.7875190105667 | -122.436494277471 | (37.7875190105667, -122.436494277471) | 13 | 6 | 11 | 29490 | 27 | |||
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 | |||
17600 | 220014 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 58X Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6005814 | 2102330 | 37.752926592326 | -122.422787042427 | (37.752926592326, -122.422787042427) | 2 | 4 | 5 | 28859 | 19 | |||
17630 | 242739 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4097 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6001725.29855 | 2105828.01986 | 37.7622997676344 | -122.437176952577 | (37.7622997676344, -122.437176952577) | 15 | 5 | 5 | 28862 | 3 | |||
17960 | 81238 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6008758.1555 | 2109381.0971 | 37.7724529612773 | -122.41310410127 | (37.7724529612773, -122.41310410127) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
17974 | 7452 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2567 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008279.66518 | 2103491.16877 | 37.7562537082641 | -122.414342431978 | (37.7562537082641, -122.414342431978) | 2 | 4 | 7 | 28859 | 19 | |||
17980 | 180512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004254.69534 | 2090025.204 | 37.7190523030053 | -122.427302962162 | (37.7190523030053, -122.427302962162) | 9 | 7 | 6 | 28861 | 5 | |||
17985 | 242506 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2690 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008258.82022 | 2102787.11957 | 37.7543193780408 | -122.414364707265 | (37.7543193780408, -122.414364707265) | 2 | 4 | 7 | 28859 | 19 | |||
18136 | 112514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1014 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992342.97239 | 2113476.2606 | 37.7827619817135 | -122.47018356399 | (37.7827619817135, -122.47018356399) | 11 | 6 | 2 | 54 | 11 | |||
18278 | 242639 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007844.9141 | 2104767.39545 | 37.7597335027307 | -122.415936326515 | (37.7597335027307, -122.415936326515) | 2 | 4 | 7 | 28859 | 19 | |||
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 | ||||||||||||
18401 | 146496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3570 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6001206.87483 | 2120871.25234 | 37.8035751557371 | -122.440048709094 | (37.8035751557371, -122.440048709094) | 13 | 9 | 1 | 57 | 17 | |||
18433 | 260397 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Thornton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/20/2018 12:00:00 AM | 3 | |||||||||||||
18546 | 141885 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1375 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003895.1071 | 2112829.8704 | 37.7816482400961 | -122.430171937151 | (37.7816482400961, -122.430171937151) | 7 | 9 | 11 | 29490 | 41 | |||
18698 | 180522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 703 Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6003548.0155 | 2090475.44462 | 37.7202485730803 | -122.429777776817 | (37.7202485730803, -122.429777776817) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
18776 | 242548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2498 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008191.23851 | 2104001.87408 | 37.7576510208955 | -122.414684382976 | (37.7576510208955, -122.414684382976) | 2 | 4 | 7 | 28859 | 19 | |||
18804 | 85789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | 8 | 2 | 9 | 28853 | 34 | ||
18889 | 242437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 155 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004941.65866 | 2098698.95529 | 37.7429073221216 | -122.425545367634 | (37.7429073221216, -122.425545367634) | 2 | 7 | 5 | 63 | 22 | |||
19093 | 25174 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3062 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6000130.8652 | 2105433.23803 | 37.7611250309289 | -122.442663135402 | (37.7611250309289, -122.442663135402) | 15 | 5 | 5 | 28862 | 3 | |||
19169 | 34703 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 591 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50359 | 5981606.78939 | 2111740.24587 | 37.777368864087 | -122.507196740825 | (37.777368864087, -122.507196740825) | 11 | 6 | 2 | 55 | 26 | |
19427 | 242615 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 195 Virginia Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6006637.73336 | 2098498.23096 | 37.7424518658562 | -122.419666561475 | (37.7424518658562, -122.419666561475) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
19733 | 215491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 45 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993998.37881 | 2097545.6525 | 37.7391162363258 | -122.463300232728 | (37.7391162363258, -122.463300232728) | 1 | 8 | 4 | 59 | 40 | |||
19785 | 198466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6015361.95352 | 2105766.343 | 37.7628961467725 | -122.390008166863 | (37.7628961467725, -122.390008166863) | 14 | 3 | 8 | 28856 | 29 | |||
19858 | 109170 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 5 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
19934 | 123687 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 24 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995428.99259 | 2113586.04452 | 37.7832413460359 | -122.459515263281 | (37.7832413460359, -122.459515263281) | 11 | 6 | 2 | 54 | 11 | |||
19935 | 242560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2331 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008202.94857 | 2104853.89142 | 37.7599911234086 | -122.414704179747 | (37.7599911234086, -122.414704179747) | 2 | 4 | 7 | 28859 | 19 | |||
19940 | 141752 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003991.9132 | 2113242.703 | 37.7827872579582 | -122.429866489942 | (37.7827872579582, -122.429866489942) | 7 | 9 | 11 | 29490 | 41 | |||
19980 | 98857 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008572.87311 | 2110548.2851 | 37.77564738136 | -122.413827590795 | (37.77564738136, -122.413827590795) | 8 | 2 | 9 | 28853 | 34 | |||
20097 | 57068 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 918 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 15 | 6x7 | Permit Number 14334 | 6015212.77238 | 2104346.74514 | 37.7589899621477 | -122.390424942382 | (37.7589899621477, -122.390424942382) | 10 | 3 | 8 | 28856 | 29 | |
20447 | 198509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 361 Texas St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6013800.26675 | 2105409.79767 | 37.7618304159729 | -122.395384559572 | (37.7618304159729, -122.395384559572) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
20688 | 242726 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003143.88793 | 2107880.88822 | 37.7680169827249 | -122.432417216901 | (37.7680169827249, -122.432417216901) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
20814 | 242748 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4096 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001694.23867 | 2105873.65626 | 37.7624233084181 | -122.437287644716 | (37.7624233084181, -122.437287644716) | 15 | 5 | 5 | 28862 | 3 | |||
20821 | 85762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | 8 | 2 | 9 | 28853 | 34 | ||
20869 | 198471 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 704 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015348.95336 | 2105815.25959 | 37.7630297401524 | -122.390056547668 | (37.7630297401524, -122.390056547668) | 14 | 3 | 8 | 28856 | 29 | |||
21138 | 198434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015605.2539 | 2106298.94966 | 37.7643720601453 | -122.389203859978 | (37.7643720601453, -122.389203859978) | 14 | 3 | 9 | 310 | 29 | |||
21183 | 254244 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 499x Benton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6006980 | 2095456 | 37.7341178478927 | -122.418267455605 | (37.7341178478927, -122.418267455605) | 2 | 7 | 7 | 28859 | 2 | ||||
21205 | 215567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 254 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993893.11792 | 2096318.45791 | 37.735740600456 | -122.463575134792 | (37.735740600456, -122.463575134792) | 9 | 8 | 4 | 59 | 40 | |||
21307 | 215486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.7395492454888 | -122.463120453749 | (37.7395492454888, -122.463120453749) | 1 | 8 | 4 | 59 | 40 |
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) );