units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
15637 | 15637 | 15636 | {"type": "MultiPolygon", "coordinates": [[[[-117.29913, 33.08782], [-117.296, 33.08783], [-117.2961, 33.09165], [-117.29506, 33.09132], [-117.29447, 33.09119], [-117.29399, 33.09112], [-117.29368, 33.09104], [-117.2933, 33.09101], [-117.29317, 33.09104], [-117.29273, 33.09131], [-117.29159, 33.09153], [-117.29145, 33.09161], [-117.29119, 33.09195], [-117.29122, 33.09209], [-117.29092, 33.09265], [-117.29069, 33.09263], [-117.29055, 33.09233], [-117.29061, 33.09211], [-117.29034, 33.09156], [-117.29014, 33.09155], [-117.28933, 33.09103], [-117.28869, 33.09113], [-117.28836, 33.09138], [-117.28839, 33.09145], [-117.28751, 33.09185], [-117.2875, 33.09199], [-117.28707, 33.09197], [-117.28667, 33.09191], [-117.28609, 33.09218], [-117.28594, 33.09218], [-117.2858, 33.09243], [-117.28541, 33.09235], [-117.28503, 33.09256], [-117.28438, 33.09257], [-117.28374, 33.09245], [-117.28356, 33.09233], [-117.28362, 33.0918], [-117.28297, 33.09161], [-117.28264, 33.09145], [-117.28199, 33.09146], [-117.28169, 33.09166], [-117.28148, 33.09219], [-117.28178, 33.09255], [-117.28098, 33.09295], [-117.28058, 33.09312], [-117.27922, 33.09404], [-117.2787, 33.09397], [-117.27868, 33.09395], [-117.27849, 33.09399], [-117.27823, 33.09392], [-117.27784, 33.09398], [-117.27746, 33.09412], [-117.27715, 33.09402], [-117.27744, 33.09379], [-117.27735, 33.09355], [-117.27702, 33.09357], [-117.2769, 33.09367], [-117.27653, 33.09371], [-117.2765, 33.09377], [-117.27625, 33.09371], [-117.27629, 33.09347], [-117.27598, 33.09332], [-117.27567, 33.09331], [-117.27499, 33.09352], [-117.27495, 33.09385], [-117.27485, 33.09385], [-117.27477, 33.09351], [-117.27465, 33.09352], [-117.27448, 33.0933], [-117.27448, 33.09326], [-117.27439, 33.09324], [-117.27412, 33.09316], [-117.27415, 33.09308], [-117.27414, 33.09307], [-117.27356, 33.09311], [-117.27351, 33.09329], [-117.27325, 33.09329], [-117.27313, 33.09348], [-117.27233, 33.09352], [-117.27149, 33.09332], [-117.27163, 33.09308], [-117.27099, 33.09295], [-117.27071, 33.09282], [-117.27048, 33.09283], [-117.2703, 33.09301], [-117.27011, 33.09307], [-117.27011, 33.09336], [-117.26959, 33.09349], [-117.26939, 33.09361], [-117.26927, 33.09402], [-117.26884, 33.09406], [-117.2691, 33.09349], [-117.26905, 33.09328], [-117.26915, 33.09306], [-117.2692, 33.09274], [-117.2694, 33.09233], [-117.26939, 33.09232], [-117.26909, 33.09228], [-117.26959, 33.09091], [-117.26969, 33.09051], [-117.26974, 33.09006], [-117.26973, 33.08974], [-117.26968, 33.0893], [-117.26914, 33.08688], [-117.26907, 33.08645], [-117.26905, 33.08621], [-117.26895, 33.0858], [-117.26896, 33.08569], [-117.26901, 33.0856], [-117.2691, 33.08553], [-117.2692, 33.08549], [-117.26995, 33.08542], [-117.27, 33.08634], [-117.27226, 33.08537], [-117.27266, 33.08545], [-117.27305, 33.08556], [-117.2735, 33.08574], [-117.27549, 33.08667], [-117.27723, 33.08753], [-117.27774, 33.08773], [-117.27833, 33.0879], [-117.27866, 33.08808], [-117.27893, 33.08802], [-117.2795, 33.08807], [-117.28, 33.08809], [-117.28049, 33.08806], [-117.28089, 33.08801], [-117.28337, 33.08757], [-117.28557, 33.08736], [-117.28897, 33.08739], [-117.29074, 33.08746], [-117.29403, 33.08635], [-117.29551, 33.08529], [-117.29563, 33.08547], [-117.29694, 33.08588], [-117.29866, 33.08722], [-117.29913, 33.08782]], [[-117.28911, 33.08744], [-117.28912, 33.08742], [-117.2891, 33.08742], [-117.2891, 33.08744], [-117.28911, 33.08744]]], [[[-117.30633, 33.0891], [-117.30621, 33.08968], [-117.3061, 33.08989], [-117.30599, 33.09005], [-117.30585, 33.09021], [-117.30547, 33.09053], [-117.30534, 33.09068], [-117.30452, 33.09207], [-117.30327, 33.09029], [-117.3049, 33.08911], [-117.30633, 33.0891]]], [[[-117.30981, 33.08934], [-117.30886, 33.08952], [-117.30803, 33.08948], [-117.30787, 33.08951], [-117.30774, 33.08955], [-117.30767, 33.08964], [-117.30769, 33.0898], [-117.30752, 33.08981], [-117.30679, 33.0891], [-117.3097, 33.08909], [-117.30981, 33.08934]]], [[[-117.31196, 33.08767], [-117.31147, 33.08776], [-117.31087, 33.08784], [-117.31081, 33.08787], [-117.3108, 33.08792], [-117.31083, 33.08801], [-117.31145, 33.0887], [-117.31157, 33.08893], [-117.3115, 33.08908], [-117.31131, 33.08917], [-117.31094, 33.08932], [-117.3106, 33.0894], [-117.30986, 33.08747], [-117.31032, 33.08713], [-117.31097, 33.08695], [-117.31177, 33.08717], [-117.31196, 33.08767]]]]} | Restricted Access 2 | 44945 | Batiquitos Lagoon Ecological Reserve | 15864 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 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 | 410.657 | Batiquitos 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]);