superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, MNG_AGENCY = 305 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Recreation/Parks District · 7 ✖
MNG_AGENCY 1
- Feather River Recreation and Park District · 7 ✖
ACCESS_TYP 1
- Open Access · 7 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1889 | 1889 | 1888 | {"type": "Polygon", "coordinates": [[[-121.5721, 39.51116], [-121.57193, 39.51195], [-121.57034, 39.51226], [-121.56889, 39.51275], [-121.56832, 39.51177], [-121.56887, 39.51152], [-121.56911, 39.51137], [-121.56929, 39.51122], [-121.56947, 39.51103], [-121.56958, 39.51087], [-121.56969, 39.51065], [-121.56977, 39.51042], [-121.5697, 39.51106], [-121.57, 39.51162], [-121.5703, 39.51159], [-121.5721, 39.51116]]]} | Open Access 1 | Bedrock Park | 15948 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 7.787 | Bedrock Park | ||
1890 | 1890 | 1889 | {"type": "Polygon", "coordinates": [[[-121.57235, 39.5091], [-121.57232, 39.51021], [-121.5721, 39.51116], [-121.5703, 39.51159], [-121.57, 39.51162], [-121.5697, 39.51107], [-121.56981, 39.51012], [-121.5711, 39.50968], [-121.57074, 39.50902], [-121.5718, 39.50875], [-121.57212, 39.5087], [-121.57235, 39.5091]]]} | Open Access 1 | Bedrock Skate and Bike Park | 15949 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 12.253 | Bedrock Skate and Bike Park | ||
6729 | 6729 | 6728 | {"type": "Polygon", "coordinates": [[[-121.54112, 39.50039], [-121.54006, 39.50042], [-121.54009, 39.49801], [-121.54107, 39.49799], [-121.54112, 39.50039]]]} | Open Access 1 | Martin Luther King Jr. Park | 21916 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 5.809 | Martin Luther King Jr. Park | ||
7070 | 7070 | 7069 | {"type": "Polygon", "coordinates": [[[-121.56479, 39.50685], [-121.56272, 39.50759], [-121.56253, 39.50729], [-121.56238, 39.5069], [-121.56237, 39.50689], [-121.56217, 39.50606], [-121.56211, 39.50606], [-121.56203, 39.50564], [-121.5629, 39.50536], [-121.56365, 39.50509], [-121.56378, 39.50507], [-121.56451, 39.50482], [-121.56449, 39.505], [-121.5645, 39.50577], [-121.56479, 39.50685]]]} | Open Access 1 | Mitchell Field | 22323 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 11.462 | Mitchell Field | ||
7339 | 7339 | 7338 | {"type": "Polygon", "coordinates": [[[-121.57867, 39.52781], [-121.5776, 39.52782], [-121.5776, 39.52519], [-121.57866, 39.5252], [-121.57867, 39.52781]]]} | Open Access 1 | Nelson Park | 22699 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 6.582 | Nelson Park | ||
11817 | 11817 | 11816 | {"type": "Polygon", "coordinates": [[[-121.57861, 39.49796], [-121.57853, 39.50175], [-121.57834, 39.50322], [-121.57815, 39.50405], [-121.57796, 39.50474], [-121.57795, 39.50494], [-121.57799, 39.50511], [-121.57795, 39.50524], [-121.5779, 39.5057], [-121.57776, 39.50648], [-121.57774, 39.50738], [-121.57738, 39.50848], [-121.57706, 39.50917], [-121.57684, 39.50996], [-121.57635, 39.51038], [-121.57574, 39.51064], [-121.57462, 39.51089], [-121.57417, 39.51078], [-121.57293, 39.51125], [-121.57282, 39.51126], [-121.57286, 39.51091], [-121.57336, 39.50949], [-121.57364, 39.50904], [-121.57397, 39.50861], [-121.57384, 39.50836], [-121.57402, 39.50797], [-121.57534, 39.50747], [-121.57519, 39.50722], [-121.57431, 39.50753], [-121.57381, 39.50733], [-121.57379, 39.50664], [-121.57413, 39.50494], [-121.57528, 39.49966], [-121.5754, 39.49901], [-121.57552, 39.49814], [-121.5759, 39.49816], [-121.57618, 39.4981], [-121.57761, 39.49798], [-121.57861, 39.49796]]]} | Open Access 1 | Riverbend Park | http://frrpd.com/parks-facilities/parks/ | 28455 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 108.206 | Riverbend Park | |
12616 | 12616 | 12615 | {"type": "Polygon", "coordinates": [[[-121.54516, 39.43302], [-121.54378, 39.43304], [-121.54377, 39.43221], [-121.54515, 39.4322], [-121.54516, 39.43302]]]} | Open Access 1 | Palermo Park | 31310 | 2222 | Feather River Recreation and Park District 305 | Special District 4 | Recreation/Parks District 4 | http://www.frrpd.com/ | Special District 4 | 2.685 | Palermo 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]);