calands: units_with_maps: 1 row where ACCESS_TYP = 1 and LABEL

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

1 row where ACCESS_TYP = 1 and LABEL_NAME = "Pismo SB"

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
16482	16482	16481	{"type": "MultiPolygon", "coordinates": [[[[-120.64219, 35.13564], [-120.64136, 35.13627], [-120.64138, 35.13632], [-120.64124, 35.13643], [-120.64121, 35.13638], [-120.64117, 35.13641], [-120.6411, 35.13638], [-120.64082, 35.13659], [-120.64071, 35.13648], [-120.64063, 35.13652], [-120.64044, 35.13639], [-120.64028, 35.13645], [-120.64002, 35.13632], [-120.64068, 35.13588], [-120.6402, 35.13533], [-120.63894, 35.13431], [-120.63866, 35.13386], [-120.63813, 35.1329], [-120.63777, 35.1322], [-120.63767, 35.13191], [-120.63761, 35.13159], [-120.63514, 35.13336], [-120.63258, 35.13106], [-120.63215, 35.13009], [-120.63202, 35.12851], [-120.63377, 35.1286], [-120.63378, 35.12858], [-120.63366, 35.12827], [-120.63343, 35.12794], [-120.63297, 35.12755], [-120.63286, 35.12742], [-120.63276, 35.12718], [-120.6327, 35.12698], [-120.63265, 35.12649], [-120.63259, 35.12616], [-120.63241, 35.12552], [-120.6323, 35.12519], [-120.63216, 35.12486], [-120.63181, 35.12411], [-120.63179, 35.12396], [-120.63166, 35.1237], [-120.63159, 35.12371], [-120.63156, 35.12365], [-120.63162, 35.12362], [-120.63149, 35.12339], [-120.63141, 35.12326], [-120.63106, 35.12282], [-120.63098, 35.12268], [-120.63092, 35.12255], [-120.63083, 35.12214], [-120.63268, 35.12223], [-120.6327, 35.12196], [-120.63009, 35.12183], [-120.63001, 35.12178], [-120.62996, 35.12128], [-120.62986, 35.12092], [-120.62732, 35.11543], [-120.62599, 35.11265], [-120.62668, 35.11244], [-120.62668, 35.11243], [-120.62661, 35.11229], [-120.62592, 35.1125], [-120.6254, 35.11137], [-120.62608, 35.11116], [-120.62603, 35.11101], [-120.62533, 35.11121], [-120.62482, 35.1101], [-120.6257, 35.10982], [-120.62495, 35.1082], [-120.62475, 35.10701], [-120.62764, 35.10612], [-120.62777, 35.10611], [-120.62791, 35.10675], [-120.63011, 35.10643], [-120.63017, 35.10669], [-120.63023, 35.10667], [-120.63017, 35.10642], [-120.63057, 35.10637], [-120.63062, 35.1066], [-120.63081, 35.10657], [-120.63062, 35.10569], [-120.63123, 35.1056], [-120.63123, 35.10559], [-120.63119, 35.10538], [-120.63058, 35.10547], [-120.63008, 35.10051], [-120.62832, 35.10063], [-120.6286, 35.10346], [-120.62804, 35.1035], [-120.62744, 35.10403], [-120.6274, 35.10387], [-120.62734, 35.10377], [-120.62741, 35.10018], [-120.62348, 35.09977], [-120.62327, 35.09366], [-120.62133, 35.09365], [-120.61762, 35.09371], [-120.61764, 35.09083], [-120.61435, 35.09082], [-120.61434, 35.09064], [-120.61373, 35.09064], [-120.61198, 35.08916], [-120.61192, 35.08856], [-120.6111, 35.08704], [-120.61102, 35.08587], [-120.60947, 35.08461], [-120.60902, 35.08441], [-120.60789, 35.08398], [-120.60651, 35.08336], [-120.60528, 35.08232], [-120.60463, 35.082], [-120.60462, 35.08151], [-120.60193, 35.08029], [-120.60234, 35.08034], [-120.60251, 35.08004], [-120.60186, 35.07992], [-120.60207, 35.07896], [-120.60561, 35.07919], [-120.60999, 35.07916], [-120.61292, 35.07963], [-120.61933, 35.08203], [-120.61932, 35.08098], [-120.62864, 35.08087], [-120.62837, 35.07497], [-120.62825, 35.06616], [-120.62807, 35.06267], [-120.62793, 35.06078], [-120.6279, 35.05684], [-120.62808, 35.05592], [-120.62861, 35.05129], [-120.63018, 35.04128], [-120.63275, 35.04134], [-120.63312, 35.04236], [-120.633, 35.04255], [-120.6329, 35.04283], [-120.63288, 35.0432], [-120.63289, 35.04378], [-120.63286, 35.04401], [-120.63282, 35.04412], [-120.63271, 35.04427], [-120.63258, 35.04454], [-120.63251, 35.04473], [-120.6325, 35.04508], [-120.63242, 35.04532], [-120.63206, 35.04662], [-120.63206, 35.04716], [-120.6321, 35.04791], [-120.63205, 35.04814], [-120.632, 35.04873], [-120.63183, 35.0493], [-120.6317, 35.04968], [-120.63163, 35.05028], [-120.63158, 35.05233], [-120.63153, 35.05203], [-120.63123, 35.05291], [-120.6312, 35.05324], [-120.63121, 35.05365], [-120.63121, 35.05465], [-120.63119, 35.05482], [-120.63099, 35.05537], [-120.6309, 35.05567], [-120.63086, 35.05596], [-120.63101, 35.05668], [-120.63101, 35.05682], [-120.63027, 35.05683], [-120.62962, 35.06827], [-120.62988, 35.08648], [-120.63004, 35.08703], [-120.63034, 35.08865], [-120.63044, 35.09202], [-120.63076, 35.09403], [-120.63067, 35.09618], [-120.63075, 35.09895], [-120.6309, 35.10003], [-120.63115, 35.10213], [-120.63158, 35.10427], [-120.63174, 35.10472], [-120.63179, 35.10581], [-120.63205, 35.10756], [-120.63212, 35.10851], [-120.63217, 35.10986], [-120.63317, 35.11331], [-120.63347, 35.11513], [-120.63369, 35.11599], [-120.63401, 35.11748], [-120.63442, 35.11873], [-120.63483, 35.12005], [-120.63531, 35.12144], [-120.63593, 35.12374], [-120.63717, 35.1263], [-120.63852, 35.12885], [-120.64027, 35.13223], [-120.64144, 35.13437], [-120.64185, 35.13484], [-120.64219, 35.13564]]], [[[-120.62208, 35.132], [-120.62202, 35.13213], [-120.62196, 35.13244], [-120.62207, 35.13388], [-120.6192, 35.13331], [-120.61911, 35.13301], [-120.61906, 35.133], [-120.61948, 35.13212], [-120.62208, 35.132]]], [[[-120.63201, 35.13518], [-120.63107, 35.13566], [-120.63102, 35.13559], [-120.63181, 35.13519], [-120.63172, 35.13417], [-120.63119, 35.13348], [-120.62974, 35.13299], [-120.62787, 35.13396], [-120.62678, 35.13374], [-120.62647, 35.13478], [-120.62592, 35.13467], [-120.62586, 35.13484], [-120.62509, 35.13469], [-120.62441, 35.13472], [-120.62336, 35.13482], [-120.62244, 35.13469], [-120.62242, 35.13444], [-120.62292, 35.13441], [-120.62286, 35.13362], [-120.62236, 35.13364], [-120.62227, 35.13252], [-120.62246, 35.13211], [-120.62258, 35.13198], [-120.62294, 35.13196], [-120.62497, 35.13158], [-120.62561, 35.13136], [-120.62615, 35.13128], [-120.62708, 35.13151], [-120.62742, 35.13174], [-120.62811, 35.1315], [-120.62995, 35.13159], [-120.63078, 35.13172], [-120.63152, 35.13097], [-120.63165, 35.13096], [-120.63201, 35.13518]]], [[[-120.62623, 35.10638], [-120.62597, 35.10646], [-120.62594, 35.10634], [-120.62574, 35.10626], [-120.6255, 35.10593], [-120.62551, 35.10565], [-120.62595, 35.10521], [-120.62616, 35.10532], [-120.62596, 35.10558], [-120.62623, 35.10638]]], [[[-120.62747, 35.10476], [-120.62656, 35.10498], [-120.62633, 35.10515], [-120.62597, 35.10496], [-120.62642, 35.1044], [-120.62668, 35.10453], [-120.62737, 35.10427], [-120.62747, 35.10476]]], [[[-120.62842, 35.10627], [-120.62826, 35.10629], [-120.62821, 35.10604], [-120.62837, 35.10602], [-120.62842, 35.10627]]], [[[-120.62872, 35.10622], [-120.62862, 35.10624], [-120.62857, 35.10599], [-120.62867, 35.10598], [-120.62872, 35.10622]]], [[[-120.62987, 35.10636], [-120.62967, 35.10638], [-120.62962, 35.10614], [-120.62981, 35.10611], [-120.62987, 35.10636]]], [[[-120.65007, 35.14646], [-120.64977, 35.14693], [-120.64947, 35.1467], [-120.64898, 35.14667], [-120.64824, 35.14593], [-120.64784, 35.14532], [-120.64709, 35.14499], [-120.6465, 35.14465], [-120.64594, 35.14402], [-120.64543, 35.14302], [-120.64429, 35.14179], [-120.64435, 35.14158], [-120.64408, 35.14116], [-120.64343, 35.14047], [-120.64372, 35.14033], [-120.6436, 35.14], [-120.64376, 35.13978], [-120.6434, 35.13923], [-120.64307, 35.13928], [-120.64275, 35.1394], [-120.64212, 35.13882], [-120.64266, 35.13845], [-120.64188, 35.13713], [-120.64199, 35.13697], [-120.64182, 35.13684], [-120.64228, 35.13652], [-120.64262, 35.13623], [-120.64283, 35.13647], [-120.64323, 35.13748], [-120.64348, 35.13799], [-120.6438, 35.1385], [-120.64661, 35.13768], [-120.64669, 35.13779], [-120.64394, 35.13872], [-120.64393, 35.13873], [-120.64414, 35.13908], [-120.64499, 35.14036], [-120.64529, 35.14089], [-120.64538, 35.1412], [-120.64561, 35.14146], [-120.6459, 35.14187], [-120.64611, 35.14211], [-120.64692, 35.14319], [-120.64741, 35.14393], [-120.64793, 35.14446], [-120.6483, 35.14479], [-120.6486, 35.14513], [-120.64888, 35.14535], [-120.64912, 35.14563], [-120.64964, 35.14606], [-120.65007, 35.14646]]]]}	Open Access 1	18615	Pismo State Beach	1682	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=595	San Luis Obispo 1	1512.609	Pismo SB	1935	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]);