calands: units_with_maps: 5 rows where ACCESS_TYP = 2, COUNTY = 26 and DES

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

5 rows where ACCESS_TYP = 2, COUNTY = 26 and DES_TP = 2

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	DES_TP	GAP_STS
3546	3546	3545	{"type": "Polygon", "coordinates": [[[-121.94776, 38.35645], [-121.94605, 38.35706], [-121.94576, 38.3565], [-121.94534, 38.35665], [-121.94491, 38.35597], [-121.94666, 38.35525], [-121.94676, 38.35524], [-121.94734, 38.35568], [-121.94757, 38.3557], [-121.94774, 38.35584], [-121.94776, 38.35645]]]}	Restricted Access 2	28309	Cooper School Park	31609	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2		Solano 26	7.337	Cooper School Park	Local Park 2	4
7627	7627	7626	{"type": "Polygon", "coordinates": [[[-122.20934, 38.07296], [-122.20924, 38.07319], [-122.20883, 38.07387], [-122.2085, 38.07392], [-122.20821, 38.07399], [-122.20786, 38.07424], [-122.20742, 38.07433], [-122.20715, 38.07423], [-122.20684, 38.07421], [-122.20685, 38.07409], [-122.20691, 38.07399], [-122.20701, 38.07373], [-122.20708, 38.0736], [-122.20707, 38.07355], [-122.20729, 38.07329], [-122.20754, 38.07308], [-122.2077, 38.07299], [-122.20824, 38.07272], [-122.2085, 38.07255], [-122.20874, 38.07232], [-122.20891, 38.07208], [-122.20916, 38.0723], [-122.20934, 38.07296]]]}	Restricted Access 2	47621	Glen Cove School Park	31356	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_School_Park	Solano 26	6.841	Glen Cove School Park	Local Park 2	4
12476	12476	12475	{"type": "Polygon", "coordinates": [[[-122.00372, 38.35245], [-122.00296, 38.35252], [-122.00294, 38.3523], [-122.00275, 38.35231], [-122.00272, 38.35216], [-122.00244, 38.35216], [-122.00227, 38.35204], [-122.00224, 38.35177], [-122.00199, 38.35177], [-122.00197, 38.35154], [-122.00179, 38.35153], [-122.00176, 38.35144], [-122.00151, 38.35143], [-122.00148, 38.35103], [-122.0019, 38.35074], [-122.00199, 38.35076], [-122.00224, 38.35092], [-122.00243, 38.35107], [-122.00248, 38.35121], [-122.00263, 38.35141], [-122.00357, 38.35193], [-122.00365, 38.352], [-122.00372, 38.35245]]]}	Restricted Access 2	28306	Alamo School Park	31601	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2		Solano 26	4.025	Alamo School Park	Local Park 2	4
12494	12494	12493	{"type": "Polygon", "coordinates": [[[-121.95197, 38.33224], [-121.9516, 38.33235], [-121.95152, 38.33221], [-121.95135, 38.33224], [-121.95129, 38.33217], [-121.95113, 38.33221], [-121.95058, 38.3326], [-121.95066, 38.33278], [-121.95007, 38.33302], [-121.95032, 38.33339], [-121.94992, 38.33336], [-121.94998, 38.33173], [-121.9501, 38.33154], [-121.95021, 38.33142], [-121.95046, 38.33125], [-121.95048, 38.33103], [-121.95196, 38.331], [-121.95197, 38.33224]]]}	Restricted Access 2	28307	Cambridge School Park	31605	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2		Solano 26	6.902	Cambridge School Park	Local Park 2	4
12497	12497	12496	{"type": "Polygon", "coordinates": [[[-122.0039, 38.3646], [-122.00387, 38.36624], [-122.00154, 38.3662], [-122.00153, 38.36566], [-122.00163, 38.36566], [-122.00165, 38.36592], [-122.00216, 38.36593], [-122.00217, 38.36567], [-122.00267, 38.36566], [-122.00267, 38.36535], [-122.00318, 38.36535], [-122.00318, 38.36517], [-122.00274, 38.36462], [-122.00284, 38.36458], [-122.0039, 38.3646]]]}	Restricted Access 2	28311	Hemlock School Park	31596	1364	Vacaville, City of 151	City 2	City Agency 2	http://www.cityofvacaville.com/index.aspx?page=374	City 2	1364	Vacaville, City of 147	City 2	City Agency 2		Solano 26	5.323	Hemlock School Park	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]);