units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 8 and UNIT_NAME = "Batiquitos Lagoon Ecological Reserve"
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 |
| 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]);