calands: units_with_maps: 2 rows where ACCESS_TYP = 2, AGNCY_TYP = 3 and MNG

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

2 rows where ACCESS_TYP = 2, AGNCY_TYP = 3 and MNG_AGENCY = 8

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
16433	16433	16432	{"type": "Polygon", "coordinates": [[[-120.74154, 35.3331], [-120.73974, 35.33628], [-120.73643, 35.3387], [-120.73575, 35.33844], [-120.73517, 35.33868], [-120.73285, 35.3378], [-120.72967, 35.33978], [-120.72435, 35.34033], [-120.72421, 35.34083], [-120.72439, 35.34155], [-120.72495, 35.34214], [-120.72174, 35.3459], [-120.71513, 35.35322], [-120.71224, 35.35091], [-120.72459, 35.32556], [-120.72558, 35.3253], [-120.72633, 35.32599], [-120.72988, 35.32905], [-120.73035, 35.3294], [-120.73084, 35.32971], [-120.73136, 35.33], [-120.73191, 35.33026], [-120.73247, 35.33048], [-120.73305, 35.33067], [-120.73498, 35.33122], [-120.7373, 35.33191], [-120.73941, 35.33243], [-120.74154, 35.3331]]]}	Restricted Access 2	14529	El Chorro Regional Park and Dairy Creek Golf Course	33039	323	San Luis Obispo, County of 8	County 3	County Agency 3	http://www.slocountyparks.com/	County 3	323	San Luis Obispo, County of 8	County 3	County Agency 3		San Luis Obispo 1	684.123	El Chorro RP and Dairy Creek GC	0	Local Recreation Area 3	4
16927	16927	16926	{"type": "MultiPolygon", "coordinates": [[[[-120.6486, 35.47827], [-120.64691, 35.47993], [-120.64474, 35.48211], [-120.64314, 35.47842], [-120.64254, 35.47751], [-120.64174, 35.47671], [-120.64078, 35.47603], [-120.63969, 35.47551], [-120.63961, 35.47559], [-120.63571, 35.47391], [-120.63519, 35.47363], [-120.63473, 35.47327], [-120.63438, 35.47285], [-120.63412, 35.47237], [-120.64037, 35.46871], [-120.6405, 35.46878], [-120.64087, 35.4689], [-120.6417, 35.46914], [-120.64319, 35.46938], [-120.64348, 35.4694], [-120.64491, 35.46934], [-120.64506, 35.46931], [-120.64513, 35.47088], [-120.64566, 35.47188], [-120.64588, 35.47365], [-120.6459, 35.47365], [-120.647, 35.47288], [-120.64704, 35.47299], [-120.64715, 35.47313], [-120.64723, 35.47319], [-120.64742, 35.47326], [-120.64749, 35.47332], [-120.64761, 35.47347], [-120.64684, 35.47375], [-120.64621, 35.47385], [-120.64521, 35.47416], [-120.64491, 35.47415], [-120.6449, 35.47417], [-120.64525, 35.47453], [-120.6486, 35.47827]]], [[[-120.64709, 35.47263], [-120.64603, 35.47336], [-120.64582, 35.47184], [-120.64531, 35.47085], [-120.64525, 35.46978], [-120.64704, 35.46978], [-120.64709, 35.47263]]], [[[-120.64864, 35.47105], [-120.64865, 35.47288], [-120.64863, 35.47292], [-120.64856, 35.47299], [-120.64843, 35.47307], [-120.64824, 35.47314], [-120.64786, 35.47317], [-120.64769, 35.4732], [-120.6475, 35.47317], [-120.64741, 35.47312], [-120.64725, 35.473], [-120.6472, 35.47292], [-120.64718, 35.47285], [-120.64718, 35.47278], [-120.6472, 35.47274], [-120.64728, 35.47267], [-120.64717, 35.47257], [-120.64713, 35.47259], [-120.64711, 35.47107], [-120.64864, 35.47105]]]]}	Restricted Access 2	48426	Chalk Mountain Golf Course	33050	323	San Luis Obispo, County of 8	County 3	County Agency 3	http://www.slocountyparks.com/	County 3	323	San Luis Obispo, County of 8	County 3	County Agency 3		San Luis Obispo 1	227.705	Chalk Mtn. GC	0	Local Recreation Area 3	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]);