calands: units_with_maps: 8 rows where COUNTY = 12 and MNG

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

8 rows where COUNTY = 12 and MNG_AGENCY = 351

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
1370	1370	1369	{"type": "Polygon", "coordinates": [[[-122.2916, 38.01582], [-122.29115, 38.01599], [-122.29085, 38.01572], [-122.2913, 38.01544], [-122.2916, 38.01582]]]}	Open Access 1	12052	Waterfront Park	27303	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	0.507	Waterfront Park	0	Local Park 2	4
5449	5449	5448	{"type": "Polygon", "coordinates": [[[-122.26061, 38.01443], [-122.26017, 38.01496], [-122.25964, 38.01488], [-122.25894, 38.01487], [-122.25863, 38.01494], [-122.2587, 38.01457], [-122.25859, 38.0141], [-122.26007, 38.01404], [-122.26061, 38.01443]]]}	Open Access 1	11993	Foxboro Park	19035	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	3.485	Foxboro Park	0	Local Park 2	4
6559	6559	6558	{"type": "Polygon", "coordinates": [[[-122.25538, 38.00159], [-122.25435, 38.00281], [-122.25412, 38.00263], [-122.25336, 38.00223], [-122.25278, 38.00201], [-122.25257, 38.00201], [-122.25192, 38.00158], [-122.25156, 38.00143], [-122.25141, 38.00151], [-122.25101, 38.00123], [-122.25072, 38.00116], [-122.2507, 38.00114], [-122.25022, 38.00086], [-122.25, 38.00083], [-122.24938, 38.00053], [-122.24896, 38.00066], [-122.24856, 38.00072], [-122.24827, 38.00072], [-122.24798, 38.00065], [-122.24767, 38.00048], [-122.24734, 38.00021], [-122.24715, 37.99991], [-122.24686, 37.99835], [-122.24698, 37.99805], [-122.24718, 37.9979], [-122.24752, 37.99777], [-122.24733, 37.99736], [-122.2477, 37.99706], [-122.24827, 37.99756], [-122.24917, 37.99858], [-122.24991, 37.99904], [-122.25092, 37.99953], [-122.25097, 37.99964], [-122.2513, 37.99978], [-122.25136, 37.99971], [-122.25169, 37.99986], [-122.25173, 37.99985], [-122.25202, 38.0], [-122.25509, 38.00144], [-122.25538, 38.00159]]]}	No Public Access 3	3421	Hercules	19832	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	37.784	Hercules		None 526
8072	8072	8071	{"type": "Polygon", "coordinates": [[[-122.25266, 38.0067], [-122.25224, 38.00769], [-122.25192, 38.00797], [-122.25101, 38.0076], [-122.25175, 38.00629], [-122.25266, 38.0067]]]}	Open Access 1	12005	Woodfield Park	27708	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	3.765	Woodfield Park	0	Local Park 2	4
8074	8074	8073	{"type": "Polygon", "coordinates": [[[-122.23719, 37.99248], [-122.23716, 37.99257], [-122.23705, 37.99266], [-122.23698, 37.99276], [-122.23681, 37.99357], [-122.23679, 37.99358], [-122.23679, 37.99363], [-122.23558, 37.9934], [-122.23555, 37.99247], [-122.23524, 37.99208], [-122.23421, 37.99163], [-122.23472, 37.99052], [-122.23565, 37.99071], [-122.23562, 37.9909], [-122.23593, 37.99102], [-122.23584, 37.99126], [-122.23608, 37.99136], [-122.23609, 37.9915], [-122.23629, 37.99157], [-122.2364, 37.99182], [-122.23657, 37.99209], [-122.23675, 37.99223], [-122.23709, 37.99238], [-122.23719, 37.99248]]]}	Open Access 1	12017	Hanna Ranch Park	19641	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	10.261	Hanna Ranch Park	0	Local Park 2	4
8076	8076	8075	{"type": "Polygon", "coordinates": [[[-122.26966, 38.00898], [-122.26961, 38.00903], [-122.26779, 38.00931], [-122.26785, 38.00878], [-122.26758, 38.00852], [-122.26758, 38.00846], [-122.2669, 38.00788], [-122.26664, 38.00778], [-122.26646, 38.00774], [-122.26682, 38.0071], [-122.26688, 38.00709], [-122.26698, 38.00713], [-122.26704, 38.00711], [-122.26742, 38.0066], [-122.26898, 38.00767], [-122.26924, 38.00793], [-122.26931, 38.00801], [-122.26946, 38.00827], [-122.2696, 38.00861], [-122.26966, 38.00896], [-122.26966, 38.00898]]]}	Open Access 1	12029	Refugio Valley Park	24268	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	10.669	Refugio Valley Park	0	Local Park 2	4
8079	8079	8078	{"type": "Polygon", "coordinates": [[[-122.27455, 38.00682], [-122.27431, 38.00723], [-122.27387, 38.00728], [-122.27367, 38.00655], [-122.27338, 38.00617], [-122.27258, 38.00601], [-122.27246, 38.00546], [-122.27306, 38.00523], [-122.27353, 38.00508], [-122.27435, 38.00571], [-122.27451, 38.00622], [-122.27437, 38.00636], [-122.27455, 38.00682]]]}	Open Access 1	12041	Ohlone Park	23077	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2		Contra Costa 12	5.665	Ohlone Park	0	Local Park 2	4
15008	15008	15007	{"type": "Polygon", "coordinates": [[[-122.27695, 38.02829], [-122.27668, 38.02857], [-122.27649, 38.02878], [-122.27626, 38.02908], [-122.27607, 38.02939], [-122.27585, 38.02979], [-122.2756, 38.0303], [-122.27523, 38.03116], [-122.27496, 38.03196], [-122.2748, 38.03258], [-122.27467, 38.03333], [-122.27449, 38.03465], [-122.27349, 38.03366], [-122.2735, 38.03363], [-122.27311, 38.03323], [-122.2733, 38.03321], [-122.27336, 38.03329], [-122.27348, 38.03333], [-122.2736, 38.03329], [-122.27365, 38.0332], [-122.27405, 38.03314], [-122.27396, 38.03285], [-122.27372, 38.03242], [-122.27387, 38.03234], [-122.27397, 38.0324], [-122.2741, 38.03267], [-122.27442, 38.03272], [-122.27447, 38.03272], [-122.27468, 38.03191], [-122.27491, 38.03132], [-122.27489, 38.03115], [-122.27485, 38.03103], [-122.27408, 38.03033], [-122.27414, 38.03025], [-122.27418, 38.03014], [-122.27423, 38.0299], [-122.27427, 38.02985], [-122.27435, 38.02982], [-122.27466, 38.02984], [-122.2748, 38.02988], [-122.27483, 38.02998], [-122.27515, 38.03012], [-122.27527, 38.03009], [-122.27546, 38.02976], [-122.27557, 38.02929], [-122.27593, 38.02886], [-122.27624, 38.02837], [-122.27647, 38.02815], [-122.27645, 38.0281], [-122.27635, 38.02804], [-122.27655, 38.0279], [-122.27695, 38.02829]]]}	Open Access 1	45658	Shoreline Park	28474	1133	Hercules, City of 354	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=166	City 2	1133	Hercules, City of 351	City 2	City Agency 2	http://www.ci.hercules.ca.us/index.aspx?page=178#Shoreline Park	Contra Costa 12	10.467	Shoreline 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]);