trees

13 rows where qLegalStatus_id = 6 and qSpecies_id = 95

✎ View and edit SQL

This data as json, CSV (advanced)

qLegalStatus_id ✖

  • Significant Tree · 13 ✖
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)
429 259715 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 210 Gold Mine Dr 1 Front Yard : Cutout Tree Private 2       3x3   6000723 2098465 37.7420256658379 -122.440115509428 (37.7420256658379, -122.440115509428) 2 7 5 63 7
8974 260925 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 1900 Noriega St 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5987961.4849 2103092.5821 37.7539969916819 -122.484579575666 (37.7539969916819, -122.484579575666) 1 8 3 56 35
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
20385 251602 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 44R Amber Dr 1 Back Yard : Yard Tree Private 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
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
54862 251605 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 48R Amber Dr 2 Back Yard : Yard Tree Private 2           5999482 2100041 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345) 2 7 5 63 22
60900 103616 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 201X Haight St 1 Sidewalk: Property side : Yard Tree Private 2           6004725 2109149 37.7715884407354 -122.427038651796 (37.7715884407354, -122.427038651796) 7 9 11 28852 10
66091 100771 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 2 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
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
100606 100772 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 3 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
147643 100770 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 450 Hayes St 1 Back Yard : Yard Tree Private 2         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
174521 258525 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 95 50 Hermann St 1 Sidewalk: Property side : Cutout Tree Private 2           6005031 2108842 37.7707627914543 -122.425958322168 (37.7707627914543, -122.425958322168) 7 9 5 28852 10

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