superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 548
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
11920 | 11920 | 11919 | {"type": "Polygon", "coordinates": [[[-121.54665, 38.98363], [-121.54635, 38.98387], [-121.54615, 38.98424], [-121.54615, 38.98439], [-121.54578, 38.9844], [-121.54495, 38.98436], [-121.54495, 38.98314], [-121.54499, 38.98309], [-121.54563, 38.98298], [-121.54589, 38.9829], [-121.54594, 38.98291], [-121.54631, 38.98334], [-121.54665, 38.98363]]]} | Open Access 1 | Bear River Park | 28703 | 2101 | Olivehurst Public Utility District 548 | Special District 4 | Water District 13 | http://www.opud.org/ | Special District 4 | 4.47 | Bear River 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]);