trees
61 rows where SiteOrder = 6 and qSpecies_id = 31
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 | |||
22198 | 14869 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1399 McAllister St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/2011 12:00:00 AM | 3 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | 15 | 5 | 11 | 29492 | 41 | ||
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 | |||
33254 | 119798 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2110122 | 6005581 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | ||||||||||
40654 | 31073 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1700X 15th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | 8 | 4 | 5 | 28853 | 19 | ||
41761 | 242738 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 115 Corbett Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6000793.83368 | 2105649.34692 | 37.7617561832258 | -122.440385717444 | (37.7617561832258, -122.440385717444) | 15 | 5 | 5 | 28862 | 3 | |||
43059 | 244376 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005617.5038 | 2109799.1317 | 37.7734239734056 | -122.423997666684 | (37.7734239734056, -122.423997666684) | 7 | 9 | 11 | 28852 | 10 | |||
46315 | 17923 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2397X Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002488.0197831 | 2115056.9941341 | 37.7876835609185 | -122.435199131446 | (37.7876835609185, -122.435199131446) | 13 | 9 | 11 | 29490 | 27 | |||
51789 | 198487 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6015204.943 | 2104516.59795 | 37.7594559071887 | -122.390463888397 | (37.7594559071887, -122.390463888397) | 10 | 3 | 8 | 28856 | 29 | |||
53797 | 200600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 6 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016471.5892 | 2094834.3971 | 37.7329407602926 | -122.385408441845 | (37.7329407602926, -122.385408441845) | 10 | 3 | 8 | 58 | 1 | |||
55922 | 109169 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 6 | Median : Cutout | Tree | DPW 1 | 3x20 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | |||||||||
67758 | 242502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2618 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008245.3225 | 2103001.91157 | 37.7549083899243 | -122.414426583341 | (37.7549083899243, -122.414426583341) | 2 | 4 | 7 | 28859 | 19 | |||
68160 | 201911 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 6 | : | Tree | Private 2 | 5 | Width 3ft | 6013805.76571 | 2093216.36455 | 37.7283501238417 | -122.394511693764 | (37.7283501238417, -122.394511693764) | 10 | 3 | 8 | 58 | 1 | |||
70618 | 198478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015196.41735 | 2104702.38206 | 37.7599655574783 | -122.390506356185 | (37.7599655574783, -122.390506356185) | 10 | 3 | 8 | 28856 | 29 | |||
71414 | 17582 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 801X Persia Ave | 6 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6003762.13068 | 2090345.22062 | 37.7199031291015 | -122.429028371762 | (37.7199031291015, -122.429028371762) | 9 | 7 | 6 | 28861 | 5 | |||
74412 | 244259 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005631.8198 | 2110120.4535 | 37.7743070536408 | -122.423970999545 | (37.7743070536408, -122.423970999545) | 7 | 9 | 11 | 28852 | 10 | |||
81046 | 198432 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2233 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010814.0242 | 2106448.53894 | 37.7645160236153 | -122.405786010411 | (37.7645160236153, -122.405786010411) | 8 | 4 | 8 | 28859 | 19 | |||
81285 | 244426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 100x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 6005680.8792 | 2109772.4112 | 37.7733541831734 | -122.423776541571 | (37.7733541831734, -122.423776541571) | 7 | 9 | 11 | 28852 | 10 | |||
81626 | 17813 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1900X Pine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/2012 12:00:00 AM | 4 | 3x3 | 6004830.0574482 | 2115432.8862429 | 37.7888483829176 | -122.427122914168 | (37.7888483829176, -122.427122914168) | 13 | 9 | 11 | 28858 | 27 | ||
83145 | 105880 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 131X RUSS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6010355 | 2111553 | 37.7785060152737 | -122.407733605583 | (37.7785060152737, -122.407733605583) | 14 | 2 | 9 | 28853 | 34 | |||
87801 | 244358 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005582.6276 | 2110470.923 | 37.775266580631 | -122.42416609455 | (37.775266580631, -122.42416609455) | 7 | 9 | 11 | 28852 | 10 | |||
90759 | 32989 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 666 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013088.2865 | 2113616.33259 | 37.7843240827368 | -122.398422883105 | (37.7843240827368, -122.398422883105) | 6 | 2 | 9 | 28853 | 6 | |
93406 | 198655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014030.31136 | 2107306.63823 | 37.7670515155374 | -122.3947217619 | (37.7670515155374, -122.3947217619) | 14 | 3 | 9 | 310 | 20 | |||
95950 | 198692 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016712.13371 | 2094960.30012 | 37.7332997702709 | -122.384585575986 | (37.7332997702709, -122.384585575986) | 10 | 3 | 8 | 58 | 1 | |||
97154 | 70472 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 450X Banks St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/18/1994 12:00:00 AM | 4 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.7371218206329 | -122.413131433288 | (37.7371218206329, -122.413131433288) | 10 | 7 | 7 | 28859 | 2 | |
98216 | 119713 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
98633 | 198578 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014761.29071 | 2114189.12116 | 37.7859898852611 | -122.392674910313 | (37.7859898852611, -122.392674910313) | 6 | 2 | 9 | 28855 | 6 | |||
99175 | 198497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6015478.44281 | 2104579.86448 | 37.7596447917884 | -122.389522401658 | (37.7596447917884, -122.389522401658) | 10 | 3 | 8 | 28856 | 29 | |||
100699 | 246540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | 7 | 9 | 11 | 28852 | 10 | |||
101944 | 7633 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008510.8607 | 2099758.97829 | 37.7460189357211 | -122.413278959756 | (37.7460189357211, -122.413278959756) | 2 | 7 | 7 | 28859 | 2 | |||
106947 | 242557 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2355 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008209.56252 | 2104759.13269 | 37.7597313092745 | -122.414674599275 | (37.7597313092745, -122.414674599275) | 2 | 4 | 7 | 28859 | 19 | |||
107318 | 198468 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6015390.71439 | 2105768.72163 | 37.7629042730221 | -122.389908858318 | (37.7629042730221, -122.389908858318) | 14 | 3 | 8 | 28856 | 29 | |||
110000 | 91036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010688.5143 | 2111227.8126 | 37.7776317911098 | -122.406556926191 | (37.7776317911098, -122.406556926191) | 14 | 2 | 9 | 28853 | 34 | ||
114018 | 254721 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 900 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x4 | 6013911 | 2107143 | 37.7665955668607 | -122.39512298129 | (37.7665955668607, -122.39512298129) | 14 | 3 | 8 | 28856 | 20 | ||
114716 | 198586 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013678.51918 | 2107141.48068 | 37.7665784640576 | -122.39592699106 | (37.7665784640576, -122.39592699106) | 14 | 3 | 8 | 28856 | 20 | |
116078 | 119786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
120435 | 198647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 421 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6016245.34642 | 2108770.39329 | 37.7711935725654 | -122.387162335966 | (37.7711935725654, -122.387162335966) | 14 | 3 | 9 | 310 | 20 | ||||
121072 | 141753 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6003977.6484 | 2113242.1747 | 37.7827849995584 | -122.429915802437 | (37.7827849995584, -122.429915802437) | 7 | 9 | 11 | 29490 | 41 | |||
121185 | 198680 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 6010306.35372 | 2111595.60808 | 37.7786202837256 | -122.407904897704 | (37.7786202837256, -122.407904897704) | 14 | 2 | 9 | 28853 | 34 | |||
123455 | 18529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3104X Folsom St | 6 | 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 | |||
127822 | 16443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 6 | 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 | |||
137869 | 16437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1299X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | |||
142901 | 198568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6014772.61549 | 2114134.95579 | 37.7858417885051 | -122.392631938935 | (37.7858417885051, -122.392631938935) | 6 | 2 | 9 | 28855 | 6 | |||
143338 | 244477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005574.5359 | 2110115.107 | 37.77428913922 | -122.424168774988 | (37.77428913922, -122.424168774988) | 7 | 9 | 11 | 28852 | 10 | |||
146614 | 198458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014912.11479 | 2106274.08898 | 37.7642653483915 | -122.391599516314 | (37.7642653483915, -122.391599516314) | 14 | 3 | 9 | 310 | 29 | |||
149284 | 119680 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2109501 | 6005733 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | ||||||||||
151442 | 215510 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Santa Paula Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5994019.70982 | 2096325.72526 | 37.73576784809 | -122.463137987822 | (37.73576784809, -122.463137987822) | 9 | 8 | 4 | 59 | 40 | |||
163757 | 198498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1215 Michigan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6016508.17513 | 2102448.92255 | 37.753850715249 | -122.385812507548 | (37.753850715249, -122.385812507548) | 10 | 3 | 8 | 28856 | 29 | |||
166520 | 198606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 456 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6016250.47578 | 2108648.85468 | 37.7708601381228 | -122.387136114449 | (37.7708601381228, -122.387136114449) | 14 | 3 | 9 | 310 | 20 | ||||
166672 | 137052 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1221 Jones St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008525.03986 | 2116714.30677 | 37.7925751052991 | -122.414429454859 | (37.7925751052991, -122.414429454859) | 5 | 1 | 10 | 28858 | 21 | |||
172832 | 16423 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016393.65878 | 2094869.65123 | 37.7330332492347 | -122.385680326224 | (37.7330332492347, -122.385680326224) | 10 | 3 | 8 | 58 | 1 | |||
174974 | 97837 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | ||||
176412 | 137024 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2201 Broadway | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003051.10397 | 2117478.36483 | 37.7943639845568 | -122.433424069968 | (37.7943639845568, -122.433424069968) | 13 | 9 | 1 | 29490 | 27 | |||
177497 | 141759 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 10 HOLLIS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6003937.2446 | 2113390.8375 | 37.7831909022721 | -122.430066191 | (37.7831909022721, -122.430066191) | 7 | 9 | 11 | 29490 | 41 | |||
177675 | 198632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 419 Mission Bay Blvd North | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015782.37645 | 2108741.7224 | 37.7710891999363 | -122.388761779325 | (37.7710891999363, -122.388761779325) | 14 | 3 | 9 | 310 | 20 | ||||
178289 | 119822 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
178302 | 119833 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
180875 | 242482 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2675 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008309.34886 | 2102910.2805 | 37.7546603883701 | -122.414198678945 | (37.7546603883701, -122.414198678945) | 2 | 4 | 7 | 28859 | 19 | |||
183611 | 246552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | 7 | 9 | 11 | 28852 | 10 | |||
186583 | 198438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015515.17331 | 2106293.18394 | 37.764351234542 | -122.389515023625 | (37.764351234542, -122.389515023625) | 14 | 3 | 9 | 310 | 29 | |||
188844 | 198617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015877.04462 | 2108628.30945 | 37.7707830392222 | -122.388426398764 | (37.7707830392222, -122.388426398764) | 14 | 3 | 9 | 310 | 20 |
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) );