trees
22 rows where SiteOrder = 1 and qLegalStatus_id = 11 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4150 | 111749 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 4124 23rd St | 1 | Back Yard : Yard | Tree | Private 2 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | 2 | 4 | 5 | 28862 | 22 | |||||
4378 | 264740 | Landmark tree 11 | Araucaria heterophylla :: Norfolk Island Pine 238 | 2040 Sutter St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002718 | 2114518 | 37.7862166771353 | -122.434364894821 | (37.7862166771353, -122.434364894821) | 13 | 9 | 11 | 29490 | 27 | ||||
10284 | 262216 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 4124 23rd St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002319 | 2102413 | 37.7529566754079 | -122.43487933109 | (37.7529566754079, -122.43487933109) | 2 | 4 | 5 | 28862 | 22 | ||||
15348 | 264739 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 1 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
16246 | 262100 | Landmark tree 11 | Sequoiadendron giganteum :: Sierra Redwood 240 | 3066 Market St | 1 | Back Yard : Yard | Tree | Private 2 | 6000145.77567 | 2105436.95685 | 37.7611360918542 | -122.442611833669 | (37.7611360918542, -122.442611833669) | 15 | 5 | 5 | 28862 | 3 | |||||
17641 | 262215 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6001000 | 2117623 | 37.7946445343139 | -122.440531492639 | (37.7946445343139, -122.440531492639) | 13 | 9 | 1 | 57 | 27 | ||||
18463 | 262218 | Landmark tree 11 | Sequoia sempervirens :: Coast Redwood 155 | 46 Stillings Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6000246 | 2095728 | 37.7344833413152 | -122.441568452522 | (37.7344833413152, -122.441568452522) | 9 | 7 | 5 | 63 | 40 | ||||
27160 | 111763 | Landmark tree 11 | Cupressus macrocarpa :: Monterey Cypress 41 | 2626 Vallejo St | 1 | Back Yard : Yard | Tree | Private 2 | 6001000.6 | 2117623.4 | 37.7946456667745 | -122.440529445268 | (37.7946456667745, -122.440529445268) | 13 | 9 | 1 | 57 | 27 | |||||
28932 | 105444 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard | Tree | Private 2 | 6005075.5 | 2108088.5 | 37.7686963767089 | -122.425750755404 | (37.7686963767089, -122.425750755404) | 8 | 4 | 5 | 28853 | 19 | |||||
64831 | 111748 | Landmark tree 11 | Aesculus californica :: California Buckeye 168 | 730 28th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5987294.2 | 2110946.4 | 37.7755225253955 | -122.487464059213 | (37.7755225253955, -122.487464059213) | 11 | 6 | 2 | 55 | 26 | |||||
16407 | 262217 | Landmark tree 11 | Sambucus mexicana :: Blue Elderberry 367 | 3440X Folsom St | 1 | Front Yard : Cutout | Tree | Rec/Park 5 | 3x3 | 6008633 | 2098934 | 37.7437605844193 | -122.412798302433 | (37.7437605844193, -122.412798302433) | 2 | 7 | 7 | 28859 | 2 | ||||
16836 | 255909 | Landmark tree 11 | Aesculus californica :: California Buckeye 168 | 2694 McAllister St | 1 | Front Yard : Yard | Tree | Private 2 | Under Review | 5996297 | 2110789 | 37.7756112723889 | -122.456310013186 | (37.7756112723889, -122.456310013186) | 11 | 6 | 2 | 54 | 16 | ||||
100815 | 111757 | Landmark tree 11 | Sambucus mexicana :: Blue Elderberry 367 | 3440X Folsom St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6008633.69746 | 2098934.7859 | 37.743762781475 | -122.412795946324 | (37.743762781475, -122.412795946324) | 2 | 7 | 7 | 28859 | 2 | |||||
172915 | 248932 | Landmark tree 11 | Araucaria heterophylla :: Norfolk Island Pine 238 | 46 Cook St | 1 | Front Yard : Yard | Tree | Private 2 | Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 | 5997514 | 2113392 | 37.7828282170553 | -122.452288002469 | (37.7828282170553, -122.452288002469) | 15 | 6 | 1 | 54 | 31 | ||||
177148 | 22364 | Landmark tree 11 | Schinus terebinthifolius :: Brazilian Pepper 93 | 5490X 03rd St | 1 | Median : Cutout | Tree | DPW 1 | 48 | 40TR | 6014151.6099 | 2093070.9929 | 37.7279701830365 | -122.393305916851 | (37.7279701830365, -122.393305916851) | 10 | 3 | 8 | 58 | 1 | |||
40100 | 251597 | Landmark tree 11 | Ficus macrophylla :: Morton Bay Fig 322 | 1650 Valencia St | 1 | Side Yard : Yard | Tree | Private 2 | 6006336 | 2100501 | 37.7479340151765 | -122.420852023863 | (37.7479340151765, -122.420852023863) | 2 | 7 | 7 | 28859 | 2 | |||||
18571 | 138024 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248 | (37.7877405482561, -122.42694291248) | 13 | 9 | 11 | 28858 | 27 | |||
40122 | 2614 | Landmark tree 11 | Eucalyptus globulus :: Blue Gum 56 | 1661X Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.7877691866782 | -122.426932689756 | (37.7877691866782, -122.426932689756) | 13 | 9 | 11 | 28858 | 27 | |||
49220 | 7946 | Landmark tree 11 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1701 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005703.15328 | 2116043.32965 | 37.7905738421571 | -122.424145551273 | (37.7905738421571, -122.424145551273) | 13 | 9 | 1 | 28858 | 27 | |||
51932 | 253858 | Landmark tree 11 | Arctostaphylos manzanita 'Dr Hurd' :: Dr. Hurd Manzanita 417 | 115 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5996817 | 2113681 | 37.7835817804999 | -122.454720202744 | (37.7835817804999, -122.454720202744) | 11 | 6 | 1 | 54 | 31 | ||||
144603 | 231331 | Landmark tree 11 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1221 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | 25 | Width 4ft | Permit Number 25220 | 5997416.53254 | 2105659.95446 | 37.7615924319549 | -122.452067155375 | (37.7615924319549, -122.452067155375) | 15 | 5 | 11 | 29492 | 12 | |
167750 | 64380 | Landmark tree 11 | Metrosideros excelsa 'Aurea' :: 471 | 1221 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/1988 12:00:00 AM | Permit Number 25220 | 5997415.00742592 | 2105661.0761541 | 37.7615954244829 | -122.452072511028 | (37.7615954244829, -122.452072511028) | 15 | 5 | 11 | 29492 | 12 |
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) );