trees
28 rows where PlotSize = "" and qLegalStatus_id = 11 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9418 | 251108 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 2 | Median : Yard | Tree | DPW 1 | |||||||||||||||
10155 | 251115 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 19 | Median : Yard | Tree | DPW 1 | |||||||||||||||
12966 | 251112 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 14 | Median : | Tree | DPW 1 | |||||||||||||||
13313 | 251111 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 7 | Median : Yard | Tree | DPW 1 | |||||||||||||||
13831 | 251113 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 15 | Median : Yard | Tree | DPW 1 | |||||||||||||||
15958 | 251109 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 3 | Median : Yard | Tree | DPW 1 | |||||||||||||||
15995 | 251116 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 20 | Median : Yard | Tree | DPW 1 | |||||||||||||||
19170 | 251114 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 16 | Median : Yard | Tree | DPW 1 | |||||||||||||||
19478 | 251110 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700X Quesada Ave | 5 | Median : Yard | Tree | DPW 1 | |||||||||||||||
45318 | 194287 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 32 | Median : Yard | Tree | DPW 1 | 31 | 6014435.32238 | 2095233.37666 | 37.7339234087228 | -122.392476296866 | (37.7339234087228, -122.392476296866) | 10 | 3 | 8 | 58 | 1 | ||||
25166 | 194288 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 37 | Median : Yard | Tree | DPW 1 | 34 | 6014411.93404 | 2095259.01392 | 37.7339925045513 | -122.392558950849 | (37.7339925045513, -122.392558950849) | 10 | 3 | 8 | 58 | 1 | ||||
62567 | 194289 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 38 | Median : Yard | Tree | DPW 1 | 48 | 6014396.14271 | 2095264.76436 | 37.734007417094 | -122.392613948889 | (37.734007417094, -122.392613948889) | 10 | 3 | 8 | 58 | 1 | ||||
65015 | 194291 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 1700x Quesada Ave | 41 | Median : Yard | Tree | DPW 1 | 38 | 6014364.32912 | 2095287.31351 | 37.7340675655682 | -122.392725516077 | (37.7340675655682, -122.392725516077) | 10 | 3 | 8 | 58 | 1 | ||||
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 | |||||
92644 | 113742 | Landmark tree 11 | Ficus macrophylla :: Morton Bay Fig 322 | 1580 Valencia St | 2 | Front Yard : Yard | Tree | Private 2 | 80 | 6006496 | 2100402 | 37.747671200831 | -122.420291724307 | (37.747671200831, -122.420291724307) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
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 | |||||
126945 | 255504 | Landmark tree 11 | Aesculus californica :: California Buckeye 168 | 757 Pennsylvania Ave | 7 | Back Yard : Yard | Tree | Private 2 | FUF | 6014476.10973 | 2103508.37921 | 37.7566470977886 | -122.392914033755 | (37.7566470977886, -122.392914033755) | 10 | 3 | 8 | 28856 | 29 | ||||
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 | |||||
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 | |||
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 | |||||
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 | ||||
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 | |||||
146489 | 111205 | Landmark tree 11 | Araucaria heterophylla :: Norfolk Island Pine 238 | 46 COOK ST | Back Yard : Yard | Tree | Private 2 | 36 | 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 | ||||
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 | ||||
1493 | 264741 | Landmark tree 11 | Phoenix canariensis :: Canary Island Date Palm 160 | 2040 Sutter St | 2 | Back Yard : Yard | Tree | Private 2 | 6002832.74822 | 2114456.05498 | 37.7860531044459 | -122.433963466929 | (37.7860531044459, -122.433963466929) | 13 | 9 | 11 | 29490 | 27 | |||||
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 | |||||
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 |
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) );