superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
124 rows where MNG_AGENCY = 533 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8992 | 8992 | 8991 | {"type": "Polygon", "coordinates": [[[-121.32215, 38.76468], [-121.32215, 38.76468], [-121.32201, 38.76495], [-121.32198, 38.76464], [-121.32215, 38.76468]]]} | Open Access 1 | Roseville holding 41 | 24662 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.059 | Roseville holding 41 | ||
8807 | 8807 | 8806 | {"type": "Polygon", "coordinates": [[[-121.32457, 38.76049], [-121.32457, 38.76049], [-121.32436, 38.76079], [-121.32439, 38.7605], [-121.32457, 38.76049]]]} | Open Access 1 | Roseville holding 7 | 24667 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.06 | Roseville holding 7 | ||
8997 | 8997 | 8996 | {"type": "Polygon", "coordinates": [[[-121.33947, 38.77588], [-121.33905, 38.77566], [-121.33905, 38.77566], [-121.33934, 38.77566], [-121.33947, 38.77588]]]} | Open Access 1 | Roseville holding 9 | 24669 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.076 | Roseville holding 9 | ||
8958 | 8958 | 8957 | {"type": "Polygon", "coordinates": [[[-121.3399, 38.77607], [-121.33948, 38.77588], [-121.33948, 38.77588], [-121.33969, 38.77582], [-121.3399, 38.77607]]]} | Open Access 1 | Roseville holding 13 | 24631 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.081 | Roseville holding 13 | ||
8891 | 8891 | 8890 | {"type": "Polygon", "coordinates": [[[-121.29997, 38.7584], [-121.29997, 38.75871], [-121.29997, 38.75871], [-121.29978, 38.75851], [-121.29978, 38.75839], [-121.29997, 38.7584]]]} | Open Access 1 | Roseville holding 8 | 24668 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.096 | Roseville holding 8 | ||
3604 | 3604 | 3603 | {"type": "Polygon", "coordinates": [[[-121.3441, 38.77738], [-121.34408, 38.77766], [-121.34393, 38.77766], [-121.34396, 38.77738], [-121.3441, 38.77738]]]} | Open Access 1 | Diamond Oaks | 18143 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.101 | Diamond Oaks | ||
8957 | 8957 | 8956 | {"type": "Polygon", "coordinates": [[[-121.31748, 38.76975], [-121.31732, 38.76971], [-121.31722, 38.76963], [-121.31737, 38.76942], [-121.31747, 38.76953], [-121.31748, 38.76975]]]} | Open Access 1 | Roseville holding 12 | 24630 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.12 | Roseville holding 12 | ||
8986 | 8986 | 8985 | {"type": "Polygon", "coordinates": [[[-121.22836, 38.73076], [-121.22836, 38.73086], [-121.22831, 38.73091], [-121.22796, 38.73092], [-121.22796, 38.73079], [-121.22827, 38.73079], [-121.22832, 38.73076], [-121.22836, 38.73076]]]} | Open Access 1 | Roseville holding 35 | 24655 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.124 | Roseville holding 35 | ||
8954 | 8954 | 8953 | {"type": "Polygon", "coordinates": [[[-121.32679, 38.76689], [-121.3266, 38.76689], [-121.3266, 38.76659], [-121.32679, 38.76659], [-121.32679, 38.76689]]]} | Open Access 1 | Roseville holding 1 | 24627 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.139 | Roseville holding 1 | ||
8989 | 8989 | 8988 | {"type": "Polygon", "coordinates": [[[-121.33024, 38.76448], [-121.33023, 38.7647], [-121.32995, 38.7647], [-121.32996, 38.76448], [-121.33024, 38.76448]]]} | Open Access 1 | Roseville holding 39 | 24659 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.146 | Roseville holding 39 | ||
8959 | 8959 | 8958 | {"type": "Polygon", "coordinates": [[[-121.31816, 38.77053], [-121.31806, 38.77076], [-121.31784, 38.77063], [-121.31776, 38.77046], [-121.31816, 38.77053]]]} | Open Access 1 | Roseville holding 14 | 24632 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.147 | Roseville holding 14 | ||
8972 | 8972 | 8971 | {"type": "Polygon", "coordinates": [[[-121.26094, 38.73866], [-121.26079, 38.73896], [-121.26056, 38.73889], [-121.26071, 38.73859], [-121.26094, 38.73866]]]} | Open Access 1 | Roseville holding 20 | 24639 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.187 | Roseville holding 20 | ||
8962 | 8962 | 8961 | {"type": "Polygon", "coordinates": [[[-121.27246, 38.72252], [-121.27227, 38.72252], [-121.2722, 38.72249], [-121.27218, 38.72246], [-121.27217, 38.72221], [-121.27246, 38.72221], [-121.27246, 38.72252]]]} | Open Access 1 | Roseville holding 17 | 24635 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.204 | Roseville holding 17 | ||
8976 | 8976 | 8975 | {"type": "Polygon", "coordinates": [[[-121.2719, 38.72246], [-121.27189, 38.72249], [-121.27183, 38.72252], [-121.27163, 38.72252], [-121.27162, 38.72235], [-121.27153, 38.72222], [-121.27189, 38.72221], [-121.2719, 38.72246]]]} | Open Access 1 | Roseville holding 24 | 24643 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.216 | Roseville holding 24 | ||
9597 | 9597 | 9596 | {"type": "Polygon", "coordinates": [[[-121.29644, 38.75001], [-121.29609, 38.75022], [-121.29585, 38.74981], [-121.29616, 38.74994], [-121.29644, 38.75001]]]} | Open Access 1 | Shirley Ferretti Park | 25415 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.216 | Shirley Ferretti Park | ||
8995 | 8995 | 8994 | {"type": "Polygon", "coordinates": [[[-121.31794, 38.76388], [-121.31789, 38.76403], [-121.31784, 38.76406], [-121.31764, 38.76402], [-121.31755, 38.76399], [-121.31753, 38.76397], [-121.31752, 38.76394], [-121.3176, 38.7635], [-121.31761, 38.76338], [-121.31777, 38.76339], [-121.31791, 38.76343], [-121.31778, 38.76341], [-121.31767, 38.76342], [-121.31762, 38.7638], [-121.31794, 38.76388]]]} | Open Access 1 | Roseville holding 5 | 24665 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.261 | Roseville holding 5 | ||
9358 | 9358 | 9357 | {"type": "Polygon", "coordinates": [[[-121.28958, 38.73527], [-121.2895, 38.73568], [-121.28937, 38.73609], [-121.28927, 38.73609], [-121.28931, 38.73527], [-121.28958, 38.73527]]]} | Open Access 1 | SAUGSTAD PARK | 25170 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.396 | SAUGSTAD PARK | ||
8955 | 8955 | 8954 | {"type": "Polygon", "coordinates": [[[-121.25834, 38.73133], [-121.25794, 38.73149], [-121.25793, 38.73087], [-121.25833, 38.73087], [-121.25834, 38.73133]]]} | Open Access 1 | Roseville holding 10 | 24628 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.513 | Roseville holding 10 | ||
8988 | 8988 | 8987 | {"type": "Polygon", "coordinates": [[[-121.24296, 38.71911], [-121.24239, 38.71886], [-121.2423, 38.71857], [-121.2423, 38.71852], [-121.24233, 38.71848], [-121.24273, 38.71815], [-121.24269, 38.71824], [-121.24268, 38.71838], [-121.24271, 38.71863], [-121.24281, 38.71889], [-121.24296, 38.71911]]]} | Open Access 1 | Roseville holding 37 | 24657 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.609 | Roseville holding 37 | ||
8982 | 8982 | 8981 | {"type": "Polygon", "coordinates": [[[-121.31243, 38.80095], [-121.3121, 38.80123], [-121.31177, 38.801], [-121.31176, 38.80094], [-121.31148, 38.80074], [-121.31191, 38.80058], [-121.31243, 38.80095]]]} | Open Access 1 | Roseville holding 30 | 24650 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 0.7 | Roseville holding 30 |
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]);