trees

12 rows where qSiteInfo = "Back Yard : Yard" and qSpecies_id = 95 sorted by qSpecies_id

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Back Yard : Yard · 12 ✖

qCareAssistant ✖

  • - 12
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)
13903 233957 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 15 Penny Ln 1 Back Yard : Yard Tree Private 2     5 Width 2ft   6002524.54294 2096295.78541 37.7361719027113 -122.433731352142 (37.7361719027113, -122.433731352142) 2 7 5 63 7
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
32306 250000 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 39 Darrell Pl 4 Back Yard : Yard Tree Private 2     9 Width 0ft   6011508.04195 2120196.77393 37.8023042418972 -122.404353336441 (37.8023042418972, -122.404353336441) 3 1 10 308 23
52206 233518 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 100 Hwy 101 Southbound 10 Back Yard : Yard Tree Private 2     7     6005873.99672 2108944.2877 37.7710912548825 -122.423049648243 (37.7710912548825, -122.423049648243) 8 2 5 28853 19
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
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
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
124106 233956 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 3 Penny Ln 3 Back Yard : Yard Tree Private 2     1 Width 2ft   6002403.32332 2096434.71653 37.7365464964208 -122.434160386288 (37.7365464964208, -122.434160386288) 2 7 5 63 7
144775 233955 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 3 Penny Ln 2 Back Yard : Yard Tree Private 2     4 Width 2ft   6002401.2653 2096437.12023 37.7365529796221 -122.434167673516 (37.7365529796221, -122.434167673516) 2 7 5 63 7
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
150260 233517 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 100 Hwy 101 Southbound 12 Back Yard : Yard Tree Private 2     7     6005882.82166 2108930.28485 37.7710533043986 -122.423018127005 (37.7710533043986, -122.423018127005) 8 2 5 28853 19
156078 233958 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 19 Penny Ln 1 Back Yard : Yard Tree Private 2     4 Width 2ft   6002544.64531 2096274.11886 37.7361135520013 -122.433660302082 (37.7361135520013, -122.433660302082) 2 7 5 63 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)
);