14 rows where Zip Codes = 58 and qSpecies_id = 95 sorted by qSpecies_id

View and edit SQL

Zip Codes

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)
15534 80384 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 10 Bridgeview Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6014069.48963 2095395.06223 37.7343470415729 -122.393752415043 (37.7343470415729, -122.393752415043) 10 3 8 58 1
50376 194569 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 2170 Revere Ave 1 Sidewalk: Property side : Yard Tree Private 2     16     6012070.84581 2096680.20048 37.7377644932337 -122.400752672218 (37.7377644932337, -122.400752672218) 10 3 8 58 1
56599 61202 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 100 Augusta St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31589 6011219.14011918 2095497.57320599 37.734469707782 -122.403614262052 (37.734469707782, -122.403614262052) 10 3 8 58 1
66833 194572 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 16 Waterville St 1 : Tree Private 2     7 Width 1ft   6011439.22525 2096039.9768 37.7359713251222 -122.402891486647 (37.7359713251222, -122.402891486647) 10 3 8 58 1
79998 64527 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1411 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/22/1988 12:00:00 AM     Permit Number 25409 6016035.70677774 2094698.28418833 37.7325428963772 -122.386905924583 (37.7325428963772, -122.386905924583) 10 3 8 58 1
88468 61214 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 141 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1983 12:00:00 AM     Permit Number 21082 6011231.36543014 2095904.87727488 37.7355887616193 -122.403600642676 (37.7355887616193, -122.403600642676) 10 3 8 58 1
89342 61200 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1745 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1983 12:00:00 AM     Permit Number 21066 6011201.29999643 2095204.84432988 37.7336649394432 -122.403655351863 (37.7336649394432, -122.403655351863) 10 3 8 58 1
95452 61216 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 155 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1983 12:00:00 AM     Permit Number 21085 6011236.78109112 2095805.55602058 37.7353163489665 -122.403574932778 (37.7353163489665, -122.403574932778) 10 3 8 58 1
113548 194571 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 10 Bridgeview Dr 3 : Tree Private 2     3 Width 2ft   6014067.17218 2095407.62951 37.7343814199646 -122.393761306632 (37.7343814199646, -122.393761306632) 10 3 8 58 1
124879 194570 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 10 Bridgeview Dr 1 : Tree Private 2     6 Width 2ft   6014071.17827 2095379.66213 37.7343048498944 -122.393745499263 (37.7343048498944, -122.393745499263) 10 3 8 58 1
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
130851 194574 DPW Maintained 1 Pittosporum crassifolium :: Karo Tree 95 6 Richards Cir 1 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   6016320.68314 2095812.692 37.7356186118941 -122.385998338957 (37.7356186118941, -122.385998338957) 10 3 8 58 1
149939 60369 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1435 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19947 6015750.16258389 2094570.92480778 37.7321773784731 -122.387884244628 (37.7321773784731, -122.387884244628) 10 3 8 58 1
167584 60395 Permitted Site 7 Pittosporum crassifolium :: Karo Tree 95 1498 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/06/1982 12:00:00 AM     Permit Number 19975 6015454.39806509 2094856.49905074 37.7329451185448 -122.388926707993 (37.7329451185448, -122.388926707993) 10 3 8 58 1

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