units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where DES_TP = 15, MNG_AGENCY = 47, MNG_AG_TYP = 5 and YR_EST = 1948
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 3 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 3 ✖
DES_TP 1
- State Park · 3 ✖
ACCESS_TYP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10530 | 10530 | 10529 | {"type": "Polygon", "coordinates": [[[-120.67131, 34.90254], [-120.65299, 34.90277], [-120.64528, 34.90274], [-120.64528, 34.90009], [-120.64412, 34.90026], [-120.64411, 34.89945], [-120.64356, 34.89941], [-120.6419, 34.89213], [-120.64256, 34.8931], [-120.64449, 34.8983], [-120.64849, 34.90111], [-120.653, 34.90106], [-120.66639, 34.901], [-120.67103, 34.90205], [-120.67131, 34.90254]]]} | Open Access 1 | 18734 | Point Sal State Beach | 1693 | 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=605 | Santa Barbara 7 | 126.988 | Point Sal SB | 1948 | State Park 15 | 4 |
16440 | 16440 | 16439 | {"type": "MultiPolygon", "coordinates": [[[[-119.27128, 34.2566], [-119.27103, 34.25667], [-119.27081, 34.25615], [-119.27105, 34.25608], [-119.27128, 34.2566]]], [[[-119.2715, 34.25714], [-119.27126, 34.25721], [-119.27104, 34.2567], [-119.27129, 34.25663], [-119.2715, 34.25714]]], [[[-119.29055, 34.27536], [-119.2901, 34.27622], [-119.28912, 34.2759], [-119.28859, 34.27564], [-119.28858, 34.27558], [-119.28627, 34.27419], [-119.28558, 34.27375], [-119.28554, 34.27375], [-119.28489, 34.27329], [-119.28498, 34.27321], [-119.28498, 34.27319], [-119.28397, 34.27247], [-119.28346, 34.27218], [-119.28293, 34.27195], [-119.28253, 34.27182], [-119.28219, 34.27173], [-119.28176, 34.27165], [-119.28141, 34.27161], [-119.28079, 34.27159], [-119.27945, 34.27165], [-119.27878, 34.27165], [-119.27796, 34.27159], [-119.27715, 34.27146], [-119.27662, 34.27134], [-119.27623, 34.27123], [-119.27585, 34.2711], [-119.27536, 34.2709], [-119.27488, 34.27067], [-119.27454, 34.27048], [-119.27427, 34.2703], [-119.274, 34.27007], [-119.27383, 34.26988], [-119.27367, 34.26969], [-119.27855, 34.26723], [-119.2762, 34.26469], [-119.27594, 34.26437], [-119.27469, 34.26266], [-119.2734, 34.26073], [-119.27197, 34.25814], [-119.27107, 34.25605], [-119.27121, 34.25601], [-119.27208, 34.25792], [-119.27289, 34.25768], [-119.27295, 34.25772], [-119.27289, 34.25777], [-119.27214, 34.25801], [-119.27211, 34.25816], [-119.27248, 34.25886], [-119.27306, 34.25981], [-119.27332, 34.26006], [-119.2739, 34.2611], [-119.274, 34.26119], [-119.2741, 34.26119], [-119.27428, 34.26115], [-119.27469, 34.26097], [-119.27472, 34.26102], [-119.27471, 34.26105], [-119.27415, 34.26129], [-119.27408, 34.26139], [-119.27414, 34.2615], [-119.2748, 34.26242], [-119.27538, 34.26332], [-119.2756, 34.2637], [-119.27581, 34.26394], [-119.27599, 34.26396], [-119.27657, 34.26371], [-119.27663, 34.26376], [-119.27663, 34.2638], [-119.27623, 34.26406], [-119.27672, 34.26476], [-119.27721, 34.26536], [-119.27781, 34.26589], [-119.27851, 34.26665], [-119.27907, 34.26731], [-119.27995, 34.26821], [-119.2817, 34.26994], [-119.28237, 34.27051], [-119.28275, 34.27073], [-119.28324, 34.27036], [-119.28331, 34.27034], [-119.2833, 34.27039], [-119.2831, 34.27057], [-119.28336, 34.27091], [-119.28522, 34.27248], [-119.28571, 34.27285], [-119.28669, 34.27348], [-119.28782, 34.27417], [-119.28871, 34.27462], [-119.28928, 34.27486], [-119.28978, 34.2751], [-119.29055, 34.27536]]], [[[-119.27173, 34.25767], [-119.27148, 34.25774], [-119.27127, 34.25724], [-119.27152, 34.25716], [-119.27173, 34.25767]]], [[[-119.27196, 34.25819], [-119.27172, 34.25828], [-119.27149, 34.25777], [-119.27174, 34.2577], [-119.27196, 34.25819]]], [[[-119.27219, 34.25861], [-119.27195, 34.2587], [-119.27173, 34.2583], [-119.27197, 34.25821], [-119.27219, 34.25861]]], [[[-119.27248, 34.25913], [-119.27224, 34.25923], [-119.27197, 34.25873], [-119.2722, 34.25863], [-119.27248, 34.25913]]], [[[-119.27277, 34.25965], [-119.27253, 34.25974], [-119.27226, 34.25925], [-119.27249, 34.25916], [-119.27277, 34.25965]]], [[[-119.27305, 34.26016], [-119.27281, 34.26025], [-119.27254, 34.25977], [-119.27278, 34.25967], [-119.27305, 34.26016]]], [[[-119.27334, 34.26068], [-119.2731, 34.26077], [-119.27283, 34.26028], [-119.27306, 34.26019], [-119.27334, 34.26068]]], [[[-119.27363, 34.26113], [-119.2734, 34.26123], [-119.27311, 34.2608], [-119.27335, 34.26071], [-119.27363, 34.26113]]], [[[-119.27394, 34.26159], [-119.27371, 34.2617], [-119.27341, 34.26126], [-119.27364, 34.26115], [-119.27394, 34.26159]]], [[[-119.27424, 34.26205], [-119.27401, 34.26216], [-119.27372, 34.26172], [-119.27395, 34.26162], [-119.27424, 34.26205]]], [[[-119.27509, 34.26326], [-119.27487, 34.26338], [-119.27444, 34.2628], [-119.27403, 34.26218], [-119.27426, 34.26207], [-119.27466, 34.26267], [-119.27509, 34.26326]]], [[[-119.27541, 34.2637], [-119.27519, 34.26381], [-119.27488, 34.2634], [-119.27511, 34.26329], [-119.27541, 34.2637]]], [[[-119.27574, 34.26414], [-119.27551, 34.26426], [-119.2752, 34.26384], [-119.27543, 34.26372], [-119.27574, 34.26414]]], [[[-119.27608, 34.2646], [-119.27586, 34.26472], [-119.27553, 34.26428], [-119.27576, 34.26417], [-119.27608, 34.2646]]], [[[-119.27645, 34.26502], [-119.27624, 34.26514], [-119.27588, 34.26474], [-119.2761, 34.26462], [-119.27645, 34.26502]]], [[[-119.27684, 34.26543], [-119.27662, 34.26556], [-119.27626, 34.26517], [-119.27647, 34.26504], [-119.27684, 34.26543]]], [[[-119.27696, 34.26556], [-119.27675, 34.2657], [-119.27664, 34.26558], [-119.27686, 34.26546], [-119.27696, 34.26556]]], [[[-119.27724, 34.26586], [-119.27703, 34.26599], [-119.27684, 34.26579], [-119.27704, 34.26565], [-119.27724, 34.26586]]], [[[-119.27762, 34.26627], [-119.27741, 34.2664], [-119.27705, 34.26601], [-119.27726, 34.26588], [-119.27762, 34.26627]]], [[[-119.27803, 34.2667], [-119.27782, 34.26684], [-119.27743, 34.26643], [-119.27764, 34.26629], [-119.27803, 34.2667]]], [[[-119.27845, 34.26716], [-119.27826, 34.26726], [-119.27822, 34.26726], [-119.27784, 34.26686], [-119.27805, 34.26672], [-119.27845, 34.26716]]]]} | Open Access 1 | 316 | San Buenaventura State Beach | 1723 | 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=600 | Ventura 8 | 97.587 | San Buenaventura SB | 1948 | State Park 15 | 4 |
16469 | 16469 | 16468 | {"type": "Polygon", "coordinates": [[[-121.87069, 36.94019], [-121.86966, 36.94078], [-121.86919, 36.9404], [-121.86859, 36.9397], [-121.86848, 36.93935], [-121.86811, 36.93884], [-121.86699, 36.93758], [-121.86642, 36.93721], [-121.86637, 36.93722], [-121.86599, 36.93691], [-121.86636, 36.93651], [-121.86509, 36.93478], [-121.86474, 36.93483], [-121.86336, 36.93308], [-121.86319, 36.93316], [-121.86278, 36.93284], [-121.86235, 36.93321], [-121.86045, 36.93232], [-121.8607, 36.93192], [-121.8607, 36.9319], [-121.86213, 36.93166], [-121.86214, 36.93165], [-121.86121, 36.93044], [-121.86033, 36.92938], [-121.85931, 36.9279], [-121.85795, 36.92554], [-121.85686, 36.92399], [-121.85605, 36.9225], [-121.85513, 36.92109], [-121.85436, 36.91983], [-121.85428, 36.91967], [-121.85427, 36.91967], [-121.85358, 36.92094], [-121.85326, 36.92086], [-121.8529, 36.9207], [-121.85283, 36.92059], [-121.85262, 36.92063], [-121.85248, 36.92074], [-121.85246, 36.92088], [-121.85235, 36.92099], [-121.85222, 36.92127], [-121.85206, 36.92127], [-121.85196, 36.92116], [-121.8518, 36.92138], [-121.8517, 36.92138], [-121.85163, 36.92112], [-121.85139, 36.92103], [-121.85117, 36.92097], [-121.85063, 36.92121], [-121.84998, 36.92236], [-121.85058, 36.92257], [-121.85051, 36.92269], [-121.85052, 36.9227], [-121.85147, 36.92304], [-121.85156, 36.92292], [-121.85215, 36.92313], [-121.85179, 36.92346], [-121.84892, 36.9225], [-121.84919, 36.922], [-121.84857, 36.92178], [-121.84929, 36.92043], [-121.84638, 36.91715], [-121.84521, 36.91586], [-121.84861, 36.91493], [-121.84885, 36.9153], [-121.8505, 36.91507], [-121.85068, 36.91536], [-121.85151, 36.91524], [-121.85135, 36.91494], [-121.85152, 36.91491], [-121.85153, 36.9149], [-121.84965, 36.91216], [-121.84938, 36.91158], [-121.84874, 36.91075], [-121.84826, 36.91006], [-121.84848, 36.90998], [-121.84877, 36.91031], [-121.84897, 36.91058], [-121.84918, 36.91084], [-121.84958, 36.91143], [-121.85033, 36.91232], [-121.8517, 36.91456], [-121.85185, 36.91474], [-121.85197, 36.91492], [-121.852, 36.915], [-121.85206, 36.91522], [-121.8522, 36.91555], [-121.85242, 36.91586], [-121.85285, 36.91672], [-121.85333, 36.91762], [-121.85341, 36.91782], [-121.85359, 36.91818], [-121.85365, 36.91827], [-121.85398, 36.91889], [-121.8544, 36.91958], [-121.85451, 36.91972], [-121.8551, 36.92067], [-121.85532, 36.92098], [-121.85571, 36.92158], [-121.85584, 36.9218], [-121.85591, 36.92188], [-121.85661, 36.92297], [-121.85679, 36.9232], [-121.85699, 36.92353], [-121.85721, 36.92383], [-121.85764, 36.92456], [-121.8579, 36.92493], [-121.85813, 36.92532], [-121.85859, 36.92593], [-121.85876, 36.92621], [-121.85917, 36.92676], [-121.85981, 36.92768], [-121.8612, 36.92941], [-121.86165, 36.93001], [-121.86212, 36.93057], [-121.86241, 36.93103], [-121.86286, 36.93161], [-121.86688, 36.93638], [-121.87069, 36.94019]]]} | Open Access 1 | 17537 | Manresa State Beach | 1619 | 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=545 | Santa Cruz 5 | 140.157 | Manresa SB | 1948 | 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]);