trees

33 rows where PlotSize = "" and qSpecies_id = 39

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

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)
2114 239212 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 9 Back Yard : Yard Tree Private 2     6     6005873.5433 2108954.58543 37.7711195043932 -122.423051948693 (37.7711195043932, -122.423051948693) 8 2 5 28853 19
20572 239214 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 7 Back Yard : Yard Tree Private 2     6     6005859.14445 2108978.35649 37.7711839614881 -122.423103444792 (37.7711839614881, -122.423103444792) 8 2 5 28853 19
32860 239195 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 7 Back Yard : Yard Tree Private 2     3     6005938.2626 2109031.33623 37.7713338955718 -122.422833537536 (37.7713338955718, -122.422833537536) 8 2 9 28853 19
34587 239198 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 10 Back Yard : Yard Tree Private 2     3     6005918.91365 2109064.99496 37.7714252226197 -122.422902859103 (37.7714252226197, -122.422902859103) 8 2 9 28853 19
37443 239209 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 14 Back Yard : Yard Tree Private 2     2     6005896.87599 2108918.25042 37.7710210537973 -122.422968657083 (37.7710210537973, -122.422968657083) 8 2 5 28853 19
59502 239192 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 4 Back Yard : Yard Tree Private 2     6     6005960.35629 2108991.91912 37.7712269122118 -122.422754312663 (37.7712269122118, -122.422754312663) 8 2 9 28853 19
62925 239202 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 24 Back Yard : Yard Tree Private 2     2     6005953.73874 2108834.81297 37.7707951629947 -122.422766036225 (37.7707951629947, -122.422766036225) 8 2 5 28853 19
68296 239193 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 5 Back Yard : Yard Tree Private 2     5     6005953.87409 2109001.55564 37.7712530060513 -122.422777419838 (37.7712530060513, -122.422777419838) 8 2 9 28853 19
75236 239200 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 26 Back Yard : Yard Tree Private 2     2     6005967.71166 2108818.2564 37.7707504909794 -122.422716526767 (37.7707504909794, -122.422716526767) 8 2 5 28853 19
82233 239207 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 18 Back Yard : Yard Tree Private 2     2     6005923.40296 2108870.98166 37.7708927619194 -122.422873539387 (37.7708927619194, -122.422873539387) 8 2 5 28853 19
82493 239190 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 2 Back Yard : Yard Tree Private 2     4     6005977.0875 2108970.19311 37.7711682017725 -122.422694894458 (37.7711682017725, -122.422694894458) 8 2 9 28853 19
93180 239210 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 13 Back Yard : Yard Tree Private 2     3     6005891.00584 2108925.69957 37.7710411761388 -122.422989491673 (37.7710411761388, -122.422989491673) 8 2 5 28853 19
96285 239196 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 8 Back Yard : Yard Tree Private 2     3     6005930.84591 2109041.94212 37.771362598325 -122.422859946125 (37.771362598325, -122.422859946125) 8 2 9 28853 19
97127 239204 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 21 Back Yard : Yard Tree Private 2     4     6005940.87649 2108850.78599 37.7708382953675 -122.422811662426 (37.7708382953675, -122.422811662426) 8 2 5 28853 19
99552 239197 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 9 Back Yard : Yard Tree Private 2     4     6005924.85036 2109052.04357 37.7713899961886 -122.42288140308 (37.7713899961886, -122.42288140308) 8 2 9 28853 19
103697 94619 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1799X Armstrong Ave 1 Sidewalk: Property side : Cutout Tree Private 2   10/13/2010 12:00:00 AM 2   Permit Number 53777 6013459.79784 2093130.51427 37.7280951570487 -122.395701716272 (37.7280951570487, -122.395701716272) 10 3 8 58 1
104718 239205 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 20 Back Yard : Yard Tree Private 2     2     6005934.94283 2108857.84078 37.7708573313359 -122.422832688574 (37.7708573313359, -122.422832688574) 8 2 5 28853 19
106471 65681 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 345 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2011 12:00:00 AM 3   Permit Number 767215 5993370.6959 2113311.72647 37.782369577363 -122.466616141073 (37.782369577363, -122.466616141073) 11 6 2 54 11
119193 39176 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 754 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2009 12:00:00 AM     Permit Number 53085 6007474 2105260 37.7610652207705 -122.417254045994 (37.7610652207705, -122.417254045994) 2 4 7 28859 19
125140 239208 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 17 Back Yard : Yard Tree Private 2     3     6005920.35776 2108877.05935 37.7709092779754 -122.42288450484 (37.7709092779754, -122.42288450484) 8 2 5 28853 19
131784 239206 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 19 Back Yard : Yard Tree Private 2     3     6005929.11782 2108865.00797 37.7708766820544 -122.422853346899 (37.7708766820544, -122.422853346899) 8 2 5 28853 19
140596 239188 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 1300 San Jose Ave 40 Sidewalk: Property side : Yard Tree Private 2     1     6003390.53226 2095588.92552 37.7342801275185 -122.430686848418 (37.7342801275185, -122.430686848418) 2 7 5 63 7
146007 239211 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 11 Back Yard : Yard Tree Private 2     5     6005882.93751 2108938.64172 37.7710762568972 -122.423018320345 (37.7710762568972, -122.423018320345) 8 2 5 28853 19
147055 239199 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 27 Back Yard : Yard Tree Private 2     2     6005974.4493 2108807.19348 37.7707204949845 -122.422692434815 (37.7707204949845, -122.422692434815) 8 2 5 28853 19
149090 239201 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 25 Back Yard : Yard Tree Private 2     3     6005958.49088 2108828.33436 37.7707776424043 -122.422749137971 (37.7707776424043, -122.422749137971) 8 2 5 28853 19
155107 239215 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 5 Back Yard : Yard Tree Private 2     2     6005849.76837 2108994.27004 37.77122712717 -122.423137008381 (37.77122712717, -122.423137008381) 8 2 5 28853 19
155722 239189 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 1 Back Yard : Yard Tree Private 2     3     6005983.85034 2108958.28367 37.7711358828561 -122.422670655046 (37.7711358828561, -122.422670655046) 8 2 9 28853 19
158561 239191 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 3 Back Yard : Yard Tree Private 2     6     6005967.76325 2108980.83852 37.7711969054453 -122.422727904078 (37.7711969054453, -122.422727904078) 8 2 9 28853 19
164043 239217 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 2 Back Yard : Yard Tree Private 2     4     6005837.81281 2109017.0594 37.7712890265976 -122.423179983379 (37.7712890265976, -122.423179983379) 8 2 5 28853 19
177062 239213 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 8 Back Yard : Yard Tree Private 2     5     6005865.35862 2108965.54677 37.771149139741 -122.423081039068 (37.771149139741, -122.423081039068) 8 2 5 28853 19
181276 239216 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 3 Back Yard : Yard Tree Private 2     5     6005843.54322 2109006.73444 37.7712610001205 -122.423159427585 (37.7712610001205, -122.423159427585) 8 2 5 28853 19
183553 239194 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 101 Hwy 101 Northbound 6 Back Yard : Yard Tree Private 2     3     6005943.75173 2109019.81978 37.7713025838749 -122.422813731768 (37.7713025838749, -122.422813731768) 8 2 9 28853 19
185872 239203 DPW Maintained 1 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 100 Hwy 101 Southbound 22 Back Yard : Yard Tree Private 2     3     6005946.44181 2108844.1649 37.7708204294492 -122.422791941214 (37.7708204294492, -122.422791941214) 8 2 5 28853 19

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