superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 419, MNG_AG_TYP = 2 and PARK_NAME = "Veterans Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11848 | 11848 | 11847 | {"type": "MultiPolygon", "coordinates": [[[[-119.54385, 36.61566], [-119.54386, 36.61616], [-119.54378, 36.61654], [-119.54373, 36.6166], [-119.54372, 36.61669], [-119.54369, 36.61667], [-119.54328, 36.61664], [-119.54326, 36.61665], [-119.54325, 36.61566], [-119.54385, 36.61566]]], [[[-119.54763, 36.61592], [-119.54762, 36.61658], [-119.54757, 36.61667], [-119.54564, 36.61667], [-119.54568, 36.616], [-119.54543, 36.61597], [-119.54541, 36.61599], [-119.5454, 36.61667], [-119.54396, 36.61667], [-119.54395, 36.61657], [-119.54404, 36.61612], [-119.54405, 36.61566], [-119.54727, 36.61565], [-119.54725, 36.616], [-119.5471, 36.61603], [-119.54709, 36.61626], [-119.54715, 36.61626], [-119.54716, 36.61634], [-119.5472, 36.61636], [-119.54723, 36.6164], [-119.54756, 36.6164], [-119.54756, 36.61602], [-119.5476, 36.61592], [-119.54763, 36.61592]]]]} | Open Access 1 | Veterans Park | 28494 | 1461 | Parlier, City of 419 | City 2 | City Agency 2 | http://www.parlier.ca.us/ | City 2 | 9.281 | Veterans Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);