calands: units_with_maps: 5 rows where ACCESS_TYP = 1, MNG_AG_TYP = 5 and YR

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

5 rows where ACCESS_TYP = 1, MNG_AG_TYP = 5 and YR_EST = 1958

Search:

descending

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
2967	2967	2966	{"type": "Polygon", "coordinates": [[[-123.48833, 39.0803], [-123.48372, 39.08029], [-123.48373, 39.08107], [-123.48368, 39.0826], [-123.48432, 39.08313], [-123.48458, 39.08343], [-123.48463, 39.08384], [-123.48435, 39.08443], [-123.48525, 39.08509], [-123.48456, 39.0858], [-123.48364, 39.08558], [-123.48368, 39.0826], [-123.48077, 39.08161], [-123.48077, 39.08131], [-123.47893, 39.08028], [-123.47439, 39.08025], [-123.47436, 39.07788], [-123.4725, 39.07663], [-123.47113, 39.07659], [-123.46798, 39.0766], [-123.46492, 39.07508], [-123.46151, 39.07281], [-123.4601, 39.07284], [-123.46008, 39.07238], [-123.46007, 39.07014], [-123.46023, 39.06539], [-123.45537, 39.06534], [-123.45544, 39.06341], [-123.45545, 39.06159], [-123.45553, 39.05798], [-123.45553, 39.05708], [-123.45559, 39.05445], [-123.46023, 39.05439], [-123.46021, 39.05711], [-123.46482, 39.05712], [-123.46487, 39.05796], [-123.4658, 39.05801], [-123.46595, 39.06175], [-123.46949, 39.06165], [-123.46951, 39.06546], [-123.46948, 39.06926], [-123.47421, 39.06927], [-123.4742, 39.06549], [-123.47884, 39.06549], [-123.47901, 39.07289], [-123.47915, 39.07652], [-123.48371, 39.07663], [-123.48825, 39.07668], [-123.48833, 39.0803]]]}	Open Access 1	20484	Hendy Woods State Park	1562	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=438	Mendocino 24	827.536	Hendy Woods SP	1958	State Park 15	4
9835	9835	9834	{"type": "MultiPolygon", "coordinates": [[[[-121.17499, 35.68531], [-121.17428, 35.68603], [-121.17415, 35.6862], [-121.17414, 35.68622], [-121.17415, 35.68623], [-121.17399, 35.68664], [-121.17108, 35.68826], [-121.16914, 35.68787], [-121.16843, 35.68807], [-121.16749, 35.68808], [-121.16448, 35.6873], [-121.16457, 35.68719], [-121.16449, 35.68716], [-121.16435, 35.68718], [-121.16346, 35.68632], [-121.16347, 35.68618], [-121.16876, 35.68171], [-121.1693, 35.68134], [-121.17032, 35.68159], [-121.17037, 35.68158], [-121.17038, 35.68162], [-121.17134, 35.68152], [-121.1721, 35.68198], [-121.17249, 35.68258], [-121.17279, 35.68263], [-121.17302, 35.6829], [-121.17295, 35.68321], [-121.17315, 35.68345], [-121.17395, 35.68317], [-121.17447, 35.68317], [-121.17482, 35.68379], [-121.17472, 35.68505], [-121.17499, 35.68531]]], [[[-121.18934, 35.64976], [-121.1891, 35.65034], [-121.18847, 35.65114], [-121.18756, 35.65158], [-121.18666, 35.65172], [-121.18567, 35.65347], [-121.18527, 35.65333], [-121.18595, 35.65211], [-121.18519, 35.65173], [-121.18538, 35.65127], [-121.18525, 35.65068], [-121.18532, 35.65019], [-121.18418, 35.64917], [-121.18375, 35.64877], [-121.18322, 35.64804], [-121.18306, 35.64748], [-121.18366, 35.64675], [-121.18728, 35.64914], [-121.18777, 35.64861], [-121.18934, 35.64976]]]]}	Open Access 1	16813	Hearst San Simeon State Historical Monument	1559	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=591	San Luis Obispo 1	165.501	Hearst San Simeon State Historical Monument	1958	State Historic or Cultural Area 132	4
16423	16423	16422	{"type": "MultiPolygon", "coordinates": [[[[-122.40251, 37.3184], [-122.40245, 37.31872], [-122.40101, 37.32145], [-122.40017, 37.32173], [-122.3999, 37.32222], [-122.40053, 37.32305], [-122.39964, 37.32438], [-122.39914, 37.3244], [-122.39762, 37.32442], [-122.39704, 37.32445], [-122.39696, 37.32408], [-122.3967, 37.32349], [-122.39634, 37.32362], [-122.3959, 37.32353], [-122.3963, 37.32204], [-122.39521, 37.32098], [-122.39422, 37.32051], [-122.39299, 37.31965], [-122.39273, 37.31943], [-122.39244, 37.31914], [-122.39213, 37.31831], [-122.39354, 37.31685], [-122.39389, 37.31659], [-122.39697, 37.31667], [-122.40251, 37.3184]]], [[[-122.40477, 37.31225], [-122.40472, 37.31286], [-122.40472, 37.31299], [-122.40474, 37.31313], [-122.40469, 37.31341], [-122.40457, 37.31367], [-122.40454, 37.31381], [-122.40454, 37.31409], [-122.40463, 37.31451], [-122.40459, 37.31507], [-122.40457, 37.31521], [-122.40441, 37.31576], [-122.40436, 37.31604], [-122.40433, 37.31617], [-122.40425, 37.31631], [-122.40424, 37.31644], [-122.40424, 37.31672], [-122.4042, 37.31701], [-122.4042, 37.31714], [-122.40422, 37.31729], [-122.40421, 37.31743], [-122.40423, 37.31798], [-122.4042, 37.31812], [-122.40421, 37.3184], [-122.40412, 37.31867], [-122.40406, 37.3188], [-122.40404, 37.31895], [-122.40399, 37.31908], [-122.404, 37.31936], [-122.40406, 37.31948], [-122.4041, 37.31961], [-122.40407, 37.31974], [-122.40391, 37.32001], [-122.40386, 37.32028], [-122.4038, 37.32042], [-122.4038, 37.32056], [-122.40384, 37.32083], [-122.40378, 37.32097], [-122.40376, 37.32111], [-122.40378, 37.32125], [-122.40378, 37.32138], [-122.40372, 37.32166], [-122.40371, 37.32194], [-122.40367, 37.32222], [-122.40359, 37.32249], [-122.40356, 37.32277], [-122.40356, 37.32305], [-122.40359, 37.32319], [-122.40375, 37.32345], [-122.40377, 37.32359], [-122.40369, 37.32386], [-122.40368, 37.32413], [-122.40372, 37.32427], [-122.4038, 37.3244], [-122.4038, 37.32454], [-122.40378, 37.32468], [-122.40367, 37.32479], [-122.40352, 37.32486], [-122.40346, 37.325], [-122.40343, 37.32513], [-122.40342, 37.32555], [-122.40339, 37.32573], [-122.40013, 37.32432], [-122.40138, 37.32245], [-122.40162, 37.32222], [-122.40181, 37.32197], [-122.40194, 37.32169], [-122.40205, 37.32124], [-122.40215, 37.32099], [-122.40236, 37.32108], [-122.40269, 37.32054], [-122.40339, 37.31784], [-122.40414, 37.31224], [-122.40477, 37.31225]]]]}	Open Access 1	421	San Gregorio State Beach	1728	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=529	San Mateo 15	161.49	San Gregorio SB	1958	State Park 15	4
16483	16483	16482	{"type": "MultiPolygon", "coordinates": [[[[-122.41265, 37.2672], [-122.40974, 37.27787], [-122.40913, 37.28002], [-122.40878, 37.27989], [-122.40876, 37.2799], [-122.40834, 37.27976], [-122.40847, 37.27804], [-122.40847, 37.2777], [-122.40845, 37.27747], [-122.40836, 37.27722], [-122.40865, 37.27526], [-122.40921, 37.27443], [-122.40888, 37.27359], [-122.40926, 37.27212], [-122.40951, 37.27188], [-122.40971, 37.27095], [-122.40962, 37.27075], [-122.40991, 37.26961], [-122.41048, 37.26827], [-122.4117, 37.26621], [-122.41265, 37.2672]]], [[[-122.41726, 37.26075], [-122.41565, 37.26285], [-122.4136, 37.26215], [-122.41349, 37.26226], [-122.41294, 37.26316], [-122.41295, 37.26352], [-122.41291, 37.264], [-122.41298, 37.26486], [-122.41304, 37.26497], [-122.413, 37.26557], [-122.41293, 37.26574], [-122.41294, 37.26665], [-122.41268, 37.26702], [-122.41258, 37.26676], [-122.41229, 37.26646], [-122.41191, 37.26632], [-122.41178, 37.26601], [-122.4122, 37.26495], [-122.41233, 37.26448], [-122.41256, 37.26383], [-122.41302, 37.26154], [-122.41337, 37.25986], [-122.41338, 37.25984], [-122.41345, 37.25984], [-122.41417, 37.25641], [-122.41436, 37.25559], [-122.41443, 37.25537], [-122.41479, 37.25541], [-122.41485, 37.25544], [-122.41491, 37.25544], [-122.41524, 37.25549], [-122.41491, 37.25615], [-122.41466, 37.25673], [-122.41443, 37.25914], [-122.41453, 37.25948], [-122.41451, 37.25951], [-122.41457, 37.2598], [-122.41726, 37.26075]]]]}	Open Access 1	18617	Pescadero State Beach	1674	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=522	San Mateo 15	90.497	Pescadero SB	1958	State Park 15	4
16660	16660	16659	{"type": "Polygon", "coordinates": [[[-123.82852, 40.06923], [-123.8284, 40.06931], [-123.82833, 40.06939], [-123.82828, 40.06949], [-123.82826, 40.06959], [-123.82827, 40.07021], [-123.82842, 40.07231], [-123.82843, 40.07264], [-123.8284, 40.07297], [-123.82833, 40.0733], [-123.82808, 40.07413], [-123.82689, 40.07376], [-123.82684, 40.0739], [-123.82676, 40.07407], [-123.82658, 40.07434], [-123.8256, 40.07545], [-123.82526, 40.07581], [-123.82483, 40.07622], [-123.82452, 40.07647], [-123.82412, 40.07673], [-123.82374, 40.06606], [-123.80985, 40.06641], [-123.80979, 40.06534], [-123.80793, 40.06484], [-123.80484, 40.06488], [-123.80483, 40.06482], [-123.80471, 40.06483], [-123.8042, 40.0651], [-123.80364, 40.06525], [-123.80347, 40.06558], [-123.80301, 40.06575], [-123.80266, 40.06613], [-123.80256, 40.06617], [-123.80256, 40.06644], [-123.80024, 40.06774], [-123.80024, 40.0678], [-123.80016, 40.06779], [-123.79981, 40.06784], [-123.7995, 40.06776], [-123.79917, 40.06752], [-123.79772, 40.06758], [-123.79738, 40.06753], [-123.79627, 40.06769], [-123.79588, 40.0676], [-123.79569, 40.06768], [-123.79552, 40.06801], [-123.79547, 40.06804], [-123.79534, 40.0674], [-123.7951, 40.06749], [-123.79484, 40.06755], [-123.79474, 40.06762], [-123.7947, 40.0676], [-123.79468, 40.06756], [-123.79457, 40.06756], [-123.79453, 40.06765], [-123.79448, 40.06771], [-123.79439, 40.06774], [-123.79427, 40.06772], [-123.79413, 40.06777], [-123.79392, 40.06782], [-123.79367, 40.06795], [-123.79372, 40.06816], [-123.79287, 40.06815], [-123.7926, 40.06816], [-123.79233, 40.06823], [-123.79191, 40.06816], [-123.79158, 40.06816], [-123.79115, 40.06823], [-123.79111, 40.06822], [-123.79117, 40.06798], [-123.79118, 40.06779], [-123.79115, 40.0676], [-123.79108, 40.06741], [-123.79098, 40.06723], [-123.79085, 40.06707], [-123.7907, 40.06692], [-123.79042, 40.06673], [-123.7903, 40.06668], [-123.79021, 40.06679], [-123.78984, 40.06661], [-123.78964, 40.06684], [-123.78808, 40.06607], [-123.78779, 40.06582], [-123.7876, 40.0656], [-123.78713, 40.06543], [-123.78523, 40.0648], [-123.78464, 40.06456], [-123.78358, 40.06403], [-123.78338, 40.06392], [-123.7832, 40.06379], [-123.78213, 40.06291], [-123.78185, 40.06274], [-123.78164, 40.06264], [-123.78142, 40.06256], [-123.78119, 40.0625], [-123.78087, 40.06245], [-123.78032, 40.06239], [-123.77935, 40.06218], [-123.77916, 40.06213], [-123.77899, 40.06205], [-123.77875, 40.06191], [-123.77863, 40.06179], [-123.77854, 40.06167], [-123.77837, 40.06134], [-123.77835, 40.06121], [-123.77835, 40.06109], [-123.77838, 40.06096], [-123.77863, 40.06044], [-123.7787, 40.06024], [-123.77874, 40.06006], [-123.77886, 40.05898], [-123.77926, 40.05863], [-123.7813, 40.05827], [-123.78128, 40.05728], [-123.7815, 40.05719], [-123.78192, 40.05699], [-123.78352, 40.05645], [-123.78374, 40.0564], [-123.78396, 40.05637], [-123.78418, 40.05636], [-123.7847, 40.05642], [-123.78558, 40.05629], [-123.78578, 40.05624], [-123.78663, 40.05596], [-123.78729, 40.05583], [-123.78786, 40.05578], [-123.78825, 40.05577], [-123.78947, 40.05585], [-123.79003, 40.05584], [-123.79041, 40.0558], [-123.7918, 40.05562], [-123.79169, 40.05432], [-123.79151, 40.05406], [-123.79142, 40.05389], [-123.79137, 40.05372], [-123.79135, 40.05354], [-123.79137, 40.05336], [-123.79164, 40.05219], [-123.79172, 40.0517], [-123.79141, 40.05007], [-123.79106, 40.04968], [-123.79508, 40.05025], [-123.80534, 40.05096], [-123.80536, 40.05429], [-123.81047, 40.05452], [-123.81046, 40.06236], [-123.81511, 40.06221], [-123.82203, 40.06227], [-123.82216, 40.06203], [-123.82224, 40.06162], [-123.82227, 40.06152], [-123.82239, 40.06132], [-123.82246, 40.06124], [-123.82272, 40.06102], [-123.82291, 40.06089], [-123.82318, 40.06078], [-123.82344, 40.06072], [-123.82362, 40.06223], [-123.8255, 40.06223], [-123.82538, 40.06249], [-123.82526, 40.06297], [-123.82519, 40.06337], [-123.82524, 40.06358], [-123.82541, 40.06413], [-123.82557, 40.06458], [-123.8257, 40.06488], [-123.82606, 40.06571], [-123.82615, 40.06587], [-123.82649, 40.06624], [-123.8272, 40.0669], [-123.82734, 40.06707], [-123.82746, 40.06728], [-123.8276, 40.06762], [-123.82788, 40.06854], [-123.82796, 40.06897], [-123.82789, 40.06923], [-123.82852, 40.06923]]]}	Open Access 1	20458	Benbow State Recreation Area	30556	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=426	Humboldt 45	1137.787	Benbow SRA	1958	State Recreation Area 39	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]);