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

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

10 rows where ACCESS_TYP = 1, DES_TP = 2 and MNG_AGENCY = 770

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
7726	7726	7725	{"type": "Polygon", "coordinates": [[[-122.01041, 38.24782], [-122.01031, 38.24929], [-122.00925, 38.24921], [-122.00837, 38.24903], [-122.0091, 38.24769], [-122.00994, 38.24782], [-122.01041, 38.24782]]]}	Open Access 1	7982	Carl E. Hall Park	16851	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	5.771	Carl E. Hall Park	0	Local Park 2	4
9015	9015	9014	{"type": "Polygon", "coordinates": [[[-122.03876, 38.24014], [-122.03742, 38.24014], [-122.03696, 38.23916], [-122.03734, 38.23912], [-122.03739, 38.23929], [-122.03763, 38.2393], [-122.03774, 38.23909], [-122.03799, 38.23898], [-122.03824, 38.23908], [-122.0384, 38.2393], [-122.03866, 38.23937], [-122.03875, 38.23956], [-122.03879, 38.23979], [-122.03876, 38.24014]]]}	Open Access 1	14920	Day Park	17961	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	3.596	Day Park	0	Local Park 2	4
9016	9016	9015	{"type": "Polygon", "coordinates": [[[-122.03655, 38.23857], [-122.03592, 38.23857], [-122.0359, 38.23861], [-122.03591, 38.23879], [-122.03587, 38.2388], [-122.03588, 38.23862], [-122.03582, 38.23857], [-122.0353, 38.23857], [-122.03522, 38.23863], [-122.03521, 38.23914], [-122.03525, 38.2392], [-122.0351, 38.23917], [-122.03515, 38.23913], [-122.03515, 38.23862], [-122.03509, 38.23857], [-122.03481, 38.23856], [-122.03481, 38.23828], [-122.03545, 38.23829], [-122.03549, 38.23824], [-122.03549, 38.23806], [-122.03556, 38.23806], [-122.03556, 38.23824], [-122.0356, 38.23829], [-122.03623, 38.23829], [-122.03629, 38.23822], [-122.03634, 38.23828], [-122.03645, 38.23833], [-122.03655, 38.23857]]]}	Open Access 1	14922	Todd Park	26385	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	1.321	Todd Park	0	Local Park 2	4
9017	9017	9016	{"type": "Polygon", "coordinates": [[[-122.01193, 38.24089], [-122.01193, 38.24114], [-122.01187, 38.24135], [-122.01158, 38.2412], [-122.01138, 38.24113], [-122.01093, 38.2411], [-122.01067, 38.24104], [-122.01042, 38.24094], [-122.01056, 38.24088], [-122.01089, 38.24087], [-122.01193, 38.24089]]]}	Open Access 1	14925	McCoy Creek Park	22010	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	0.899	McCoy Creek Park	0	Local Park 2	4
9018	9018	9017	{"type": "Polygon", "coordinates": [[[-122.00675, 38.23792], [-122.00667, 38.24075], [-122.00645, 38.24053], [-122.00646, 38.24046], [-122.00635, 38.24039], [-122.00626, 38.24045], [-122.00609, 38.24053], [-122.00543, 38.24065], [-122.00539, 38.24063], [-122.00536, 38.2406], [-122.00535, 38.24054], [-122.00528, 38.2404], [-122.00513, 38.23984], [-122.00499, 38.23958], [-122.00484, 38.23936], [-122.00468, 38.23919], [-122.00449, 38.23906], [-122.00422, 38.2389], [-122.00392, 38.23876], [-122.00612, 38.23807], [-122.00675, 38.23792]]]}	Open Access 1	14927	Lawler Ranch Park	31000	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	10.688	Lawler Ranch Park	0	Local Park 2	4
9019	9019	9018	{"type": "Polygon", "coordinates": [[[-121.99949, 38.23699], [-121.99899, 38.23756], [-121.999, 38.2376], [-121.99895, 38.23768], [-121.99894, 38.23777], [-121.99902, 38.23782], [-121.99908, 38.23783], [-121.99898, 38.23816], [-121.99911, 38.23825], [-121.99918, 38.23839], [-121.9992, 38.23854], [-121.99921, 38.23877], [-121.99894, 38.23877], [-121.99881, 38.23862], [-121.99864, 38.2385], [-121.99843, 38.23841], [-121.99818, 38.23836], [-121.99784, 38.23838], [-121.99759, 38.23816], [-121.9976, 38.23802], [-121.9977, 38.23781], [-121.99784, 38.23776], [-121.99839, 38.23785], [-121.99857, 38.23754], [-121.99868, 38.23748], [-121.99873, 38.23741], [-121.99883, 38.23742], [-121.9993, 38.23687], [-121.99949, 38.23699]]]}	Open Access 1	14929	Lawler Falls Park	21113	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	3.14	Lawler Falls Park	0	Local Park 2	4
9020	9020	9019	{"type": "Polygon", "coordinates": [[[-121.98443, 38.24864], [-121.98241, 38.2497], [-121.98174, 38.24893], [-121.98363, 38.24788], [-121.98443, 38.24864]]]}	Open Access 1	14931	Montebello Vista Park	22407	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	5.462	Montebello Vista Park	0	Local Park 2	4
9021	9021	9020	{"type": "Polygon", "coordinates": [[[-121.99686, 38.2494], [-121.9951, 38.24948], [-121.99479, 38.24852], [-121.99642, 38.24811], [-121.99686, 38.2494]]]}	Open Access 1	14934	Samuel W. Geopp Park	24822	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	4.82	Samuel W. Geopp Park	0	Local Park 2	4
9871	9871	9870	{"type": "Polygon", "coordinates": [[[-122.02496, 38.24674], [-122.02492, 38.24958], [-122.02414, 38.2496], [-122.0235, 38.24955], [-122.02346, 38.24783], [-122.02373, 38.24776], [-122.02372, 38.2467], [-122.02496, 38.24674]]]}	Open Access 1	16933	Heritage Park	19856	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	9.412	Heritage Park	2000	Local Park 2	4
14256	14256	14255	{"type": "Polygon", "coordinates": [[[-121.98527, 38.2566], [-121.98393, 38.25659], [-121.98382, 38.25657], [-121.98374, 38.25661], [-121.98369, 38.25668], [-121.9835, 38.25668], [-121.9835, 38.2565], [-121.98321, 38.25555], [-121.98368, 38.25555], [-121.98369, 38.2556], [-121.98373, 38.25564], [-121.98382, 38.25567], [-121.98401, 38.25565], [-121.98562, 38.25566], [-121.98565, 38.2557], [-121.98565, 38.25587], [-121.98548, 38.25602], [-121.98546, 38.25608], [-121.98545, 38.25614], [-121.9855, 38.25626], [-121.98562, 38.25635], [-121.98565, 38.2564], [-121.98564, 38.25658], [-121.98559, 38.25661], [-121.98527, 38.2566]]]}	Open Access 1	44175	Patriot Park	23515	1344	Suisun City, City of 792	City 2	City Agency 2	http://www.suisun.com/departments/recreation-community-services/suisun-city-parks/	City 2	1344	Suisun City, City of 770	City 2	City Agency 2	Solano 26	5.112	Patriot 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]);