superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, MNG_AG_TYP = 5 and YR_EST = 1953
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15164 | 15164 | 15163 | {"type": "MultiPolygon", "coordinates": [[[[-122.30503, 38.22931], [-122.30469, 38.23036], [-122.30378, 38.23118], [-122.30336, 38.23185], [-122.30369, 38.2322], [-122.30335, 38.23229], [-122.29938, 38.23475], [-122.29743, 38.23418], [-122.29593, 38.23482], [-122.29445, 38.23613], [-122.29395, 38.23827], [-122.29305, 38.23889], [-122.29236, 38.23958], [-122.2919, 38.24023], [-122.29152, 38.24089], [-122.29155, 38.24092], [-122.29089, 38.24314], [-122.28888, 38.24275], [-122.28867, 38.24399], [-122.28669, 38.24356], [-122.28632, 38.24342], [-122.28642, 38.24321], [-122.28692, 38.24129], [-122.28711, 38.24094], [-122.28751, 38.23983], [-122.28757, 38.23953], [-122.28764, 38.2394], [-122.28829, 38.23706], [-122.28852, 38.23453], [-122.28901, 38.23328], [-122.28943, 38.23294], [-122.28971, 38.23273], [-122.29017, 38.23246], [-122.29309, 38.23251], [-122.29719, 38.23161], [-122.29783, 38.23116], [-122.29871, 38.23073], [-122.29969, 38.23028], [-122.30054, 38.22959], [-122.30145, 38.22903], [-122.30223, 38.22832], [-122.30402, 38.22748], [-122.30428, 38.22782], [-122.30495, 38.22887], [-122.30503, 38.22931]]], [[[-122.35787, 38.21482], [-122.3576, 38.21731], [-122.3573, 38.21728], [-122.3572, 38.21747], [-122.3571, 38.21757], [-122.35685, 38.21801], [-122.35672, 38.21812], [-122.35619, 38.21935], [-122.35321, 38.22072], [-122.35254, 38.22061], [-122.35251, 38.21999], [-122.3523, 38.21996], [-122.3523, 38.21899], [-122.35271, 38.21897], [-122.3527, 38.21403], [-122.35787, 38.21482]]]]} | Restricted Access 2 | Napa-Sonoma Marshes Wildlife Area | 22626 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 293.545 | Napa-Sonoma Marshes Wildlife Area | 1953 |
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]);