calands: units_with_maps: 4 rows where ACCESS_TYP = 3, AGNCY_TYP = 2 and MNG

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

4 rows where ACCESS_TYP = 3, AGNCY_TYP = 2 and MNG_AGENCY = 147

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
6300	6300	6299	{"type": "Polygon", "coordinates": [[[-122.00948, 38.34308], [-122.00872, 38.34467], [-122.00701, 38.34922], [-122.00683, 38.34903], [-122.00699, 38.34894], [-122.00699, 38.34892], [-122.00674, 38.34867], [-122.00658, 38.34877], [-122.00653, 38.34873], [-122.00669, 38.34811], [-122.00525, 38.34739], [-122.00384, 38.34625], [-122.00365, 38.34649], [-122.00372, 38.3469], [-122.00364, 38.34691], [-122.00347, 38.34659], [-122.00335, 38.3466], [-122.00333, 38.34675], [-122.00313, 38.34708], [-122.00328, 38.34718], [-122.0034, 38.34738], [-122.00345, 38.34758], [-122.00328, 38.34776], [-122.00331, 38.34791], [-122.00325, 38.34817], [-122.00307, 38.34857], [-122.00277, 38.34889], [-122.00279, 38.3491], [-122.00256, 38.34887], [-122.00265, 38.34871], [-122.00284, 38.34855], [-122.00297, 38.34837], [-122.00309, 38.34797], [-122.00303, 38.34764], [-122.00318, 38.34745], [-122.00312, 38.34727], [-122.00301, 38.34719], [-122.00296, 38.34712], [-122.00307, 38.3466], [-122.00299, 38.34644], [-122.00268, 38.34637], [-122.00253, 38.3462], [-122.00226, 38.34601], [-122.00198, 38.34544], [-122.00181, 38.34515], [-122.00175, 38.34498], [-122.00215, 38.34482], [-122.00702, 38.34317], [-122.00825, 38.343], [-122.00928, 38.34317], [-122.00948, 38.34308]]]}	No Public Access 3	1417	Alamo Terrace Open Space	15323	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	55.193	Alamo Terrace OS	2000	Local Recreation Area 3	4
11334	11334	11333	{"type": "Polygon", "coordinates": [[[-122.03688, 38.31196], [-122.03629, 38.31305], [-122.03366, 38.31645], [-122.03216, 38.31563], [-122.03232, 38.31462], [-122.03293, 38.31293], [-122.03356, 38.30987], [-122.03451, 38.30962], [-122.03456, 38.30784], [-122.03685, 38.3093], [-122.03577, 38.3104], [-122.03688, 38.31196]]]}	No Public Access 3	22071	Lagoon Valley Gateway Open Space	30788	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	50.705	Lagoon Valley Gateway OS	0	Local Recreation Area 3	4
15992	15992	15991	{"type": "Polygon", "coordinates": [[[-121.9799, 38.37625], [-121.97978, 38.37626], [-121.97969, 38.37632], [-121.97967, 38.37636], [-121.97967, 38.37641], [-121.97972, 38.3765], [-121.97906, 38.37666], [-121.97898, 38.37672], [-121.97889, 38.3767], [-121.97882, 38.3767], [-121.97877, 38.37672], [-121.97872, 38.37667], [-121.97795, 38.37669], [-121.97733, 38.37393], [-121.97713, 38.37363], [-121.97701, 38.37346], [-121.977, 38.37339], [-121.97718, 38.37325], [-121.97737, 38.37299], [-121.97738, 38.37294], [-121.9774, 38.3729], [-121.97744, 38.37276], [-121.97745, 38.37234], [-121.9775, 38.3723], [-121.97831, 38.37233], [-121.97891, 38.37241], [-121.97913, 38.37242], [-121.97914, 38.37278], [-121.97928, 38.37297], [-121.97928, 38.37308], [-121.9793, 38.37312], [-121.97931, 38.37328], [-121.97934, 38.37343], [-121.97935, 38.37375], [-121.97943, 38.3738], [-121.97942, 38.37399], [-121.97936, 38.37423], [-121.97943, 38.37455], [-121.97952, 38.37459], [-121.9795, 38.37467], [-121.97953, 38.37474], [-121.97948, 38.37477], [-121.97954, 38.37506], [-121.97976, 38.37535], [-121.97972, 38.3754], [-121.97972, 38.37545], [-121.97975, 38.37551], [-121.97981, 38.37556], [-121.9798, 38.37594], [-121.9799, 38.37625]]]}	No Public Access 3	1305	Sunrise Woodcrest Open Space	26039	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	20.516	Sunrise Woodcrest OS	0	Local Recreation Area 3	4
16141	16141	16140	{"type": "MultiPolygon", "coordinates": [[[[-122.03212, 38.31331], [-122.03196, 38.3141], [-122.0313, 38.31544], [-122.03096, 38.31544], [-122.03056, 38.31614], [-122.0301, 38.31688], [-122.03005, 38.31707], [-122.03027, 38.31735], [-122.02952, 38.31821], [-122.02738, 38.32038], [-122.02634, 38.32147], [-122.02566, 38.32227], [-122.02487, 38.32309], [-122.0247, 38.32296], [-122.02481, 38.32271], [-122.02483, 38.32231], [-122.02483, 38.32091], [-122.02485, 38.32029], [-122.0247, 38.32019], [-122.02475, 38.31971], [-122.0241, 38.31956], [-122.0236, 38.31937], [-122.02353, 38.3194], [-122.02348, 38.31936], [-122.02274, 38.31931], [-122.02228, 38.31923], [-122.02192, 38.31888], [-122.0215, 38.31869], [-122.02116, 38.31849], [-122.02102, 38.31823], [-122.02092, 38.31819], [-122.02096, 38.31815], [-122.02096, 38.31813], [-122.02055, 38.31799], [-122.01993, 38.31769], [-122.01946, 38.3173], [-122.01902, 38.31716], [-122.01847, 38.31693], [-122.018, 38.31679], [-122.01748, 38.3165], [-122.01657, 38.31619], [-122.0151, 38.3158], [-122.01478, 38.31549], [-122.01664, 38.31423], [-122.01662, 38.31401], [-122.01662, 38.31386], [-122.01666, 38.31363], [-122.0167, 38.3135], [-122.01679, 38.3133], [-122.01718, 38.31269], [-122.01719, 38.31264], [-122.01713, 38.31259], [-122.01662, 38.31255], [-122.01647, 38.31252], [-122.01631, 38.31243], [-122.01624, 38.31236], [-122.01617, 38.31227], [-122.01613, 38.31219], [-122.01612, 38.31209], [-122.01615, 38.31194], [-122.01619, 38.31185], [-122.01642, 38.31155], [-122.01651, 38.31136], [-122.01649, 38.31128], [-122.01645, 38.31124], [-122.0164, 38.31121], [-122.01614, 38.31119], [-122.01585, 38.3112], [-122.01556, 38.31124], [-122.01526, 38.31132], [-122.01513, 38.3114], [-122.01506, 38.31147], [-122.01501, 38.31158], [-122.015, 38.31175], [-122.01495, 38.31183], [-122.01488, 38.31189], [-122.01477, 38.31193], [-122.01466, 38.31195], [-122.01453, 38.31193], [-122.01442, 38.31187], [-122.01427, 38.31127], [-122.01425, 38.31107], [-122.01427, 38.31084], [-122.01435, 38.31059], [-122.01478, 38.30969], [-122.01478, 38.30965], [-122.01477, 38.3096], [-122.01473, 38.30955], [-122.0145, 38.30941], [-122.01443, 38.30938], [-122.01382, 38.30946], [-122.01352, 38.30948], [-122.01333, 38.30946], [-122.01311, 38.3094], [-122.01293, 38.30928], [-122.01278, 38.30911], [-122.01274, 38.30903], [-122.0127, 38.30886], [-122.01269, 38.30872], [-122.01858, 38.30883], [-122.01866, 38.30895], [-122.01898, 38.30911], [-122.02115, 38.30989], [-122.02458, 38.31092], [-122.0254, 38.31237], [-122.02696, 38.31291], [-122.02885, 38.31231], [-122.02898, 38.31232], [-122.03212, 38.31331]], [[-122.02474, 38.31963], [-122.02475, 38.31964], [-122.02476, 38.31963], [-122.02475, 38.31962], [-122.02474, 38.31963]]], [[[-122.03081, 38.3203], [-122.03054, 38.32057], [-122.03033, 38.32076], [-122.02936, 38.32075], [-122.02948, 38.32125], [-122.02987, 38.32264], [-122.02992, 38.32293], [-122.03005, 38.3234], [-122.03005, 38.32493], [-122.02932, 38.325], [-122.02804, 38.32553], [-122.02611, 38.32602], [-122.02533, 38.32521], [-122.02522, 38.325], [-122.02514, 38.32475], [-122.02511, 38.32448], [-122.02514, 38.32422], [-122.02521, 38.32396], [-122.02543, 38.32374], [-122.0258, 38.32326], [-122.02614, 38.32278], [-122.0283, 38.32044], [-122.02862, 38.32014], [-122.03003, 38.31861], [-122.03081, 38.3203]]]]}	No Public Access 3	17793	Lagoon Valley Open Space	30790	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	346.712	Lagoon Valley OS	0	Local Recreation Area 3	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]);