trees

16 rows where Zip Codes = 308 and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 308 · 16 ✖
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)
20460 100528 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1728 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 4.5x6   6008351.1313 2118382.01094 37.7971444383282 -122.415149288427 (37.7971444383282, -122.415149288427) 5 1 10 308 21
49688 136713 DPW Maintained 1 Taxus baccata :: Irish Yew 86 290 Green St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6011569.99478 2119432.50864 37.8002092172264 -122.404085130728 (37.8002092172264, -122.404085130728) 3 1 10 308 23
59813 136702 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1728 Jones St 5 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6008349.70738 2118393.07464 37.7971747364841 -122.415154999108 (37.7971747364841, -122.415154999108) 5 1 10 308 21
65762 136699 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1955 Jones St 1 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6008168.57169 2119227.42502 37.7994554738439 -122.415840886849 (37.7994554738439, -122.415840886849) 5 1 10 308 32
83289 64384 DPW Maintained 1 Taxus baccata :: Irish Yew 86 290 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2010 12:00:00 AM 6 3x3 Permit Number 53175 6011583.39503 2119434.85196 37.8002164001168 -122.404038925378 (37.8002164001168, -122.404038925378) 3 1 10 308 23
84545 136709 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6007914.92474 2120604.50253 37.8032223202271 -122.416816212417 (37.8032223202271, -122.416816212417) 5 1 1 308 32
90245 136682 DPW Maintained 1 Taxus baccata :: Irish Yew 86 874 Green St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6008846.30156 2119059.10202 37.7990313778645 -122.413483781748 (37.7990313778645, -122.413483781748) 3 1 10 308 32
100575 136700 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1955 Jones St 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 2ft   6008170.72961 2119215.54579 37.7994229777558 -122.415832578026 (37.7994229777558, -122.415832578026) 5 1 10 308 32
115962 136711 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 5 Sidewalk: Property side : Yard Tree Private 2     10 Width 3ft   6007948.87662 2120608.06628 37.8032340150017 -122.416698973183 (37.8032340150017, -122.416698973183) 5 1 1 308 32
140172 136708 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6007910.30742 2120604.37308 37.803221705081 -122.416832181661 (37.803221705081, -122.416832181661) 5 1 1 308 32
147511 136710 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6007938.82451 2120606.36693 37.8032287836485 -122.41673363846 (37.8032287836485, -122.41673363846) 5 1 1 308 32
152644 136704 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1728 Jones St 7 Sidewalk: Property side : Yard Tree Private 2     6 Width 2ft   6008348.41822 2118399.20524 37.7971914971435 -122.415159894117 (37.7971914971435, -122.415159894117) 5 1 10 308 21
173768 136712 DPW Maintained 1 Taxus baccata :: Irish Yew 86 84 MacOndray Ln 1 Sidewalk: Property side : Yard Tree Private 2     14     6008291.17542 2119130.0368 37.7991949618221 -122.415409734769 (37.7991949618221, -122.415409734769) 5 1 10 308 32
183336 136701 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1728 Jones St 4 Sidewalk: Property side : Yard Tree Private 2     5 Width 2ft   6008350.35689 2118390.24391 37.7971670005024 -122.415152551158 (37.7971670005024, -122.415152551158) 5 1 10 308 21
186499 136703 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1728 Jones St 6 Sidewalk: Property side : Yard Tree Private 2     4 Width 2ft   6008348.84171 2118396.84882 37.7971850507978 -122.415158261846 (37.7971850507978, -122.415158261846) 5 1 10 308 21
190798 136683 DPW Maintained 1 Taxus baccata :: Irish Yew 86 874 Green St 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 3ft   6008833.05028 2119058.08121 37.7990278309217 -122.413529563544 (37.7990278309217, -122.413529563544) 3 1 10 308 32

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