units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, COUNTY = 4, MNG_AG_TYP = 5 and YR_EST = 1983
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15553 | 15553 | 15552 | {"type": "MultiPolygon", "coordinates": [[[[-117.31177, 33.08716], [-117.31097, 33.08695], [-117.31032, 33.08713], [-117.30986, 33.08747], [-117.30871, 33.0838], [-117.30937, 33.08358], [-117.30942, 33.08364], [-117.31037, 33.08461], [-117.31037, 33.08463], [-117.31046, 33.08471], [-117.31077, 33.0851], [-117.31109, 33.08558], [-117.31122, 33.0858], [-117.31142, 33.0862], [-117.31177, 33.08716]]], [[[-117.28912, 33.08742], [-117.28912, 33.08744], [-117.28909, 33.08744], [-117.28909, 33.08742], [-117.28912, 33.08742]]], [[[-117.3097, 33.08908], [-117.30489, 33.0891], [-117.30327, 33.09029], [-117.3023, 33.08894], [-117.30142, 33.08757], [-117.30096, 33.0874], [-117.3008, 33.087], [-117.30112, 33.08734], [-117.30214, 33.08708], [-117.30369, 33.08636], [-117.30459, 33.08529], [-117.30502, 33.08485], [-117.30503, 33.08483], [-117.30539, 33.08445], [-117.30567, 33.08408], [-117.30807, 33.08406], [-117.30937, 33.08815], [-117.3097, 33.08908]]], [[[-117.3024, 33.09298], [-117.30198, 33.09308], [-117.30159, 33.09313], [-117.30126, 33.09313], [-117.30107, 33.09311], [-117.30074, 33.09303], [-117.30047, 33.09291], [-117.30025, 33.09276], [-117.29985, 33.09233], [-117.29948, 33.09234], [-117.2989, 33.09159], [-117.2985, 33.09155], [-117.29708, 33.09182], [-117.29667, 33.09179], [-117.2961, 33.09165], [-117.29609, 33.09132], [-117.29611, 33.09131], [-117.29605, 33.08981], [-117.296, 33.08782], [-117.29913, 33.08782], [-117.30025, 33.08927], [-117.30108, 33.09068], [-117.3024, 33.09298]]]]} | Open Access 1 | 1109 | Batiquitos Lagoon Ecological Reserve | 32042 | 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/Batiquitos-Lagoon-ER | San Diego 4 | 142.251 | Batiquitos 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]);