units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 524
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
ACCESS_TYP 2
MNG_AG_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6218 | 6218 | 6217 | {"type": "Polygon", "coordinates": [[[-122.22564, 38.15293], [-122.22516, 38.15364], [-122.22485, 38.15405], [-122.22462, 38.15394], [-122.22416, 38.15388], [-122.22394, 38.15359], [-122.2239, 38.15324], [-122.22435, 38.15302], [-122.22465, 38.15275], [-122.22491, 38.15266], [-122.22559, 38.15271], [-122.22564, 38.15293]]]} | No Public Access 3 | 1275 | Summit Reservoir | 25968 | 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.617 | Summit Reservoir | 0 | Local Recreation Area 3 | 4 | |
| 15997 | 15997 | 15996 | {"type": "MultiPolygon", "coordinates": [[[[-122.17097, 38.14107], [-122.17086, 38.14153], [-122.17007, 38.14193], [-122.17015, 38.14258], [-122.16941, 38.14362], [-122.16924, 38.14268], [-122.16917, 38.14194], [-122.17097, 38.14107]]], [[[-122.17703, 38.16025], [-122.17606, 38.16017], [-122.17525, 38.16013], [-122.17469, 38.16007], [-122.17443, 38.16012], [-122.17416, 38.16015], [-122.17404, 38.16012], [-122.17383, 38.16026], [-122.17376, 38.1604], [-122.17374, 38.16049], [-122.1738, 38.16069], [-122.17395, 38.16075], [-122.17418, 38.16072], [-122.17428, 38.16078], [-122.17443, 38.16074], [-122.17467, 38.16109], [-122.17556, 38.16105], [-122.17606, 38.16114], [-122.17606, 38.16141], [-122.17601, 38.16171], [-122.17599, 38.16225], [-122.1759, 38.16316], [-122.17585, 38.16338], [-122.17627, 38.1639], [-122.17641, 38.16401], [-122.17633, 38.16426], [-122.1763, 38.16452], [-122.17619, 38.16479], [-122.17601, 38.16505], [-122.17581, 38.16529], [-122.17466, 38.166], [-122.17436, 38.16604], [-122.17419, 38.16594], [-122.17403, 38.16576], [-122.17383, 38.16564], [-122.17368, 38.16566], [-122.17331, 38.16583], [-122.17308, 38.16588], [-122.17224, 38.16075], [-122.17088, 38.15287], [-122.1697, 38.1454], [-122.17062, 38.14401], [-122.17114, 38.14481], [-122.17109, 38.14497], [-122.17141, 38.1462], [-122.17171, 38.14626], [-122.17174, 38.14654], [-122.17208, 38.14665], [-122.17219, 38.14677], [-122.17229, 38.14714], [-122.17263, 38.14747], [-122.17287, 38.14785], [-122.17325, 38.14893], [-122.17321, 38.14934], [-122.17363, 38.14981], [-122.17402, 38.15021], [-122.17414, 38.15071], [-122.1746, 38.151], [-122.17488, 38.15096], [-122.17509, 38.15084], [-122.17526, 38.15092], [-122.17509, 38.15122], [-122.17495, 38.15138], [-122.17453, 38.15197], [-122.17431, 38.15218], [-122.17462, 38.15269], [-122.17464, 38.15288], [-122.17473, 38.15331], [-122.17479, 38.15369], [-122.17499, 38.15364], [-122.17533, 38.15345], [-122.17562, 38.15326], [-122.1757, 38.1534], [-122.17565, 38.15351], [-122.17531, 38.15377], [-122.17527, 38.15394], [-122.17494, 38.15426], [-122.17501, 38.15451], [-122.17504, 38.15479], [-122.17515, 38.15534], [-122.17497, 38.1555], [-122.1749, 38.15568], [-122.17488, 38.15581], [-122.17482, 38.15618], [-122.17483, 38.15743], [-122.17518, 38.1575], [-122.17524, 38.1581], [-122.17386, 38.15839], [-122.17368, 38.15926], [-122.17362, 38.15976], [-122.17461, 38.15983], [-122.17512, 38.15978], [-122.17545, 38.15966], [-122.17558, 38.15986], [-122.17601, 38.15994], [-122.17701, 38.16005], [-122.17703, 38.16025]]], [[[-122.19871, 38.15935], [-122.19863, 38.15957], [-122.19852, 38.15972], [-122.19836, 38.15986], [-122.19805, 38.16004], [-122.1977, 38.16037], [-122.1972, 38.1608], [-122.19696, 38.16076], [-122.1962, 38.16052], [-122.19562, 38.16018], [-122.19552, 38.16006], [-122.19563, 38.16011], [-122.19621, 38.15972], [-122.19748, 38.15907], [-122.19787, 38.15879], [-122.19807, 38.15873], [-122.19815, 38.15852], [-122.19803, 38.15828], [-122.19765, 38.15812], [-122.19699, 38.15833], [-122.19684, 38.15851], [-122.19661, 38.15839], [-122.19649, 38.15805], [-122.19654, 38.15784], [-122.19688, 38.15766], [-122.19704, 38.15751], [-122.19689, 38.15721], [-122.19658, 38.15711], [-122.19635, 38.15699], [-122.19605, 38.15677], [-122.19582, 38.15659], [-122.19559, 38.15653], [-122.19517, 38.15631], [-122.19501, 38.15613], [-122.19471, 38.15588], [-122.19452, 38.15554], [-122.19445, 38.15522], [-122.19428, 38.15519], [-122.19371, 38.15469], [-122.19337, 38.1545], [-122.19293, 38.15442], [-122.19244, 38.15451], [-122.19126, 38.15486], [-122.19053, 38.15524], [-122.19035, 38.15539], [-122.19033, 38.15578], [-122.18966, 38.15666], [-122.18964, 38.15666], [-122.18969, 38.15685], [-122.19003, 38.15725], [-122.19084, 38.15765], [-122.19261, 38.15787], [-122.19357, 38.15779], [-122.1945, 38.15749], [-122.1948, 38.15753], [-122.19557, 38.15832], [-122.19483, 38.15889], [-122.1943, 38.15889], [-122.19386, 38.15892], [-122.19294, 38.15912], [-122.19251, 38.15915], [-122.19186, 38.15927], [-122.1902, 38.15932], [-122.18959, 38.1584], [-122.18749, 38.15742], [-122.18629, 38.15759], [-122.18606, 38.15728], [-122.1856, 38.15679], [-122.18526, 38.15655], [-122.18482, 38.15487], [-122.18501, 38.15484], [-122.18516, 38.15508], [-122.18527, 38.15533], [-122.18562, 38.15567], [-122.18592, 38.15588], [-122.18673, 38.15586], [-122.18724, 38.15562], [-122.18751, 38.15544], [-122.18786, 38.15516], [-122.1878, 38.15456], [-122.18717, 38.1533], [-122.18448, 38.15092], [-122.18364, 38.15098], [-122.18303, 38.15105], [-122.18247, 38.15104], [-122.18055, 38.15133], [-122.18025, 38.1514], [-122.17987, 38.15157], [-122.17959, 38.15125], [-122.18044, 38.15112], [-122.1811, 38.15097], [-122.18226, 38.15065], [-122.18264, 38.15038], [-122.18298, 38.15003], [-122.18396, 38.14997], [-122.1843, 38.14958], [-122.18474, 38.14932], [-122.18614, 38.14861], [-122.18513, 38.14698], [-122.18419, 38.14666], [-122.18367, 38.14722], [-122.18229, 38.14795], [-122.18184, 38.14809], [-122.18139, 38.14809], [-122.18102, 38.14804], [-122.18004, 38.14741], [-122.18006, 38.14722], [-122.17993, 38.14702], [-122.17983, 38.14678], [-122.18028, 38.14638], [-122.18046, 38.14598], [-122.18001, 38.14568], [-122.17964, 38.14599], [-122.17882, 38.14558], [-122.17866, 38.14512], [-122.17672, 38.14431], [-122.17648, 38.14391], [-122.17604, 38.14393], [-122.17526, 38.1438], [-122.17486, 38.14381], [-122.1745, 38.14357], [-122.17468, 38.14288], [-122.17497, 38.14279], [-122.1754, 38.14256], [-122.1754, 38.14254], [-122.17514, 38.14221], [-122.17483, 38.14193], [-122.17434, 38.142], [-122.17389, 38.14146], [-122.17369, 38.14143], [-122.17344, 38.14131], [-122.17304, 38.14097], [-122.17272, 38.14139], [-122.17218, 38.14136], [-122.17248, 38.14069], [-122.17291, 38.14042], [-122.17323, 38.14032], [-122.17439, 38.14115], [-122.17709, 38.14318], [-122.18073, 38.14577], [-122.18048, 38.14596], [-122.18048, 38.14598], [-122.181, 38.14603], [-122.18197, 38.14671], [-122.18499, 38.14511], [-122.19094, 38.14174], [-122.1916, 38.14396], [-122.19183, 38.14502], [-122.19361, 38.14526], [-122.19342, 38.14641], [-122.19344, 38.14685], [-122.19363, 38.14756], [-122.19366, 38.14792], [-122.19374, 38.14817], [-122.19425, 38.14846], [-122.19385, 38.1495], [-122.19366, 38.1501], [-122.19533, 38.15225], [-122.19571, 38.15271], [-122.19593, 38.15296], [-122.19627, 38.15434], [-122.1961, 38.15471], [-122.19561, 38.15479], [-122.19556, 38.15487], [-122.19532, 38.15487], [-122.19526, 38.15506], [-122.19526, 38.15524], [-122.19532, 38.15531], [-122.19529, 38.15537], [-122.19548, 38.15558], [-122.1957, 38.15573], [-122.19578, 38.15581], [-122.19695, 38.15655], [-122.19726, 38.15679], [-122.19741, 38.15688], [-122.19754, 38.157], [-122.19758, 38.15707], [-122.1977, 38.15739], [-122.19789, 38.1577], [-122.19808, 38.15798], [-122.19841, 38.15838], [-122.19851, 38.15896], [-122.19868, 38.15919], [-122.19871, 38.15935]], [[-122.19236, 38.15205], [-122.19302, 38.15155], [-122.19134, 38.14984], [-122.18977, 38.1493], [-122.19132, 38.15093], [-122.19236, 38.15205]]], [[[-122.19538, 38.16025], [-122.19392, 38.16102], [-122.19345, 38.15933], [-122.19093, 38.15984], [-122.1914, 38.16222], [-122.19097, 38.16252], [-122.18605, 38.16501], [-122.18458, 38.16552], [-122.18126, 38.1665], [-122.18032, 38.16692], [-122.17906, 38.16745], [-122.17755, 38.16812], [-122.17541, 38.16897], [-122.1737, 38.1696], [-122.17352, 38.16878], [-122.17347, 38.16778], [-122.17363, 38.16787], [-122.17406, 38.16799], [-122.17428, 38.16793], [-122.17565, 38.16731], [-122.17617, 38.16705], [-122.17675, 38.16674], [-122.17742, 38.16634], [-122.17839, 38.16615], [-122.17868, 38.16627], [-122.17939, 38.16663], [-122.17971, 38.16667], [-122.17995, 38.16667], [-122.1803, 38.16631], [-122.18072, 38.16604], [-122.1813, 38.16562], [-122.18188, 38.16538], [-122.18354, 38.16551], [-122.18454, 38.16533], [-122.18535, 38.16513], [-122.1859, 38.16486], [-122.18636, 38.1645], [-122.18675, 38.16429], [-122.18679, 38.16404], [-122.18691, 38.1638], [-122.18722, 38.1638], [-122.18738, 38.16386], [-122.18768, 38.16377], [-122.18783, 38.16366], [-122.18768, 38.16338], [-122.18696, 38.16334], [-122.18688, 38.1631], [-122.18765, 38.16295], [-122.18897, 38.16266], [-122.18989, 38.16242], [-122.19025, 38.16215], [-122.19074, 38.16194], [-122.19063, 38.16179], [-122.1906, 38.16145], [-122.19075, 38.16115], [-122.19037, 38.16099], [-122.19027, 38.16023], [-122.19012, 38.15956], [-122.19135, 38.15948], [-122.19224, 38.15939], [-122.1934, 38.15918], [-122.1934, 38.15913], [-122.19394, 38.15907], [-122.19421, 38.1591], [-122.19436, 38.15938], [-122.19459, 38.15968], [-122.19501, 38.15993], [-122.19524, 38.16011], [-122.1953, 38.16009], [-122.19538, 38.16025]]]]} | Open Access 1 | 896 | Hiddenbrooke Open Space | 14435 | 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 | 547.175 | Hiddenbrooke OS | 1999 | Local Recreation Area 3 | 4 | |
| 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 | 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]);