calands: units_with_maps: 1 row where DES_TP = 39, MNG_AGENCY = 47 and UNIT_NAME = "Standish-Hickey State Recreation Area"

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

1 row where DES_TP = 39, MNG_AGENCY = 47 and UNIT_NAME = "Standish-Hickey State Recreation Area"

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
16662	16662	16661	{"type": "MultiPolygon", "coordinates": [[[[-123.755, 39.87752], [-123.75055, 39.87759], [-123.75066, 39.88593], [-123.75094, 39.88594], [-123.75092, 39.88684], [-123.75087, 39.88704], [-123.75058, 39.89043], [-123.75052, 39.89133], [-123.75038, 39.89109], [-123.749, 39.8906], [-123.74871, 39.89041], [-123.74865, 39.89024], [-123.74867, 39.89014], [-123.74908, 39.88965], [-123.7491, 39.88932], [-123.74952, 39.88836], [-123.74918, 39.88773], [-123.74887, 39.88724], [-123.7483, 39.88721], [-123.74778, 39.88698], [-123.74754, 39.88669], [-123.747, 39.88634], [-123.7459, 39.8862], [-123.74548, 39.88623], [-123.74448, 39.88606], [-123.74281, 39.88631], [-123.74168, 39.8868], [-123.74075, 39.88691], [-123.73998, 39.88672], [-123.73935, 39.88646], [-123.73875, 39.8863], [-123.73814, 39.88634], [-123.73792, 39.88625], [-123.73756, 39.88601], [-123.73747, 39.88542], [-123.73781, 39.8847], [-123.7379, 39.8844], [-123.73814, 39.88399], [-123.73821, 39.88343], [-123.73818, 39.88291], [-123.73798, 39.88262], [-123.73766, 39.88234], [-123.73659, 39.88168], [-123.73606, 39.88143], [-123.73523, 39.88072], [-123.73486, 39.88024], [-123.73477, 39.87985], [-123.7346, 39.8795], [-123.73434, 39.87912], [-123.73385, 39.87865], [-123.73272, 39.87868], [-123.73158, 39.87814], [-123.73089, 39.87795], [-123.73049, 39.8778], [-123.72278, 39.87776], [-123.72224, 39.87746], [-123.72231, 39.87425], [-123.72056, 39.87422], [-123.72014, 39.87474], [-123.71949, 39.8752], [-123.7185, 39.87573], [-123.71811, 39.87606], [-123.71783, 39.87654], [-123.71767, 39.87751], [-123.71887, 39.8775], [-123.71833, 39.87805], [-123.718, 39.87829], [-123.71745, 39.87862], [-123.71721, 39.8787], [-123.71683, 39.87879], [-123.7166, 39.8788], [-123.71643, 39.87871], [-123.71594, 39.87795], [-123.71439, 39.87795], [-123.71401, 39.87776], [-123.71342, 39.87738], [-123.71321, 39.8773], [-123.71297, 39.87726], [-123.71294, 39.87563], [-123.7128, 39.87542], [-123.71248, 39.8751], [-123.71232, 39.87497], [-123.71216, 39.87468], [-123.71205, 39.87422], [-123.71206, 39.87371], [-123.71204, 39.8734], [-123.71211, 39.87311], [-123.71225, 39.87281], [-123.71274, 39.87221], [-123.71296, 39.872], [-123.71319, 39.87186], [-123.7131, 39.87078], [-123.71373, 39.87073], [-123.71771, 39.87076], [-123.7317, 39.87066], [-123.73178, 39.86706], [-123.73285, 39.86693], [-123.73306, 39.86696], [-123.73319, 39.86793], [-123.73633, 39.86793], [-123.73635, 39.87067], [-123.7411, 39.87063], [-123.74117, 39.87419], [-123.74549, 39.87415], [-123.75493, 39.87397], [-123.75503, 39.87595], [-123.755, 39.87752]]], [[[-123.71376, 39.87805], [-123.71298, 39.87807], [-123.71302, 39.87765], [-123.7134, 39.87773], [-123.7136, 39.87785], [-123.71376, 39.87805]]], [[[-123.73643, 39.88607], [-123.73235, 39.88614], [-123.73237, 39.88849], [-123.72993, 39.88851], [-123.72993, 39.88603], [-123.72945, 39.88602], [-123.72928, 39.87809], [-123.73095, 39.87825], [-123.73203, 39.87858], [-123.73261, 39.87927], [-123.73299, 39.88019], [-123.73282, 39.88058], [-123.73328, 39.88099], [-123.73332, 39.88171], [-123.734, 39.88208], [-123.7339, 39.88265], [-123.73432, 39.88267], [-123.73433, 39.88311], [-123.73504, 39.88356], [-123.73643, 39.88607]]]]}	Open Access 1	20522	Standish-Hickey State Recreation Area	1755	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=423	Mendocino 24	1010.72	Standish-Hickey SRA	1921	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]);