131 rows where qLegalStatus_id = 10 sorted by Latitude

View and edit SQL

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)
86412 109945 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 5 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
93470 109942 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
108791 109943 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
118512 109946 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 6 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
145260 109947 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 7 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
191841 109941 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
192360 109949 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 400x CLEMENTINA ST 9 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3   6011439 2112324 37.7806836249396 -122.404037890761 (37.7806836249396, -122.404037890761) 14 2 9 28853 34
148956 32654 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011426.1069309 2112339.71009356 37.7807260408269 -122.40408360027 (37.7807260408269, -122.40408360027) 14 2 9 28853 34
26043 100060 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
102447 100059 Section 143 10 Lophostemon confertus :: Brisbane Box 11 260 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435 2112345 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
79198 112368 Section 143 10 Prunus cerasifera :: Cherry Plum 7 550 Jessie St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
93555 112370 Section 143 10 Prunus cerasifera :: Cherry Plum 7 550 Jessie St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
98375 112371 Section 143 10 Prunus cerasifera :: Cherry Plum 7 550 Jessie St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
169504 112369 Section 143 10 Prunus cerasifera :: Cherry Plum 7 550 Jessie St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2015 12:00:00 AM 3 3x3   6009683.8 2112475.6 37.7810016601266 -122.410120702727 (37.7810016601266, -122.410120702727) 14 2 9 28853 34
23848 114246 Section 143 10 Magnolia grandiflora :: Southern Magnolia 19 54 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996571 2114184 37.7849487713586 -122.455607632252 (37.7849487713586, -122.455607632252) 11 6 1 54 31
143556 112627 Section 143 10 Tristaniopsis laurina :: Swamp Myrtle 1 2385 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002100 2114635 37.7865028312467 -122.436511387034 (37.7865028312467, -122.436511387034) 13 6 1 29490 27
189972 17872 Section 143 10 Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 2148 Pine St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Private 07/21/2010 12:00:00 AM 0 3X3 Permit Number 53638 6003654.7045158 2115269.5781823 37.7883334451781 -122.431177809024 (37.7883334451781, -122.431177809024) 13 9 1 29490 27
55082 108822 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
62944 108821 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2015 12:00:00 AM 3 5x5 Permit Number 774616 6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
193590 108823 Section 143 10 Acer buergeranum :: Trident Maple 110 101x FREMONT ST 3 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6013648.6 2115847.1 37.7904804500674 -122.396640813258 (37.7904804500674, -122.396640813258) 12 2 9 28855 6
134560 101923 Section 143 10 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1401X California St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.7907261358602 -122.418266664095 (37.7907261358602, -122.418266664095) 13 1 10 28858 21
41083 101926 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
184745 101925 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
188204 101924 Section 143 10 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1099X Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007639 2116135.7 37.7909365792809 -122.417454166812 (37.7909365792809, -122.417454166812) 13 1 10 28858 21
52587 107964 Section 143 10 Platanus x hispanica :: Sycamore: London Plane 27 2401x SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096 2116670 37.7920333111805 -122.440130949989 (37.7920333111805, -122.440130949989) 13 6 1 29490 27
138302 107977 Section 143 10 Platanus x hispanica :: Sycamore: London Plane 27 2750 JACKSON ST 7 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770079 6001096.4 2116670.4 37.7920344322485 -122.440129594684 (37.7920344322485, -122.440129594684) 13 6 1 29490 27
56667 103097 Section 143 10 Fagus sylvatica 'Red Obelisk' :: Red Obelisk Beech 483 1199X Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2013 12:00:00 AM   3x3 Permit Number 768649 6008392.3 2117900.9 37.7958257402639 -122.414972764224 (37.7958257402639, -122.414972764224) 5 1 10 308 21
22900 103469 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 799X Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012272.7 2118721.6 37.7982964705447 -122.401603488036 (37.7982964705447, -122.401603488036) 3 1 10 28860 6
20128 103466 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
43905 103465 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 1 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6
169034 103467 Section 143 10 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 890X Sansome St 3 Sidewalk: Curb side : Cutout Tree Private 2           6012118 2118740.5 37.7983397318906 -122.402140129264 (37.7983397318906, -122.402140129264) 3 1 10 28860 6

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