calands: units_with_maps: 1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and UNIT

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

1 row where MNG_AGENCY = 47, MNG_AG_TYP = 5 and UNIT_NAME = "Pomponio State Beach"

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
16478	16478	16477	{"type": "MultiPolygon", "coordinates": [[[[-122.40432, 37.29977], [-122.40425, 37.30152], [-122.40431, 37.30496], [-122.40413, 37.30807], [-122.40354, 37.31222], [-122.38707, 37.31165], [-122.38706, 37.31158], [-122.38683, 37.31065], [-122.38673, 37.31042], [-122.38658, 37.31018], [-122.38646, 37.31008], [-122.38631, 37.31002], [-122.38562, 37.30993], [-122.38543, 37.30978], [-122.3852, 37.30969], [-122.38515, 37.30965], [-122.38514, 37.3096], [-122.3852, 37.30944], [-122.38521, 37.3093], [-122.38525, 37.30926], [-122.38531, 37.30924], [-122.38556, 37.30925], [-122.38572, 37.30923], [-122.38589, 37.30915], [-122.38601, 37.30905], [-122.3863, 37.30855], [-122.3865, 37.30753], [-122.38949, 37.30553], [-122.39023, 37.30427], [-122.39115, 37.30451], [-122.39139, 37.30449], [-122.39164, 37.30472], [-122.39169, 37.30487], [-122.39189, 37.30494], [-122.39221, 37.30482], [-122.3926, 37.30519], [-122.39314, 37.30524], [-122.39319, 37.30497], [-122.3937, 37.30529], [-122.39397, 37.30519], [-122.39389, 37.30497], [-122.39419, 37.30487], [-122.39442, 37.30501], [-122.39468, 37.30501], [-122.39521, 37.30472], [-122.3955, 37.30472], [-122.39567, 37.30491], [-122.39588, 37.30479], [-122.39649, 37.30497], [-122.39679, 37.30493], [-122.39678, 37.30513], [-122.39718, 37.3052], [-122.39726, 37.3051], [-122.39741, 37.30504], [-122.39779, 37.3051], [-122.39793, 37.30482], [-122.39809, 37.30468], [-122.39838, 37.30463], [-122.39871, 37.30468], [-122.399, 37.30465], [-122.39943, 37.30437], [-122.39929, 37.30398], [-122.3994, 37.30376], [-122.39982, 37.30383], [-122.40009, 37.30371], [-122.40022, 37.30334], [-122.40052, 37.30338], [-122.40078, 37.30325], [-122.4007, 37.30292], [-122.40068, 37.30264], [-122.40089, 37.30258], [-122.40124, 37.30267], [-122.40139, 37.30244], [-122.40162, 37.30237], [-122.40184, 37.30205], [-122.40199, 37.30194], [-122.40198, 37.30126], [-122.40228, 37.30118], [-122.40249, 37.30122], [-122.40279, 37.30117], [-122.40432, 37.29977]]], [[[-122.40857, 37.28288], [-122.40859, 37.283], [-122.40858, 37.28311], [-122.40846, 37.28337], [-122.40836, 37.28379], [-122.40829, 37.28395], [-122.40832, 37.28428], [-122.40829, 37.28441], [-122.40831, 37.28494], [-122.40818, 37.28572], [-122.40818, 37.28596], [-122.40813, 37.28617], [-122.40806, 37.28633], [-122.40795, 37.28647], [-122.4079, 37.28658], [-122.40786, 37.28671], [-122.40785, 37.28697], [-122.40774, 37.28689], [-122.40757, 37.28685], [-122.40755, 37.28695], [-122.40675, 37.29373], [-122.40675, 37.2969], [-122.40642, 37.29723], [-122.40626, 37.29744], [-122.40624, 37.29788], [-122.40629, 37.29894], [-122.40624, 37.29913], [-122.40621, 37.29944], [-122.40622, 37.29965], [-122.40629, 37.29987], [-122.40561, 37.30499], [-122.40478, 37.30498], [-122.40492, 37.30153], [-122.40483, 37.29977], [-122.40487, 37.29895], [-122.40518, 37.2977], [-122.40575, 37.29669], [-122.40599, 37.29617], [-122.40619, 37.29599], [-122.40623, 37.29584], [-122.40636, 37.29567], [-122.40644, 37.29553], [-122.40654, 37.29523], [-122.40656, 37.29498], [-122.40655, 37.2948], [-122.4065, 37.29464], [-122.40654, 37.29423], [-122.40654, 37.29383], [-122.4065, 37.29351], [-122.40645, 37.29324], [-122.40644, 37.29291], [-122.40639, 37.29264], [-122.40629, 37.29232], [-122.40612, 37.29198], [-122.40595, 37.29146], [-122.40508, 37.28939], [-122.405, 37.28912], [-122.4049, 37.28872], [-122.40485, 37.28831], [-122.40482, 37.28791], [-122.40477, 37.28775], [-122.40503, 37.28651], [-122.40527, 37.28606], [-122.40756, 37.28257], [-122.40857, 37.28288]]]]}	Open Access 1	18821	Pomponio State Beach	1695	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=521	San Mateo 15	399.836	Pomponio SB	1960	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]);