units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, DES_TP = 8 and LABEL_NAME = "Coal Oil Point Natural Reserve"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
DES_TP 1
- State Conservation Area · 1 ✖
ACCESS_TYP 1
- Restricted Access · 1 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7672 | 7672 | 7671 | {"type": "Polygon", "coordinates": [[[-119.88447, 34.41537], [-119.88109, 34.41543], [-119.8811, 34.41769], [-119.87698, 34.41751], [-119.87697, 34.41748], [-119.87253, 34.41749], [-119.87264, 34.41654], [-119.87287, 34.41634], [-119.87326, 34.41582], [-119.87337, 34.41572], [-119.87354, 34.41562], [-119.87402, 34.41543], [-119.87405, 34.41541], [-119.87415, 34.41528], [-119.87415, 34.4152], [-119.87413, 34.41511], [-119.87398, 34.41487], [-119.8737, 34.41453], [-119.8736, 34.41438], [-119.87358, 34.41429], [-119.87366, 34.41409], [-119.87406, 34.41367], [-119.87424, 34.41353], [-119.87484, 34.41345], [-119.87492, 34.41343], [-119.87511, 34.4133], [-119.87521, 34.41316], [-119.87535, 34.41284], [-119.87544, 34.41272], [-119.87573, 34.41241], [-119.87588, 34.41226], [-119.87597, 34.4122], [-119.8761, 34.41214], [-119.87647, 34.41204], [-119.87677, 34.41186], [-119.87692, 34.41168], [-119.87702, 34.41149], [-119.87731, 34.41112], [-119.87748, 34.41083], [-119.87809, 34.41023], [-119.87832, 34.40993], [-119.87843, 34.40976], [-119.8785, 34.40956], [-119.87848, 34.4095], [-119.87828, 34.40933], [-119.87753, 34.40893], [-119.87745, 34.40884], [-119.87746, 34.40873], [-119.87745, 34.40867], [-119.87755, 34.40847], [-119.8776, 34.40821], [-119.87773, 34.40793], [-119.87778, 34.40784], [-119.87783, 34.4078], [-119.87802, 34.40771], [-119.87823, 34.40767], [-119.87837, 34.40768], [-119.87892, 34.40783], [-119.87898, 34.40775], [-119.87895, 34.40755], [-119.87836, 34.40717], [-119.87818, 34.4072], [-119.87779, 34.40751], [-119.87745, 34.40752], [-119.87739, 34.40733], [-119.87753, 34.40714], [-119.87764, 34.40705], [-119.8778, 34.40697], [-119.87796, 34.40689], [-119.87807, 34.40685], [-119.87821, 34.40684], [-119.87839, 34.40687], [-119.87864, 34.40696], [-119.87905, 34.40717], [-119.88006, 34.40796], [-119.88044, 34.40829], [-119.88136, 34.40918], [-119.88176, 34.40962], [-119.88228, 34.41026], [-119.88332, 34.41179], [-119.88351, 34.41198], [-119.8837, 34.41226], [-119.88443, 34.41319], [-119.88447, 34.41537]]]} | Restricted Access 2 | 7582 | Coal Oil Point Natural Reserve | 33181 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | http://coaloilpoint.ucnrs.org/ | Santa Barbara 7 | 174.185 | Coal Oil Point Natural Reserve | 0 | 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]);