calands: units_with_maps: 12 rows where COUNTY = 12, DES_TP = 2 and MNG

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

12 rows where COUNTY = 12, DES_TP = 2 and MNG_AGENCY = 352

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
1373	1373	1372	{"type": "Polygon", "coordinates": [[[-122.12277, 37.98731], [-122.12226, 37.98757], [-122.12207, 37.98735], [-122.12185, 37.98743], [-122.12071, 37.98629], [-122.12149, 37.98589], [-122.12277, 37.98731]]]}	Open Access 1	12112	Nancy Boyd Park	22623	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	3.529	Nancy Boyd Park	0	Local Park 2	4
1588	1588	1587	{"type": "Polygon", "coordinates": [[[-122.13539, 38.01361], [-122.13479, 38.01396], [-122.1344, 38.01352], [-122.13499, 38.01317], [-122.13539, 38.01361]]]}	Open Access 1	12148	Ygnacio Plaza Martinez Park	27770	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	0.965	Ygnacio Plaza Martinez Park	0	Local Park 2	4
2451	2451	2450	{"type": "Polygon", "coordinates": [[[-122.14512, 38.01547], [-122.14511, 38.01555], [-122.14506, 38.01563], [-122.14493, 38.01567], [-122.1447, 38.01566], [-122.14462, 38.01569], [-122.14447, 38.01578], [-122.14423, 38.016], [-122.14414, 38.01615], [-122.14397, 38.01638], [-122.14379, 38.01658], [-122.14259, 38.01583], [-122.14436, 38.01553], [-122.14435, 38.01531], [-122.14439, 38.01527], [-122.14494, 38.01527], [-122.14508, 38.01538], [-122.14512, 38.01547]]]}	Open Access 1	12183	Rankin Park	24186	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	3.017	Rankin Park	0	Local Park 2	4
5150	5150	5149	{"type": "Polygon", "coordinates": [[[-122.13398, 38.01445], [-122.13343, 38.01479], [-122.13301, 38.01435], [-122.13357, 38.01402], [-122.13398, 38.01445]]]}	Open Access 1	12160	Susana Park	26080	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	0.914	Susana Park	0	Local Park 2	4
7584	7584	7583	{"type": "Polygon", "coordinates": [[[-122.09881, 37.96587], [-122.09858, 37.96595], [-122.09694, 37.96348], [-122.09736, 37.96373], [-122.09774, 37.96377], [-122.09788, 37.96445], [-122.09881, 37.96587]]]}	Open Access 1	12171	Foothills Park	18983	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	1.866	Foothills Park	2000	Local Park 2	4
7767	7767	7766	{"type": "Polygon", "coordinates": [[[-122.09667, 37.99585], [-122.09615, 37.99596], [-122.09581, 37.99551], [-122.09495, 37.99462], [-122.09564, 37.9944], [-122.09667, 37.99585]]]}	Open Access 1	12124	Holiday Highlands Park	20030	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	2.388	Holiday Highlands Park	0	Local Park 2	4
8081	8081	8080	{"type": "Polygon", "coordinates": [[[-122.12208, 37.99953], [-122.12207, 38.00049], [-122.12143, 38.0005], [-122.12061, 37.99958], [-122.12208, 37.99953]]]}	Open Access 1	12100	John Muir Park	20458	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	2.42	John Muir Park	0	Local Park 2	4
8083	8083	8082	{"type": "Polygon", "coordinates": [[[-122.11593, 38.00143], [-122.11599, 38.00166], [-122.11582, 38.0035], [-122.11502, 38.00348], [-122.11518, 38.00271], [-122.11518, 38.00234], [-122.11486, 38.00192], [-122.11442, 38.00148], [-122.11593, 38.00143]]]}	Open Access 1	12089	Mountainview Park	22564	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	4.521	Mountainview Park	0	Local Park 2	4
8100	8100	8099	{"type": "Polygon", "coordinates": [[[-122.12743, 38.01388], [-122.12684, 38.01421], [-122.12642, 38.01377], [-122.12703, 38.01344], [-122.12743, 38.01388]]]}	Open Access 1	12136	Cappy Ricks Park	16841	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	0.968	Cappy Ricks Park	0	Local Park 2	4
9288	9288	9287	{"type": "Polygon", "coordinates": [[[-122.12948, 38.0189], [-122.12919, 38.01904], [-122.12882, 38.01857], [-122.12913, 38.01843], [-122.12948, 38.0189]]]}	Open Access 1	15506	Highland Avenue Park	19929	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	0.453	Highland Avenue Park	0	Local Park 2	4
9304	9304	9303	{"type": "Polygon", "coordinates": [[[-122.10163, 38.00127], [-122.10134, 38.00127], [-122.10128, 38.0012], [-122.10118, 38.00117], [-122.10025, 38.00119], [-122.10021, 38.00118], [-122.10015, 38.00111], [-122.10007, 38.00109], [-122.09999, 38.00111], [-122.09994, 38.00116], [-122.09955, 38.00116], [-122.09954, 38.0007], [-122.10162, 38.00068], [-122.10163, 38.00127]]]}	Open Access 1	15508	Morello Park	22476	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	2.458	Morello Park	0	Local Park 2	4
10155	10155	10154	{"type": "Polygon", "coordinates": [[[-122.11132, 37.96097], [-122.11095, 37.96139], [-122.11059, 37.96121], [-122.11025, 37.96163], [-122.11003, 37.96435], [-122.10815, 37.96267], [-122.10729, 37.96263], [-122.10597, 37.96145], [-122.10589, 37.96083], [-122.10616, 37.96082], [-122.1081, 37.96183], [-122.1083, 37.96161], [-122.10843, 37.96151], [-122.10862, 37.96129], [-122.10842, 37.96118], [-122.10915, 37.96066], [-122.10919, 37.96072], [-122.10951, 37.96049], [-122.10973, 37.96048], [-122.11008, 37.9602], [-122.11104, 37.96083], [-122.11132, 37.96097]]]}	Open Access 1	17697	Golden Hills Park	19364	1198	Martinez, City of 355	City 2	City Agency 2	http://www.cityofmartinez.org/depts/recreation/parks/default.asp	City 2	1198	Martinez, City of 352	City 2	City Agency 2	Contra Costa 12	20.421	Golden Hills Park	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]);