trees
58 rows where qLegalStatus_id = 11 sorted by XCoord descending
This data as json, CSV (advanced)
qSpecies_id ✖
- Phoenix canariensis :: Canary Island Date Palm 18
- Eucalyptus globulus :: Blue Gum 12
- Quercus agrifolia :: Coast Live Oak 4
- Aesculus californica :: California Buckeye 3
- Araucaria heterophylla :: Norfolk Island Pine 3
- Cupressus macrocarpa :: Monterey Cypress 2
- Fraxinus ornus :: Flowering Ash 2
- Ficus macrophylla :: Morton Bay Fig 2
- Sambucus mexicana :: Blue Elderberry 2
- Metrosideros excelsa :: New Zealand Xmas Tree 1
- Laurus nobilis :: Sweet Bay: Grecian Laurel 1
- Acacia melanoxylon :: Blackwood Acacia 1
- Schinus terebinthifolius :: Brazilian Pepper 1
- Melaleuca ericifolia :: Heath Melaleuca 1
- Sequoia sempervirens :: Coast Redwood 1
- Sequoiadendron giganteum :: Sierra Redwood 1
- Prunus domestica 'Mariposa' :: Mariposa Plum 1
- Arctostaphylos manzanita 'Dr Hurd' :: Dr. Hurd Manzanita 1
- Metrosideros excelsa 'Aurea' :: 1
qSiteInfo ✖
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||||
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 | ||||
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 | |||
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 | |||
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 | |||||
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 | |||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||||
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 | ||||
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 | ||||
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 | |||||
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 | ||||
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 | |||||
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 | ||||
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 | |||
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 | ||||
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 | |||||
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 |
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) );