trees
2,365 rows where qSpecies_id = 31 sorted by Latitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5601 | 180565 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6004047.94044 | 2092448.57496 | 37.7256946506667 | -122.428190247706 | (37.7256946506667, -122.428190247706) | 9 | 7 | 6 | 28861 | 5 | |||
95546 | 180564 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 522 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003993.12546 | 2092482.75388 | 37.7257853967595 | -122.428382173808 | (37.7257853967595, -122.428382173808) | 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 | ||
116487 | 56779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 118 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/26/1974 12:00:00 AM | 10 | 3x3 | Permit Number 14000 | 6004445.70809 | 2092827.36067 | 37.7267572104766 | -122.426842159439 | (37.7267572104766, -122.426842159439) | 9 | 7 | 6 | 28861 | 5 | |
87095 | 88329 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 120 London St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940 | 2092960 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | 9 | 7 | 6 | 28861 | 5 | |||
143107 | 180568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 136 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007069.51192 | 2093001.96725 | 37.7273846467688 | -122.417784094277 | (37.7273846467688, -122.417784094277) | 9 | 3 | 7 | 309 | 5 | |||
175536 | 215516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 88 Keystone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994119.69741 | 2093345.38089 | 37.7275903136211 | -122.462576174158 | (37.7275903136211, -122.462576174158) | 9 | 8 | 4 | 59 | 40 | |||
128472 | 58204 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 501x BURROWS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/12/1978 12:00:00 AM | 18 | 3x3 | Permit Number 17195 | 6009864 | 2093047 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | 10 | 3 | 7 | 309 | 28 | |
185430 | 113083 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 501x BURROWS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009864 | 2093047 | 37.7276651627155 | -122.408126678641 | (37.7276651627155, -122.408126678641) | 10 | 3 | 7 | 309 | 28 | ||||
125643 | 180572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 515 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6009820.00163 | 2093055.54033 | 37.7276861489955 | -122.408279384389 | (37.7276861489955, -122.408279384389) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
173101 | 201913 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 8 | : | Tree | Private 2 | 5 | Width 3ft | 6013833.24742 | 2093196.526 | 37.7282971789522 | -122.394415299033 | (37.7282971789522, -122.394415299033) | 10 | 3 | 8 | 58 | 1 | |||
62432 | 201912 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 7 | : | Tree | Private 2 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
98386 | 46780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 60 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/25/2002 12:00:00 AM | 6 | Permit Number 44871 | 6002511.8819 | 2093449.26082 | 37.7283552769641 | -122.433571759353 | (37.7283552769641, -122.433571759353) | 9 | 7 | 6 | 28861 | 25 | |
101072 | 201910 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 5 | : | Tree | Private 2 | 5 | Width 3ft | 6013794.8405 | 2093225.07 | 37.7283734198726 | -122.394550072331 | (37.7283734198726, -122.394550072331) | 10 | 3 | 8 | 58 | 1 | |||
156325 | 201909 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6013782.36653 | 2093233.80649 | 37.728396715017 | -122.394593807271 | (37.728396715017, -122.394593807271) | 10 | 3 | 8 | 58 | 1 | |||
109770 | 201908 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 3 | : | Tree | Private 2 | 5 | Width 3ft | 6013768.13816 | 2093245.14959 | 37.7284270698286 | -122.394643789789 | (37.7284270698286, -122.394643789789) | 10 | 3 | 8 | 58 | 1 | |||
101626 | 201907 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6013751.60826 | 2093257.56774 | 37.7284602485269 | -122.394701804167 | (37.7284602485269, -122.394701804167) | 10 | 3 | 8 | 58 | 1 | |||
97198 | 201906 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1751 Yosemite Ave | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6013735.56827 | 2093268.69044 | 37.7284898973927 | -122.394758034254 | (37.7284898973927, -122.394758034254) | 10 | 3 | 8 | 58 | 1 | |||
125652 | 117152 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | 6015252.32147994 | 2093260.25332261 | 37.7285509455903 | -122.389513905896 | (37.7285509455903, -122.389513905896) | 10 | 3 | 8 | 58 | 1 | |||
103111 | 46632 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1478 Underwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 9 | 3x3 | Permit Number 44753 | 6015248.4747 | 2093270.3779 | 37.7285785323655 | -122.389527911332 | (37.7285785323655, -122.389527911332) | 10 | 3 | 8 | 58 | 1 |
142895 | 107048 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 1478 UNDERWOOD AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015262.9 | 2093276.2 | 37.7285953185109 | -122.389478448264 | (37.7285953185109, -122.389478448264) | 10 | 3 | 8 | 58 | 1 | |||
96419 | 81863 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 880 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50491 | 5994900.59315185 | 2093952.33613362 | 37.7293018063197 | -122.459920577502 | (37.7293018063197, -122.459920577502) | 9 | 7 | 4 | 28861 | 40 | ||
140908 | 180569 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 Tulane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6007329.33398 | 2093756.28906 | 37.729470469574 | -122.416939308919 | (37.729470469574, -122.416939308919) | 9 | 3 | 7 | 309 | 28 | |||
182514 | 198695 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2 Baldwin Ct | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6017823.53796 | 2093627.90873 | 37.7297026844336 | -122.3806505222 | (37.7297026844336, -122.3806505222) | 10 | 3 | 8 | 58 | 1 | |||
97054 | 11630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 5991380.578 | 2094219.03 | 37.7298310098579 | -122.472108899465 | (37.7298310098579, -122.472108899465) | 9 | 8 | 4 | 64 | 40 | |||
149754 | 180570 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 39 University St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007772.76642 | 2093897.53246 | 37.7298832269189 | -122.415416310622 | (37.7298832269189, -122.415416310622) | 9 | 3 | 7 | 309 | 28 | |||
193109 | 180571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009971.64388 | 2093913.46554 | 37.7300503209452 | -122.407815622898 | (37.7300503209452, -122.407815622898) | 10 | 3 | 7 | 309 | 28 | |||
102357 | 180567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 79 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6003968.93484 | 2094040.31559 | 37.7300607449837 | -122.428576774521 | (37.7300607449837, -122.428576774521) | 9 | 7 | 6 | 28861 | 5 | |||
30944 | 180566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 111 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004117.41747 | 2094047.56106 | 37.7300890412712 | -122.428063967571 | (37.7300890412712, -122.428063967571) | 9 | 7 | 6 | 28861 | 5 | |||
73095 | 215524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 80 Northwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5995481.22092 | 2094239.13462 | 37.7301226615312 | -122.457934054513 | (37.7301226615312, -122.457934054513) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
2974 | 260217 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Thornton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010872 | 2093992 | 37.7303163237311 | -122.404708489988 | (37.7303163237311, -122.404708489988) | 10 | 3 | 7 | 309 | 28 | ||||
87526 | 200759 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1628 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6014603.9551 | 2094093.5604 | 37.7308030679401 | -122.391813605271 | (37.7308030679401, -122.391813605271) | 10 | 3 | 8 | 58 | 1 | |||
179924 | 26628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | 10 | 3 | 8 | 58 | 1 | ||
145272 | 22327 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5155 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6014617.6908 | 2094280.6281 | 37.7313174804906 | -122.391779193474 | (37.7313174804906, -122.391779193474) | 10 | 3 | 8 | 58 | 1 | |||
134540 | 200744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014678.5205 | 2094530.4879 | 37.7320069215178 | -122.391586354626 | (37.7320069215178, -122.391586354626) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
83633 | 200746 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5101 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014691.6022 | 2094572.3492 | 37.732122590278 | -122.391544053582 | (37.732122590278, -122.391544053582) | 10 | 3 | 8 | 58 | 1 | |||
36858 | 22315 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
86976 | 22316 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
99304 | 22314 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5115X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6014716.40109 | 2094586.27231 | 37.7321621967642 | -122.391459290654 | (37.7321621967642, -122.391459290654) | 10 | 3 | 8 | 58 | 1 | |||
8701 | 200755 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6014751.1238 | 2094745.6812 | 37.7326018284177 | -122.391350385093 | (37.7326018284177, -122.391350385093) | 10 | 3 | 8 | 58 | 1 | |||
192083 | 22309 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5033 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6014806.53085 | 2094754.47288 | 37.7326290435242 | -122.391159442188 | (37.7326290435242, -122.391159442188) | 10 | 3 | 8 | 58 | 1 | |||
69763 | 200749 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5099 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6014757.0105 | 2094768.5741 | 37.7326650143875 | -122.391331632933 | (37.7326650143875, -122.391331632933) | 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 | |||
160975 | 16434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1299X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016431.779935 | 2094795.010481 | 37.7328304099415 | -122.385543330143 | (37.7328304099415, -122.385543330143) | 10 | 3 | 8 | 58 | 1 | |||
191242 | 200601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016439.2859 | 2094833.558 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
58566 | 200635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 9 | Median : Cutout | Tree | DPW 1 | 5 | Width 0ft | 6016404.4653 | 2094836.0752 | 37.7329416541175 | -122.385640625637 | (37.7329416541175, -122.385640625637) | 10 | 3 | 8 | 58 | 1 | |||
55149 | 97435 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 4 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 6016490.8874 | 2094837.7533 | 37.7329510434152 | -122.385341956131 | (37.7329510434152, -122.385341956131) | 10 | 3 | 8 | 58 | 1 | |||
39111 | 200598 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 3 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016502.2145 | 2094839.4314 | 37.7329562777939 | -122.385302911931 | (37.7329562777939, -122.385302911931) | 10 | 3 | 8 | 58 | 1 | |||
170708 | 200597 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 2 | Median : Cutout | Tree | DPW 1 | 1 | Width 0ft | 6016514.3807 | 2094844.0461 | 37.7329696218978 | -122.385261171263 | (37.7329696218978, -122.385261171263) | 10 | 3 | 8 | 58 | 1 | |||
146659 | 97233 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300X Newcomb Ave | 13 | Median : Cutout | Tree | DPW 1 | 6 | 15x200 | 6016357.8982 | 2094854.1147 | 37.7329886101989 | -122.385802878589 | (37.7329886101989, -122.385802878589) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |||
106373 | 16438 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 1 | 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 | |||
108987 | 16441 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 4 | 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 | |||
111256 | 16440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 3 | 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 | |||
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 | |||
146179 | 16452 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2000 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
146461 | 16439 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 2 | 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 | |||
150079 | 16446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
151036 | 16447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
155817 | 16449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 12 | 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 | ||
178017 | 16444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 7 | 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 | |||
191729 | 16445 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
126107 | 16421 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016475.45956 | 2094869.09162 | 37.7330362386527 | -122.385397477745 | (37.7330362386527, -122.385397477745) | 10 | 3 | 8 | 58 | 1 | |||
135776 | 200630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1352 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6016410.2733 | 2094871.4126 | 37.7330390049329 | -122.38562300763 | (37.7330390049329, -122.38562300763) | 10 | 3 | 8 | 58 | 1 | |||
61858 | 200580 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1330 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6016475.5774 | 2094870.1567 | 37.7330391696694 | -122.385397144532 | (37.7330391696694, -122.385397144532) | 10 | 3 | 8 | 58 | 1 | |||
87166 | 16411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
126690 | 16415 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1200X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016451.798598 | 2094870.875206 | 37.7330398269448 | -122.385479404945 | (37.7330398269448, -122.385479404945) | 10 | 3 | 8 | 58 | 1 | |||
119811 | 16424 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.385712405803 | (37.7330411346315, -122.385712405803) | 10 | 3 | 8 | 58 | 1 | |||
54742 | 200631 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1354 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016389.5518 | 2094874.5522 | 37.7330464790647 | -122.385694866729 | (37.7330464790647, -122.385694866729) | 10 | 3 | 8 | 58 | 1 | |||
49167 | 16426 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2007 12:00:00 AM | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | ||
57103 | 16428 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
106040 | 16430 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
119302 | 16425 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016278.230833 | 2094877.189867 | 37.7330475611009 | -122.386079920066 | (37.7330475611009, -122.386079920066) | 10 | 3 | 8 | 58 | 1 | |||
61263 | 16420 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016497.09656 | 2094873.12693 | 37.7330485158596 | -122.385322953325 | (37.7330485158596, -122.385322953325) | 10 | 3 | 8 | 58 | 1 | |||
126634 | 200579 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1324 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6016496.9269 | 2094875.1801 | 37.7330541440687 | -122.385323682911 | (37.7330541440687, -122.385323682911) | 10 | 3 | 8 | 58 | 1 | |||
38292 | 200627 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1360 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016371.342 | 2094881.4594 | 37.7330644372172 | -122.385758304658 | (37.7330644372172, -122.385758304658) | 10 | 3 | 8 | 58 | 1 | |||
172739 | 200628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1362 Newcomb Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016361.9231 | 2094886.4828 | 37.7330777092621 | -122.385791218603 | (37.7330777092621, -122.385791218603) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
145100 | 97234 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380X Newcomb Ave | 14 | Median : Cutout | Tree | DPW 1 | 8 | 15x200 | 6016360.63733 | 2094893.94179 | 37.7330981190079 | -122.385796183605 | (37.7330981190079, -122.385796183605) | 10 | 3 | 8 | 58 | 1 | |||
178532 | 200623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1380 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016334.2945 | 2094904.0647 | 37.7331244567265 | -122.385887963991 | (37.7331244567265, -122.385887963991) | 10 | 3 | 8 | 58 | 1 | |||
182324 | 16418 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1992 12:00:00 AM | 13 | 3x3 | 6016308.5496 | 2094919.7628 | 37.7331661358215 | -122.385978065712 | (37.7331661358215, -122.385978065712) | 10 | 3 | 8 | 58 | 1 | ||
70359 | 16431 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6016292.5361 | 2094929.44377 | 37.7331918315913 | -122.386034103828 | (37.7331918315913, -122.386034103828) | 10 | 3 | 8 | 58 | 1 | |||
114660 | 200622 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1400 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6016290.9677 | 2094932.3213 | 37.7331996459116 | -122.386039726783 | (37.7331996459116, -122.386039726783) | 10 | 3 | 8 | 58 | 1 | |||
30156 | 198691 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301 Newcomb Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6016677.93992 | 2094927.14945 | 37.7332068541071 | -122.384701486 | (37.7332068541071, -122.384701486) | 10 | 3 | 8 | 58 | 1 | |||
40918 | 97229 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 9 | Median : Cutout | Tree | DPW 1 | 28 | 15x200 | 6016636.94251 | 2094930.84044 | 37.7332147213866 | -122.384843483567 | (37.7332147213866, -122.384843483567) | 10 | 3 | 8 | 58 | 1 | |||
188111 | 97225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.91351 | 37.7332595687675 | -122.384799975236 | (37.7332595687675, -122.384799975236) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
121839 | 198694 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 97 Whitney Young Cir | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6016624.01227 | 2094969.82171 | 37.7333210410161 | -122.384890902109 | (37.7333210410161, -122.384890902109) | 10 | 3 | 8 | 58 | 1 | |||
47416 | 255466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15x200 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
65768 | 255467 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6016676.72369 | 2094975.37763 | 37.7333392118181 | -122.384709049297 | (37.7333392118181, -122.384709049297) | 10 | 3 | 8 | 58 | 1 | ||||
107965 | 97221 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 1 | Median : Cutout | Tree | DPW 1 | 5 | 15x200 | 6016689.53805 | 2094986.80633 | 37.733371301443 | -122.384665541907 | (37.733371301443, -122.384665541907) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 |
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) );