16 rows where qSpecies_id = 316

View and edit SQL

Suggested facets: SiteOrder, DBH, Fire Prevention Districts, Supervisor Districts, Neighborhoods (old)

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)
7859 220108 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 278 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6007735.49502 2097817.48934 37.7406444767514 -122.415822626123 (37.7406444767514, -122.415822626123) 2 7 7 28859 2
41183 220107 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 250 Moultrie St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6007745.97334 2097944.05799 37.740992595335 -122.41579535599 (37.740992595335, -122.41579535599) 2 7 7 28859 2
44078 220113 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 4107 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6001603.08502 2105817.42706 37.7622637344979 -122.437598883894 (37.7622637344979, -122.437598883894) 15 5 5 28862 3
44895 220106 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1000 San Jose Ave 52 Front Yard : Yard Tree Private 2     9     6005101.06856 2097135.68497 37.7386239420276 -122.424882977386 (37.7386239420276, -122.424882977386) 2 7 5 63 7
68438 220109 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 192 San Jose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006127.85911 2102056.51499 37.7521933690475 -122.421682233571 (37.7521933690475, -122.421682233571) 2 4 5 28859 19
78977 188538 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1501 22nd St 2 Sidewalk: Property side : Yard Tree Private 2     11     6013548.97774 2103796.70407 37.7573872335395 -122.396140620513 (37.7573872335395, -122.396140620513) 10 3 8 28856 29
82246 220110 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1301 Diamond St 1 Sidewalk: Curb side : Pot Tree Private 2     7 Width 6ft   6002012.53381 2100276.70293 37.7470735061305 -122.435786312882 (37.7470735061305, -122.435786312882) 2 7 5 63 22
91476 220112 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 4308 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001856.38082 2101202.65635 37.7496070834215 -122.436392535996 (37.7496070834215, -122.436392535996) 2 4 5 28862 22
91737 188537 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 861 Vermont St 1 Sidewalk: Curb side : Yard Tree Private 2     16     6011328.80753 2104353.51433 37.7587923298333 -122.403858071687 (37.7587923298333, -122.403858071687) 10 3 8 28856 29
94183 220105 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1000 San Jose Ave 19 Front Yard : Yard Tree Private 2     7     6005168.18558 2097265.60079 37.7389844523574 -122.42466015776 (37.7389844523574, -122.42466015776) 2 7 5 28859 7
114540 220111 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 533 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003200.8617 2096092.88035 37.7356531251924 -122.431378562891 (37.7356531251924, -122.431378562891) 2 7 5 63 7
121089 174967 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 31 Sala Ter 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   5998978.93202 2088288.05687 37.7139827113048 -122.445414327027 (37.7139827113048, -122.445414327027) 9 7 6 28861 25
135410 220103 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1000 San Jose Ave 17 Front Yard : Yard Tree Private 2     10     6005163.66406 2097268.22494 37.738991402317 -122.424675977735 (37.738991402317, -122.424675977735) 2 7 5 28859 7
135663 188536 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 900x Carolina St 17 Median : Yard Tree DPW 1     12     6012479.96595 2103541.08212 37.7566258135487 -122.399819761371 (37.7566258135487, -122.399819761371) 10 3 8 28856 29
184546 188539 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1501 22nd St 3 Front Yard : Yard Tree Private 2     12     6013533.61614 2103796.77627 37.7573865770488 -122.396193752453 (37.7573865770488, -122.396193752453) 10 3 8 28856 29
185851 220104 DPW Maintained 1 Acacia cyclops :: Cyclops wattle 316 1000 San Jose Ave 18 Front Yard : Yard Tree Private 2     8     6005169.80907 2097270.37684 37.738997658003 -122.424654884133 (37.738997658003, -122.424654884133) 2 7 5 28859 7

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