units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where PARK_URL = "https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10083 | 10083 | 10082 | {"type": "MultiPolygon", "coordinates": [[[[-117.27291, 33.00739], [-117.26287, 33.00739], [-117.26203, 33.00689], [-117.26063, 33.00632], [-117.26066, 33.00626], [-117.26003, 33.00589], [-117.25972, 33.00557], [-117.25947, 33.00491], [-117.25957, 33.00483], [-117.25923, 33.00381], [-117.2588, 33.00344], [-117.25859, 33.00253], [-117.2588, 33.00172], [-117.25872, 33.00139], [-117.25829, 33.0005], [-117.25825, 33.0003], [-117.25846, 33.0003], [-117.2604, 33.00252], [-117.26197, 33.00312], [-117.26213, 33.00334], [-117.26214, 33.00387], [-117.26433, 33.00388], [-117.26433, 33.00262], [-117.26471, 33.00262], [-117.26472, 33.00248], [-117.26513, 33.00249], [-117.26513, 33.00208], [-117.26657, 33.00209], [-117.26659, 33.00211], [-117.2669, 33.00284], [-117.26699, 33.00292], [-117.26713, 33.00294], [-117.26724, 33.00291], [-117.2673, 33.00286], [-117.2678, 33.00198], [-117.26806, 33.00198], [-117.26818, 33.00279], [-117.26812, 33.00299], [-117.26835, 33.00318], [-117.26842, 33.0035], [-117.2686, 33.00363], [-117.26861, 33.00391], [-117.27039, 33.00393], [-117.2704, 33.00381], [-117.27061, 33.00383], [-117.27072, 33.00382], [-117.27089, 33.00376], [-117.27131, 33.00356], [-117.27158, 33.00354], [-117.27197, 33.00355], [-117.2721, 33.00359], [-117.27221, 33.0036], [-117.27223, 33.00361], [-117.2724, 33.00364], [-117.27248, 33.0037], [-117.27258, 33.0037], [-117.27269, 33.00406], [-117.27274, 33.00414], [-117.27287, 33.00423], [-117.27291, 33.00739]], [[-117.26716, 33.00301], [-117.26673, 33.00297], [-117.26688, 33.0036], [-117.26733, 33.00348], [-117.26726, 33.00297], [-117.26716, 33.00301]]], [[[-117.25116, 33.00742], [-117.25114, 33.00903], [-117.25115, 33.01098], [-117.24055, 33.01098], [-117.23939, 33.00941], [-117.2428, 33.00937], [-117.2428, 33.0092], [-117.24294, 33.00923], [-117.24295, 33.00922], [-117.24295, 33.00892], [-117.2428, 33.00883], [-117.24281, 33.00747], [-117.24445, 33.00745], [-117.24444, 33.00563], [-117.24552, 33.00564], [-117.24553, 33.00744], [-117.25116, 33.00742]]], [[[-117.27505, 33.0139], [-117.275, 33.01393], [-117.27475, 33.01377], [-117.27434, 33.01359], [-117.27395, 33.01348], [-117.27374, 33.01345], [-117.27352, 33.01343], [-117.27351, 33.01315], [-117.27319, 33.01314], [-117.27309, 33.01322], [-117.27307, 33.01326], [-117.27304, 33.01336], [-117.27305, 33.01344], [-117.27284, 33.01347], [-117.27256, 33.01347], [-117.27231, 33.01344], [-117.272, 33.01337], [-117.27171, 33.01326], [-117.27134, 33.01306], [-117.27104, 33.01279], [-117.27096, 33.01269], [-117.27083, 33.01249], [-117.27404, 33.01107], [-117.27469, 33.01223], [-117.27472, 33.01331], [-117.27505, 33.0139]]], [[[-117.25907, 33.01465], [-117.25889, 33.01488], [-117.25873, 33.01505], [-117.25836, 33.01536], [-117.25815, 33.0155], [-117.25784, 33.01568], [-117.25757, 33.0158], [-117.25711, 33.01597], [-117.25673, 33.01617], [-117.25651, 33.01633], [-117.25568, 33.01708], [-117.25569, 33.01468], [-117.25907, 33.01465]]], [[[-117.24895, 33.02066], [-117.24723, 33.0218], [-117.24698, 33.0218], [-117.24696, 33.02001], [-117.24894, 33.02002], [-117.24895, 33.02066]]]]} | Restricted Access 2 | 1714 | San Elijo Lagoon Ecological Reserve | 24877 | 319 | San Diego, County of 104 | County 3 | County Agency 3 | http://www.sandiegocounty.gov/parks/ | County 3 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 268.615 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
15562 | 15562 | 15561 | {"type": "MultiPolygon", "coordinates": [[[[-117.27823, 33.00739], [-117.27696, 33.00739], [-117.27579, 33.00316], [-117.2755, 33.00216], [-117.27644, 33.00177], [-117.27683, 33.00232], [-117.27723, 33.00297], [-117.27744, 33.00338], [-117.27757, 33.0037], [-117.27771, 33.0041], [-117.27781, 33.00452], [-117.2779, 33.00499], [-117.27814, 33.00683], [-117.27823, 33.00739]]], [[[-117.27827, 33.01398], [-117.27762, 33.01405], [-117.27724, 33.01413], [-117.27725, 33.0146], [-117.27718, 33.01464], [-117.27697, 33.01464], [-117.27691, 33.01459], [-117.27686, 33.01463], [-117.27657, 33.01463], [-117.27654, 33.01461], [-117.27648, 33.01463], [-117.27616, 33.01463], [-117.27604, 33.01458], [-117.27598, 33.01463], [-117.27583, 33.01464], [-117.2755, 33.01431], [-117.27505, 33.0139], [-117.27472, 33.01331], [-117.27469, 33.01223], [-117.27405, 33.01107], [-117.27083, 33.01249], [-117.27086, 33.01242], [-117.26978, 33.01017], [-117.26866, 33.00967], [-117.26761, 33.00948], [-117.2676, 33.00938], [-117.26698, 33.0093], [-117.26671, 33.00929], [-117.26645, 33.00932], [-117.26566, 33.00961], [-117.26287, 33.00739], [-117.2729, 33.00739], [-117.27287, 33.00423], [-117.27333, 33.00446], [-117.27349, 33.0045], [-117.27363, 33.00449], [-117.27373, 33.00446], [-117.2738, 33.00443], [-117.27391, 33.00435], [-117.27411, 33.004], [-117.27412, 33.00396], [-117.27409, 33.00359], [-117.274, 33.00359], [-117.27392, 33.00254], [-117.27418, 33.0023], [-117.27488, 33.00236], [-117.27527, 33.00379], [-117.2751, 33.00385], [-117.27518, 33.00413], [-117.27536, 33.00412], [-117.27585, 33.00585], [-117.27471, 33.0061], [-117.27504, 33.00738], [-117.27627, 33.00739], [-117.27714, 33.01056], [-117.27795, 33.01322], [-117.27798, 33.01337], [-117.27813, 33.01375], [-117.27827, 33.01398]]], [[[-117.26399, 33.01038], [-117.26271, 33.01096], [-117.26242, 33.01114], [-117.2624, 33.01115], [-117.26215, 33.01132], [-117.26175, 33.0117], [-117.26171, 33.01175], [-117.26175, 33.0118], [-117.25948, 33.01385], [-117.25945, 33.01403], [-117.25879, 33.01464], [-117.25879, 33.01465], [-117.25569, 33.01469], [-117.25568, 33.01708], [-117.25558, 33.01714], [-117.25557, 33.01763], [-117.25537, 33.01812], [-117.25221, 33.01809], [-117.25123, 33.0188], [-117.25123, 33.02002], [-117.24697, 33.02001], [-117.24698, 33.0218], [-117.24792, 33.0218], [-117.24916, 33.02175], [-117.24922, 33.02323], [-117.24911, 33.02332], [-117.24913, 33.02285], [-117.24911, 33.02201], [-117.24905, 33.0218], [-117.24793, 33.02184], [-117.24792, 33.02181], [-117.24791, 33.02181], [-117.24749, 33.02222], [-117.24648, 33.02303], [-117.24617, 33.02318], [-117.24534, 33.02333], [-117.24407, 33.02496], [-117.24393, 33.02511], [-117.24374, 33.02525], [-117.2435, 33.02539], [-117.2432, 33.02551], [-117.24204, 33.02552], [-117.24211, 33.02687], [-117.24209, 33.02689], [-117.2421, 33.02692], [-117.24194, 33.02703], [-117.24122, 33.02768], [-117.24112, 33.02764], [-117.24108, 33.02761], [-117.24104, 33.02755], [-117.24103, 33.0275], [-117.24115, 33.02713], [-117.2412, 33.02671], [-117.24119, 33.02651], [-117.24113, 33.02634], [-117.24089, 33.02586], [-117.24076, 33.02542], [-117.24072, 33.02511], [-117.24068, 33.02487], [-117.24051, 33.02429], [-117.2405, 33.02407], [-117.24051, 33.02387], [-117.24061, 33.02332], [-117.24179, 33.02155], [-117.24182, 33.02176], [-117.24429, 33.02045], [-117.24431, 33.01797], [-117.24693, 33.01677], [-117.24688, 33.01279], [-117.24674, 33.01278], [-117.24282, 33.0128], [-117.2428, 33.01115], [-117.24069, 33.01116], [-117.24056, 33.01098], [-117.25115, 33.01098], [-117.25114, 33.00903], [-117.25116, 33.00742], [-117.25547, 33.00739], [-117.26028, 33.00739], [-117.26077, 33.00794], [-117.26399, 33.01038]]]]} | Open Access 1 | 1719 | San Elijo Lagoon Ecological Reserve | 32291 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/San-Elijo-Lagoon-ER | San Diego 4 | 609.254 | San Elijo Lagoon ER | 1983 | State Conservation Area 8 | 2 |
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]);