units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where COUNTY = 10 and DES_TP = 15
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5314 | 5314 | 5313 | {"type": "MultiPolygon", "coordinates": [[[[-117.65112, 33.88518], [-117.65112, 33.88524], [-117.65075, 33.88593], [-117.65062, 33.88625], [-117.65052, 33.88655], [-117.65042, 33.88697], [-117.64996, 33.88712], [-117.65026, 33.88744], [-117.65022, 33.88756], [-117.64951, 33.88762], [-117.64971, 33.88805], [-117.65006, 33.88838], [-117.65009, 33.88856], [-117.64724, 33.88851], [-117.64703, 33.88828], [-117.64638, 33.88801], [-117.64634, 33.88727], [-117.64664, 33.88709], [-117.64661, 33.8869], [-117.64631, 33.88677], [-117.64626, 33.886], [-117.64657, 33.88589], [-117.64655, 33.88574], [-117.64946, 33.88479], [-117.65112, 33.88518]]], [[[-117.66475, 33.88794], [-117.66435, 33.88796], [-117.66385, 33.88794], [-117.66335, 33.88789], [-117.66296, 33.88782], [-117.64961, 33.88474], [-117.65126, 33.8842], [-117.65132, 33.88153], [-117.65332, 33.88116], [-117.65394, 33.88103], [-117.65442, 33.88088], [-117.65496, 33.88066], [-117.65584, 33.88018], [-117.65592, 33.87992], [-117.65677, 33.8801], [-117.65704, 33.88023], [-117.65688, 33.88018], [-117.65666, 33.88016], [-117.65645, 33.88019], [-117.65625, 33.88026], [-117.65518, 33.88095], [-117.65454, 33.88129], [-117.65438, 33.88143], [-117.65416, 33.8817], [-117.65462, 33.88199], [-117.65475, 33.88204], [-117.65492, 33.88208], [-117.65506, 33.88208], [-117.65524, 33.88205], [-117.65537, 33.88201], [-117.65555, 33.88192], [-117.65575, 33.88187], [-117.65675, 33.8819], [-117.65732, 33.88213], [-117.65918, 33.88354], [-117.66028, 33.88397], [-117.66078, 33.88439], [-117.66107, 33.88458], [-117.66139, 33.8847], [-117.66169, 33.88473], [-117.662, 33.88469], [-117.66227, 33.88458], [-117.66284, 33.88544], [-117.66475, 33.88794]]], [[[-117.67653, 33.88889], [-117.66341, 33.88881], [-117.65497, 33.88863], [-117.65026, 33.88856], [-117.65021, 33.88835], [-117.64987, 33.88803], [-117.64973, 33.88774], [-117.65041, 33.88767], [-117.65047, 33.8874], [-117.65024, 33.88717], [-117.6506, 33.88705], [-117.65069, 33.88662], [-117.65077, 33.88633], [-117.65104, 33.88572], [-117.65125, 33.88538], [-117.65252, 33.88568], [-117.65252, 33.88575], [-117.65347, 33.88596], [-117.65351, 33.88577], [-117.65127, 33.88526], [-117.65128, 33.88521], [-117.66304, 33.88792], [-117.66374, 33.88801], [-117.66435, 33.88804], [-117.66476, 33.88802], [-117.66516, 33.88798], [-117.66576, 33.88788], [-117.66615, 33.88779], [-117.66662, 33.88764], [-117.66699, 33.88749], [-117.66734, 33.88732], [-117.66768, 33.88714], [-117.66816, 33.88682], [-117.66845, 33.88659], [-117.66873, 33.88634], [-117.66898, 33.88607], [-117.66921, 33.8858], [-117.66942, 33.8855], [-117.6696, 33.8852], [-117.66976, 33.88488], [-117.67055, 33.88312], [-117.67106, 33.88362], [-117.67079, 33.88357], [-117.67079, 33.88359], [-117.67274, 33.88539], [-117.67276, 33.88671], [-117.67291, 33.88679], [-117.67292, 33.88705], [-117.6757, 33.88837], [-117.67653, 33.88889]]]]} | Open Access 1 | 5614 | Chino Hills State Park | 1478 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=648 | Riverside 10 | 292.456 | Chino Hills SP | 1981 | State Park 15 | 4 |
| 16539 | 16539 | 16538 | {"type": "MultiPolygon", "coordinates": [[[[-116.7519, 33.78651], [-116.75086, 33.78637], [-116.74932, 33.78637], [-116.74929, 33.78674], [-116.74496, 33.78678], [-116.74496, 33.78634], [-116.74165, 33.78631], [-116.74183, 33.78623], [-116.74187, 33.78459], [-116.7364, 33.78454], [-116.73635, 33.78688], [-116.71926, 33.78706], [-116.71977, 33.80146], [-116.71963, 33.80817], [-116.71952, 33.81444], [-116.71949, 33.82201], [-116.71979, 33.82505], [-116.71947, 33.82582], [-116.71945, 33.83129], [-116.70167, 33.83132], [-116.63232, 33.83094], [-116.61542, 33.83094], [-116.61456, 33.8295], [-116.61455, 33.827], [-116.61537, 33.82512], [-116.61546, 33.82329], [-116.61551, 33.81597], [-116.61556, 33.78749], [-116.64935, 33.78757], [-116.67558, 33.78774], [-116.68391, 33.78738], [-116.70177, 33.78764], [-116.70178, 33.78732], [-116.70287, 33.77307], [-116.70282, 33.7694], [-116.70278, 33.76939], [-116.70253, 33.76276], [-116.7027, 33.76275], [-116.7027, 33.76252], [-116.70684, 33.76261], [-116.7069, 33.76201], [-116.70687, 33.75907], [-116.71122, 33.75894], [-116.71123, 33.75716], [-116.71198, 33.75715], [-116.71199, 33.75635], [-116.7114, 33.75615], [-116.71139, 33.75608], [-116.71124, 33.75603], [-116.71124, 33.75535], [-116.71142, 33.75534], [-116.71143, 33.75505], [-116.71188, 33.75504], [-116.71191, 33.75173], [-116.71228, 33.75172], [-116.71228, 33.75229], [-116.71513, 33.75225], [-116.71515, 33.75533], [-116.71746, 33.75525], [-116.71748, 33.75607], [-116.72003, 33.75598], [-116.72, 33.75869], [-116.72003, 33.76226], [-116.71567, 33.7659], [-116.71571, 33.76943], [-116.72006, 33.76931], [-116.72008, 33.77278], [-116.73138, 33.77267], [-116.73139, 33.7756], [-116.73126, 33.77583], [-116.73127, 33.77609], [-116.73213, 33.77594], [-116.73253, 33.77593], [-116.73407, 33.77636], [-116.73496, 33.7764], [-116.73604, 33.77635], [-116.736, 33.77667], [-116.73605, 33.77679], [-116.73609, 33.77695], [-116.73636, 33.77716], [-116.73683, 33.77731], [-116.73726, 33.77737], [-116.73771, 33.77749], [-116.73823, 33.77771], [-116.73863, 33.7779], [-116.73909, 33.77816], [-116.73969, 33.77884], [-116.74005, 33.77913], [-116.7405, 33.77928], [-116.74078, 33.77936], [-116.74123, 33.77939], [-116.74187, 33.7793], [-116.7427, 33.77893], [-116.74314, 33.77876], [-116.7436, 33.7788], [-116.74416, 33.77904], [-116.74589, 33.78], [-116.74644, 33.78028], [-116.74704, 33.78066], [-116.7487, 33.7824], [-116.74917, 33.78269], [-116.74968, 33.78286], [-116.75069, 33.78295], [-116.7511, 33.78309], [-116.75139, 33.78338], [-116.75148, 33.78366], [-116.75146, 33.78407], [-116.75131, 33.78442], [-116.7509, 33.78482], [-116.7508, 33.78515], [-116.75083, 33.78544], [-116.75108, 33.78579], [-116.75154, 33.78615], [-116.75189, 33.78649], [-116.7519, 33.78651]]], [[[-116.71671, 33.74859], [-116.71626, 33.75015], [-116.71593, 33.75002], [-116.71568, 33.74996], [-116.71473, 33.74989], [-116.71452, 33.74981], [-116.71443, 33.74975], [-116.7143, 33.7496], [-116.71425, 33.7495], [-116.71422, 33.74941], [-116.71409, 33.74827], [-116.7141, 33.74804], [-116.71417, 33.74784], [-116.7143, 33.74764], [-116.71444, 33.74749], [-116.71477, 33.74725], [-116.71493, 33.74705], [-116.71563, 33.74746], [-116.71543, 33.74785], [-116.71671, 33.74859]]]]} | Open Access 1 | 5529 | Mount San Jacinto State Park | 1652 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=636 | Riverside 10 | 13572.357 | Mount San Jacinto SP | 1930 | State Park 15 | 4 |
| 16583 | 16583 | 16582 | {"type": "MultiPolygon", "coordinates": [[[[-116.61118, 33.4274], [-116.60579, 33.42736], [-116.60799, 33.42737], [-116.61118, 33.4274]]], [[[-116.41969, 33.42686], [-116.41969, 33.42686], [-116.41969, 33.427], [-116.41969, 33.42686], [-116.41969, 33.42686]]], [[[-116.55266, 33.51641], [-116.55266, 33.52006], [-116.54848, 33.52005], [-116.5485, 33.5164], [-116.55266, 33.51641]]], [[[-116.62157, 33.52643], [-116.61264, 33.52653], [-116.61257, 33.52261], [-116.62152, 33.52261], [-116.62157, 33.52643]]], [[[-116.55266, 33.52188], [-116.55266, 33.52553], [-116.54846, 33.52553], [-116.54846, 33.5237], [-116.55064, 33.5237], [-116.55065, 33.52188], [-116.55266, 33.52188]]], [[[-116.61694, 33.4853], [-116.60506, 33.48526], [-116.60504, 33.48914], [-116.58766, 33.48917], [-116.58768, 33.48651], [-116.60003, 33.48655], [-116.60005, 33.48528], [-116.60504, 33.48526], [-116.60505, 33.48525], [-116.60484, 33.47093], [-116.58754, 33.47083], [-116.58753, 33.47084], [-116.5875, 33.48173], [-116.58317, 33.48174], [-116.58314, 33.48282], [-116.58262, 33.48283], [-116.58257, 33.48526], [-116.57021, 33.48525], [-116.57019, 33.50011], [-116.5877, 33.50026], [-116.5877, 33.50374], [-116.58753, 33.51462], [-116.60481, 33.51477], [-116.60455, 33.52584], [-116.60453, 33.52929], [-116.58699, 33.52924], [-116.58692, 33.54343], [-116.56993, 33.54342], [-116.56992, 33.54373], [-116.56985, 33.54374], [-116.57008, 33.52907], [-116.55288, 33.52905], [-116.55288, 33.51462], [-116.54418, 33.51459], [-116.54411, 33.52901], [-116.53979, 33.52901], [-116.53986, 33.51458], [-116.53557, 33.51456], [-116.53556, 33.51458], [-116.53553, 33.51818], [-116.53766, 33.51818], [-116.53761, 33.52901], [-116.53547, 33.52901], [-116.53546, 33.52899], [-116.51824, 33.52893], [-116.51818, 33.51454], [-116.50117, 33.51431], [-116.50116, 33.51453], [-116.49687, 33.51452], [-116.49687, 33.5109], [-116.49259, 33.51089], [-116.49258, 33.51452], [-116.46684, 33.51448], [-116.46682, 33.49997], [-116.45017, 33.49995], [-116.44953, 33.49989], [-116.44978, 33.48558], [-116.4324, 33.48557], [-116.43249, 33.47115], [-116.41531, 33.47093], [-116.4153, 33.4704], [-116.41512, 33.47039], [-116.41518, 33.44193], [-116.39755, 33.44177], [-116.38829, 33.44181], [-116.38859, 33.44138], [-116.38863, 33.4269], [-116.4024, 33.42687], [-116.40241, 33.42751], [-116.4238, 33.42739], [-116.45415, 33.42737], [-116.4639, 33.42734], [-116.50776, 33.4271], [-116.52744, 33.42712], [-116.52745, 33.42702], [-116.54249, 33.42708], [-116.54814, 33.42712], [-116.55293, 33.42712], [-116.56649, 33.42719], [-116.57997, 33.42722], [-116.58753, 33.42727], [-116.58754, 33.42728], [-116.59048, 33.4273], [-116.59801, 33.42729], [-116.59802, 33.42732], [-116.60485, 33.42736], [-116.60479, 33.44177], [-116.61671, 33.44173], [-116.61672, 33.44182], [-116.61682, 33.44183], [-116.61685, 33.45634], [-116.60497, 33.45631], [-116.60484, 33.47092], [-116.61675, 33.47098], [-116.61694, 33.4853]], [[-116.58753, 33.51464], [-116.58752, 33.51463], [-116.57021, 33.51468], [-116.57008, 33.52906], [-116.58699, 33.52923], [-116.58753, 33.51464]], [[-116.57019, 33.50012], [-116.56154, 33.49972], [-116.5615, 33.50339], [-116.56099, 33.50416], [-116.56081, 33.50504], [-116.56137, 33.50648], [-116.56117, 33.5076], [-116.56114, 33.50922], [-116.56222, 33.5146], [-116.56988, 33.51461], [-116.56989, 33.51467], [-116.5702, 33.51467], [-116.57019, 33.50012]], [[-116.49258, 33.50727], [-116.48829, 33.50726], [-116.48829, 33.51088], [-116.49258, 33.51089], [-116.49258, 33.50727]], [[-116.48829, 33.50364], [-116.48401, 33.50363], [-116.484, 33.50544], [-116.48615, 33.50544], [-116.48615, 33.50726], [-116.48828, 33.50726], [-116.48829, 33.50364]], [[-116.50115, 33.50365], [-116.50116, 33.50002], [-116.49687, 33.50002], [-116.49687, 33.50364], [-116.50115, 33.50365]], [[-116.48381, 33.4856], [-116.48382, 33.48546], [-116.48381, 33.48545], [-116.46712, 33.48539], [-116.46711, 33.4854], [-116.46712, 33.48555], [-116.48381, 33.4856]], [[-116.60484, 33.44534], [-116.60483, 33.45628], [-116.60359, 33.45628], [-116.60359, 33.4563], [-116.60497, 33.4563], [-116.60489, 33.4454], [-116.60482, 33.44313], [-116.60484, 33.44534]], [[-116.58756, 33.44893], [-116.58743, 33.44892], [-116.58742, 33.44893], [-116.58753, 33.45369], [-116.58756, 33.44893]], [[-116.59796, 33.44177], [-116.60235, 33.44177], [-116.59837, 33.44172], [-116.58751, 33.44168], [-116.58746, 33.44535], [-116.58831, 33.44536], [-116.59376, 33.44524], [-116.58758, 33.44519], [-116.5876, 33.44175], [-116.59796, 33.44177]], [[-116.57027, 33.44165], [-116.57028, 33.44164], [-116.57023, 33.43742], [-116.57022, 33.44164], [-116.57027, 33.44165]], [[-116.58171, 33.43313], [-116.5817, 33.43312], [-116.57595, 33.43312], [-116.57591, 33.43724], [-116.58167, 33.43727], [-116.58171, 33.43313]]]]} | Open Access 1 | 17930 | Anza-Borrego Desert State Park | 1413 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=638 | Riverside 10 | 40107.224 | Anza-Borrego Desert SP | 1933 | State Park 15 | 4 |
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]);