units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where DES_TP = 15, MNG_AGENCY = 47 and YR_EST = 1956
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- California Department of Parks and Recreation · 2 ✖
DES_TP 1
- State Park · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16465 | 16465 | 16464 | {"type": "MultiPolygon", "coordinates": [[[[-122.43608, 37.42275], [-122.436, 37.42273], [-122.42616, 37.42242], [-122.4261, 37.42217], [-122.42603, 37.42194], [-122.42633, 37.42193], [-122.4265, 37.4223], [-122.43336, 37.42249], [-122.43422, 37.42152], [-122.43421, 37.4215], [-122.43399, 37.42142], [-122.4341, 37.42131], [-122.43446, 37.42083], [-122.43469, 37.42037], [-122.43472, 37.4203], [-122.4352, 37.41972], [-122.43527, 37.41972], [-122.43553, 37.41982], [-122.43563, 37.41988], [-122.43573, 37.41988], [-122.43582, 37.41996], [-122.43584, 37.42], [-122.43581, 37.42009], [-122.43577, 37.42012], [-122.4356, 37.42044], [-122.43551, 37.42066], [-122.43546, 37.42087], [-122.43546, 37.42112], [-122.4356, 37.4217], [-122.43562, 37.42184], [-122.43593, 37.42255], [-122.43608, 37.42275]]], [[[-122.46056, 37.49295], [-122.46009, 37.49326], [-122.45908, 37.49234], [-122.45866, 37.49256], [-122.45852, 37.49248], [-122.45819, 37.49268], [-122.45819, 37.4927], [-122.45855, 37.49303], [-122.45824, 37.49308], [-122.456, 37.4897], [-122.45555, 37.48995], [-122.45526, 37.48972], [-122.45508, 37.48981], [-122.4542, 37.48876], [-122.45222, 37.49006], [-122.45223, 37.48995], [-122.45415, 37.48869], [-122.45306, 37.48739], [-122.45178, 37.48562], [-122.4501, 37.48273], [-122.44697, 37.48397], [-122.44651, 37.48338], [-122.44616, 37.48286], [-122.44634, 37.48294], [-122.44646, 37.48296], [-122.44673, 37.48289], [-122.44688, 37.48291], [-122.44709, 37.48304], [-122.44734, 37.48299], [-122.44758, 37.48285], [-122.44782, 37.48261], [-122.44847, 37.48242], [-122.44871, 37.48231], [-122.44903, 37.48193], [-122.44961, 37.48191], [-122.44962, 37.4819], [-122.44836, 37.48038], [-122.44925, 37.47992], [-122.44926, 37.47991], [-122.44606, 37.47602], [-122.44617, 37.47596], [-122.44617, 37.47594], [-122.44542, 37.47507], [-122.44524, 37.47512], [-122.44382, 37.47342], [-122.44428, 37.47355], [-122.44471, 37.47364], [-122.44507, 37.47362], [-122.44533, 37.47355], [-122.44551, 37.4734], [-122.44593, 37.47246], [-122.44573, 37.47234], [-122.44523, 37.4723], [-122.44544, 37.47012], [-122.4443, 37.46669], [-122.44446, 37.46508], [-122.44689, 37.46526], [-122.44727, 37.46733], [-122.4473, 37.46972], [-122.44755, 37.47076], [-122.44773, 37.47113], [-122.44787, 37.47203], [-122.4491, 37.47491], [-122.4493, 37.4758], [-122.44939, 37.47585], [-122.44953, 37.47642], [-122.45088, 37.47866], [-122.4512, 37.4794], [-122.45169, 37.48015], [-122.45172, 37.4804], [-122.45195, 37.48059], [-122.45244, 37.48127], [-122.45258, 37.48182], [-122.45281, 37.48233], [-122.45281, 37.48249], [-122.45396, 37.48441], [-122.45468, 37.48585], [-122.45557, 37.48729], [-122.45632, 37.4883], [-122.45638, 37.48851], [-122.45732, 37.48956], [-122.45784, 37.49029], [-122.45838, 37.49091], [-122.45925, 37.49165], [-122.46051, 37.49292], [-122.46056, 37.49295]]], [[[-122.46335, 37.49585], [-122.46314, 37.49602], [-122.46172, 37.49469], [-122.46195, 37.49453], [-122.4621, 37.4947], [-122.46243, 37.49496], [-122.46261, 37.49516], [-122.46298, 37.49549], [-122.46307, 37.49565], [-122.46314, 37.49571], [-122.46335, 37.49585]]]]} | Open Access 1 | 16846 | Half Moon Bay State Beach | 1554 | 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/default.asp?page_id=531 | San Mateo 15 | 202.669 | Half Moon Bay SB | 1956 | State Park 15 | 4 |
16538 | 16538 | 16537 | {"type": "Polygon", "coordinates": [[[-122.34977, 37.20981], [-122.34916, 37.21214], [-122.34933, 37.21369], [-122.34872, 37.2136], [-122.34845, 37.21377], [-122.34807, 37.21378], [-122.34764, 37.214], [-122.34708, 37.21344], [-122.34604, 37.21369], [-122.34543, 37.21434], [-122.34506, 37.21502], [-122.34482, 37.21519], [-122.34582, 37.2162], [-122.34561, 37.21635], [-122.34551, 37.21647], [-122.34527, 37.21683], [-122.34525, 37.21697], [-122.34522, 37.21711], [-122.34513, 37.21723], [-122.34511, 37.21737], [-122.34512, 37.21764], [-122.34505, 37.21777], [-122.34492, 37.21786], [-122.34476, 37.21793], [-122.34435, 37.21819], [-122.33888, 37.21271], [-122.33887, 37.21272], [-122.33886, 37.21602], [-122.33308, 37.21594], [-122.33309, 37.21849], [-122.33235, 37.21847], [-122.33236, 37.21495], [-122.332, 37.21495], [-122.33114, 37.21551], [-122.33084, 37.21563], [-122.33063, 37.21564], [-122.33043, 37.21577], [-122.32992, 37.21596], [-122.32944, 37.21617], [-122.32847, 37.21648], [-122.3282, 37.21654], [-122.32823, 37.2177], [-122.32785, 37.21772], [-122.32788, 37.21883], [-122.32831, 37.21884], [-122.32842, 37.22217], [-122.32358, 37.22219], [-122.3234, 37.22968], [-122.31913, 37.22961], [-122.31912, 37.22221], [-122.32358, 37.22218], [-122.32366, 37.2186], [-122.31453, 37.21857], [-122.31453, 37.22204], [-122.30558, 37.22201], [-122.3055, 37.22936], [-122.29686, 37.2292], [-122.27959, 37.22905], [-122.26177, 37.22779], [-122.26167, 37.22146], [-122.25808, 37.222], [-122.25808, 37.22147], [-122.25758, 37.22066], [-122.25714, 37.21873], [-122.25665, 37.2188], [-122.25667, 37.21556], [-122.26168, 37.21479], [-122.26168, 37.21116], [-122.2704, 37.21108], [-122.2705, 37.20758], [-122.2794, 37.20769], [-122.27919, 37.21471], [-122.27928, 37.21839], [-122.27939, 37.22195], [-122.29213, 37.22199], [-122.29216, 37.21491], [-122.29673, 37.21498], [-122.30146, 37.21503], [-122.30149, 37.21186], [-122.30562, 37.21187], [-122.30571, 37.20786], [-122.3146, 37.20787], [-122.3147, 37.20081], [-122.29706, 37.20079], [-122.28812, 37.20084], [-122.28812, 37.2005], [-122.28824, 37.20047], [-122.28867, 37.20021], [-122.28969, 37.19991], [-122.29002, 37.19973], [-122.29056, 37.19963], [-122.2908, 37.19951], [-122.29101, 37.19932], [-122.29117, 37.19895], [-122.29126, 37.19881], [-122.29138, 37.1987], [-122.29211, 37.19825], [-122.29252, 37.19794], [-122.29312, 37.19762], [-122.29333, 37.19746], [-122.29344, 37.19734], [-122.29353, 37.19723], [-122.29366, 37.19684], [-122.29377, 37.19671], [-122.29391, 37.19658], [-122.29427, 37.19632], [-122.29457, 37.19585], [-122.29504, 37.19559], [-122.29593, 37.19559], [-122.29643, 37.19603], [-122.29704, 37.19623], [-122.29705, 37.19622], [-122.29705, 37.19606], [-122.29656, 37.1959], [-122.29597, 37.1954], [-122.29498, 37.19542], [-122.29441, 37.19574], [-122.2941, 37.19622], [-122.29377, 37.19646], [-122.29347, 37.19675], [-122.29333, 37.19717], [-122.29326, 37.19726], [-122.29315, 37.19738], [-122.29299, 37.19749], [-122.2924, 37.19781], [-122.29198, 37.19812], [-122.29132, 37.19852], [-122.29116, 37.19864], [-122.29099, 37.19886], [-122.29082, 37.19923], [-122.29067, 37.19939], [-122.29048, 37.19948], [-122.28993, 37.19957], [-122.28959, 37.19976], [-122.28872, 37.20002], [-122.28825, 37.20025], [-122.28812, 37.20028], [-122.28812, 37.19749], [-122.29251, 37.19747], [-122.29256, 37.19429], [-122.29705, 37.19419], [-122.30632, 37.19408], [-122.3156, 37.19397], [-122.32019, 37.19396], [-122.32112, 37.19488], [-122.32131, 37.19476], [-122.32163, 37.19468], [-122.32178, 37.19461], [-122.32246, 37.19444], [-122.32261, 37.19438], [-122.32303, 37.19412], [-122.32334, 37.19399], [-122.32348, 37.1939], [-122.32359, 37.19378], [-122.32382, 37.19361], [-122.32394, 37.19346], [-122.32409, 37.1932], [-122.3242, 37.19311], [-122.32439, 37.19288], [-122.32443, 37.19278], [-122.32439, 37.19254], [-122.32416, 37.19215], [-122.32403, 37.19189], [-122.32399, 37.19173], [-122.324, 37.19161], [-122.32399, 37.19135], [-122.32395, 37.19122], [-122.32381, 37.19096], [-122.32377, 37.19085], [-122.32365, 37.19059], [-122.32364, 37.19046], [-122.32366, 37.19035], [-122.32374, 37.1901], [-122.32379, 37.18999], [-122.32394, 37.18986], [-122.32424, 37.18969], [-122.32475, 37.18946], [-122.32489, 37.18935], [-122.3251, 37.18913], [-122.32527, 37.18898], [-122.3254, 37.18892], [-122.32546, 37.18886], [-122.3257, 37.18874], [-122.32592, 37.18852], [-122.32605, 37.18842], [-122.32636, 37.1883], [-122.3265, 37.18821], [-122.32684, 37.18789], [-122.32697, 37.1878], [-122.3273, 37.18769], [-122.32745, 37.18762], [-122.32785, 37.1876], [-122.32803, 37.18757], [-122.32817, 37.18752], [-122.32856, 37.18731], [-122.32885, 37.18725], [-122.32938, 37.18724], [-122.32956, 37.1872], [-122.33001, 37.18698], [-122.33013, 37.1869], [-122.33048, 37.18661], [-122.33064, 37.1865], [-122.33094, 37.18622], [-122.33104, 37.18614], [-122.33134, 37.18598], [-122.3319, 37.18588], [-122.33245, 37.18582], [-122.33295, 37.18573], [-122.33328, 37.18563], [-122.33342, 37.18557], [-122.33354, 37.18549], [-122.33371, 37.18542], [-122.33417, 37.18544], [-122.3343, 37.18542], [-122.33513, 37.18513], [-122.33533, 37.18509], [-122.33545, 37.18509], [-122.33558, 37.18511], [-122.3358, 37.18521], [-122.33622, 37.18561], [-122.33665, 37.18588], [-122.3368, 37.18594], [-122.33702, 37.18598], [-122.33722, 37.18597], [-122.33742, 37.18594], [-122.33775, 37.18586], [-122.33789, 37.18588], [-122.33825, 37.18597], [-122.3386, 37.18599], [-122.33878, 37.18601], [-122.33987, 37.18626], [-122.34001, 37.18623], [-122.3401, 37.1862], [-122.33998, 37.18709], [-122.33969, 37.18759], [-122.33959, 37.18786], [-122.33971, 37.18818], [-122.34021, 37.18877], [-122.34053, 37.18934], [-122.34097, 37.19032], [-122.34108, 37.19083], [-122.34098, 37.19136], [-122.34117, 37.19189], [-122.34133, 37.19216], [-122.3415, 37.19227], [-122.34204, 37.19232], [-122.34225, 37.19243], [-122.34251, 37.19268], [-122.34285, 37.19323], [-122.34312, 37.19353], [-122.34404, 37.19418], [-122.34433, 37.19449], [-122.3462, 37.19734], [-122.34628, 37.19751], [-122.34635, 37.1978], [-122.34634, 37.19791], [-122.34632, 37.19797], [-122.34626, 37.19805], [-122.34619, 37.19811], [-122.34579, 37.19829], [-122.34553, 37.19837], [-122.34518, 37.19846], [-122.34501, 37.19853], [-122.34481, 37.19867], [-122.34472, 37.19876], [-122.34463, 37.1989], [-122.34453, 37.19896], [-122.34443, 37.19897], [-122.34409, 37.19893], [-122.34379, 37.19895], [-122.34357, 37.199], [-122.34325, 37.19911], [-122.34289, 37.1992], [-122.34238, 37.19927], [-122.34234, 37.19922], [-122.34231, 37.19924], [-122.34222, 37.19932], [-122.34219, 37.19938], [-122.34218, 37.19945], [-122.34225, 37.19973], [-122.34219, 37.19975], [-122.34232, 37.20029], [-122.34239, 37.20042], [-122.34249, 37.20053], [-122.3426, 37.20061], [-122.34273, 37.20068], [-122.34289, 37.20072], [-122.34405, 37.20097], [-122.34412, 37.2011], [-122.34433, 37.20116], [-122.3461, 37.20234], [-122.34626, 37.20254], [-122.3464, 37.20276], [-122.3466, 37.20301], [-122.34703, 37.20316], [-122.34719, 37.20341], [-122.34735, 37.20375], [-122.34725, 37.20416], [-122.34789, 37.20491], [-122.3481, 37.20534], [-122.34813, 37.20563], [-122.34828, 37.20591], [-122.34841, 37.20601], [-122.34939, 37.20812], [-122.34941, 37.20913], [-122.34977, 37.20981]]]} | Open Access 1 | 5031 | Butano State Park | 1451 | 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=536 | San Mateo 15 | 4536.506 | Butano SP | 1956 | 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]);