trees
14 rows where Zip Codes = 58 and qSpecies_id = 95 sorted by Police Districts
This data as json, CSV (advanced)
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
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) );