superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AGENCY = 543 and PARK_NAME = "County Of Sacramento"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3250 | 3250 | 3249 | {"type": "MultiPolygon", "coordinates": [[[[-121.20158, 38.69514], [-121.20156, 38.69574], [-121.20155, 38.69578], [-121.20151, 38.69581], [-121.20067, 38.69581], [-121.20049, 38.69583], [-121.20049, 38.69539], [-121.19937, 38.6953], [-121.19888, 38.69513], [-121.19834, 38.6949], [-121.19795, 38.69477], [-121.19761, 38.69473], [-121.19711, 38.69472], [-121.19713, 38.69437], [-121.19853, 38.6944], [-121.19854, 38.6945], [-121.19883, 38.69451], [-121.19885, 38.69441], [-121.19949, 38.69442], [-121.19949, 38.69492], [-121.2004, 38.69496], [-121.20158, 38.69514]]], [[[-121.26253, 38.63482], [-121.26223, 38.63496], [-121.26189, 38.63458], [-121.26039, 38.63544], [-121.25986, 38.63483], [-121.26152, 38.63391], [-121.26213, 38.63444], [-121.26232, 38.63458], [-121.26253, 38.63482]]], [[[-121.26439, 38.63395], [-121.26357, 38.63433], [-121.26303, 38.63368], [-121.26299, 38.63358], [-121.263, 38.63348], [-121.26304, 38.6334], [-121.26311, 38.63333], [-121.26365, 38.63302], [-121.26439, 38.63395]]], [[[-121.325, 38.58998], [-121.32489, 38.59], [-121.32456, 38.58892], [-121.32454, 38.58891], [-121.32255, 38.59098], [-121.32204, 38.59149], [-121.32194, 38.59124], [-121.32446, 38.58861], [-121.3242, 38.58776], [-121.32414, 38.58775], [-121.32412, 38.58766], [-121.32308, 38.58433], [-121.32305, 38.5841], [-121.32175, 38.57992], [-121.32185, 38.57986], [-121.325, 38.58998]]], [[[-121.35463, 38.5704], [-121.35403, 38.57048], [-121.35403, 38.5705], [-121.35418, 38.57064], [-121.35335, 38.57103], [-121.35193, 38.56789], [-121.3508, 38.56544], [-121.35129, 38.5652], [-121.35141, 38.56534], [-121.35162, 38.56568], [-121.35254, 38.56755], [-121.35262, 38.56769], [-121.35291, 38.56809], [-121.35322, 38.56887], [-121.35369, 38.5699], [-121.35378, 38.57004], [-121.354, 38.57024], [-121.35417, 38.57033], [-121.3544, 38.5704], [-121.35463, 38.5704]]]]} | Open Access 1 | County Of Sacramento | 17713 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 28.659 | County Of Sacramento |
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]);