superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 548 sorted by map
This data as json, copyable, CSV (advanced)
Link | rowid | id | map ▼ | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8388 | 8388 | 8387 | {"type": "Polygon", "coordinates": [[[-121.56747, 39.0595], [-121.56741, 39.05964], [-121.56737, 39.05981], [-121.5668, 39.05982], [-121.56678, 39.05978], [-121.56673, 39.05974], [-121.56662, 39.05971], [-121.56675, 39.05938], [-121.56747, 39.0595]]]} | Open Access 1 | Prairie Trails Park | 23977 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 0.658 | Prairie Trails Park | ||
11166 | 11166 | 11165 | {"type": "Polygon", "coordinates": [[[-121.57315, 39.06192], [-121.57181, 39.06191], [-121.5718, 39.06053], [-121.57215, 39.06041], [-121.57248, 39.06027], [-121.57278, 39.06009], [-121.573, 39.05994], [-121.57313, 39.06003], [-121.57315, 39.06192]]]} | Open Access 1 | Wheeler Ranch Lot I Park | 27454 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 5.273 | Wheeler Ranch Lot I Park | ||
14654 | 14654 | 14653 | {"type": "Polygon", "coordinates": [[[-121.57781, 39.05126], [-121.57738, 39.05126], [-121.57737, 39.05195], [-121.57699, 39.052], [-121.57681, 39.05207], [-121.57672, 39.05216], [-121.57665, 39.05226], [-121.57675, 39.05239], [-121.57675, 39.05255], [-121.57672, 39.05269], [-121.57693, 39.05305], [-121.57605, 39.05305], [-121.57607, 39.05208], [-121.57612, 39.05195], [-121.57653, 39.05135], [-121.57572, 39.0514], [-121.5757, 39.05121], [-121.57545, 39.05079], [-121.57646, 39.05041], [-121.57624, 39.05007], [-121.57612, 39.04957], [-121.57606, 39.04765], [-121.57683, 39.04765], [-121.57775, 39.04833], [-121.57775, 39.04991], [-121.57784, 39.05009], [-121.57781, 39.05126]]]} | Open Access 1 | Tent Meadow Detention Pond and Open Space | 26246 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 17.894 | Tent Meadow Detention Pond and OS |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);