superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 47 and PARK_URL = "http://www.parks.ca.gov/?page_id=437"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 1 ✖
ACCESS_TYP 1
- Open Access · 1 ✖
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15269 | 15269 | 15268 | {"type": "MultiPolygon", "coordinates": [[[[-123.76025, 38.973], [-123.72603, 39.0061], [-123.69603, 39.00647], [-123.6946, 39.00641], [-123.69417, 39.00573], [-123.69381, 39.00594], [-123.69298, 39.00535], [-123.69304, 39.0046], [-123.69321, 39.00401], [-123.69293, 39.00379], [-123.69311, 39.00277], [-123.69331, 39.00191], [-123.69583, 39.00201], [-123.69704, 38.99992], [-123.69736, 38.99973], [-123.69767, 38.99893], [-123.6981, 38.99798], [-123.6981, 38.99733], [-123.69817, 38.99435], [-123.68855, 38.99447], [-123.68795, 38.99348], [-123.68746, 38.99274], [-123.68716, 38.99232], [-123.68664, 38.99168], [-123.68609, 38.99094], [-123.68608, 38.98748], [-123.68487, 38.98753], [-123.68499, 38.98676], [-123.68564, 38.98516], [-123.68694, 38.98175], [-123.68694, 38.98118], [-123.68701, 38.98046], [-123.69112, 38.98057], [-123.69109, 38.98331], [-123.69544, 38.98319], [-123.69542, 38.98189], [-123.69544, 38.98058], [-123.70473, 38.98051], [-123.70477, 38.9822], [-123.70695, 38.98223], [-123.70681, 38.97647], [-123.70778, 38.97643], [-123.70783, 38.97284], [-123.70912, 38.97283], [-123.70915, 38.96926], [-123.71326, 38.96621], [-123.71454, 38.96646], [-123.71455, 38.96645], [-123.71448, 38.96616], [-123.71341, 38.96588], [-123.71222, 38.96537], [-123.71108, 38.96516], [-123.71025, 38.96439], [-123.71151, 38.96422], [-123.71155, 38.96435], [-123.71172, 38.96451], [-123.71183, 38.96456], [-123.71195, 38.9646], [-123.7121, 38.96461], [-123.71225, 38.9646], [-123.71236, 38.96456], [-123.71245, 38.96451], [-123.71256, 38.96442], [-123.71263, 38.9643], [-123.71402, 38.96506], [-123.71427, 38.96517], [-123.71396, 38.9638], [-123.71266, 38.96404], [-123.71261, 38.96392], [-123.71257, 38.96386], [-123.71246, 38.96375], [-123.71231, 38.96368], [-123.71216, 38.96365], [-123.71211, 38.96361], [-123.71199, 38.96288], [-123.71197, 38.96245], [-123.71203, 38.96197], [-123.71214, 38.96162], [-123.7122, 38.96148], [-123.71235, 38.9612], [-123.71322, 38.95993], [-123.71331, 38.95991], [-123.71369, 38.96002], [-123.71397, 38.96007], [-123.71438, 38.96012], [-123.71468, 38.96011], [-123.71455, 38.95932], [-123.71418, 38.95935], [-123.71422, 38.95992], [-123.71367, 38.95982], [-123.7133, 38.95971], [-123.71292, 38.95954], [-123.71258, 38.95934], [-123.71242, 38.95923], [-123.71214, 38.95898], [-123.7119, 38.9587], [-123.71171, 38.95839], [-123.71151, 38.95791], [-123.71141, 38.95777], [-123.7113, 38.95766], [-123.71132, 38.9576], [-123.71159, 38.95709], [-123.71168, 38.95683], [-123.71443, 38.95708], [-123.71444, 38.95706], [-123.71168, 38.95681], [-123.71172, 38.9565], [-123.71168, 38.9561], [-123.71162, 38.95591], [-123.71147, 38.95559], [-123.71129, 38.95535], [-123.71107, 38.9551], [-123.71074, 38.95484], [-123.71045, 38.95467], [-123.70996, 38.95446], [-123.70964, 38.95436], [-123.70932, 38.95429], [-123.70901, 38.95424], [-123.7087, 38.95422], [-123.70854, 38.95421], [-123.70812, 38.95424], [-123.70775, 38.95432], [-123.70746, 38.95441], [-123.70706, 38.95458], [-123.70679, 38.95474], [-123.70643, 38.95503], [-123.70622, 38.95524], [-123.70602, 38.9555], [-123.70588, 38.95572], [-123.70493, 38.95544], [-123.7053, 38.95471], [-123.70571, 38.95369], [-123.70644, 38.9517], [-123.70773, 38.95202], [-123.71026, 38.95271], [-123.71358, 38.95358], [-123.71383, 38.95353], [-123.71417, 38.95414], [-123.71441, 38.95464], [-123.71445, 38.95481], [-123.72324, 38.95477], [-123.72797, 38.95483], [-123.72799, 38.95715], [-123.72775, 38.95733], [-123.72731, 38.95759], [-123.72686, 38.95801], [-123.72634, 38.95841], [-123.72634, 38.95842], [-123.73978, 38.96417], [-123.76025, 38.973]], [[-123.69781, 39.00271], [-123.69779, 39.00269], [-123.6969, 39.00365], [-123.69488, 39.00426], [-123.69325, 39.00401], [-123.69323, 39.00402], [-123.69364, 39.00462], [-123.69676, 39.00471], [-123.69689, 39.00449], [-123.69707, 39.00429], [-123.69714, 39.00416], [-123.69744, 39.00326], [-123.69773, 39.00285], [-123.69781, 39.00271]], [[-123.69636, 39.00561], [-123.69634, 39.0056], [-123.69621, 39.00583], [-123.6962, 39.00598], [-123.69636, 39.00561]], [[-123.70337, 38.99224], [-123.70339, 38.99217], [-123.70338, 38.99216], [-123.70312, 38.9925], [-123.70285, 38.99291], [-123.70271, 38.99322], [-123.70256, 38.99351], [-123.70225, 38.99392], [-123.70224, 38.99405], [-123.70245, 38.99377], [-123.70248, 38.99368], [-123.70281, 38.99316], [-123.70288, 38.99301], [-123.70337, 38.99224]], [[-123.70839, 38.98224], [-123.70837, 38.98223], [-123.7083, 38.98234], [-123.70807, 38.9829], [-123.70835, 38.98236], [-123.70839, 38.98224]], [[-123.71081, 38.9779], [-123.71079, 38.97789], [-123.71075, 38.97796], [-123.71072, 38.97807], [-123.71081, 38.9779]]], [[[-123.70535, 38.96364], [-123.70319, 38.96348], [-123.70272, 38.96311], [-123.7025, 38.96283], [-123.70159, 38.96372], [-123.69906, 38.96409], [-123.69905, 38.9605], [-123.69907, 38.95938], [-123.69903, 38.95859], [-123.69906, 38.95821], [-123.69906, 38.95754], [-123.70136, 38.95747], [-123.70209, 38.95746], [-123.70215, 38.95748], [-123.70217, 38.95752], [-123.70217, 38.95805], [-123.7022, 38.95824], [-123.70228, 38.95847], [-123.70239, 38.95865], [-123.703, 38.95938], [-123.70403, 38.96053], [-123.70466, 38.96128], [-123.70512, 38.96187], [-123.70513, 38.96192], [-123.70508, 38.96205], [-123.70509, 38.96212], [-123.70518, 38.96222], [-123.70532, 38.96226], [-123.70535, 38.96364]]], [[[-123.70231, 38.95562], [-123.70225, 38.95733], [-123.70072, 38.95735], [-123.70074, 38.95535], [-123.70231, 38.95562]]], [[[-123.71306, 38.95982], [-123.71305, 38.9599], [-123.71239, 38.96084], [-123.71216, 38.96119], [-123.71206, 38.96138], [-123.71187, 38.96189], [-123.71179, 38.96239], [-123.7117, 38.96242], [-123.71064, 38.96243], [-123.71054, 38.96246], [-123.71049, 38.96251], [-123.71047, 38.96254], [-123.71047, 38.9626], [-123.7105, 38.96264], [-123.71055, 38.96268], [-123.71066, 38.9627], [-123.71076, 38.96266], [-123.71082, 38.96258], [-123.71089, 38.96256], [-123.71171, 38.96255], [-123.71175, 38.96255], [-123.7118, 38.96259], [-123.71183, 38.96289], [-123.71193, 38.96363], [-123.71191, 38.96367], [-123.71178, 38.96372], [-123.71158, 38.96388], [-123.7115, 38.96408], [-123.7115, 38.96416], [-123.71019, 38.96434], [-123.70971, 38.96391], [-123.70928, 38.96316], [-123.70873, 38.96184], [-123.70858, 38.96181], [-123.708, 38.96254], [-123.70816, 38.96383], [-123.70769, 38.96424], [-123.70543, 38.96364], [-123.7054, 38.96226], [-123.70552, 38.96222], [-123.7056, 38.96215], [-123.70564, 38.96203], [-123.70562, 38.96194], [-123.70559, 38.9619], [-123.70548, 38.96183], [-123.70532, 38.96182], [-123.70528, 38.96179], [-123.7045, 38.96083], [-123.70294, 38.95901], [-123.70256, 38.95856], [-123.70247, 38.95839], [-123.70239, 38.95816], [-123.70238, 38.95798], [-123.70238, 38.95752], [-123.70241, 38.95748], [-123.7025, 38.95746], [-123.7043, 38.95743], [-123.70502, 38.95701], [-123.70512, 38.95693], [-123.70532, 38.95682], [-123.70551, 38.95676], [-123.7057, 38.95672], [-123.70602, 38.9567], [-123.70629, 38.95672], [-123.70658, 38.95679], [-123.70687, 38.95694], [-123.70727, 38.9572], [-123.70764, 38.9574], [-123.70796, 38.95753], [-123.70838, 38.95764], [-123.70894, 38.95772], [-123.70938, 38.95773], [-123.70993, 38.95769], [-123.71036, 38.95762], [-123.71072, 38.95762], [-123.71092, 38.95767], [-123.71101, 38.95771], [-123.71112, 38.95778], [-123.71122, 38.95786], [-123.71135, 38.95805], [-123.71146, 38.95835], [-123.71163, 38.95867], [-123.71172, 38.95882], [-123.71198, 38.95911], [-123.71228, 38.95937], [-123.71247, 38.95949], [-123.71266, 38.95961], [-123.71303, 38.95978], [-123.71306, 38.95982]]], [[[-123.70758, 38.95587], [-123.70685, 38.95674], [-123.70648, 38.95661], [-123.70619, 38.95656], [-123.70579, 38.95655], [-123.70576, 38.95655], [-123.70572, 38.95649], [-123.70572, 38.95639], [-123.70579, 38.95617], [-123.70607, 38.95564], [-123.70626, 38.95538], [-123.7065, 38.95514], [-123.70758, 38.95587]]], [[[-123.71127, 38.95735], [-123.71119, 38.9575], [-123.71113, 38.95755], [-123.71109, 38.95757], [-123.71086, 38.9575], [-123.71072, 38.95748], [-123.71047, 38.95747], [-123.70975, 38.95757], [-123.70941, 38.95759], [-123.70912, 38.95759], [-123.70875, 38.95756], [-123.70837, 38.95749], [-123.70817, 38.95744], [-123.7077, 38.95726], [-123.70914, 38.95617], [-123.70866, 38.95561], [-123.7081, 38.95439], [-123.7085, 38.95435], [-123.70878, 38.95436], [-123.70907, 38.95438], [-123.70961, 38.9545], [-123.70998, 38.95461], [-123.7103, 38.95475], [-123.71058, 38.95491], [-123.71092, 38.95517], [-123.71114, 38.95541], [-123.71131, 38.95566], [-123.71145, 38.95594], [-123.71153, 38.95625], [-123.71154, 38.95656], [-123.71151, 38.95681], [-123.71142, 38.95708], [-123.71127, 38.95735]]]]} | Open Access 1 | Manchester State Park | http://www.parks.ca.gov/?page_id=437 | 1960 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 5303.306 | Manchester SP | 1955 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);