units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 1, MNG_AGENCY = 1 and YR_EST = 0
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6286 | 6286 | 6285 | {"type": "Polygon", "coordinates": [[[-120.99489, 35.76641], [-120.9948, 35.77005], [-120.99019, 35.76999], [-120.9901, 35.77362], [-120.98088, 35.77351], [-120.98096, 35.76988], [-120.98095, 35.76987], [-120.97635, 35.76981], [-120.97626, 35.77345], [-120.96703, 35.77333], [-120.96712, 35.76969], [-120.97634, 35.76981], [-120.97643, 35.76621], [-120.99027, 35.76638], [-120.99489, 35.76641]]]} | Open Access 1 | 1372 | Tierra Redonda Mountain Natural Area | 26354 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Luis Obispo 1 | 331.67 | Tierra Redonda Mtn. Natural Area | 0 | Area of Critical Environmental Concern 509 | 3 | |
| 16905 | 16905 | 16904 | {"type": "MultiPolygon", "coordinates": [[[[-120.96273, 35.60361], [-120.96271, 35.60713], [-120.95835, 35.60701], [-120.95844, 35.61045], [-120.95429, 35.61023], [-120.95416, 35.60679], [-120.94984, 35.60655], [-120.94983, 35.60656], [-120.94996, 35.61005], [-120.94566, 35.60986], [-120.93796, 35.60988], [-120.93801, 35.6062], [-120.94278, 35.60624], [-120.94269, 35.60248], [-120.92903, 35.60221], [-120.92436, 35.60208], [-120.92442, 35.59419], [-120.9233, 35.59408], [-120.92287, 35.59058], [-120.92739, 35.5904], [-120.92767, 35.59447], [-120.93814, 35.59539], [-120.93804, 35.59882], [-120.94261, 35.59879], [-120.9427, 35.60248], [-120.94544, 35.60253], [-120.94524, 35.59601], [-120.95809, 35.59654], [-120.95822, 35.60342], [-120.96273, 35.60361]]], [[[-120.94475, 35.5896], [-120.94126, 35.58977], [-120.94098, 35.58624], [-120.94449, 35.58608], [-120.94475, 35.5896]]], [[[-120.96337, 35.62004], [-120.95981, 35.61993], [-120.95944, 35.6174], [-120.95534, 35.6172], [-120.9548, 35.61378], [-120.95895, 35.61399], [-120.95944, 35.6174], [-120.96312, 35.61759], [-120.96337, 35.62004]]]]} | Open Access 1 | 12076 | Cypress Mountain Natural Area | 17875 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | http://www.blm.gov/wo/st/en.html | US Bureau of Land Management 1 | 102 | United States Bureau of Land Management 1 | Federal 1 | Federal Agency 1 | San Luis Obispo 1 | 962.122 | Cypress Mtn. Natural Area | 0 | Area of Critical Environmental Concern 509 | 3 |
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]);