trees

10 rows where qSiteInfo = "Front Yard : Yard" and qSpecies_id = 95 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Front Yard : Yard · 10 ✖

qCareAssistant ✖

  • - 10
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)
9570 132301 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2747 Larkin St 2 Front Yard : Yard Tree Private 2     9     6006508.97625 2120792.8563 37.8036603116463 -122.421694934677 (37.8036603116463, -122.421694934677) 5 9 1 28858 32
20293 254534 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 737 Buena Vista Ave West 6 Front Yard : Yard Tree Private 2   02/27/2018 12:00:00 AM 3 10X10   5999910.14564 2107959.614 37.7680492454315 -122.443607999122 (37.7680492454315, -122.443607999122) 15 5 5 29492 9
35669 132300 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2747 Larkin St 1 Front Yard : Yard Tree Private 2     11     6006512.88528 2120797.48529 37.8036732420995 -122.421681736235 (37.8036732420995, -122.421681736235) 5 9 1 28858 32
48151 98950 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 401 Grove St 10 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
67745 249906 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 302 Greenwich St 7 Front Yard : Yard Tree Private 2     7 Width 0ft   6011297.14242 2120427.53777 37.802926075438 -122.405099414011 (37.802926075438, -122.405099414011) 3 1 10 308 23
69454 98948 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 401 Grove St 8 Front Yard : Yard Tree Private 2           6005778.2 2111279 37.7774964045324 -122.423547027313 (37.7774964045324, -122.423547027313) 7 9 11 28852 10
95493 100209 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 701 Rhode Island St 1 Front Yard : Yard Tree Private 2     10   Permit Number 769013 6011855.86556 2105057.10212 37.7607536567646 -122.402084714731 (37.7607536567646, -122.402084714731) 10 3 8 28856 29
123704 249908 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 302 Greenwich St 9 Front Yard : Yard Tree Private 2     16 Width 0ft   6011286.29454 2120430.4742 37.8029335317239 -122.405137160374 (37.8029335317239, -122.405137160374) 3 1 10 308 23
129496 255714 Undocumented 4 Pittosporum crassifolium :: Karo Tree 95 618x Mendell St 9 Front Yard : Yard Tree Private 2       3x3 Permit Number 781846 6016376 2097269 37.7396204009215 -122.385908564927 (37.7396204009215, -122.385908564927) 10 3 8 58 1
163493 233513 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 1001 San Jose Ave 73 Front Yard : Yard Tree Private 2     0     6005382.19397 2097506.55271 37.7396581363049 -122.423937343859 (37.7396581363049, -122.423937343859) 2 7 5 28859 2

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