units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, DES_TP = 8 and LABEL_NAME = "Morro Bay Wildlife Area"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16774 | 16774 | 16773 | {"type": "Polygon", "coordinates": [[[-120.86553, 35.31438], [-120.86552, 35.31585], [-120.8655, 35.31606], [-120.86538, 35.31654], [-120.86541, 35.31685], [-120.86529, 35.31688], [-120.865, 35.31687], [-120.86458, 35.31689], [-120.86426, 35.31697], [-120.86413, 35.31703], [-120.86404, 35.31711], [-120.86391, 35.31729], [-120.86386, 35.31743], [-120.86381, 35.31751], [-120.86374, 35.31758], [-120.86367, 35.31773], [-120.86371, 35.31817], [-120.86375, 35.31829], [-120.86383, 35.31845], [-120.86386, 35.31857], [-120.86386, 35.31868], [-120.86376, 35.31884], [-120.86369, 35.31893], [-120.86335, 35.31904], [-120.86323, 35.3191], [-120.86314, 35.31919], [-120.86311, 35.31939], [-120.86315, 35.3196], [-120.86313, 35.31975], [-120.86302, 35.31987], [-120.86294, 35.32002], [-120.8629, 35.32029], [-120.86261, 35.32054], [-120.86251, 35.32093], [-120.86242, 35.32103], [-120.86216, 35.32114], [-120.86212, 35.32118], [-120.86209, 35.32155], [-120.86207, 35.32169], [-120.86197, 35.32211], [-120.86197, 35.32222], [-120.86211, 35.32244], [-120.86224, 35.32259], [-120.86251, 35.32307], [-120.86254, 35.32317], [-120.86255, 35.32329], [-120.86251, 35.3234], [-120.86231, 35.32361], [-120.86209, 35.3238], [-120.86175, 35.32403], [-120.86141, 35.32418], [-120.86105, 35.32437], [-120.86064, 35.32461], [-120.86048, 35.32478], [-120.8603, 35.32502], [-120.86023, 35.32529], [-120.86023, 35.32547], [-120.86025, 35.32573], [-120.86025, 35.32608], [-120.86023, 35.3264], [-120.86029, 35.3266], [-120.86054, 35.32725], [-120.86053, 35.32738], [-120.86048, 35.32749], [-120.8604, 35.32755], [-120.8603, 35.32761], [-120.86002, 35.32766], [-120.85981, 35.32775], [-120.85971, 35.32784], [-120.85957, 35.32796], [-120.85952, 35.3281], [-120.8595, 35.32826], [-120.85949, 35.32841], [-120.85953, 35.32853], [-120.85973, 35.32881], [-120.85994, 35.32905], [-120.86027, 35.32933], [-120.86032, 35.32942], [-120.86029, 35.32988], [-120.86023, 35.32999], [-120.86013, 35.33006], [-120.85999, 35.33011], [-120.85992, 35.33018], [-120.85981, 35.33046], [-120.85977, 35.33064], [-120.85962, 35.33094], [-120.85953, 35.33105], [-120.85949, 35.33116], [-120.8594, 35.33124], [-120.85932, 35.33136], [-120.8593, 35.3315], [-120.85926, 35.33201], [-120.85927, 35.33237], [-120.8594, 35.33251], [-120.85945, 35.33258], [-120.85945, 35.33268], [-120.85942, 35.3328], [-120.85933, 35.33299], [-120.85931, 35.33309], [-120.85934, 35.3332], [-120.85939, 35.33327], [-120.85943, 35.33338], [-120.85953, 35.33375], [-120.85966, 35.33394], [-120.85967, 35.33403], [-120.85961, 35.33426], [-120.85952, 35.33439], [-120.8594, 35.33444], [-120.85929, 35.33447], [-120.85897, 35.33448], [-120.85886, 35.3345], [-120.85853, 35.33465], [-120.8582, 35.33472], [-120.85774, 35.3348], [-120.85744, 35.33494], [-120.85735, 35.33506], [-120.85736, 35.33511], [-120.8574, 35.33516], [-120.85742, 35.33534], [-120.85748, 35.33545], [-120.85765, 35.33565], [-120.85773, 35.33584], [-120.85774, 35.33589], [-120.85771, 35.33604], [-120.85774, 35.33615], [-120.85771, 35.33618], [-120.8577, 35.33623], [-120.85776, 35.33641], [-120.85776, 35.33646], [-120.85772, 35.33653], [-120.85771, 35.33666], [-120.85771, 35.337], [-120.85774, 35.33706], [-120.85793, 35.33727], [-120.85806, 35.33746], [-120.85814, 35.33768], [-120.8582, 35.33788], [-120.85821, 35.33798], [-120.85819, 35.33806], [-120.85813, 35.33816], [-120.85823, 35.33869], [-120.85832, 35.33894], [-120.85871, 35.33968], [-120.85897, 35.34028], [-120.85911, 35.34088], [-120.8591, 35.34092], [-120.85881, 35.34108], [-120.85861, 35.34126], [-120.85847, 35.34148], [-120.85843, 35.34157], [-120.85841, 35.34176], [-120.85842, 35.34187], [-120.85845, 35.342], [-120.85844, 35.34212], [-120.8584, 35.34214], [-120.8583, 35.34216], [-120.85818, 35.34221], [-120.85809, 35.34227], [-120.85793, 35.3426], [-120.85792, 35.34266], [-120.85793, 35.34275], [-120.85798, 35.34286], [-120.858, 35.34318], [-120.85803, 35.34323], [-120.85813, 35.34329], [-120.85818, 35.34329], [-120.8582, 35.34321], [-120.85824, 35.34321], [-120.85826, 35.34324], [-120.85826, 35.34332], [-120.85823, 35.3435], [-120.85819, 35.34361], [-120.85815, 35.34365], [-120.85782, 35.34366], [-120.85771, 35.34371], [-120.85764, 35.34377], [-120.85759, 35.34385], [-120.85757, 35.34411], [-120.85757, 35.34433], [-120.85756, 35.34443], [-120.85753, 35.3445], [-120.85725, 35.34472], [-120.85717, 35.34481], [-120.85703, 35.34506], [-120.85698, 35.34519], [-120.85696, 35.34531], [-120.85682, 35.34549], [-120.85646, 35.34586], [-120.85635, 35.34613], [-120.85631, 35.34616], [-120.85624, 35.34617], [-120.85614, 35.34639], [-120.85615, 35.34663], [-120.8561, 35.34688], [-120.85635, 35.34733], [-120.85669, 35.34759], [-120.8568, 35.3477], [-120.85706, 35.34804], [-120.85709, 35.3481], [-120.85709, 35.34823], [-120.85718, 35.34844], [-120.85737, 35.3487], [-120.85765, 35.34901], [-120.85797, 35.34927], [-120.85817, 35.34943], [-120.85836, 35.34953], [-120.85842, 35.34959], [-120.85862, 35.34983], [-120.85888, 35.3501], [-120.8593, 35.35076], [-120.85949, 35.3511], [-120.8598, 35.35285], [-120.8435, 35.34928], [-120.84339, 35.34885], [-120.84365, 35.34772], [-120.8439, 35.34737], [-120.84419, 35.34728], [-120.84433, 35.34699], [-120.84463, 35.34665], [-120.84442, 35.3464], [-120.84426, 35.3463], [-120.84344, 35.33164], [-120.84359, 35.33146], [-120.84422, 35.33056], [-120.8442, 35.33055], [-120.84479, 35.32897], [-120.84465, 35.3283], [-120.84226, 35.32727], [-120.84199, 35.32714], [-120.84115, 35.3268], [-120.84051, 35.32616], [-120.84035, 35.32593], [-120.84027, 35.32511], [-120.84041, 35.32436], [-120.84069, 35.3238], [-120.84157, 35.32248], [-120.84305, 35.32222], [-120.84319, 35.32215], [-120.84526, 35.32195], [-120.84642, 35.32149], [-120.84804, 35.32132], [-120.84815, 35.32137], [-120.84822, 35.32126], [-120.84987, 35.32176], [-120.85038, 35.32168], [-120.85046, 35.32165], [-120.85057, 35.32155], [-120.85063, 35.32158], [-120.85076, 35.32147], [-120.85092, 35.32139], [-120.85086, 35.32134], [-120.8521, 35.31941], [-120.85215, 35.3193], [-120.85317, 35.31855], [-120.85361, 35.3181], [-120.854, 35.31778], [-120.85604, 35.31827], [-120.86108, 35.31702], [-120.86109, 35.31665], [-120.86149, 35.3165], [-120.86209, 35.31614], [-120.86232, 35.31618], [-120.86299, 35.31589], [-120.86362, 35.31574], [-120.86426, 35.31556], [-120.86491, 35.31515], [-120.86527, 35.31474], [-120.86552, 35.31443], [-120.86553, 35.31438]]]} | Open Access 1 | 25324 | Morro Bay Wildlife Area | 30475 | 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 | San Luis Obispo 1 | 1266.86 | Morro Bay Wildlife Area | 1997 | 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]);