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_URL = "http://www.parks.ca.gov/?page_id=415"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15254 | 15254 | 15253 | {"type": "Polygon", "coordinates": [[[-124.07725, 41.35459], [-124.07713, 41.35539], [-124.07703, 41.3558], [-124.07683, 41.35627], [-124.07681, 41.35642], [-124.07654, 41.35701], [-124.07647, 41.35722], [-124.07627, 41.35773], [-124.07607, 41.35813], [-124.07602, 41.35829], [-124.07594, 41.35848], [-124.07578, 41.35901], [-124.07569, 41.35943], [-124.07559, 41.36031], [-124.07548, 41.36081], [-124.07546, 41.36105], [-124.07548, 41.36136], [-124.07546, 41.36163], [-124.07538, 41.36207], [-124.07527, 41.36241], [-124.07482, 41.36336], [-124.07467, 41.36372], [-124.07454, 41.36434], [-124.07447, 41.36497], [-124.07442, 41.36515], [-124.07437, 41.3654], [-124.07418, 41.36611], [-124.07417, 41.36647], [-124.07402, 41.36748], [-124.0739, 41.36784], [-124.07384, 41.36798], [-124.07358, 41.36878], [-124.07342, 41.36956], [-124.0734, 41.36974], [-124.07341, 41.36992], [-124.07346, 41.37012], [-124.07359, 41.37049], [-124.07364, 41.37072], [-124.07365, 41.37086], [-124.07356, 41.37147], [-124.07351, 41.37163], [-124.07346, 41.37185], [-124.07304, 41.37323], [-124.07293, 41.3735], [-124.07277, 41.37384], [-124.0725, 41.3746], [-124.07248, 41.37469], [-124.07255, 41.37517], [-124.0724, 41.3764], [-124.07244, 41.37693], [-124.07237, 41.37775], [-124.07217, 41.37883], [-124.07199, 41.37926], [-124.07176, 41.37992], [-124.07155, 41.38045], [-124.07138, 41.38094], [-124.07134, 41.38134], [-124.07133, 41.38181], [-124.07149, 41.38191], [-124.07159, 41.38212], [-124.07159, 41.38236], [-124.07156, 41.38274], [-124.07156, 41.38318], [-124.07161, 41.38349], [-124.07163, 41.38381], [-124.07158, 41.38408], [-124.07148, 41.38443], [-124.07128, 41.38481], [-124.07118, 41.38519], [-124.07107, 41.38599], [-124.07101, 41.38702], [-124.07066, 41.38849], [-124.07053, 41.38896], [-124.07039, 41.38972], [-124.07021, 41.39119], [-124.07022, 41.39165], [-124.0701, 41.39203], [-124.06991, 41.39243], [-124.06981, 41.39275], [-124.06965, 41.39428], [-124.06937, 41.39581], [-124.06935, 41.3962], [-124.06931, 41.39676], [-124.06931, 41.39725], [-124.06924, 41.39841], [-124.06917, 41.39882], [-124.06893, 41.39934], [-124.06878, 41.39974], [-124.06861, 41.4003], [-124.06858, 41.40083], [-124.06859, 41.40168], [-124.06852, 41.40228], [-124.06837, 41.40265], [-124.06841, 41.40301], [-124.06826, 41.40341], [-124.06806, 41.40409], [-124.06753, 41.40602], [-124.06748, 41.40639], [-124.06748, 41.40682], [-124.06742, 41.40738], [-124.0673, 41.408], [-124.0671, 41.40865], [-124.06701, 41.40946], [-124.06697, 41.40991], [-124.0668, 41.41116], [-124.06667, 41.41186], [-124.06661, 41.41295], [-124.06654, 41.41336], [-124.06642, 41.41384], [-124.06626, 41.41499], [-124.06608, 41.4159], [-124.066, 41.41764], [-124.06574, 41.41918], [-124.06561, 41.4198], [-124.06548, 41.42077], [-124.06533, 41.42142], [-124.06513, 41.422], [-124.06497, 41.42257], [-124.06484, 41.42366], [-124.06487, 41.42401], [-124.06483, 41.42453], [-124.06467, 41.42575], [-124.06456, 41.42638], [-124.06435, 41.42684], [-124.06419, 41.42734], [-124.06411, 41.42792], [-124.06409, 41.42857], [-124.06415, 41.42928], [-124.06418, 41.43], [-124.06415, 41.43066], [-124.06421, 41.4309], [-124.06425, 41.43135], [-124.06409, 41.43209], [-124.06399, 41.43263], [-124.06382, 41.43455], [-124.06375, 41.435], [-124.06373, 41.43528], [-124.06364, 41.43567], [-124.0635, 41.43603], [-124.06364, 41.43638], [-124.06367, 41.43675], [-124.06354, 41.43757], [-124.06324, 41.43863], [-124.06309, 41.43908], [-124.06312, 41.43938], [-124.06306, 41.4398], [-124.06305, 41.44018], [-124.06322, 41.44059], [-124.06329, 41.44102], [-124.06328, 41.44189], [-124.06331, 41.44213], [-124.06337, 41.44236], [-124.06348, 41.44258], [-124.0637, 41.44273], [-124.06392, 41.44281], [-124.06421, 41.44288], [-124.06433, 41.44311], [-124.06423, 41.44322], [-124.06407, 41.44334], [-124.0639, 41.44339], [-124.0637, 41.4435], [-124.06366, 41.44368], [-124.06367, 41.44398], [-124.06375, 41.44439], [-124.06405, 41.44521], [-124.06406, 41.44569], [-124.06412, 41.44612], [-124.06423, 41.44657], [-124.06417, 41.44672], [-124.06416, 41.44688], [-124.06432, 41.44743], [-124.06445, 41.44757], [-124.06468, 41.44814], [-124.06499, 41.44858], [-124.06521, 41.44895], [-124.06553, 41.44982], [-124.06569, 41.45019], [-124.06592, 41.45063], [-124.06606, 41.45103], [-124.06647, 41.45179], [-124.06651, 41.45202], [-124.06645, 41.45228], [-124.06614, 41.45293], [-124.06601, 41.45327], [-124.06589, 41.45372], [-124.06588, 41.45406], [-124.06592, 41.45454], [-124.06592, 41.45502], [-124.06596, 41.45536], [-124.06573, 41.45577], [-124.06568, 41.45598], [-124.06567, 41.45623], [-124.06573, 41.45641], [-124.06585, 41.45775], [-124.06597, 41.45855], [-124.066, 41.4589], [-124.06597, 41.45921], [-124.06589, 41.45962], [-124.06582, 41.45988], [-124.06575, 41.46059], [-124.0658, 41.46092], [-124.0658, 41.46132], [-124.06595, 41.46171], [-124.06595, 41.46201], [-124.06591, 41.46218], [-124.06559, 41.46256], [-124.06539, 41.46283], [-124.06525, 41.46306], [-124.06516, 41.46341], [-124.06516, 41.46365], [-124.06509, 41.46385], [-124.06518, 41.46458], [-124.06526, 41.46505], [-124.06536, 41.46536], [-124.06539, 41.46558], [-124.06547, 41.46583], [-124.06573, 41.46632], [-124.0656, 41.4668], [-124.06555, 41.46706], [-124.06555, 41.46729], [-124.0656, 41.46757], [-124.06567, 41.46781], [-124.06579, 41.46837], [-124.06595, 41.46869], [-124.06608, 41.46892], [-124.06598, 41.46969], [-124.06597, 41.46998], [-124.06606, 41.47029], [-124.06614, 41.47063], [-124.06633, 41.47127], [-124.06663, 41.47177], [-124.06678, 41.47217], [-124.06079, 41.47219], [-124.06071, 41.46461], [-124.05583, 41.46463], [-124.05595, 41.47223], [-124.05117, 41.47218], [-124.05105, 41.46848], [-124.0463, 41.46856], [-124.04634, 41.46466], [-124.04327, 41.46465], [-124.04471, 41.46349], [-124.04548, 41.4634], [-124.04878, 41.45978], [-124.04767, 41.45777], [-124.04668, 41.45738], [-124.0327, 41.45721], [-124.03291, 41.44961], [-124.03308, 41.4459], [-124.02359, 41.44579], [-124.02395, 41.42706], [-124.0191, 41.42699], [-124.01913, 41.42341], [-124.01437, 41.42311], [-124.01454, 41.41199], [-124.00495, 41.4125], [-124.00473, 41.40522], [-124.00022, 41.40562], [-123.9993, 41.40522], [-123.99738, 41.40403], [-123.99668, 41.40364], [-123.99738, 41.40374], [-123.99739, 41.40373], [-123.99786, 41.38806], [-123.99822, 41.37368], [-123.99698, 41.3662], [-123.99633, 41.36125], [-124.00128, 41.36137], [-124.01176, 41.36128], [-124.01188, 41.36075], [-124.01553, 41.36017], [-124.01982, 41.3589], [-124.02228, 41.35843], [-124.02253, 41.35391], [-124.02692, 41.35399], [-124.02702, 41.35373], [-124.02723, 41.35271], [-124.02952, 41.3528], [-124.03012, 41.35405], [-124.03267, 41.3541], [-124.03233, 41.36143], [-124.03711, 41.36149], [-124.03539, 41.36675], [-124.03551, 41.3701], [-124.05442, 41.3734], [-124.05814, 41.37339], [-124.05816, 41.37338], [-124.05795, 41.36669], [-124.05917, 41.36665], [-124.05919, 41.36254], [-124.05932, 41.36251], [-124.0593, 41.35298], [-124.06389, 41.35303], [-124.06394, 41.34622], [-124.06447, 41.34622], [-124.06664, 41.34652], [-124.0665, 41.34947], [-124.06935, 41.35083], [-124.07056, 41.35081], [-124.07179, 41.351], [-124.07237, 41.35183], [-124.07239, 41.3524], [-124.07213, 41.3529], [-124.07233, 41.35324], [-124.073, 41.3538], [-124.0733, 41.35449], [-124.07725, 41.35459]], [[-124.04981, 41.44459], [-124.05223, 41.44465], [-124.05236, 41.44283], [-124.04829, 41.44263], [-124.04279, 41.44242], [-124.04263, 41.44619], [-124.04741, 41.44633], [-124.0473, 41.44812], [-124.04959, 41.4482], [-124.04981, 41.44459]]]} | Open Access 1 | Prairie Creek Redwoods State Park | http://www.parks.ca.gov/?page_id=415 | 1699 | 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 | 13212.103 | Prairie Creek Redwoods SP | 1923 |
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]);