calands: units_with_maps: 1 row where ACCESS_TYP = 1, MNG_AGENCY = 258 and SUID

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

1 row where ACCESS_TYP = 1, MNG_AGENCY = 258 and SUID_NMA = 9395

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
16385	16385	16384	{"type": "Polygon", "coordinates": [[[-117.42159, 33.98048], [-117.42081, 33.98144], [-117.41987, 33.9818], [-117.41783, 33.98249], [-117.41783, 33.98251], [-117.41846, 33.98293], [-117.41668, 33.98402], [-117.4151, 33.98494], [-117.41511, 33.98495], [-117.41679, 33.98621], [-117.41677, 33.98622], [-117.41647, 33.98611], [-117.41616, 33.98602], [-117.41589, 33.98597], [-117.41561, 33.98594], [-117.41415, 33.98593], [-117.41401, 33.98606], [-117.4138, 33.98591], [-117.41345, 33.9859], [-117.41311, 33.98586], [-117.41278, 33.9858], [-117.41244, 33.98569], [-117.41217, 33.98558], [-117.41188, 33.98542], [-117.40831, 33.98323], [-117.40796, 33.98304], [-117.40754, 33.98284], [-117.40716, 33.98271], [-117.40677, 33.9826], [-117.40638, 33.98252], [-117.40581, 33.98246], [-117.40524, 33.98246], [-117.4046, 33.98253], [-117.40404, 33.98265], [-117.40351, 33.98283], [-117.40295, 33.98309], [-117.40268, 33.98325], [-117.40243, 33.98342], [-117.40202, 33.98376], [-117.40249, 33.98324], [-117.40324, 33.98249], [-117.40376, 33.98201], [-117.40431, 33.98155], [-117.40525, 33.98081], [-117.40543, 33.98095], [-117.40598, 33.98057], [-117.40598, 33.98055], [-117.40584, 33.98039], [-117.40712, 33.97953], [-117.40517, 33.97713], [-117.4044, 33.97762], [-117.40329, 33.97839], [-117.40257, 33.97893], [-117.40154, 33.97979], [-117.40088, 33.98038], [-117.39995, 33.9813], [-117.39801, 33.98342], [-117.40257, 33.97667], [-117.40275, 33.97634], [-117.40381, 33.97674], [-117.40711, 33.97636], [-117.40986, 33.97527], [-117.41045, 33.97568], [-117.41297, 33.97467], [-117.41986, 33.97931], [-117.41979, 33.97937], [-117.41979, 33.97939], [-117.42056, 33.97987], [-117.42099, 33.98007], [-117.42159, 33.98048]]]}	Open Access 1	30003	Ranch Jurupa Regional Park	9395	2123	Riverside County Regional Park and Open Space District 262	Special District 4	Recreation/Parks District 4	http://www.riversidecountyparks.org/	Special District 4	2123	Riverside County Regional Park and Open Space District 258	Special District 4	Recreation/Parks District 4	http://www.rivcoparks.org/parks/rancho-jurupa/rancho-jurupa-park-home/	Riverside 10	309.352	Ranch Jurupa RP	0	Local Park 2	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]);