trees
8,758 rows where qSpecies_id = 16 sorted by XCoord descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 158752 | 193831 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 351 Cargo Way | 17 | : | Tree | Private 2 | 8 | Width 3ft | 6017496.31387 | 2098500.41004 | 37.7430635397576 | -122.382120602585 | (37.7430635397576, -122.382120602585) | 10 | 3 | 8 | 58 | 1 | |||
| 163867 | 193967 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 599 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6017494.4463 | 2096301.95703 | 37.7370269259389 | -122.381974170481 | (37.7370269259389, -122.381974170481) | 10 | 3 | 8 | 58 | 1 | |||
| 13488 | 200023 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1550 Griffith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6017489.0598 | 2092100.1023 | 37.7254891615497 | -122.381700645666 | (37.7254891615497, -122.381700645666) | 10 | 3 | 8 | 58 | 1 | |||
| 129606 | 193981 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6017456.57186 | 2096356.73609 | 37.7371752466304 | -122.382108930285 | (37.7371752466304, -122.382108930285) | 10 | 3 | 8 | 58 | 1 | |||
| 89535 | 59851 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1119 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1981 12:00:00 AM | Permit Number 19307 | 6017428.44424481 | 2093319.71178593 | 37.7288346243781 | -122.381994988143 | (37.7288346243781, -122.381994988143) | 10 | 3 | 8 | 58 | 1 | ||
| 56654 | 193982 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017413.08546 | 2096375.70861 | 37.7372249395861 | -122.38226060364 | (37.7372249395861, -122.38226060364) | 10 | 3 | 8 | 58 | 1 | |||
| 9199 | 59852 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1123 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | 4x4 | Permit Number 19308 | 6017402.1303 | 2093334.4078 | 37.7288735235199 | -122.382086980049 | (37.7288735235199, -122.382086980049) | 10 | 3 | 8 | 58 | 1 |
| 118345 | 11884 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017395.5575924 | 2096373.0107113 | 37.7372165635579 | -122.382321018478 | (37.7372165635579, -122.382321018478) | 10 | 3 | 8 | 58 | 1 | |||
| 124489 | 11885 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 450X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/24/1998 12:00:00 AM | 6 | 4X4 | 6017395.5575924 | 2096373.0107113 | 37.7372165635579 | -122.382321018478 | (37.7372165635579, -122.382321018478) | 10 | 3 | 8 | 58 | 1 | ||
| 107712 | 193983 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6017392.53863 | 2096382.36228 | 37.7372420743459 | -122.382332106939 | (37.7372420743459, -122.382332106939) | 10 | 3 | 8 | 58 | 1 | |||
| 171696 | 193966 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6017384.08087 | 2096328.02614 | 37.7370924109796 | -122.382357570353 | (37.7370924109796, -122.382357570353) | 10 | 3 | 8 | 58 | 1 | |||
| 5831 | 11910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 20694 | 11897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 36616 | 11906 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 38781 | 11911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 62677 | 11903 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 102729 | 11904 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 112932 | 11912 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 118406 | 11908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | |||
| 138222 | 11900 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 172664 | 11913 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | Permit Number 769095 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 184007 | 11901 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 495 Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/23/2002 12:00:00 AM | 18 | 3x3 | 6017380.0742244 | 2096325.4684637 | 37.7370851667986 | -122.382371245383 | (37.7370851667986, -122.382371245383) | 10 | 3 | 8 | 58 | 1 | ||
| 51477 | 11891 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2016 02:46:00 PM | 3 | 3X4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | ||
| 133473 | 11890 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 135913 | 11892 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 148595 | 11894 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 151081 | 11893 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 610X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6017375.6982661 | 2096379.4784168 | 37.7372332256353 | -122.382390131809 | (37.7372332256353, -122.382390131809) | 10 | 3 | 8 | 58 | 1 | |||
| 51676 | 193984 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017366.37274 | 2096390.06542 | 37.7372617803131 | -122.382423111136 | (37.7372617803131, -122.382423111136) | 10 | 3 | 8 | 58 | 1 | |||
| 144264 | 11914 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 611 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6017360.2148981 | 2096331.9361692 | 37.737101828847 | -122.382440358603 | (37.737101828847, -122.382440358603) | 10 | 3 | 8 | 58 | 1 | |||
| 9136 | 11920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 46481 | 11921 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/1993 12:00:00 AM | 12 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | ||
| 107946 | 11924 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 110103 | 11919 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 124074 | 11925 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 128011 | 11917 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 149343 | 11923 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 184963 | 11918 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 620X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017350.6902257 | 2096387.6229349 | 37.7372542074531 | -122.382477163454 | (37.7372542074531, -122.382477163454) | 10 | 3 | 8 | 58 | 1 | |||
| 125895 | 11915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 615 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017349.9174697 | 2096335.2897942 | 37.7371104684115 | -122.382476195099 | (37.7371104684115, -122.382476195099) | 10 | 3 | 8 | 58 | 1 | |||
| 87934 | 193985 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017346.74675 | 2096395.76454 | 37.7372763448378 | -122.382491364312 | (37.7372763448378, -122.382491364312) | 10 | 3 | 8 | 58 | 1 | |||
| 10286 | 193965 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6017340.35978 | 2096340.01342 | 37.7371229105773 | -122.382509569261 | (37.7371229105773, -122.382509569261) | 10 | 3 | 8 | 58 | 1 | |||
| 64547 | 11916 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 619 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017340.3555719 | 2096338.4038747 | 37.7371184908548 | -122.382509471853 | (37.7371184908548, -122.382509471853) | 10 | 3 | 8 | 58 | 1 | |||
| 53780 | 11895 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604X Keith St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017303.30396 | 2096401.31923 | 37.7372891970298 | -122.382641953956 | (37.7372891970298, -122.382641953956) | 10 | 3 | 8 | 58 | 1 | |||
| 17523 | 11896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 603 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/04/2017 12:00:00 AM | 3 | 3x3 | 6017299.30184 | 2096353.90744 | 37.7371587926313 | -122.382652493121 | (37.7371587926313, -122.382652493121) | 10 | 3 | 8 | 58 | 1 | ||
| 96730 | 193986 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6017278.04637 | 2096407.44384 | 37.7373046186106 | -122.382729708036 | (37.7373046186106, -122.382729708036) | 10 | 3 | 8 | 58 | 1 | |||
| 18742 | 60351 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1151 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 13 | Permit Number 19929 | 6017264.1776 | 2093436.6356 | 37.7291466011683 | -122.382571007193 | (37.7291466011683, -122.382571007193) | 10 | 3 | 8 | 58 | 1 | |
| 172017 | 193987 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6017255.03161 | 2096416.01942 | 37.7373268939148 | -122.382809878088 | (37.7373268939148, -122.382809878088) | 10 | 3 | 8 | 58 | 1 | |||
| 3066 | 11935 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017236.56511 | 2096428.9556383 | 37.7373613939034 | -122.382874625964 | (37.7373613939034, -122.382874625964) | 10 | 3 | 8 | 58 | 1 | |||
| 58424 | 11934 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017236.56511 | 2096428.9556383 | 37.7373613939034 | -122.382874625964 | (37.7373613939034, -122.382874625964) | 10 | 3 | 8 | 58 | 1 | |||
| 98525 | 193988 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6017233.92755 | 2096426.11724 | 37.7373534545004 | -122.382883547851 | (37.7373534545004, -122.382883547851) | 10 | 3 | 8 | 58 | 1 | |||
| 75192 | 11937 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017227.6542782 | 2096435.1103852 | 37.7373778012685 | -122.382905863363 | (37.7373778012685, -122.382905863363) | 10 | 3 | 8 | 58 | 1 | |||
| 141313 | 11939 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 660X Keith St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017219.3799344 | 2096440.8255073 | 37.7373930366714 | -122.38293486953 | (37.7373930366714, -122.38293486953) | 10 | 3 | 8 | 58 | 1 | |||
| 90788 | 193989 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6017215.04094 | 2096437.418 | 37.7373834405944 | -122.382949634528 | (37.7373834405944, -122.382949634528) | 10 | 3 | 8 | 58 | 1 | |||
| 8323 | 10894 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 21418 | 10896 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 162384 | 10898 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 163230 | 10897 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 168671 | 10899 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 178241 | 10900 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 183425 | 10895 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1300X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017213.3373221 | 2095437.5732367 | 37.7346379721127 | -122.382885962987 | (37.7346379721127, -122.382885962987) | 10 | 3 | 8 | 58 | 1 | |||
| 49105 | 11941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690X Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017210.4691026 | 2096446.9802542 | 37.7374094440205 | -122.382966106955 | (37.7374094440205, -122.382966106955) | 10 | 3 | 8 | 58 | 1 | |||
| 94364 | 11936 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 671 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017208.149229 | 2096387.8151752 | 37.7372468603658 | -122.382970011468 | (37.7372468603658, -122.382970011468) | 10 | 3 | 8 | 58 | 1 | |||
| 65615 | 11944 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017197.7393428 | 2096455.7727498 | 37.7374328830762 | -122.383010731872 | (37.7374328830762, -122.383010731872) | 10 | 3 | 8 | 58 | 1 | |||
| 51947 | 194004 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1040 Palou Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6017196.67156 | 2093557.92535 | 37.729475909582 | -122.38281282065 | (37.729475909582, -122.38281282065) | 10 | 3 | 8 | 58 | 1 | |||
| 61169 | 11947 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690X Keith St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6017193.2839269 | 2096458.8501232 | 37.7374410867415 | -122.3830263506 | (37.7374410867415, -122.3830263506) | 10 | 3 | 8 | 58 | 1 | |||
| 115418 | 11945 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 690X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6017193.2839269 | 2096458.8501232 | 37.7374410867415 | -122.3830263506 | (37.7374410867415, -122.3830263506) | 10 | 3 | 8 | 58 | 1 | |||
| 50037 | 59853 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1167 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/2015 12:00:00 AM | 3 | 3x3 | Permit Number 19309 | 6017186.1327 | 2093497.6426 | 37.7293098027153 | -122.382845061392 | (37.7293098027153, -122.382845061392) | 10 | 3 | 8 | 58 | 1 |
| 72347 | 193990 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6017178.35833 | 2096467.48683 | 37.7374639766737 | -122.38307855683 | (37.7374639766737, -122.38307855683) | 10 | 3 | 8 | 58 | 1 | |||
| 65685 | 60352 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1171 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19930 | 6017163.09585765 | 2093517.51572031 | 37.7293630975772 | -122.382926085128 | (37.7293630975772, -122.382926085128) | 10 | 3 | 8 | 58 | 1 | ||
| 182719 | 193991 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6017161.38899 | 2096480.62152 | 37.7374991042091 | -122.383138142322 | (37.7374991042091, -122.383138142322) | 10 | 3 | 8 | 58 | 1 | |||
| 37877 | 193992 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6017139.75256 | 2096495.41015 | 37.737538515194 | -122.383213979456 | (37.737538515194, -122.383213979456) | 10 | 3 | 8 | 58 | 1 | |||
| 6976 | 59854 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1182 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 18 | Permit Number 19310 | 6017139.45768 | 2093603.92018 | 37.7295990411395 | -122.38301381645 | (37.7295990411395, -122.38301381645) | 10 | 3 | 8 | 58 | 1 | |
| 30065 | 107237 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 HUDSON AVE | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 6017131 | 2095773 | 37.7355544375929 | -122.383193973215 | (37.7355544375929, -122.383193973215) | 10 | 3 | 8 | 58 | 1 | ||||
| 25769 | 193993 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6017119.98315 | 2096509.53696 | 37.7375762120827 | -122.383283315377 | (37.7375762120827, -122.383283315377) | 10 | 3 | 8 | 58 | 1 | |||
| 4026 | 60353 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1183 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1982 12:00:00 AM | 11 | Permit Number 19931 | 6017103.6909 | 2093557.0007 | 37.729468233098 | -122.383134202737 | (37.729468233098, -122.383134202737) | 10 | 3 | 8 | 58 | 1 | |
| 189007 | 193994 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 19 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6017099.24247 | 2096522.12365 | 37.7376096263918 | -122.383355902368 | (37.7376096263918, -122.383355902368) | 10 | 3 | 8 | 58 | 1 | |||
| 37082 | 10908 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1994 12:00:00 AM | 18 | 3X4 | 6017092.2050139 | 2095860.328118 | 37.7357920792709 | -122.383334180509 | (37.7357920792709, -122.383334180509) | 10 | 3 | 8 | 58 | 1 | ||
| 142861 | 10907 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X4 | 6017092.2050139 | 2095860.328118 | 37.7357920792709 | -122.383334180509 | (37.7357920792709, -122.383334180509) | 10 | 3 | 8 | 58 | 1 | |||
| 80687 | 40039 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1190 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/03/1999 12:00:00 AM | 23 | Permit Number 41276 | 6017077.86387 | 2093649.33383 | 37.729720334504 | -122.383229914525 | (37.729720334504, -122.383229914525) | 10 | 3 | 8 | 58 | 1 | |
| 37960 | 193995 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 604 Keith St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6017076.54744 | 2096531.00508 | 37.7376327587424 | -122.383434988751 | (37.7376327587424, -122.383434988751) | 10 | 3 | 8 | 58 | 1 | |||
| 137013 | 10931 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1344X Hudson Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017075.7448059 | 2095947.2070815 | 37.7360297218772 | -122.383397136361 | (37.7360297218772, -122.383397136361) | 10 | 3 | 8 | 58 | 1 | |||
| 175467 | 10927 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1338X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/05/1990 12:00:00 AM | 18 | 3X3 | 6017075.37575 | 2095929.58108 | 37.7359813040002 | -122.383397185751 | (37.7359813040002, -122.383397185751) | 10 | 3 | 8 | 58 | 1 | ||
| 14134 | 10928 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1338X Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017067.78489 | 2095945.48919 | 37.7360245649694 | -122.383424537716 | (37.7360245649694, -122.383424537716) | 10 | 3 | 8 | 58 | 1 | |||
| 64572 | 3815 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101X Cashmere St | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | |||
| 171762 | 3812 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 101X Cashmere St | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017067.4579304 | 2095837.0108628 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | 10 | 3 | 8 | 58 | 1 | |||
| 79647 | 10929 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1338X Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/30/2018 08:49:00 AM | 3 | 3X4 | 6017066.3628 | 2095973.08997 | 37.7361002726033 | -122.383431375281 | (37.7361002726033, -122.383431375281) | 10 | 3 | 8 | 58 | 1 | ||
| 88533 | 10903 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017060.94718 | 2095998.80172 | 37.7361705726225 | -122.383451888802 | (37.7361705726225, -122.383451888802) | 10 | 3 | 8 | 58 | 1 | |||
| 69173 | 193954 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6017057.38952 | 2096018.56782 | 37.7362246497575 | -122.383465564789 | (37.7362246497575, -122.383465564789) | 10 | 3 | 8 | 58 | 1 | |||
| 98260 | 193955 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6017052.93578 | 2096042.94715 | 37.7362913443725 | -122.383482659998 | (37.7362913443725, -122.383482659998) | 10 | 3 | 8 | 58 | 1 | |||
| 156177 | 10906 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1340 Hudson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017046.99341 | 2096075.23411 | 37.7363796694793 | -122.383505452431 | (37.7363796694793, -122.383505452431) | 10 | 3 | 8 | 58 | 1 | |||
| 16384 | 59855 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1195 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1981 12:00:00 AM | 14 | Permit Number 19312 | 6017044.3327 | 2093602.6185 | 37.7295902103514 | -122.383342586023 | (37.7295902103514, -122.383342586023) | 10 | 3 | 8 | 58 | 1 | |
| 169020 | 11940 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 679 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6017037.35977 | 2096493.77854 | 37.7375283762364 | -122.383567889663 | (37.7375283762364, -122.383567889663) | 10 | 3 | 8 | 58 | 1 | |||
| 125169 | 10922 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1351X Hudson Ave | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017030.05127 | 2095928.88949 | 37.735976899997 | -122.383553844033 | (37.735976899997, -122.383553844033) | 10 | 3 | 8 | 58 | 1 | |||
| 139283 | 193996 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 680 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017028.16872 | 2096540.40353 | 37.7376558911012 | -122.38360291284 | (37.7376558911012, -122.38360291284) | 10 | 3 | 8 | 58 | 1 | |||
| 56666 | 10921 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1351X Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017026.43196 | 2095954.4439 | 37.7360468672572 | -122.383568136056 | (37.7360468672572, -122.383568136056) | 10 | 3 | 8 | 58 | 1 | |||
| 84299 | 193956 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1342 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6017023.66 | 2096205.64565 | 37.7367364638197 | -122.383595202961 | (37.7367364638197, -122.383595202961) | 10 | 3 | 8 | 58 | 1 | |||
| 87224 | 10920 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1351X Hudson Ave | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017020.81363 | 2095978.47036 | 37.7361125285794 | -122.383589233257 | (37.7361125285794, -122.383589233257) | 10 | 3 | 8 | 58 | 1 | |||
| 125912 | 193957 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1342 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6017017.13984 | 2096224.31817 | 37.736787374435 | -122.383619045805 | (37.736787374435, -122.383619045805) | 10 | 3 | 8 | 58 | 1 | |||
| 7156 | 10925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1345X Hudson Ave | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 10 | 3 | 8 | 58 | 1 | |||
| 83860 | 10915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1345X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 10 | 3 | 8 | 58 | 1 | |||
| 104355 | 10926 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1345X Hudson Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6017013.5679363 | 2096006.7331036 | 37.7361897319358 | -122.383616251853 | (37.7361897319358, -122.383616251853) | 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) );