superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 10 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1468 | 1468 | 1467 | {"type": "Polygon", "coordinates": [[[-121.1509, 37.46277], [-121.1508, 37.46292], [-121.14988, 37.46396], [-121.14979, 37.46411], [-121.14974, 37.46424], [-121.14971, 37.46426], [-121.14957, 37.46426], [-121.14958, 37.46277], [-121.1509, 37.46277]]]} | Open Access 1 | Amaryllis Park | 15440 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.566 | Amaryllis Park | ||
1526 | 1526 | 1525 | {"type": "Polygon", "coordinates": [[[-121.15135, 37.46576], [-121.15132, 37.46714], [-121.15127, 37.46718], [-121.15088, 37.46718], [-121.15078, 37.46715], [-121.15072, 37.46715], [-121.15063, 37.46719], [-121.1506, 37.46725], [-121.15028, 37.46725], [-121.15029, 37.46575], [-121.15059, 37.46575], [-121.15063, 37.46573], [-121.15072, 37.46575], [-121.15088, 37.46571], [-121.1513, 37.46572], [-121.15135, 37.46576]]]} | Open Access 1 | Aprigold Park | 15545 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 3.755 | Aprigold Park | ||
4270 | 4270 | 4269 | {"type": "Polygon", "coordinates": [[[-121.15166, 37.46918], [-121.15088, 37.47082], [-121.15013, 37.4706], [-121.15013, 37.47015], [-121.15025, 37.47014], [-121.15026, 37.4691], [-121.15141, 37.46911], [-121.15166, 37.46918]]]} | Open Access 1 | Floragold Park | 18957 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 4.276 | Floragold Park | ||
1471 | 1471 | 1470 | {"type": "Polygon", "coordinates": [[[-121.15169, 37.47476], [-121.15143, 37.47478], [-121.15101, 37.47485], [-121.15025, 37.47485], [-121.15026, 37.4736], [-121.15131, 37.4736], [-121.15156, 37.47359], [-121.15169, 37.47476]]]} | Open Access 1 | Ambercot Park | 15443 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 4.088 | Ambercot Park | ||
4618 | 4618 | 4617 | {"type": "Polygon", "coordinates": [[[-121.1527, 37.47726], [-121.15269, 37.47821], [-121.15093, 37.47821], [-121.15093, 37.47775], [-121.15095, 37.47748], [-121.15165, 37.47732], [-121.15206, 37.47726], [-121.1527, 37.47726]]]} | Open Access 1 | Goldbar Park | 19357 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 3.779 | Goldbar Park | ||
8019 | 8019 | 8018 | {"type": "Polygon", "coordinates": [[[-121.15526, 37.46194], [-121.15507, 37.46228], [-121.15456, 37.46207], [-121.15464, 37.46189], [-121.15464, 37.46185], [-121.15461, 37.46182], [-121.15454, 37.46182], [-121.15434, 37.46192], [-121.15427, 37.46191], [-121.15422, 37.46189], [-121.15457, 37.46164], [-121.1549, 37.4618], [-121.15526, 37.46194]]]} | Open Access 1 | Patterson holding 1 | 23519 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.674 | Patterson holding 1 | ||
3784 | 3784 | 3783 | {"type": "Polygon", "coordinates": [[[-121.15626, 37.46621], [-121.15624, 37.46686], [-121.1555, 37.46686], [-121.15551, 37.4662], [-121.15626, 37.46621]]]} | Open Access 1 | Early Gold Park | 18356 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.191 | Early Gold Park | ||
11395 | 11395 | 11394 | {"type": "Polygon", "coordinates": [[[-121.15628, 37.45985], [-121.15627, 37.46111], [-121.15586, 37.46102], [-121.15548, 37.46088], [-121.15546, 37.46084], [-121.15551, 37.4606], [-121.15552, 37.45989], [-121.15556, 37.45985], [-121.15628, 37.45985]]]} | Open Access 1 | Woodland Star Park | 27726 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.171 | Woodland Star Park | ||
8965 | 8965 | 8964 | {"type": "Polygon", "coordinates": [[[-121.15657, 37.4739], [-121.15593, 37.47409], [-121.15572, 37.47363], [-121.15597, 37.47356], [-121.15644, 37.47349], [-121.15657, 37.4739]]]} | Open Access 1 | Tri Gem Park | 26528 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.807 | Tri Gem Park | ||
2693 | 2693 | 2692 | {"type": "Polygon", "coordinates": [[[-121.15669, 37.46915], [-121.15657, 37.46931], [-121.15657, 37.46937], [-121.1566, 37.46943], [-121.15668, 37.46948], [-121.15648, 37.46951], [-121.15606, 37.46951], [-121.15586, 37.46948], [-121.15657, 37.46901], [-121.15669, 37.46906], [-121.15669, 37.46915]]]} | Open Access 1 | Castlebrite Park | 16958 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.52 | Castlebrite Park | ||
10083 | 10083 | 10082 | {"type": "Polygon", "coordinates": [[[-121.15761, 37.47688], [-121.15739, 37.47687], [-121.15635, 37.47688], [-121.15608, 37.47685], [-121.15604, 37.47677], [-121.15606, 37.4767], [-121.1572, 37.47637], [-121.15749, 37.47631], [-121.15759, 37.47634], [-121.15762, 37.47645], [-121.15763, 37.47666], [-121.15761, 37.47688]]]} | Open Access 1 | Sungiant Park | 25995 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.472 | Sungiant Park | ||
8953 | 8953 | 8952 | {"type": "Polygon", "coordinates": [[[-121.15853, 37.47069], [-121.1585, 37.47121], [-121.15777, 37.47121], [-121.15777, 37.47066], [-121.15847, 37.47066], [-121.15853, 37.47069]]]} | Open Access 1 | Rosette Park | 24626 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.001 | Rosette 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]);