trees

17 rows where PlotSize = "Width 0ft" and qSpecies_id = 86

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 0ft · 17 ✖
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)
9034 179812 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1349 Cayuga Ave 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 0ft   5999375.14619 2089880.54718 37.71837793826 -122.444159228684 (37.71837793826, -122.444159228684) 9 7 6 28861 25
21045 179811 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1367 Cayuga Ave 3 Sidewalk: Curb side : Pot Tree Private 2     10 Width 0ft   5999338.15399 2089837.49101 37.7182576053899 -122.444284002399 (37.7182576053899, -122.444284002399) 9 7 6 28861 25
23215 218419 DPW Maintained 1 Taxus baccata :: Irish Yew 86 206 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5994236.56093 2100588.83344 37.7474857670642 -122.462697413572 (37.7474857670642, -122.462697413572) 1 8 4 29491 40
44578 179805 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1475 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5998972.41815 2089460.57977 37.7172018201812 -122.445521103537 (37.7172018201812, -122.445521103537) 9 7 6 28861 25
46837 179803 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1481 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5998958.13876 2089448.31197 37.7171673203931 -122.445569578776 (37.7171673203931, -122.445569578776) 9 7 6 28861 25
49026 179810 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1367 Cayuga Ave 1 Sidewalk: Curb side : Pot Tree Private 2     14 Width 0ft   5999324.75892 2089823.48937 37.7182183958423 -122.444329297662 (37.7182183958423, -122.444329297662) 9 7 6 28861 25
67559 179809 DPW Maintained 1 Taxus baccata :: Irish Yew 86 114 Niagara Ave 2 Sidewalk: Curb side : Pot Tree Private 2     6 Width 0ft   5999497.59387 2089483.70241 37.7172952777295 -122.443707485722 (37.7172952777295, -122.443707485722) 9 7 6 28861 25
103352 179813 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1349 Cayuga Ave 3 Sidewalk: Curb side : Pot Tree Private 2     4 Width 0ft   5999385.00434 2089890.92911 37.7184070070682 -122.444125898896 (37.7184070070682, -122.444125898896) 9 7 6 28861 25
103524 179808 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1401 Cayuga Ave 1 Front Yard : Yard Tree Private 2     8 Width 0ft   5999197.61143 2089687.82893 37.7178386481083 -122.444759045 (37.7178386481083, -122.444759045) 9 7 6 28861 25
121368 179807 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1441 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5999120.21959 2089604.47334 37.7176053558696 -122.445020564272 (37.7176053558696, -122.445020564272) 9 7 6 28861 25
127564 179912 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 Rome St 5 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5998434.10808 2088860.2602 37.7155227337561 -122.447338595604 (37.7155227337561, -122.447338595604) 9 7 6 28861 25
127847 218418 DPW Maintained 1 Taxus baccata :: Irish Yew 86 206 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5994240.64803 2100595.30557 37.7475037732855 -122.462683750177 (37.7475037732855, -122.462683750177) 1 8 4 29491 40
135830 179804 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1481 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5998957.13313 2089446.35886 37.717161900187 -122.44557291438 (37.717161900187, -122.44557291438) 9 7 6 28861 25
142858 179806 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1475 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5998976.19185 2089464.18471 37.7172119339604 -122.445508318764 (37.7172119339604, -122.445508318764) 9 7 6 28861 25
158009 179911 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 Rome St 4 Sidewalk: Property side : Yard Tree Private 2     6 Width 0ft   5998429.31666 2088867.05856 37.7155411266995 -122.447355645862 (37.7155411266995, -122.447355645862) 9 7 6 28861 25
168781 179913 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 Rome St 6 Sidewalk: Property side : Yard Tree Private 2     4 Width 0ft   5998438.88118 2088852.56905 37.7155018883663 -122.447321544456 (37.7155018883663, -122.447321544456) 9 7 6 28861 25
171818 179910 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 Rome St 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 0ft   5998425.41243 2088873.3917 37.7155582929503 -122.447369596148 (37.7155582929503, -122.447369596148) 9 7 6 28861 25

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