58 rows where qLegalStatus_id = 11 sorted by qAddress

View and edit SQL

Zip Codes

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)
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
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
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
2730 138025 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     49 Width 0ft   6004878.9655 2114979.8902 37.7876073348692 -122.426921423586 (37.7876073348692, -122.426921423586) 13 9 11 28858 27
2985 138087 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     30 Width 0ft   6004894.5944 2114873.9606 37.7873173623789 -122.426859803648 (37.7873173623789, -122.426859803648) 13 9 11 28858 27
4739 138026 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     57 Width 0ft   6004881.8597 2114953.842 37.7875359766764 -122.426909554358 (37.7875359766764, -122.426909554358) 13 9 11 28858 27
5001 138027 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     39 Width 0ft   6004885.3328 2114935.3188 37.7874853129815 -122.426896218405 (37.7874853129815, -122.426896218405) 13 9 11 28858 27
6626 138028 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     49 Width 0ft   6004887.6482 2114917.9533 37.7874377625804 -122.426886970359 (37.7874377625804, -122.426886970359) 13 9 11 28858 27
13887 2618 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 5 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
28953 2619 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 6 Sidewalk: Curb side : Cutout Tree DPW 1     36 10X10   6004877.75733 2115027.26874 37.7877373561683 -122.426928979241 (37.7877373561683, -122.426928979241) 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
47435 2617 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 4 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
146721 2615 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 2 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
165250 2616 Landmark tree 11 Eucalyptus globulus :: Blue Gum 56 1661X Octavia St 3 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
3537 18548 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 3 Median : Cutout Tree DPW 1     30 19   6014665.0129 2095058.69239 37.7334565140045 -122.391669970993 (37.7334565140045, -122.391669970993) 10 3 8 58 1
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                              
37495 18550 Landmark tree 11 Acacia melanoxylon :: Blackwood Acacia 70 1700X Quesada Ave 5 Median : Cutout Tree DPW 1     30 19   6014656.2717 2095062.29209 37.733465912826 -122.391700443637 (37.733465912826, -122.391700443637) 10 3 8 58 1
177598 18547 Landmark tree 11 Prunus domestica 'Mariposa' :: Mariposa Plum 256 1700X Quesada Ave 2 Median : Cutout Tree DPW 1     30 19   6014668.27449 2095058.71423 37.733456755021 -122.391658696189 (37.733456755021, -122.391658696189) 10 3 8 58 1
183525 18555 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 10 Median : Cutout Tree DPW 1     12 19   6014626.04256 2095092.92008 37.7335483329791 -122.391807096032 (37.7335483329791, -122.391807096032) 10 3 8 58 1
192277 18551 Landmark tree 11 Phoenix canariensis :: Canary Island Date Palm 160 1700X Quesada Ave 6 Median : Cutout Tree DPW 1     30 19   6014649.71614 2095074.32399 37.7334985860723 -122.391723949223 (37.7334985860723, -122.391723949223) 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
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
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
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
14339 151836 Landmark tree 11 Quercus agrifolia :: Coast Live Oak 172 20 Rosemont Pl 2 Back Yard : Yard Tree Private 2     0 Width 3ft   6005099.05709 2108071.10762 37.7686499525699 -122.425668035147 (37.7686499525699, -122.425668035147) 8 4 5 28853 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
11977 24539 Landmark tree 11 Fraxinus ornus :: Flowering Ash 301 500X Cortland Ave 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     50 3X3   6007622.12549 2097206.54003 37.7389605708788 -122.41617135712 (37.7389605708788, -122.41617135712) 2 7 7 28859 2
14279 24540 Landmark tree 11 Fraxinus ornus :: Flowering Ash 301 500X Cortland Ave 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     50 3X3   6007652.96823 2097201.05938 37.7389472564055 -122.416064328819 (37.7389472564055, -122.416064328819) 2 7 7 28859 2
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
135688 1716 Landmark tree 11 Laurus nobilis :: Sweet Bay: Grecian Laurel 18 555 Battery St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x15   6012528.51285 2117974.41064 37.7962591384932 -122.400665775228 (37.7962591384932, -122.400665775228) 3 1 10 28860 4
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);