calands: units_with_maps: 2 rows where DES_TP = 4 and MNG

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

2 rows where DES_TP = 4 and MNG_AGENCY = 338

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
7556	7556	7555	{"type": "Polygon", "coordinates": [[[-122.20957, 38.06758], [-122.20956, 38.06787], [-122.2084, 38.06804], [-122.20788, 38.06822], [-122.20785, 38.06852], [-122.20778, 38.06848], [-122.2077, 38.06847], [-122.20762, 38.0685], [-122.20758, 38.06855], [-122.20759, 38.06864], [-122.2077, 38.06874], [-122.20771, 38.06882], [-122.20641, 38.06881], [-122.20508, 38.06877], [-122.2051, 38.06835], [-122.2051, 38.06699], [-122.20529, 38.06729], [-122.20608, 38.06766], [-122.20684, 38.06774], [-122.20738, 38.0674], [-122.20741, 38.06735], [-122.20741, 38.06694], [-122.20762, 38.06695], [-122.20766, 38.06688], [-122.20789, 38.06689], [-122.20799, 38.06681], [-122.20802, 38.06687], [-122.20812, 38.06691], [-122.20868, 38.06703], [-122.20899, 38.06696], [-122.20924, 38.06686], [-122.20938, 38.06689], [-122.20936, 38.06708], [-122.20948, 38.0671], [-122.20946, 38.06757], [-122.20957, 38.06758]]]}	Open Access 1	47640	Glen Cove Nature Area	31382	2224	Greater Vallejo Recreation and Park District 341	Special District 4	Recreation/Parks District 4	http://www.gvrd.org/	Special District 4	2224	Greater Vallejo Recreation and Park District 338	Special District 4	Recreation/Parks District 4	http://www.gvrd.org/?page=Glen_Cove_Nature_Area	Solano 26	13.068	Glen Cove Nature Area	0	Local Conservation Area 4	2
14222	14222	14221	{"type": "Polygon", "coordinates": [[[-122.20351, 38.11873], [-122.20328, 38.11883], [-122.20313, 38.11904], [-122.20284, 38.11927], [-122.20219, 38.11961], [-122.20174, 38.11972], [-122.20122, 38.12015], [-122.20077, 38.1204], [-122.20056, 38.12044], [-122.20036, 38.12056], [-122.20022, 38.12088], [-122.19972, 38.12162], [-122.19969, 38.12201], [-122.19851, 38.12033], [-122.19912, 38.12062], [-122.20048, 38.12015], [-122.2031, 38.11852], [-122.20351, 38.11873]]]}	Open Access 1	44102	Blue Rock Springs Corridor	16188	2224	Greater Vallejo Recreation and Park District 341	Special District 4	Recreation/Parks District 4	http://www.gvrd.org/	Special District 4	2224	Greater Vallejo Recreation and Park District 338	Special District 4	Recreation/Parks District 4		Solano 26	6.569	Blue Rock Springs Corridor	0	Local Conservation Area 4	2

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]);