superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 44 and PARK_URL = "http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
821 | 821 | 820 | {"type": "MultiPolygon", "coordinates": [[[[-117.09275, 32.55093], [-117.08419, 32.55089], [-117.08418, 32.54718], [-117.0885, 32.54724], [-117.08851, 32.54815], [-117.09275, 32.54817], [-117.09274, 32.54879], [-117.09275, 32.55093]]], [[[-117.10589, 32.55459], [-117.10142, 32.55462], [-117.09931, 32.55462], [-117.09923, 32.55817], [-117.09713, 32.55816], [-117.09714, 32.55462], [-117.09633, 32.5546], [-117.09634, 32.55816], [-117.09383, 32.55815], [-117.09382, 32.55778], [-117.09285, 32.55777], [-117.09287, 32.54879], [-117.09289, 32.5476], [-117.09288, 32.54732], [-117.10159, 32.54731], [-117.10155, 32.54367], [-117.10156, 32.53999], [-117.10318, 32.53998], [-117.10318, 32.54033], [-117.10459, 32.54111], [-117.1046, 32.54364], [-117.10584, 32.54365], [-117.10585, 32.54377], [-117.10576, 32.54379], [-117.10576, 32.5473], [-117.10584, 32.54732], [-117.10583, 32.55098], [-117.10589, 32.55459]]], [[[-117.11232, 32.54729], [-117.11231, 32.55095], [-117.11011, 32.55096], [-117.11016, 32.54731], [-117.11232, 32.54729]]]]} | Open Access 1 | Tijuana River Valley Regional Park | http://www.sdparks.org/content/sdparks/en/park-pages/TJRVRP.html | 26362 | 106 | United States Fish and Wildlife Service 44 | Federal 1 | Federal Agency 1 | http://www.fws.gov/ | US Fish and Wildlife Service 8 | 451.213 | Tijuana River Valley RP |
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]);