superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_NAME = "Santa Susana Pass State Historic Park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15204 | 15204 | 15203 | {"type": "MultiPolygon", "coordinates": [[[[-118.63271, 34.26846], [-118.63228, 34.26865], [-118.63215, 34.26875], [-118.63205, 34.26886], [-118.63194, 34.26904], [-118.6319, 34.26916], [-118.63188, 34.2695], [-118.63186, 34.26958], [-118.63181, 34.26968], [-118.63174, 34.26976], [-118.63132, 34.27], [-118.63084, 34.27034], [-118.63074, 34.27038], [-118.63055, 34.2704], [-118.63039, 34.27045], [-118.6301, 34.27062], [-118.62981, 34.27077], [-118.62971, 34.27085], [-118.62962, 34.27101], [-118.62958, 34.27126], [-118.62961, 34.27149], [-118.62973, 34.27184], [-118.62971, 34.27191], [-118.62966, 34.27196], [-118.62959, 34.27198], [-118.62948, 34.27198], [-118.62941, 34.27196], [-118.62931, 34.27192], [-118.62911, 34.27169], [-118.62902, 34.27152], [-118.62887, 34.27136], [-118.62848, 34.27101], [-118.62837, 34.27094], [-118.62824, 34.27089], [-118.62804, 34.27087], [-118.6278, 34.27093], [-118.62756, 34.27103], [-118.62721, 34.27123], [-118.62701, 34.2714], [-118.62684, 34.27164], [-118.62675, 34.27174], [-118.62662, 34.27183], [-118.6264, 34.27194], [-118.62628, 34.27205], [-118.62623, 34.27212], [-118.62621, 34.2722], [-118.6262, 34.27256], [-118.62617, 34.27271], [-118.6261, 34.27287], [-118.62599, 34.273], [-118.62592, 34.27314], [-118.62587, 34.27328], [-118.62585, 34.27343], [-118.62582, 34.27353], [-118.62574, 34.27364], [-118.62566, 34.27371], [-118.62555, 34.27377], [-118.62544, 34.27381], [-118.62528, 34.27382], [-118.62513, 34.27381], [-118.62448, 34.2736], [-118.62509, 34.27343], [-118.62472, 34.27246], [-118.62363, 34.27224], [-118.62331, 34.27234], [-118.62192, 34.27233], [-118.62238, 34.27325], [-118.62244, 34.27375], [-118.62279, 34.27423], [-118.62259, 34.27428], [-118.62245, 34.27427], [-118.62218, 34.27414], [-118.62195, 34.27409], [-118.62158, 34.27409], [-118.6212, 34.27412], [-118.621, 34.27411], [-118.6208, 34.27404], [-118.62058, 34.27392], [-118.62048, 34.27385], [-118.6204, 34.27375], [-118.62036, 34.27365], [-118.6203, 34.27336], [-118.62024, 34.2732], [-118.62014, 34.27302], [-118.61999, 34.27284], [-118.61975, 34.27268], [-118.6196, 34.27262], [-118.61938, 34.27255], [-118.61924, 34.27248], [-118.61911, 34.27238], [-118.61895, 34.27216], [-118.61879, 34.272], [-118.6186, 34.27186], [-118.61841, 34.27179], [-118.61821, 34.27175], [-118.618, 34.27176], [-118.6176, 34.27183], [-118.61692, 34.27193], [-118.61662, 34.27201], [-118.61607, 34.27224], [-118.61587, 34.27231], [-118.61564, 34.27236], [-118.61524, 34.2724], [-118.61572, 34.27147], [-118.61612, 34.27122], [-118.61679, 34.27122], [-118.6168, 34.27111], [-118.61698, 34.2711], [-118.61715, 34.27104], [-118.61732, 34.27093], [-118.61742, 34.27081], [-118.61747, 34.27082], [-118.61785, 34.27077], [-118.61832, 34.27022], [-118.61989, 34.27017], [-118.61909, 34.2679], [-118.6181, 34.26791], [-118.61738, 34.26734], [-118.61718, 34.26734], [-118.61716, 34.26731], [-118.61481, 34.26733], [-118.6148, 34.26365], [-118.61526, 34.26363], [-118.61526, 34.26288], [-118.61531, 34.26283], [-118.61521, 34.26248], [-118.61562, 34.26213], [-118.61562, 34.2621], [-118.61624, 34.26172], [-118.61635, 34.26172], [-118.61664, 34.26157], [-118.61694, 34.26147], [-118.61694, 34.26401], [-118.61806, 34.26401], [-118.61928, 34.2637], [-118.61928, 34.26399], [-118.61935, 34.264], [-118.6205, 34.2637], [-118.62091, 34.26363], [-118.62087, 34.26334], [-118.62136, 34.26332], [-118.6219, 34.26334], [-118.62732, 34.26397], [-118.62937, 34.26393], [-118.62936, 34.26392], [-118.62353, 34.26325], [-118.62354, 34.26226], [-118.62411, 34.26234], [-118.6242, 34.26193], [-118.6239, 34.26154], [-118.62356, 34.26119], [-118.6234, 34.26122], [-118.62332, 34.26138], [-118.62028, 34.25827], [-118.61812, 34.25972], [-118.61706, 34.25972], [-118.61543, 34.25721], [-118.61484, 34.25721], [-118.61484, 34.2567], [-118.61915, 34.2567], [-118.61917, 34.25526], [-118.62236, 34.25526], [-118.62237, 34.25075], [-118.62195, 34.2504], [-118.62176, 34.25026], [-118.62146, 34.25008], [-118.62114, 34.24994], [-118.6208, 34.24983], [-118.6204, 34.24974], [-118.62009, 34.24971], [-118.61963, 34.24971], [-118.61982, 34.2495], [-118.62095, 34.24951], [-118.62097, 34.24964], [-118.62204, 34.24965], [-118.62206, 34.24993], [-118.6232, 34.24993], [-118.62322, 34.2501], [-118.62411, 34.2501], [-118.62412, 34.24991], [-118.62499, 34.24991], [-118.625, 34.24946], [-118.63265, 34.24941], [-118.63262, 34.25305], [-118.62805, 34.25308], [-118.62803, 34.2567], [-118.62797, 34.25672], [-118.62795, 34.25849], [-118.62796, 34.25851], [-118.62932, 34.25851], [-118.62891, 34.26032], [-118.63152, 34.26032], [-118.6316, 34.26052], [-118.63173, 34.26058], [-118.6322, 34.26064], [-118.63215, 34.26088], [-118.6322, 34.26102], [-118.63255, 34.26139], [-118.63255, 34.26343], [-118.63271, 34.26846]]], [[[-118.61694, 34.26081], [-118.61694, 34.2613], [-118.61667, 34.26137], [-118.61641, 34.26147], [-118.6162, 34.26158], [-118.61588, 34.26177], [-118.61586, 34.26159], [-118.61481, 34.26138], [-118.61481, 34.26029], [-118.61515, 34.2603], [-118.61694, 34.26081]]], [[[-118.62962, 34.27234], [-118.62893, 34.27242], [-118.62828, 34.27213], [-118.62794, 34.27235], [-118.62792, 34.27241], [-118.62782, 34.27249], [-118.62782, 34.27122], [-118.62761, 34.2712], [-118.6278, 34.2711], [-118.62803, 34.27104], [-118.62817, 34.27105], [-118.6283, 34.2711], [-118.62876, 34.2715], [-118.62885, 34.27161], [-118.62895, 34.27179], [-118.62917, 34.27202], [-118.62935, 34.27211], [-118.62956, 34.27214], [-118.62962, 34.27234]]], [[[-118.63273, 34.26909], [-118.63271, 34.26914], [-118.6327, 34.2694], [-118.63235, 34.26985], [-118.63184, 34.27006], [-118.63121, 34.27053], [-118.63107, 34.27118], [-118.63031, 34.27169], [-118.62991, 34.27176], [-118.62982, 34.27151], [-118.62978, 34.27128], [-118.62981, 34.27107], [-118.62984, 34.271], [-118.62989, 34.27093], [-118.62996, 34.27088], [-118.63022, 34.27075], [-118.63047, 34.27059], [-118.63057, 34.27056], [-118.6308, 34.27054], [-118.63095, 34.27048], [-118.63144, 34.27012], [-118.63178, 34.26995], [-118.63188, 34.26988], [-118.63198, 34.26977], [-118.63205, 34.26964], [-118.63208, 34.26952], [-118.63208, 34.2692], [-118.63219, 34.26899], [-118.63228, 34.26888], [-118.63239, 34.26879], [-118.63271, 34.26864], [-118.63273, 34.26909]]]]} | Open Access 1 | Santa Susana Pass State Historic Park | http://www.parks.ca.gov/?page_id=611 | 1739 | 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 | 682.572 | Santa Susana Pass SHP | 1979 |
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]);