calands: units_with_maps: 2 rows where COUNTY = 1 and YR

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

2 rows where COUNTY = 1 and YR_EST = 1974

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
4052	4052	4051	{"type": "Polygon", "coordinates": [[[-120.62013, 35.03081], [-120.61761, 35.03273], [-120.61532, 35.03311], [-120.61364, 35.03325], [-120.61193, 35.03342], [-120.61133, 35.03435], [-120.60821, 35.03622], [-120.60821, 35.03689], [-120.60696, 35.04631], [-120.61165, 35.05697], [-120.60801, 35.057], [-120.60052, 35.05401], [-120.59852, 35.05278], [-120.59685, 35.05291], [-120.59637, 35.04946], [-120.59602, 35.04949], [-120.59405, 35.0355], [-120.59325, 35.03276], [-120.59845, 35.03437], [-120.60263, 35.0349], [-120.6082, 35.03622], [-120.60821, 35.02925], [-120.61044, 35.02376], [-120.61978, 35.03058], [-120.62013, 35.03081]]]}	Restricted Access 2	47022	Oceano Dunes State Vehicular Recreation Area	30668	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		San Luis Obispo 1	845.96	Oceano Dunes SVRA	1974	State Recreation Area 39	4
16668	16668	16667	{"type": "Polygon", "coordinates": [[[-120.63643, 35.01784], [-120.63637, 35.01818], [-120.63622, 35.01883], [-120.63615, 35.01987], [-120.63579, 35.02097], [-120.63573, 35.02206], [-120.63521, 35.02377], [-120.63517, 35.02516], [-120.63512, 35.02605], [-120.63452, 35.02722], [-120.63466, 35.02858], [-120.63436, 35.02988], [-120.63414, 35.03142], [-120.63362, 35.0328], [-120.6336, 35.03357], [-120.63374, 35.03397], [-120.63334, 35.03491], [-120.63337, 35.03553], [-120.63356, 35.03581], [-120.63357, 35.03613], [-120.63344, 35.03684], [-120.63311, 35.0378], [-120.63306, 35.03854], [-120.63297, 35.03946], [-120.6327, 35.03996], [-120.6327, 35.04021], [-120.63264, 35.04056], [-120.63275, 35.04134], [-120.63018, 35.04128], [-120.62861, 35.05129], [-120.62808, 35.05592], [-120.6279, 35.05684], [-120.62793, 35.06078], [-120.62807, 35.06267], [-120.62825, 35.06616], [-120.62837, 35.07497], [-120.62864, 35.08087], [-120.61932, 35.08098], [-120.61917, 35.06809], [-120.61911, 35.06083], [-120.61572, 35.06084], [-120.61568, 35.05693], [-120.61165, 35.05697], [-120.60696, 35.04631], [-120.60821, 35.03689], [-120.60821, 35.03622], [-120.61133, 35.03435], [-120.61193, 35.03342], [-120.61364, 35.03325], [-120.61532, 35.03311], [-120.6176, 35.03273], [-120.62013, 35.03081], [-120.62069, 35.03088], [-120.6207, 35.03086], [-120.62007, 35.03036], [-120.62045, 35.03008], [-120.62078, 35.02939], [-120.62099, 35.02884], [-120.62148, 35.02831], [-120.62243, 35.02747], [-120.623, 35.0272], [-120.62464, 35.02677], [-120.62527, 35.02699], [-120.62589, 35.02701], [-120.62615, 35.0266], [-120.63127, 35.02843], [-120.6322, 35.02364], [-120.62112, 35.02369], [-120.61199, 35.01744], [-120.61221, 35.0171], [-120.60732, 35.01378], [-120.6001, 35.0088], [-120.63643, 35.01784]], [[-120.61375, 35.04511], [-120.61376, 35.0451], [-120.61354, 35.04414], [-120.61231, 35.04431], [-120.61254, 35.04528], [-120.61375, 35.04511]], [[-120.61406, 35.03687], [-120.61407, 35.03686], [-120.61406, 35.03588], [-120.61281, 35.03587], [-120.61282, 35.03686], [-120.61406, 35.03687]], [[-120.61452, 35.0405], [-120.61577, 35.04051], [-120.61576, 35.03953], [-120.61452, 35.03952], [-120.61452, 35.0405]], [[-120.61766, 35.03702], [-120.61891, 35.03704], [-120.6189, 35.03605], [-120.61766, 35.03604], [-120.61766, 35.03702]], [[-120.61915, 35.0565], [-120.61915, 35.05568], [-120.61818, 35.05569], [-120.6182, 35.05651], [-120.61915, 35.0565]], [[-120.62004, 35.04314], [-120.62003, 35.04315], [-120.62028, 35.04411], [-120.6215, 35.04391], [-120.62125, 35.04295], [-120.62004, 35.04314]], [[-120.62574, 35.0357], [-120.62602, 35.03474], [-120.62481, 35.03449], [-120.62454, 35.03545], [-120.62574, 35.0357]], [[-120.62597, 35.04014], [-120.62472, 35.04013], [-120.62473, 35.04111], [-120.62597, 35.04112], [-120.62597, 35.04014]], [[-120.62579, 35.0556], [-120.6258, 35.05643], [-120.62676, 35.05642], [-120.62675, 35.0556], [-120.62579, 35.0556]], [[-120.62921, 35.03568], [-120.62893, 35.03664], [-120.63014, 35.03689], [-120.63041, 35.03593], [-120.62921, 35.03568]], [[-120.62971, 35.04009], [-120.6297, 35.0401], [-120.62971, 35.04108], [-120.63096, 35.04109], [-120.63095, 35.0401], [-120.62971, 35.04009]]]}	Open Access 1	18256	Oceano Dunes State Vehicular Recreation Area	1659	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=406	San Luis Obispo 1	2612.474	Oceano Dunes SVRA	1974	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]);