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

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

2 rows where ACCESS_TYP = 1, DES_TP = 3 and MNG_AGENCY = 198

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
4220	4220	4219	{"type": "Polygon", "coordinates": [[[-119.22967, 34.44042], [-119.22934, 34.44104], [-119.22896, 34.44199], [-119.22891, 34.4424], [-119.2287, 34.44271], [-119.2267, 34.44309], [-119.22634, 34.44335], [-119.22505, 34.44413], [-119.22493, 34.44422], [-119.22486, 34.44385], [-119.22446, 34.44408], [-119.22421, 34.44417], [-119.22364, 34.44429], [-119.22324, 34.44458], [-119.22283, 34.44477], [-119.22248, 34.44279], [-119.22792, 34.44213], [-119.22748, 34.43959], [-119.22936, 34.43921], [-119.22967, 34.44042]]]}	Open Access 1	44996	Soule Recreation Area	25633	331	Ventura, County of 202	County 3	County Agency 3	http://www.ventura.org/general-services-agency/parks-department	County 3	331	Ventura, County of 198	County 3	County Agency 3		Ventura 8	30.851	Soule Rec. Area	0	Local Recreation Area 3	4
15989	15989	15988	{"type": "Polygon", "coordinates": [[[-118.83946, 34.24946], [-118.83926, 34.24994], [-118.83054, 34.24995], [-118.83088, 34.24987], [-118.83099, 34.24983], [-118.83165, 34.24954], [-118.83188, 34.24941], [-118.83227, 34.24914], [-118.83247, 34.24897], [-118.83283, 34.2486], [-118.83303, 34.24836], [-118.83365, 34.24841], [-118.83379, 34.24837], [-118.8341, 34.24821], [-118.83431, 34.2482], [-118.83453, 34.24827], [-118.83468, 34.24841], [-118.83486, 34.2485], [-118.83509, 34.2485], [-118.83529, 34.24844], [-118.83542, 34.24832], [-118.8355, 34.24816], [-118.83555, 34.24796], [-118.83572, 34.24786], [-118.83589, 34.24769], [-118.83618, 34.24723], [-118.83626, 34.24705], [-118.83628, 34.24668], [-118.83712, 34.24662], [-118.8375, 34.24662], [-118.83776, 34.24651], [-118.83788, 34.24635], [-118.83782, 34.24616], [-118.83784, 34.24596], [-118.83779, 34.24578], [-118.83782, 34.24558], [-118.83776, 34.24524], [-118.83761, 34.24509], [-118.83736, 34.24506], [-118.83692, 34.2451], [-118.83666, 34.2451], [-118.8364, 34.24516], [-118.83566, 34.24518], [-118.83516, 34.24514], [-118.83475, 34.24506], [-118.83468, 34.24502], [-118.83489, 34.24478], [-118.83507, 34.24461], [-118.83547, 34.24429], [-118.83574, 34.24411], [-118.839, 34.24411], [-118.83906, 34.24414], [-118.83867, 34.24452], [-118.83864, 34.24469], [-118.83921, 34.24531], [-118.83912, 34.24685], [-118.83845, 34.24721], [-118.83863, 34.24856], [-118.83929, 34.24906], [-118.83946, 34.24946]]]}	Open Access 1	1216	Sunset Hills - Olsen Road Open Space	26047	331	Ventura, County of 202	County 3	County Agency 3	http://www.ventura.org/general-services-agency/parks-department	County 3	331	Ventura, County of 198	County 3	County Agency 3		Ventura 8	54.712	Sunset Hills - Olsen Road OS	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]);