trees
8,758 rows where qSpecies_id = 16 sorted by YCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69336 | 46207 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 229 Santos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2002 12:00:00 AM | 7 | Permit Number 44523 | 6006431.19699 | 2086460.28919 | 37.7093866531391 | -122.419526839197 | (37.7093866531391, -122.419526839197) | 9 | 7 | 8 | 309 | 39 | ||
| 111457 | 177586 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 44 Melra Ct | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 6ft | 6008941.6423 | 2086478.69899 | 37.7095782887729 | -122.410851594747 | (37.7095782887729, -122.410851594747) | 9 | 7 | 8 | 309 | 39 | |||
| 170946 | 15966 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5894 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 5996871.49621 | 2086494.71439 | 37.7089380748908 | -122.452569038239 | (37.7089380748908, -122.452569038239) | 9 | 7 | 6 | 28861 | 25 | |||
| 130461 | 15965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5894 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 5996894.16825 | 2086505.28201 | 37.7089683901523 | -122.452491442944 | (37.7089683901523, -122.452491442944) | 9 | 7 | 6 | 28861 | 25 | |||
| 164064 | 177646 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5870 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 5996947.52419 | 2086525.1457 | 37.7090259881292 | -122.452308470453 | (37.7090259881292, -122.452308470453) | 9 | 7 | 6 | 28861 | 25 | |||
| 113926 | 15960 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5870 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5996972.39546 | 2086534.8395 | 37.7090540298949 | -122.452223211127 | (37.7090540298949, -122.452223211127) | 9 | 7 | 6 | 28861 | 25 | |||
| 156481 | 15956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5853 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 5997148.28101 | 2086539.17139 | 37.7090759985243 | -122.451615639949 | (37.7090759985243, -122.451615639949) | 9 | 7 | 6 | 28861 | 5 | |||
| 50101 | 15957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5858 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5996992.22779 | 2086542.15413 | 37.7090752502926 | -122.452155195428 | (37.7090752502926, -122.452155195428) | 9 | 7 | 6 | 28861 | 25 | |||
| 29071 | 15955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5851 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5997169.58385 | 2086548.66205 | 37.7091032776624 | -122.45154269863 | (37.7091032776624, -122.45154269863) | 9 | 7 | 6 | 28861 | 5 | |||
| 137379 | 15952 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5845 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2016 12:00:00 AM | 15 | 4x6 | 5997201.68184 | 2086560.6022 | 37.7091379006634 | -122.451432624323 | (37.7091379006634, -122.451432624323) | 9 | 7 | 6 | 28861 | 5 | ||
| 182399 | 15951 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5840 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 6x5 | 5997069.49341 | 2086569.25103 | 37.7091540779749 | -122.451890108828 | (37.7091540779749, -122.451890108828) | 9 | 7 | 6 | 28861 | 25 | |||
| 56107 | 15953 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5845 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2013 12:00:00 AM | 14 | 4x4 | 5997237.66299 | 2086574.75412 | 37.7091788189244 | -122.451309288592 | (37.7091788189244, -122.451309288592) | 9 | 7 | 6 | 28861 | 5 | ||
| 45785 | 177645 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5838 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5997080.84986 | 2086578.39546 | 37.7091798369367 | -122.451851518653 | (37.7091798369367, -122.451851518653) | 9 | 7 | 6 | 28861 | 25 | |||
| 24236 | 15958 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5858 MISSION ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5996945.1 | 2086589.8 | 37.7092033751387 | -122.452321511011 | (37.7092033751387, -122.452321511011) | 9 | 7 | 6 | 28861 | 25 | |||
| 184549 | 177658 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011894.9133 | 2086606.50806 | 37.7100943818314 | -122.400653490482 | (37.7100943818314, -122.400653490482) | 10 | 3 | 8 | 309 | 1 | |||
| 98747 | 177711 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 1 | : | Tree | Private 2 | 18 | Width 3ft | 5994431.51774 | 2086616.48409 | 37.7091323221755 | -122.461010711685 | (37.7091323221755, -122.461010711685) | 9 | 8 | 6 | 28861 | 25 | |||
| 76849 | 177644 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5818 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5997179.78016 | 2086617.18219 | 37.7092920021922 | -122.451512397797 | (37.7092920021922, -122.451512397797) | 9 | 7 | 6 | 28861 | 25 | |||
| 182589 | 15938 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5810X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/24/1995 12:00:00 AM | 6 | 4X4 | 5997196.02808 | 2086625.39972 | 37.7093154960794 | -122.45145683499 | (37.7093154960794, -122.45145683499) | 9 | 7 | 6 | 28861 | 25 | ||
| 140245 | 177710 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 5994442.40126 | 2086628.41328 | 37.7091657032093 | -122.460973960888 | (37.7091657032093, -122.460973960888) | 9 | 8 | 6 | 28861 | 25 | |||
| 52858 | 15942 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5810X MISSION ST | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 4X4 | 5997175 | 2086632 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | 9 | 7 | 6 | 28861 | 25 | |||
| 115991 | 15941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5810X MISSION ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5997175 | 2086632 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | 9 | 7 | 6 | 28861 | 25 | |||
| 81068 | 177657 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011903.43858 | 2086633.42033 | 37.710168753063 | -122.400625914559 | (37.710168753063, -122.400625914559) | 10 | 3 | 8 | 309 | 1 | |||
| 93395 | 15948 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5813 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5997387.00519 | 2086633.54202 | 37.7093487871892 | -122.450797377394 | (37.7093487871892, -122.450797377394) | 9 | 7 | 6 | 28861 | 5 | |||
| 191913 | 177709 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994451.68551 | 2086639.19983 | 37.7091958547847 | -122.460942654584 | (37.7091958547847, -122.460942654584) | 9 | 8 | 6 | 28861 | 25 | |||
| 24055 | 177708 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5994462.16701 | 2086650.7454 | 37.7092281593337 | -122.460907265375 | (37.7092281593337, -122.460907265375) | 9 | 8 | 6 | 28861 | 25 | |||
| 122312 | 177656 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011912.31908 | 2086659.96413 | 37.7102421323529 | -122.400597084994 | (37.7102421323529, -122.400597084994) | 10 | 3 | 8 | 309 | 1 | |||
| 64339 | 177707 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 5994471.04103 | 2086660.75611 | 37.7092561570118 | -122.460877320635 | (37.7092561570118, -122.460877320635) | 9 | 8 | 6 | 28861 | 25 | |||
| 70003 | 177706 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 41 Rhine St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 5994482.43629 | 2086673.39058 | 37.7092915039818 | -122.460838852155 | (37.7092915039818, -122.460838852155) | 9 | 8 | 6 | 28861 | 25 | |||
| 56477 | 177782 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002051.13514 | 2086675.27094 | 37.7097292579622 | -122.434680392291 | (37.7097292579622, -122.434680392291) | 9 | 7 | 6 | 28861 | 5 | |||
| 161572 | 177783 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 6ft | 6002048.25006 | 2086684.24887 | 37.7097537456034 | -122.434691005195 | (37.7097537456034, -122.434691005195) | 9 | 7 | 6 | 28861 | 5 | |||
| 129494 | 177655 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011921.19197 | 2086686.14682 | 37.7103145196741 | -122.400568256324 | (37.7103145196741, -122.400568256324) | 10 | 3 | 8 | 309 | 1 | |||
| 173639 | 177584 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 414 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 9ft | 6010519.18521 | 2086688.04681 | 37.7102414461649 | -122.405414040027 | (37.7102414461649, -122.405414040027) | 9 | 7 | 8 | 309 | 39 | |||
| 123518 | 177784 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002043.43466 | 2086698.87237 | 37.7097936251552 | -122.43470869307 | (37.7097936251552, -122.43470869307) | 9 | 7 | 6 | 28861 | 5 | |||
| 135176 | 177654 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011927.89725 | 2086712.7348 | 37.7103878989459 | -122.40054694781 | (37.7103878989459, -122.40054694781) | 10 | 3 | 8 | 309 | 1 | |||
| 84640 | 177785 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002038.86994 | 2086713.23619 | 37.7098328059114 | -122.434725496011 | (37.7098328059114, -122.434725496011) | 9 | 7 | 6 | 28861 | 5 | |||
| 111642 | 177786 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6002034.31049 | 2086727.85439 | 37.709872685436 | -122.434742298935 | (37.709872685436, -122.434742298935) | 9 | 7 | 6 | 28861 | 5 | |||
| 87827 | 177653 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011937.88716 | 2086740.33953 | 37.7104642531879 | -122.400514358176 | (37.7104642531879, -122.400514358176) | 10 | 3 | 8 | 309 | 1 | |||
| 53946 | 177787 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6002029.96459 | 2086740.42997 | 37.7099069684944 | -122.434758217838 | (37.7099069684944, -122.434758217838) | 9 | 7 | 6 | 28861 | 5 | |||
| 13752 | 38739 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 42451 | 38736 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 45085 | 38735 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 56840 | 38738 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 60635 | 38748 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 75396 | 38728 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 82191 | 38746 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 85712 | 38743 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 90707 | 38727 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 100127 | 38737 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 111622 | 38747 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 117300 | 38745 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 120286 | 38731 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 137778 | 38749 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 140232 | 38729 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 140673 | 38734 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 145832 | 38732 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 148448 | 38726 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 151331 | 38733 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 163558 | 38740 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 167670 | 38741 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 168922 | 38725 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 182040 | 38730 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 186291 | 38742 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 187960 | 38744 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 222 Schwerin St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1998 12:00:00 AM | Permit Number 40629 | 6008735.41747655 | 2086742.92913816 | 37.7102922449528 | -122.411583002336 | (37.7102922449528, -122.411583002336) | 9 | 7 | 8 | 309 | 39 | |||
| 83577 | 31054 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 209 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 4 | Permit Number 34807 | 6003260.06759 | 2086751.87462 | 37.7100081539218 | -122.430507568565 | (37.7100081539218, -122.430507568565) | 9 | 7 | 6 | 28861 | 5 | |
| 73231 | 177788 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 6ft | 6002023.21365 | 2086760.44466 | 37.7099615411737 | -122.434782980643 | (37.7099615411737, -122.434782980643) | 9 | 7 | 6 | 28861 | 5 | |||
| 57868 | 15927 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5750 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997533.17015 | 2086761.44901 | 37.709708356642 | -122.450301423963 | (37.709708356642, -122.450301423963) | 9 | 7 | 6 | 28861 | 25 | |||
| 93612 | 15928 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5750 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/1997 12:00:00 AM | 6 | 3X3 | 5997533.43344 | 2086762.16841 | 37.7097103470182 | -122.450300565813 | (37.7097103470182, -122.450300565813) | 9 | 7 | 6 | 28861 | 25 | ||
| 20045 | 177652 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Wheeler Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6011945.30264 | 2086766.19057 | 37.710535648564 | -122.400490543214 | (37.710535648564, -122.400490543214) | 10 | 3 | 8 | 309 | 1 | |||
| 193054 | 177789 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6002017.64706 | 2086775.84814 | 37.7100035197158 | -122.434803320611 | (37.7100035197158, -122.434803320611) | 9 | 7 | 6 | 28861 | 5 | |||
| 142181 | 31055 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 209 South Hill Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 6 | Permit Number 34807 | 6003240.30345 | 2086787.7714 | 37.7101055990722 | -122.430578436949 | (37.7101055990722, -122.430578436949) | 9 | 7 | 6 | 28861 | 5 | |
| 173818 | 177790 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401 Cordova St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6002013.3907 | 2086792.75344 | 37.7100496963121 | -122.434819239526 | (37.7100496963121, -122.434819239526) | 9 | 7 | 6 | 28861 | 5 | |||
| 138842 | 108541 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401-423X Wheeler Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011955.27785 | 2086793.07341 | 37.7106100198023 | -122.40045795359 | (37.7106100198023, -122.40045795359) | 10 | 3 | 8 | 309 | 1 |
| 87314 | 177705 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 84 De Long St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 5994659.32331 | 2086819.21058 | 37.7097020678628 | -122.460238064532 | (37.7097020678628, -122.460238064532) | 9 | 8 | 6 | 28861 | 25 | |||
| 185784 | 108540 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401-423X Wheeler Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011963.42578 | 2086819.27084 | 37.7106824071298 | -122.400431631316 | (37.7106824071298, -122.400431631316) | 10 | 3 | 8 | 309 | 1 |
| 5171 | 108539 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 401-423X Wheeler Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773817 | 6011972.2839 | 2086844.73133 | 37.710752810564 | -122.400402802668 | (37.710752810564, -122.400402802668) | 10 | 3 | 8 | 309 | 1 |
| 141450 | 177651 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 120 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011959.13663 | 2086879.78065 | 37.7108483158589 | -122.400450703235 | (37.7108483158589, -122.400450703235) | 10 | 3 | 8 | 309 | 1 | |||
| 44876 | 65037 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 120 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/19/1989 12:00:00 AM | 11 | Permit Number 26089 | 6011900.7584 | 2086898.97279 | 37.7108977578975 | -122.40065382052 | (37.7108977578975, -122.40065382052) | 10 | 3 | 8 | 309 | 1 | ||
| 144144 | 177781 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Naylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002479.647 | 2086903.76099 | 37.7103809597902 | -122.433215695261 | (37.7103809597902, -122.433215695261) | 9 | 7 | 6 | 28861 | 5 | |||
| 105928 | 177780 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Naylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002460.33828 | 2086926.38208 | 37.7104419769938 | -122.433284045522 | (37.7104419769938, -122.433284045522) | 9 | 7 | 6 | 28861 | 5 | |||
| 121644 | 177779 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Naylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002437.01172 | 2086956.49391 | 37.7105233341512 | -122.43336681733 | (37.7105233341512, -122.43336681733) | 9 | 7 | 6 | 28861 | 5 | |||
| 192899 | 177778 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 50 Naylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002419.92073 | 2086977.96609 | 37.7105813224323 | -122.433427420845 | (37.7105813224323, -122.433427420845) | 9 | 7 | 6 | 28861 | 5 | |||
| 168089 | 177580 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 765 Morse St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 5ft | 5998269.55663 | 2087006.20653 | 37.7104225210511 | -122.447773960118 | (37.7104225210511, -122.447773960118) | 9 | 7 | 6 | 28861 | 5 | |||
| 75111 | 1302 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4000X Alemany Blvd | 10 | Median : Cutout | Tree | DPW 1 | 25 | 10 | 5991739.11571 | 2087020.66511 | 37.7100868068254 | -122.470345390352 | (37.7100868068254, -122.470345390352) | 9 | 8 | 4 | 64 | 24 | |||
| 126655 | 177643 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5638 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5998365.81296 | 2087202.45771 | 37.7109668833845 | -122.447455395976 | (37.7109668833845, -122.447455395976) | 9 | 7 | 6 | 28861 | 25 | |||
| 143307 | 177642 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5638 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5998391.93487 | 2087219.0265 | 37.7110138702572 | -122.447366304614 | (37.7110138702572, -122.447366304614) | 9 | 7 | 6 | 28861 | 25 | |||
| 149816 | 65728 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 318 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/1990 12:00:00 AM | 8 | Permit Number 28662 | 6000516.37868 | 2087219.69055 | 37.7111368633441 | -122.440023784376 | (37.7111368633441, -122.440023784376) | 9 | 7 | 6 | 28861 | 5 | |
| 44394 | 96864 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620 Palmetto Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 2x2 | 5991921.11564 | 2087237.00736 | 37.7106913517985 | -122.469732108476 | (37.7106913517985, -122.469732108476) | 9 | 8 | 4 | 64 | 24 | |||
| 63558 | 110234 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 157 Rae Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 5997768.4937 | 2087242.59748 | 37.7110429453417 | -122.449522753872 | (37.7110429453417, -122.449522753872) | 9 | 7 | 6 | 28861 | 25 | |||
| 184809 | 96877 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620 Palmetto Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5991825.84937 | 2087243.04288 | 37.7107024170406 | -122.47006180623 | (37.7107024170406, -122.47006180623) | 9 | 8 | 4 | 64 | 24 | |||
| 53905 | 15892 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5630 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5998415.18601 | 2087264.53084 | 37.7111401434751 | -122.447289216406 | (37.7111401434751, -122.447289216406) | 9 | 7 | 6 | 28861 | 25 | |||
| 187093 | 15893 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 5630 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5998415.18601 | 2087264.53084 | 37.7111401434751 | -122.447289216406 | (37.7111401434751, -122.447289216406) | 9 | 7 | 6 | 28861 | 25 | |||
| 2147 | 1184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3014 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 5996622.2967 | 2087313.8651 | 37.7111729927061 | -122.453489407116 | (37.7111729927061, -122.453489407116) | 9 | 7 | 6 | 28861 | 25 | |||
| 105256 | 1289 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3982 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 7x5 | 5992193.06254 | 2087314.05023 | 37.7109186077819 | -122.468797809971 | (37.7109186077819, -122.468797809971) | 9 | 8 | 4 | 64 | 24 | |||
| 146258 | 1183 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3008 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5996645.29847 | 2087325.84579 | 37.7112072074278 | -122.453410772198 | (37.7112072074278, -122.453410772198) | 9 | 7 | 6 | 28861 | 25 | |||
| 100055 | 177594 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2973 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5996791.90428 | 2087327.24396 | 37.711219448989 | -122.452904169693 | (37.711219448989, -122.452904169693) | 9 | 7 | 6 | 28861 | 25 | |||
| 54583 | 1180 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 3000 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5996663.31767 | 2087335.28734 | 37.7112341646084 | -122.453349174921 | (37.7112341646084, -122.453349174921) | 9 | 7 | 6 | 28861 | 25 | |||
| 51061 | 177595 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2973 Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 5996814.56723 | 2087343.31681 | 37.7112648800324 | -122.45282700067 | (37.7112648800324, -122.45282700067) | 9 | 7 | 6 | 28861 | 25 | |||
| 7600 | 12920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
| 73401 | 12919 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2981X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x9 | 5996820.13855 | 2087345.5314 | 37.7112712800431 | -122.452807904632 | (37.7112712800431, -122.452807904632) | 9 | 7 | 6 | 28861 | 25 | |||
| 152809 | 65691 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 298 Pope St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/1990 12:00:00 AM | Permit Number 28617 | 6000465.61879312 | 2087349.15527737 | 37.7114894548419 | -122.440208500633 | (37.7114894548419, -122.440208500633) | 9 | 7 | 6 | 28861 | 5 |
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) );