trees
194,517 rows sorted by Longitude 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9242 | 119783 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
12246 | 119784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
15738 | 119781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
68996 | 119785 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
116078 | 119786 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
165603 | 119792 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
190843 | 119787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
34450 | 119816 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 12 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
37614 | 119819 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 3 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
57589 | 119826 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 10 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
73186 | 119818 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
77310 | 119820 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
77972 | 119824 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 8 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
89957 | 119827 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
156235 | 119817 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 1 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
173780 | 119823 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
175267 | 119821 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 5 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
178289 | 119822 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 6 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
187008 | 119825 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 302x Octavia St Frontage East | 9 | Median : Cutout | Tree | DPW 1 | 2110484 | 6005595 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | ||||||||||
154 | 119838 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
225 | 119839 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
406 | 119837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
428 | 119830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
4570 | 119828 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
10263 | 119836 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
15578 | 119832 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
139973 | 119829 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
178302 | 119833 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
178452 | 119834 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
180678 | 119831 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
50608 | 90293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
82205 | 90292 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
116691 | 90294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
127510 | 90951 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4899X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
160862 | 90295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4899X Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.7750226590497 | -122.511257155794 | (37.7750226590497, -122.511257155794) | 11 | 6 | 2 | 55 | 26 | |
46781 | 90290 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4825X Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980449 | 2110794 | 37.7747024934985 | -122.511131484433 | (37.7747024934985, -122.511131484433) | 11 | 6 | 2 | 55 | 26 | ||
22814 | 65028 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4875 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1989 12:00:00 AM | 3 | Permit Number 26080 | 5980518.0662 | 2110908.19812 | 37.77502012338 | -122.510901064292 | (37.77502012338, -122.510901064292) | 11 | 6 | 2 | 55 | 26 | ||
91851 | 90291 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4800X Balboa St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980520.08002 | 2110961.83438 | 37.7751675115073 | -122.510898085477 | (37.7751675115073, -122.510898085477) | 11 | 6 | 2 | 55 | 26 | ||
2953 | 118676 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4825 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5980559.76523 | 2110909.18852 | 37.7750253031785 | -122.510756894567 | (37.7750253031785, -122.510756894567) | 11 | 6 | 2 | 55 | 26 | |||
76279 | 118675 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4825 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5980581.14799 | 2110910.44383 | 37.7750300115108 | -122.510683021621 | (37.7750300115108, -122.510683021621) | 11 | 6 | 2 | 55 | 26 | |||
77244 | 90289 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4800X Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980602.31718 | 2110965.89815 | 37.7751835216483 | -122.510613916 | (37.7751835216483, -122.510613916) | 11 | 6 | 2 | 55 | 26 | ||
61519 | 118674 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4825 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5980614.91009 | 2110910.7476 | 37.7750328375051 | -122.510566255892 | (37.7750328375051, -122.510566255892) | 11 | 6 | 2 | 55 | 26 | |||
77683 | 118902 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 7300 Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980610.15564 | 2109606.19987 | 37.7714506535132 | -122.510485742594 | (37.7714506535132, -122.510485742594) | 11 | 6 | 2 | 55 | 26 | |
144815 | 90952 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4801 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980655.26522 | 2110913.31037 | 37.7750422548765 | -122.510426851738 | (37.7750422548765, -122.510426851738) | 11 | 6 | 2 | 55 | 26 | ||
181863 | 118901 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 7300 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779332 | 5980648.88475 | 2109606.36291 | 37.7714533859213 | -122.510351791198 | (37.7714533859213, -122.510351791198) | 11 | 6 | 2 | 55 | 26 | |
103558 | 118904 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 701 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980709.06279 | 2110874.30302 | 37.774938325765 | -122.510237858768 | (37.774938325765, -122.510237858768) | 11 | 6 | 2 | 55 | 26 | |||
78192 | 46282 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 705 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | 5 | Permit Number 44561 | 5980709.06285 | 2110831.64762 | 37.7748212066407 | -122.510234688625 | (37.7748212066407, -122.510234688625) | 11 | 6 | 2 | 55 | 26 | ||
186180 | 46284 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 711 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | 7 | Permit Number 44563 | 5980709.97353 | 2110788.74424 | 37.7747034603493 | -122.510228350103 | (37.7747034603493, -122.510228350103) | 11 | 6 | 2 | 55 | 26 | ||
104383 | 41420 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 725 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 6 | 5x5 | Permit Number 42027 | 5980710.81691 | 2110753.36996 | 37.7746063827707 | -122.510222803918 | (37.7746063827707, -122.510222803918) | 11 | 6 | 2 | 55 | 26 | |
108253 | 90950 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4800X Balboa St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980719.998472 | 2110962.378876 | 37.7751808011063 | -122.510206575867 | (37.7751808011063, -122.510206575867) | 11 | 6 | 2 | 55 | 26 | |
64182 | 90953 | DPW Maintained 1 | Dracaena draco :: Dragon Tree 156 | 4801 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980721.4437 | 2110922.404993 | 37.7750711298852 | -122.510198605975 | (37.7750711298852, -122.510198605975) | 11 | 6 | 2 | 55 | 26 | |
134919 | 46283 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 4801 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2002 12:00:00 AM | Permit Number 44562 | 5980721.66048407 | 2110916.40891105 | 37.7750546792032 | -122.510197410494 | (37.7750546792032, -122.510197410494) | 11 | 6 | 2 | 55 | 26 | |||
113922 | 41421 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 731A B C La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 7 | Permit Number 42028 | 5980717.31821 | 2110693.46667 | 37.774442289512 | -122.51019586344 | (37.774442289512, -122.51019586344) | 11 | 6 | 2 | 55 | 26 | ||
101064 | 41422 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 737A B C La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 7 | Permit Number 42029 | 5980718.37612 | 2110657.40313 | 37.7743433320773 | -122.510189524011 | (37.7743433320773, -122.510189524011) | 11 | 6 | 2 | 55 | 26 | ||
46558 | 41423 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 743A B C La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 6 | Permit Number 42030 | 5980719.58689 | 2110639.12886 | 37.7742932277433 | -122.510183977803 | (37.7742932277433, -122.510183977803) | 11 | 6 | 2 | 55 | 26 | ||
38854 | 40217 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 755 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1999 12:00:00 AM | 9 | Permit Number 41396 | 5980721.24963 | 2110609.89549 | 37.7742130596134 | -122.51017605379 | (37.7742130596134, -122.51017605379) | 11 | 6 | 2 | 55 | 26 | |
47234 | 118905 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 759 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5980723.1377 | 2110591.1502 | 37.7741617019468 | -122.51016812974 | (37.7741617019468, -122.51016812974) | 11 | 6 | 2 | 55 | 26 | |||
124925 | 118906 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 763 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5980722.84871 | 2110577.69802 | 37.7741247491826 | -122.510168129734 | (37.7741247491826, -122.510168129734) | 11 | 6 | 2 | 55 | 26 | |||
59157 | 118907 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 767 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980723.00275 | 2110520.89615 | 37.7739687970878 | -122.510163375859 | (37.7739687970878, -122.510163375859) | 11 | 6 | 2 | 55 | 26 | |||
153617 | 118910 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 779 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5980721.87491 | 2110457.73462 | 37.7737953076248 | -122.510162583557 | (37.7737953076248, -122.510162583557) | 11 | 6 | 2 | 55 | 26 | |||
148415 | 118909 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 775 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5980722.52384 | 2110466.61703 | 37.7738197343812 | -122.510160998907 | (37.7738197343812, -122.510160998907) | 11 | 6 | 2 | 55 | 26 | |||
120926 | 118908 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 771 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980724.52574 | 2110506.49264 | 37.7739293391312 | -122.510157037335 | (37.7739293391312, -122.510157037335) | 11 | 6 | 2 | 55 | 26 | |||
98871 | 118911 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 783 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5980723.51809 | 2110427.58911 | 37.7737126338651 | -122.510154659499 | (37.7737126338651, -122.510154659499) | 11 | 6 | 2 | 55 | 26 | |||
87742 | 118912 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 787 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5980724.35298 | 2110402.47948 | 37.7736437394687 | -122.510149905624 | (37.7736437394687, -122.510149905624) | 11 | 6 | 2 | 55 | 26 | |||
45822 | 118913 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 791 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980726.27409 | 2110374.60886 | 37.7735673282771 | -122.51014118926 | (37.7735673282771, -122.51014118926) | 11 | 6 | 2 | 55 | 26 | |||
63024 | 118914 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 795 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5980726.65599 | 2110349.737 | 37.7734990600053 | -122.510138020006 | (37.7734990600053, -122.510138020006) | 11 | 6 | 2 | 55 | 26 | |||
75255 | 118899 | Undocumented 4 | Myoporum laetum :: Myoporum 62 | 7300 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 4ft | 5980716.90165 | 2109609.13106 | 37.771464998604 | -122.510116727255 | (37.771464998604, -122.510116727255) | 11 | 6 | 2 | 55 | 26 | ||||
129300 | 118915 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 825 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 4x4 | 5980733.09837 | 2110116.47079 | 37.772858959689 | -122.510098401613 | (37.772858959689, -122.510098401613) | 11 | 6 | 2 | 55 | 26 | ||
100506 | 79125 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.7727211685223 | -122.510088100636 | (37.7727211685223, -122.510088100636) | 11 | 6 | 2 | 55 | 26 | ||
179493 | 118916 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 825 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 4x4 | 5980736.9232 | 2110038.60279 | 37.7726453826771 | -122.510079385172 | (37.7726453826771, -122.510079385172) | 11 | 6 | 2 | 55 | 26 | |||
192842 | 119167 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 716 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980755.1675 | 2110858.13796 | 37.7748966607872 | -122.510077174438 | (37.7748966607872, -122.510077174438) | 11 | 6 | 2 | 55 | 26 | |||
172058 | 119168 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 716 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980756.29412 | 2110846.59632 | 37.7748650373033 | -122.510072419645 | (37.7748650373033, -122.510072419645) | 11 | 6 | 2 | 55 | 26 | |||
128269 | 118917 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 855 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | 4x4 | 5980738.79777 | 2109987.23765 | 37.772504459681 | -122.510069084185 | (37.772504459681, -122.510069084185) | 11 | 6 | 2 | 55 | 26 | ||
157079 | 119174 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 738 La Playa | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 7 | Width 8ft | 5980754.24139 | 2110680.27075 | 37.7744082353086 | -122.510067160899 | (37.7744082353086, -122.510067160899) | 11 | 6 | 2 | 55 | 26 | |||
141530 | 118918 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 855 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5980739.80677 | 2109948.89302 | 37.7723992361183 | -122.510062744773 | (37.7723992361183, -122.510062744773) | 11 | 6 | 2 | 55 | 26 | |||
92257 | 118919 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 855 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 5980739.30228 | 2109925.40839 | 37.7723347244745 | -122.510062744769 | (37.7723347244745, -122.510062744769) | 11 | 6 | 2 | 55 | 26 | |||
51937 | 119173 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 738 La Playa | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5980756.1033 | 2110688.30545 | 37.7744304060443 | -122.510061317362 | (37.7744304060443, -122.510061317362) | 11 | 6 | 2 | 55 | 26 | |||
41118 | 119176 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 8ft | 5980756.08521 | 2110656.0073 | 37.7743417237871 | -122.510058979927 | (37.7743417237871, -122.510058979927) | 11 | 6 | 2 | 55 | 26 | |||
176100 | 90288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4790X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980763.025413 | 2110963.934321 | 37.7751876098256 | -122.51005785431 | (37.7751876098256, -122.51005785431) | 11 | 6 | 2 | 55 | 26 | |
36996 | 118924 | DPW Maintained 1 | Juniperus chinensis :: Juniper 113 | 855 La Playa | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 01/05/2017 12:00:00 AM | 3 | Width 4ft | 5980738.40206 | 2109808.86226 | 37.7720146699664 | -122.510057198601 | (37.7720146699664, -122.510057198601) | 11 | 6 | 2 | 55 | 26 | ||
8267 | 119175 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 742 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 8ft | 5980756.90149 | 2110662.55033 | 37.7743597371632 | -122.510056642513 | (37.7743597371632, -122.510056642513) | 11 | 6 | 2 | 55 | 26 | |||
187545 | 118920 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 855 La Playa | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5980740.60981 | 2109900.97244 | 37.7722677076623 | -122.510056406253 | (37.7722677076623, -122.510056406253) | 11 | 6 | 2 | 55 | 26 | |||
3579 | 119169 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 720 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5980759.87673 | 2110793.19365 | 37.7747186206505 | -122.510056058609 | (37.7747186206505, -122.510056058609) | 11 | 6 | 2 | 55 | 26 | |||
152855 | 119170 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 728 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5980760.8194 | 2110774.16468 | 37.7746664283171 | -122.510051383777 | (37.7746664283171, -122.510051383777) | 11 | 6 | 2 | 55 | 26 | |||
35335 | 118921 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 855 La Playa | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5980742.3657 | 2109876.07038 | 37.7721994374932 | -122.510048482225 | (37.7721994374932, -122.510048482225) | 11 | 6 | 2 | 55 | 26 | |||
185671 | 119171 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 734 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5980760.66584 | 2110719.83278 | 37.7745172398983 | -122.510047877677 | (37.7745172398983, -122.510047877677) | 11 | 6 | 2 | 55 | 26 | |||
67610 | 119172 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 734 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5980761.41272 | 2110715.27486 | 37.7745047692475 | -122.510044955434 | (37.7745047692475, -122.510044955434) | 11 | 6 | 2 | 55 | 26 | |||
161371 | 118923 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 855 La Playa | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5980744.20111 | 2109822.88075 | 37.7720535026603 | -122.510038181246 | (37.7720535026603, -122.510038181246) | 11 | 6 | 2 | 55 | 26 | |||
167368 | 118925 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 855 La Playa | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5980744.81689 | 2109798.23147 | 37.7719858593014 | -122.510034219696 | (37.7719858593014, -122.510034219696) | 11 | 6 | 2 | 55 | 26 | |||
176447 | 119177 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 750 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5980764.81035 | 2110613.93297 | 37.7742267147145 | -122.510025672196 | (37.7742267147145, -122.510025672196) | 11 | 6 | 2 | 55 | 26 | |||
125459 | 83542 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 5980747.69672 | 2109761.67142 | 37.7718856460039 | -122.510021541764 | (37.7718856460039, -122.510021541764) | 11 | 6 | 2 | 55 | 26 | ||
136118 | 119178 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5980765.96509 | 2110596.91774 | 37.7741800640196 | -122.510020413475 | (37.7741800640196, -122.510020413475) | 11 | 6 | 2 | 55 | 26 | |||
56411 | 119179 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | Width 3ft | 5980765.91375 | 2110586.65735 | 37.7741518889865 | -122.510019828655 | (37.7741518889865, -122.510019828655) | 11 | 6 | 2 | 55 | 26 | |||
95441 | 119180 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5980766.80768 | 2110581.0869 | 37.7741366468987 | -122.510016322531 | (37.7741366468987, -122.510016322531) | 11 | 6 | 2 | 55 | 26 | |||
101951 | 50783 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 770 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2018 12:00:00 AM | 14 | Permit Number 47309 | 5980766.08534 | 2110461.55309 | 37.7738083996933 | -122.510009939122 | (37.7738083996933, -122.510009939122) | 11 | 6 | 2 | 55 | 26 | ||
168099 | 118926 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 875 La Playa | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5980750.36595 | 2109715.30711 | 37.7717585006639 | -122.510008863841 | (37.7717585006639, -122.510008863841) | 11 | 6 | 2 | 55 | 26 | ||
143794 | 118927 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 875 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5980750.45803 | 2109699.47585 | 37.7717150381052 | -122.510007369019 | (37.7717150381052, -122.510007369019) | 11 | 6 | 2 | 55 | 26 | ||
28190 | 118928 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 875 La Playa | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5980750.07937 | 2109680.63976 | 37.7716632974006 | -122.51000727922 | (37.7716632974006, -122.51000727922) | 11 | 6 | 2 | 55 | 26 | ||
61314 | 119181 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 758 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | Width 3ft | 5980769.04237 | 2110551.43207 | 37.7740553552846 | -122.510006388961 | (37.7740553552846, -122.510006388961) | 11 | 6 | 2 | 55 | 26 | |||
53123 | 119182 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 770 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/08/2018 08:55:00 AM | 3 | Width 3ft | 5980768.60163 | 2110516.49212 | 37.7739593944882 | -122.510005317294 | (37.7739593944882, -122.510005317294) | 11 | 6 | 2 | 55 | 26 |
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) );