calands: superunits_with_maps: 1 row where ACCESS_TYP = 1, MNG_AGENCY = 47 and PARK

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 47 and PARK_NAME = "Annadel State Park"

Search:

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	id	map	ACCESS_TYP	PARK_NAME	PARK_URL	SUID_NMA	MNG_AG_ID	MNG_AGENCY	MNG_AG_LEV	MNG_AG_TYP	AGNCY_WEB	LAYER	ACRES	LABEL_NAME	YR_EST
15220	15220	15219	{"type": "Polygon", "coordinates": [[[-122.65157, 38.44273], [-122.65084, 38.44301], [-122.65083, 38.44305], [-122.65007, 38.44418], [-122.64989, 38.44433], [-122.64969, 38.4444], [-122.6494, 38.44444], [-122.64868, 38.44435], [-122.64837, 38.44417], [-122.6481, 38.44392], [-122.64786, 38.44383], [-122.64766, 38.44361], [-122.64765, 38.44361], [-122.64765, 38.44392], [-122.64761, 38.44458], [-122.64766, 38.44494], [-122.6476, 38.44518], [-122.64757, 38.44542], [-122.6476, 38.44564], [-122.64767, 38.44585], [-122.64782, 38.44613], [-122.6482, 38.44901], [-122.64456, 38.45144], [-122.6435, 38.45135], [-122.64267, 38.45431], [-122.64222, 38.45571], [-122.64164, 38.45583], [-122.64182, 38.45655], [-122.64227, 38.45645], [-122.6421, 38.45683], [-122.64214, 38.45704], [-122.64062, 38.45687], [-122.63923, 38.45679], [-122.63922, 38.45677], [-122.63899, 38.45675], [-122.63869, 38.45669], [-122.6384, 38.4566], [-122.63813, 38.45649], [-122.63792, 38.45637], [-122.63772, 38.45623], [-122.63755, 38.45607], [-122.6374, 38.45591], [-122.63731, 38.45567], [-122.63644, 38.45445], [-122.63605, 38.45394], [-122.63581, 38.45369], [-122.63504, 38.45312], [-122.63458, 38.45282], [-122.63304, 38.45184], [-122.63252, 38.45154], [-122.63128, 38.45102], [-122.63046, 38.45064], [-122.62987, 38.45029], [-122.62879, 38.44975], [-122.62695, 38.44876], [-122.62645, 38.44854], [-122.62448, 38.44781], [-122.62426, 38.44809], [-122.62419, 38.4479], [-122.62404, 38.44774], [-122.62377, 38.44765], [-122.62304, 38.44735], [-122.62231, 38.44674], [-122.62199, 38.44656], [-122.62164, 38.44671], [-122.62138, 38.44658], [-122.62105, 38.44658], [-122.62079, 38.44654], [-122.62043, 38.44606], [-122.62014, 38.44561], [-122.62001, 38.44546], [-122.61972, 38.44538], [-122.61917, 38.44554], [-122.61876, 38.44585], [-122.61866, 38.44588], [-122.61802, 38.4459], [-122.61785, 38.44603], [-122.61758, 38.44611], [-122.61748, 38.44622], [-122.61711, 38.44595], [-122.61634, 38.44557], [-122.61618, 38.44556], [-122.61591, 38.44546], [-122.61593, 38.44528], [-122.61543, 38.4451], [-122.61488, 38.44482], [-122.61463, 38.44467], [-122.61339, 38.44381], [-122.61482, 38.44222], [-122.61253, 38.4371], [-122.60911, 38.43416], [-122.60581, 38.43213], [-122.60185, 38.4305], [-122.60021, 38.4262], [-122.60054, 38.42356], [-122.6002, 38.42148], [-122.59868, 38.42095], [-122.59069, 38.42117], [-122.59069, 38.42118], [-122.59268, 38.42372], [-122.59192, 38.42409], [-122.59109, 38.42566], [-122.59211, 38.42627], [-122.59191, 38.42827], [-122.59123, 38.42841], [-122.59086, 38.42843], [-122.59061, 38.42847], [-122.59023, 38.42848], [-122.59003, 38.42712], [-122.58901, 38.42717], [-122.58883, 38.42671], [-122.58805, 38.42606], [-122.58724, 38.42548], [-122.58693, 38.42497], [-122.58688, 38.42469], [-122.58738, 38.42433], [-122.58718, 38.42395], [-122.58705, 38.42383], [-122.58789, 38.42403], [-122.58824, 38.4242], [-122.58875, 38.42424], [-122.58921, 38.42432], [-122.58966, 38.42448], [-122.59105, 38.4246], [-122.59151, 38.42412], [-122.59097, 38.42361], [-122.58983, 38.42364], [-122.58928, 38.42417], [-122.58879, 38.42407], [-122.5883, 38.42403], [-122.58797, 38.42387], [-122.58751, 38.42377], [-122.58725, 38.42351], [-122.58767, 38.42323], [-122.58777, 38.42187], [-122.58687, 38.42144], [-122.58559, 38.42256], [-122.58401, 38.42122], [-122.58543, 38.42012], [-122.58543, 38.4201], [-122.58408, 38.41939], [-122.58265, 38.41965], [-122.58018, 38.41832], [-122.57871, 38.42042], [-122.57753, 38.41666], [-122.57687, 38.41691], [-122.57672, 38.41732], [-122.57507, 38.41753], [-122.57509, 38.41696], [-122.57537, 38.41614], [-122.57574, 38.41522], [-122.57574, 38.4149], [-122.57537, 38.41405], [-122.57533, 38.4137], [-122.57888, 38.41214], [-122.57696, 38.40906], [-122.57594, 38.40949], [-122.5749, 38.40804], [-122.575, 38.40799], [-122.57547, 38.40816], [-122.57582, 38.40811], [-122.57629, 38.40761], [-122.57702, 38.40748], [-122.57751, 38.4076], [-122.57838, 38.40736], [-122.57913, 38.40755], [-122.58092, 38.40563], [-122.57968, 38.40355], [-122.57928, 38.40312], [-122.57849, 38.40233], [-122.5786, 38.4022], [-122.57855, 38.40211], [-122.57894, 38.40227], [-122.57925, 38.40225], [-122.57933, 38.4022], [-122.57985, 38.40196], [-122.5801, 38.40208], [-122.58047, 38.40243], [-122.58172, 38.40133], [-122.58087, 38.39986], [-122.58137, 38.39922], [-122.58433, 38.39517], [-122.58907, 38.39731], [-122.60729, 38.40567], [-122.62403, 38.41295], [-122.62588, 38.41496], [-122.63921, 38.41581], [-122.64534, 38.41623], [-122.64751, 38.4163], [-122.64829, 38.41628], [-122.64839, 38.42719], [-122.64837, 38.43081], [-122.64843, 38.43685], [-122.6485, 38.43696], [-122.64847, 38.43698], [-122.64847, 38.43755], [-122.6487, 38.43806], [-122.64804, 38.43806], [-122.64803, 38.43807], [-122.64818, 38.43858], [-122.64828, 38.43907], [-122.64838, 38.43974], [-122.64884, 38.44022], [-122.64859, 38.44073], [-122.64858, 38.44083], [-122.6486, 38.44093], [-122.64868, 38.4411], [-122.64908, 38.44157], [-122.64922, 38.44169], [-122.64944, 38.44177], [-122.65052, 38.44195], [-122.65087, 38.44206], [-122.65109, 38.44218], [-122.65132, 38.44236], [-122.65146, 38.44253], [-122.65157, 38.44273]], [[-122.63767, 38.45493], [-122.63621, 38.45283], [-122.6362, 38.45283], [-122.63621, 38.45385], [-122.63681, 38.45466], [-122.63757, 38.45575], [-122.63766, 38.45568], [-122.63757, 38.45527], [-122.63767, 38.45493]], [[-122.63961, 38.456], [-122.6396, 38.45598], [-122.63888, 38.45589], [-122.63878, 38.45638], [-122.63906, 38.45647], [-122.63926, 38.45649], [-122.63946, 38.45649], [-122.63961, 38.456]]]}	Open Access 1	Annadel State Park	http://www.parks.ca.gov/?page_id=480	1395	204	California Department of Parks and Recreation 47	State 5	State Agency 5	http://www.parks.ca.gov/	California Department of Parks and Recreation 9	5112.378	Annadel SP	1971

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE superunits_with_maps(
  id INT,
  map,
  ACCESS_TYP INT,
  PARK_NAME TEXT,
  PARK_URL TEXT,
  SUID_NMA INT,
  MNG_AG_ID INT,
  MNG_AGENCY INT,
  MNG_AG_LEV INT,
  MNG_AG_TYP INT,
  AGNCY_WEB TEXT,
  LAYER INT,
  ACRES REAL,
  LABEL_NAME TEXT,
  YR_EST INT,
   FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
    ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
    ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
    ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
    ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
    ON [superunits_with_maps] ([ACCESS_TYP]);