units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_WEB = "http://www.ci.vallejo.ca.us/attractions___events/sports___recreation/parks___trails", COUNTY = 11 and DES_TP = 520
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6397 | 6397 | 6396 | {"type": "Polygon", "coordinates": [[[-122.11544, 38.38481], [-122.11085, 38.38485], [-122.11091, 38.38267], [-122.11093, 38.38014], [-122.111, 38.37767], [-122.09259, 38.37779], [-122.09265, 38.37418], [-122.09308, 38.37371], [-122.09356, 38.37334], [-122.0949, 38.37217], [-122.09681, 38.3721], [-122.0983, 38.37151], [-122.09981, 38.37125], [-122.10093, 38.37053], [-122.10295, 38.36978], [-122.10869, 38.36903], [-122.10856, 38.36776], [-122.10988, 38.36786], [-122.11024, 38.36696], [-122.11195, 38.3669], [-122.11229, 38.36599], [-122.11168, 38.36504], [-122.11442, 38.36431], [-122.11479, 38.36369], [-122.11499, 38.36371], [-122.11581, 38.36318], [-122.11586, 38.36198], [-122.11638, 38.36158], [-122.11721, 38.36118], [-122.11751, 38.36079], [-122.11748, 38.35989], [-122.11809, 38.35895], [-122.11957, 38.35813], [-122.11997, 38.35753], [-122.12053, 38.35653], [-122.12122, 38.35702], [-122.12167, 38.35723], [-122.12188, 38.35576], [-122.12341, 38.35574], [-122.12355, 38.35555], [-122.12382, 38.35544], [-122.1243, 38.35538], [-122.12565, 38.35533], [-122.1258, 38.35478], [-122.12584, 38.35485], [-122.12745, 38.35453], [-122.12788, 38.35542], [-122.12782, 38.35783], [-122.1305, 38.35809], [-122.13208, 38.35914], [-122.13312, 38.35871], [-122.135, 38.35888], [-122.13607, 38.35969], [-122.13737, 38.36011], [-122.13806, 38.36013], [-122.14092, 38.36156], [-122.14146, 38.36186], [-122.143, 38.3619], [-122.14372, 38.36113], [-122.14487, 38.36143], [-122.14617, 38.36078], [-122.147, 38.36125], [-122.14761, 38.36115], [-122.14965, 38.36007], [-122.15036, 38.35989], [-122.15096, 38.35888], [-122.1527, 38.3596], [-122.15299, 38.36046], [-122.15403, 38.36153], [-122.15406, 38.36222], [-122.15549, 38.36355], [-122.15126, 38.36401], [-122.14689, 38.36435], [-122.14511, 38.36421], [-122.14503, 38.36891], [-122.14499, 38.37022], [-122.14326, 38.37027], [-122.14325, 38.37093], [-122.1428, 38.37066], [-122.1427, 38.37054], [-122.14273, 38.37046], [-122.144, 38.36923], [-122.14424, 38.36897], [-122.14443, 38.36844], [-122.14445, 38.3679], [-122.14446, 38.36562], [-122.1444, 38.36532], [-122.14435, 38.36515], [-122.14429, 38.36501], [-122.14417, 38.36482], [-122.14391, 38.36448], [-122.14354, 38.36412], [-122.14318, 38.36382], [-122.14297, 38.36374], [-122.14284, 38.36373], [-122.14244, 38.36385], [-122.14209, 38.36392], [-122.14187, 38.36391], [-122.14154, 38.36376], [-122.14118, 38.36349], [-122.14045, 38.36313], [-122.13997, 38.36301], [-122.13964, 38.36301], [-122.13927, 38.36294], [-122.13906, 38.3628], [-122.13852, 38.36235], [-122.13817, 38.36222], [-122.13659, 38.36209], [-122.13516, 38.36173], [-122.13481, 38.36166], [-122.13475, 38.36158], [-122.13454, 38.36146], [-122.13414, 38.3614], [-122.13386, 38.36137], [-122.13364, 38.36141], [-122.13331, 38.3614], [-122.13301, 38.36147], [-122.13241, 38.36148], [-122.13123, 38.36138], [-122.13061, 38.3614], [-122.13022, 38.36131], [-122.13003, 38.36124], [-122.12971, 38.36105], [-122.12947, 38.36072], [-122.1293, 38.36005], [-122.129, 38.35959], [-122.12873, 38.35958], [-122.12898, 38.36], [-122.12913, 38.36022], [-122.12914, 38.36054], [-122.12938, 38.36098], [-122.1296, 38.36121], [-122.12991, 38.36141], [-122.13045, 38.36156], [-122.13104, 38.36158], [-122.13157, 38.36156], [-122.13253, 38.36165], [-122.13312, 38.36166], [-122.13337, 38.36161], [-122.13369, 38.36158], [-122.13388, 38.36154], [-122.13442, 38.36164], [-122.13455, 38.36169], [-122.13468, 38.3618], [-122.13497, 38.36189], [-122.13563, 38.362], [-122.13632, 38.36221], [-122.13678, 38.36228], [-122.1372, 38.36229], [-122.13787, 38.36233], [-122.1382, 38.36239], [-122.13839, 38.36248], [-122.13855, 38.36259], [-122.1387, 38.36274], [-122.13879, 38.36286], [-122.13904, 38.36302], [-122.13927, 38.36312], [-122.13961, 38.36316], [-122.13991, 38.36317], [-122.14057, 38.36336], [-122.14122, 38.36376], [-122.14166, 38.364], [-122.14198, 38.36408], [-122.14226, 38.36404], [-122.14281, 38.36389], [-122.14295, 38.3639], [-122.14322, 38.3641], [-122.14346, 38.36433], [-122.14384, 38.36478], [-122.14404, 38.36509], [-122.14416, 38.36534], [-122.14421, 38.36561], [-122.14423, 38.36687], [-122.14423, 38.3675], [-122.1442, 38.36834], [-122.14405, 38.36879], [-122.1438, 38.36917], [-122.14325, 38.36964], [-122.14279, 38.37007], [-122.14257, 38.37033], [-122.14249, 38.3705], [-122.14253, 38.37065], [-122.14267, 38.37084], [-122.14288, 38.37096], [-122.14325, 38.3711], [-122.14328, 38.37163], [-122.14394, 38.37239], [-122.14249, 38.37349], [-122.14246, 38.37491], [-122.13816, 38.37472], [-122.13819, 38.37527], [-122.13871, 38.37775], [-122.13877, 38.38821], [-122.13876, 38.39117], [-122.13879, 38.39262], [-122.13883, 38.39836], [-122.13884, 38.40294], [-122.13429, 38.40294], [-122.12538, 38.40262], [-122.1252, 38.39908], [-122.11618, 38.39882], [-122.11535, 38.38839], [-122.11825, 38.38838], [-122.12002, 38.38842], [-122.12, 38.38757], [-122.12008, 38.38554], [-122.12007, 38.38483], [-122.1174, 38.38474], [-122.11544, 38.38481]]]} | No Public Access 3 | 1835 | Lake Curry | 20880 | 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 | Napa 11 | 3148.149 | Lake Curry | 0 | None 520 |
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]);