units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 10 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
- City Agency 12
MNG_AGENCY 1
- Patterson, City of · 12 ✖
ACCESS_TYP 1
- Open Access 12
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA ▼ | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77 | 77 | 76 | {"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 | 200 | Rosette Park | 24626 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.001 | Rosette Park | 0 | Local Park 2 | 4 | |
5860 | 5860 | 5859 | {"type": "Polygon", "coordinates": [[[-121.14328, 37.47506], [-121.14327, 37.47581], [-121.14098, 37.47581], [-121.14098, 37.47579], [-121.1411, 37.47572], [-121.14137, 37.47562], [-121.1426, 37.47542], [-121.1428, 37.47536], [-121.14307, 37.47524], [-121.14328, 37.47506]]]} | Open Access 1 | 205 | Sorensen Park | 25626 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.85 | Sorensen Park | 0 | Local Park 2 | 4 | |
81 | 81 | 80 | {"type": "Polygon", "coordinates": [[[-121.12814, 37.46297], [-121.12754, 37.4631], [-121.1266, 37.46244], [-121.12814, 37.46244], [-121.12811, 37.4628], [-121.12812, 37.46289], [-121.12814, 37.46297]]]} | Open Access 1 | 213 | Sunflower Park | 25993 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.599 | Sunflower Park | 0 | Local Park 2 | 4 | |
5844 | 5844 | 5843 | {"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 | 216 | Sungiant Park | 25995 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.472 | Sungiant Park | 0 | Local Park 2 | 4 | |
84 | 84 | 83 | {"type": "Polygon", "coordinates": [[[-121.14983, 37.46874], [-121.14983, 37.46946], [-121.14809, 37.46893], [-121.1481, 37.46872], [-121.14983, 37.46874]]]} | Open Access 1 | 220 | Sunglow Park | 25996 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.956 | Sunglow Park | 0 | Local Park 2 | 4 | |
86 | 86 | 85 | {"type": "MultiPolygon", "coordinates": [[[[-121.14464, 37.45253], [-121.14452, 37.4562], [-121.14113, 37.45496], [-121.14118, 37.45251], [-121.14464, 37.45253]]], [[[-121.14422, 37.45628], [-121.14118, 37.45628], [-121.1412, 37.45516], [-121.1412, 37.45516], [-121.14422, 37.45628]]]]} | Open Access 1 | 225 | T.W. Patterson Sports Complex | 26158 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 29.665 | T.W. Patterson Sports Complex | 0 | Local Recreation Area 3 | 4 | |
90 | 90 | 89 | {"type": "Polygon", "coordinates": [[[-121.14404, 37.46746], [-121.14353, 37.46854], [-121.14345, 37.46857], [-121.14247, 37.46832], [-121.14315, 37.46691], [-121.14328, 37.46704], [-121.14343, 37.46715], [-121.1437, 37.46729], [-121.14401, 37.4674], [-121.14404, 37.46746]]]} | Open Access 1 | 232 | Tilton Park | 26367 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 3.517 | Tilton Park | 0 | Local Park 2 | 4 | |
93 | 93 | 92 | {"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 | 239 | Tri Gem Park | 26528 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.807 | Tri Gem Park | 0 | Local Park 2 | 4 | |
71 | 71 | 70 | {"type": "MultiPolygon", "coordinates": [[[[-121.12968, 37.47162], [-121.12901, 37.47193], [-121.12846, 37.47115], [-121.12967, 37.4715], [-121.12968, 37.47162]]], [[[-121.12992, 37.4719], [-121.12992, 37.4719], [-121.12973, 37.47288], [-121.12916, 37.47211], [-121.1298, 37.47182], [-121.12992, 37.4719]]]]} | Open Access 1 | 209 | Veterans Memorial Park | 27031 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.982 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
94 | 94 | 93 | {"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 | 244 | Woodland Star Park | 27726 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 2.171 | Woodland Star Park | 0 | Local Park 2 | 4 | |
10814 | 10814 | 10813 | {"type": "Polygon", "coordinates": [[[-121.14316, 37.4669], [-121.14248, 37.46832], [-121.1421, 37.46825], [-121.14168, 37.46824], [-121.14156, 37.4682], [-121.14111, 37.4682], [-121.14112, 37.46691], [-121.14114, 37.46687], [-121.14258, 37.46679], [-121.14298, 37.46672], [-121.14304, 37.46674], [-121.14316, 37.4669]]]} | Open Access 1 | 48545 | City of Patterson Community Complex | 33264 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 6.025 | City of Patterson Community Complex | 0 | Local Recreation Area 3 | 4 | |
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-121.1454, 37.46398], [-121.14539, 37.46422], [-121.14474, 37.46421], [-121.14469, 37.46417], [-121.14469, 37.46347], [-121.1453, 37.46348], [-121.14529, 37.46374], [-121.14524, 37.46379], [-121.14522, 37.46387], [-121.14527, 37.46394], [-121.14534, 37.46398], [-121.1454, 37.46398]]]} | Open Access 1 | 48546 | Unknown Park - Patterson, City of | 33386 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.121 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);