units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Bolsa Chica SB" and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16456 | 16456 | 16455 | {"type": "MultiPolygon", "coordinates": [[[[-118.03593, 33.68227], [-118.0356, 33.68249], [-118.0351, 33.68195], [-118.0348, 33.68214], [-118.03452, 33.68184], [-118.03425, 33.6816], [-118.03494, 33.68233], [-118.0346, 33.68199], [-118.03406, 33.68148], [-118.03221, 33.6799], [-118.0322, 33.67981], [-118.03212, 33.67974], [-118.03212, 33.67955], [-118.02451, 33.67309], [-118.02378, 33.67251], [-118.02293, 33.67187], [-118.0072, 33.66055], [-118.00628, 33.65984], [-118.00592, 33.65947], [-118.00587, 33.65891], [-118.00501, 33.65824], [-118.00464, 33.65832], [-118.00466, 33.65856], [-118.00447, 33.65874], [-118.00189, 33.65686], [-118.00297, 33.65564], [-118.00345, 33.65591], [-118.00386, 33.65627], [-118.00418, 33.65663], [-118.00462, 33.65716], [-118.00524, 33.6577], [-118.00541, 33.65801], [-118.00606, 33.65873], [-118.00657, 33.65923], [-118.00653, 33.6594], [-118.00736, 33.66013], [-118.00843, 33.66094], [-118.01142, 33.66286], [-118.01473, 33.66536], [-118.01807, 33.66776], [-118.02042, 33.6692], [-118.02167, 33.67002], [-118.02229, 33.6704], [-118.02333, 33.67099], [-118.02523, 33.67225], [-118.02629, 33.67299], [-118.02685, 33.67344], [-118.02719, 33.67379], [-118.02784, 33.67431], [-118.02897, 33.67567], [-118.02932, 33.67615], [-118.02956, 33.67643], [-118.0299, 33.67677], [-118.03074, 33.67742], [-118.03209, 33.67841], [-118.03211, 33.67907], [-118.03212, 33.67906], [-118.03213, 33.67866], [-118.0324, 33.67889], [-118.03258, 33.67913], [-118.03308, 33.67945], [-118.03324, 33.67968], [-118.0338, 33.68024], [-118.03593, 33.68227]]], [[[-118.06598, 33.71151], [-118.06327, 33.71154], [-118.0624, 33.71065], [-118.06107, 33.70903], [-118.0606, 33.7085], [-118.06008, 33.708], [-118.05444, 33.70303], [-118.05385, 33.70247], [-118.05328, 33.7019], [-118.03909, 33.68676], [-118.03904, 33.68668], [-118.03825, 33.68585], [-118.03832, 33.6858], [-118.03832, 33.68578], [-118.03769, 33.68519], [-118.0363, 33.68375], [-118.03638, 33.6837], [-118.03637, 33.68368], [-118.03668, 33.68347], [-118.03738, 33.68422], [-118.03749, 33.68413], [-118.03686, 33.68347], [-118.03706, 33.68334], [-118.03796, 33.68423], [-118.03976, 33.68588], [-118.04122, 33.68728], [-118.04204, 33.68811], [-118.04283, 33.68895], [-118.04315, 33.68937], [-118.04339, 33.68964], [-118.04366, 33.68988], [-118.04417, 33.69029], [-118.04437, 33.69049], [-118.04454, 33.6907], [-118.04473, 33.69099], [-118.04482, 33.6911], [-118.04493, 33.69119], [-118.04534, 33.69147], [-118.04562, 33.69173], [-118.0459, 33.69209], [-118.04656, 33.69307], [-118.04675, 33.69324], [-118.04712, 33.69344], [-118.04732, 33.6936], [-118.04741, 33.69373], [-118.04753, 33.69394], [-118.048, 33.69445], [-118.04864, 33.69519], [-118.05046, 33.69712], [-118.05094, 33.69765], [-118.05113, 33.69789], [-118.05199, 33.69882], [-118.05238, 33.69919], [-118.05286, 33.69957], [-118.05304, 33.69973], [-118.05319, 33.69991], [-118.05339, 33.70021], [-118.05376, 33.70054], [-118.05402, 33.7008], [-118.0546, 33.70147], [-118.0552, 33.70211], [-118.05585, 33.7027], [-118.05675, 33.70342], [-118.05739, 33.70399], [-118.05858, 33.70516], [-118.05994, 33.70653], [-118.06085, 33.70736], [-118.06182, 33.70816], [-118.06202, 33.70837], [-118.0623, 33.70861], [-118.06297, 33.70911], [-118.06399, 33.70982], [-118.06416, 33.70995], [-118.06437, 33.71015], [-118.06492, 33.71055], [-118.06598, 33.71151]]]]} | Open Access 1 | 7223 | Bolsa Chica State Beach | 1443 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=642 | Orange 3 | 203.196 | Bolsa Chica SB | 1960 | State Park 15 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);