calands: units_with_maps: 7 rows where ACCESS_TYP = 1, MNG_AGENCY = 524 and YR

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

7 rows where ACCESS_TYP = 1, MNG_AGENCY = 524 and YR_EST = 0

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	DES_TP	GAP_STS
2518	2518	2517	{"type": "Polygon", "coordinates": [[[-122.26538, 38.10494], [-122.26507, 38.10505], [-122.26492, 38.10505], [-122.26471, 38.10508], [-122.26443, 38.10508], [-122.26294, 38.10315], [-122.26225, 38.10314], [-122.25992, 38.10308], [-122.25997, 38.10286], [-122.2605, 38.10252], [-122.26133, 38.10247], [-122.26131, 38.10227], [-122.26133, 38.10056], [-122.26156, 38.10061], [-122.26197, 38.10104], [-122.26218, 38.10133], [-122.26229, 38.10145], [-122.26243, 38.10151], [-122.26272, 38.10183], [-122.2633, 38.10232], [-122.26356, 38.10241], [-122.26391, 38.10265], [-122.26436, 38.10321], [-122.26457, 38.10351], [-122.26488, 38.10387], [-122.26528, 38.10453], [-122.26538, 38.10494]]]}	Open Access 1	17636	Marina Vista Park	21842	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	17.166	Marina Vista Park	Local Park 2	4
5726	5726	5725	{"type": "Polygon", "coordinates": [[[-122.24554, 38.09305], [-122.24232, 38.09484], [-122.24201, 38.09477], [-122.24164, 38.09465], [-122.24032, 38.09404], [-122.24015, 38.09398], [-122.2398, 38.09389], [-122.23943, 38.09347], [-122.23949, 38.09163], [-122.23955, 38.0915], [-122.24069, 38.09152], [-122.24122, 38.09122], [-122.24097, 38.09093], [-122.24157, 38.09058], [-122.24115, 38.09014], [-122.24161, 38.08989], [-122.24142, 38.08966], [-122.24107, 38.08931], [-122.24172, 38.08895], [-122.24292, 38.09026], [-122.24311, 38.09035], [-122.24465, 38.09202], [-122.24554, 38.09305]]]}	Open Access 1	2179	Lake Dalwigk Park	20882	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	45.796	Lake Dalwigk Park	Local Park 2	4
8043	8043	8042	{"type": "Polygon", "coordinates": [[[-122.24487, 38.10479], [-122.24365, 38.10479], [-122.24368, 38.1036], [-122.24461, 38.10363], [-122.24487, 38.10479]]]}	Open Access 1	11644	Gibson Park	19291	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	3.05	Gibson Park	Local Park 2	4
8045	8045	8044	{"type": "Polygon", "coordinates": [[[-122.25989, 38.15146], [-122.25922, 38.1516], [-122.25814, 38.15209], [-122.25823, 38.15023], [-122.25984, 38.15024], [-122.25989, 38.15146]]]}	Open Access 1	11632	Rosa Mini Park	24601	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	5.996	Rosa MP	Local Park 2	4
13793	13793	13792	{"type": "Polygon", "coordinates": [[[-122.27659, 38.12585], [-122.27653, 38.12614], [-122.27436, 38.12596], [-122.27377, 38.12604], [-122.2735, 38.12621], [-122.27296, 38.12726], [-122.27264, 38.127], [-122.27238, 38.12688], [-122.27137, 38.1267], [-122.27073, 38.1267], [-122.26972, 38.12673], [-122.26882, 38.12673], [-122.2686, 38.12664], [-122.26957, 38.12564], [-122.27074, 38.12565], [-122.27154, 38.12519], [-122.27256, 38.12469], [-122.27347, 38.12403], [-122.27385, 38.12357], [-122.27422, 38.12319], [-122.27481, 38.12286], [-122.27546, 38.12227], [-122.27609, 38.12257], [-122.2763, 38.12316], [-122.27645, 38.12379], [-122.27639, 38.12421], [-122.27607, 38.12463], [-122.27575, 38.12484], [-122.27511, 38.12496], [-122.2741, 38.125], [-122.27379, 38.12521], [-122.2742, 38.12542], [-122.27516, 38.12546], [-122.27622, 38.12572], [-122.27659, 38.12585]]]}	Open Access 1	36360	Vallejo holding 1	26778	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	35.154	Vallejo holding 1	Local Other or Unknown 14	4
14656	14656	14655	{"type": "Polygon", "coordinates": [[[-122.26076, 38.07691], [-122.26064, 38.0769], [-122.26063, 38.07694], [-122.25758, 38.07677], [-122.2557, 38.07638], [-122.25595, 38.07779], [-122.2569, 38.07836], [-122.25772, 38.0818], [-122.25793, 38.08285], [-122.25917, 38.08302], [-122.25879, 38.08349], [-122.25825, 38.08339], [-122.25824, 38.0834], [-122.25873, 38.08378], [-122.25901, 38.08386], [-122.26016, 38.08403], [-122.25886, 38.0844], [-122.26004, 38.08473], [-122.25888, 38.08472], [-122.2582, 38.08463], [-122.25799, 38.08463], [-122.25783, 38.08472], [-122.25682, 38.08369], [-122.25648, 38.08233], [-122.25642, 38.0818], [-122.25625, 38.08136], [-122.25608, 38.08105], [-122.2553, 38.08068], [-122.25544, 38.08059], [-122.25543, 38.08058], [-122.25322, 38.07996], [-122.25387, 38.0795], [-122.25321, 38.07877], [-122.25264, 38.07903], [-122.2507, 38.07665], [-122.25133, 38.0765], [-122.25284, 38.0755], [-122.25368, 38.07531], [-122.25483, 38.0753], [-122.25564, 38.07534], [-122.25591, 38.07527], [-122.25604, 38.07515], [-122.25659, 38.07432], [-122.25704, 38.07441], [-122.25737, 38.07472], [-122.25771, 38.07484], [-122.25796, 38.07497], [-122.25807, 38.07533], [-122.25857, 38.07549], [-122.25899, 38.07592], [-122.25921, 38.076], [-122.25952, 38.0763], [-122.26039, 38.07621], [-122.26043, 38.07599], [-122.2605, 38.07594], [-122.26059, 38.07596], [-122.26042, 38.07647], [-122.26076, 38.07691]]]}	Open Access 1	44916	Mare Island Shoreline Heritage Preserve	21800	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	83.482	Mare Island Shoreline Heritage Preserve	Local Conservation Area 4	2
16000	16000	15999	{"type": "MultiPolygon", "coordinates": [[[[-122.18849, 38.10403], [-122.18851, 38.10422], [-122.18822, 38.10503], [-122.18814, 38.10535], [-122.18793, 38.10542], [-122.18791, 38.10566], [-122.18766, 38.10566], [-122.18746, 38.10485], [-122.18647, 38.10017], [-122.18684, 38.10004], [-122.18697, 38.10042], [-122.18716, 38.10084], [-122.18731, 38.10104], [-122.18763, 38.10159], [-122.18808, 38.10208], [-122.18808, 38.10227], [-122.18802, 38.10261], [-122.18824, 38.10285], [-122.18828, 38.10313], [-122.18832, 38.10401], [-122.18849, 38.10403]]], [[[-122.19633, 38.10483], [-122.19523, 38.10469], [-122.19415, 38.10414], [-122.19394, 38.1042], [-122.19381, 38.10438], [-122.19386, 38.10455], [-122.19456, 38.1048], [-122.19447, 38.10492], [-122.19403, 38.10488], [-122.19378, 38.1047], [-122.19334, 38.10467], [-122.19319, 38.10487], [-122.19299, 38.10482], [-122.19294, 38.10457], [-122.19228, 38.10487], [-122.19226, 38.10519], [-122.192, 38.10517], [-122.19163, 38.1051], [-122.19094, 38.10523], [-122.19066, 38.1052], [-122.19074, 38.10495], [-122.19146, 38.10473], [-122.19186, 38.10468], [-122.19206, 38.1046], [-122.19233, 38.10444], [-122.19306, 38.10381], [-122.19327, 38.10365], [-122.19386, 38.10345], [-122.1942, 38.10358], [-122.19496, 38.10401], [-122.19587, 38.10446], [-122.19633, 38.10483]]], [[[-122.19937, 38.10653], [-122.19915, 38.10671], [-122.19895, 38.10673], [-122.19862, 38.10649], [-122.19836, 38.10581], [-122.19816, 38.10542], [-122.19778, 38.10507], [-122.19719, 38.10466], [-122.19671, 38.10437], [-122.19539, 38.10374], [-122.19544, 38.10357], [-122.19525, 38.10325], [-122.19441, 38.10301], [-122.19448, 38.10274], [-122.19479, 38.10271], [-122.19535, 38.10268], [-122.19573, 38.10259], [-122.19608, 38.10243], [-122.19639, 38.10246], [-122.19692, 38.10296], [-122.19777, 38.103], [-122.19838, 38.10279], [-122.19866, 38.10275], [-122.19908, 38.10304], [-122.19902, 38.10338], [-122.19898, 38.10395], [-122.19919, 38.1044], [-122.19902, 38.10469], [-122.19883, 38.10493], [-122.19875, 38.10533], [-122.19885, 38.10568], [-122.19912, 38.10603], [-122.19937, 38.10653]]]]}	Open Access 1	967	Sommerset Open Space	25604	1365	Vallejo, City of 531	City 2	City Agency 2	http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails	City 2	1365	Vallejo, City of 524	City 2	City Agency 2	Solano 26	39.314	Sommerset OS	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]);