superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where MNG_AGENCY = 10 and MNG_AG_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10816 | 10816 | 10815 | {"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.12973, 37.47288], [-121.12973, 37.47288], [-121.12916, 37.47211], [-121.1298, 37.47182], [-121.12992, 37.4719]]]]} | Open Access 1 | Veterans Memorial Park | 27031 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.982 | Veterans Memorial Park | ||
10207 | 10207 | 10206 | {"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 | T.W. Patterson Sports Complex | 26158 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 29.663 | T.W. Patterson Sports Complex | ||
4200 | 4200 | 4199 | {"type": "Polygon", "coordinates": [[[-121.12622, 37.47895], [-121.12464, 37.47968], [-121.12384, 37.47861], [-121.12544, 37.47788], [-121.12622, 37.47895]]]} | Open Access 1 | Felipe Garza Park | 18867 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 5.539 | Felipe Garza Park | ||
10081 | 10081 | 10080 | {"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 | Sunflower Park | 25993 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.598 | Sunflower Park | ||
3060 | 3060 | 3059 | {"type": "Polygon", "coordinates": [[[-121.12982, 37.47991], [-121.12928, 37.48015], [-121.12914, 37.47996], [-121.12969, 37.4797], [-121.12982, 37.47991]]]} | Open Access 1 | El Pescadero Park | 18527 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.351 | El Pescadero Park | ||
7403 | 7403 | 7402 | {"type": "Polygon", "coordinates": [[[-121.13122, 37.47881], [-121.13121, 37.47884], [-121.13118, 37.47888], [-121.13095, 37.47898], [-121.13088, 37.47899], [-121.13066, 37.47909], [-121.1306, 37.47915], [-121.12982, 37.47951], [-121.12975, 37.4795], [-121.1297, 37.47945], [-121.1297, 37.47941], [-121.12972, 37.47938], [-121.13004, 37.47924], [-121.13012, 37.47922], [-121.13033, 37.47912], [-121.1304, 37.47907], [-121.13109, 37.47875], [-121.13117, 37.47875], [-121.13122, 37.47881]]]} | Open Access 1 | Noble Park | 22779 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.565 | Noble Park | ||
3539 | 3539 | 3538 | {"type": "Polygon", "coordinates": [[[-121.13139, 37.46901], [-121.13089, 37.46894], [-121.13099, 37.46845], [-121.13139, 37.46901], [-121.13139, 37.46901]]]} | Open Access 1 | Del Puerto Park | 18048 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.306 | Del Puerto Park | ||
4619 | 4619 | 4618 | {"type": "Polygon", "coordinates": [[[-121.14269, 37.47264], [-121.14187, 37.47299], [-121.14169, 37.47269], [-121.14164, 37.47256], [-121.1416, 37.47241], [-121.14166, 37.47235], [-121.14202, 37.47228], [-121.14236, 37.47215], [-121.14269, 37.47264]]]} | Open Access 1 | Golden Amber Park | 19358 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.294 | Golden Amber Park | ||
14423 | 14423 | 14422 | {"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 | City of Patterson Community Complex | 33264 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 6.025 | City of Patterson Community Complex | ||
9780 | 9780 | 9779 | {"type": "Polygon", "coordinates": [[[-121.14328, 37.47506], [-121.14327, 37.47581], [-121.14098, 37.47581], [-121.14098, 37.47579], [-121.14109, 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 | Sorensen Park | 25626 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.85 | Sorensen Park | ||
8873 | 8873 | 8872 | {"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 | Tilton Park | 26367 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 3.516 | Tilton Park | ||
6869 | 6869 | 6868 | {"type": "Polygon", "coordinates": [[[-121.14493, 37.46191], [-121.14464, 37.46191], [-121.14412, 37.46212], [-121.144, 37.46199], [-121.14368, 37.46171], [-121.14316, 37.46139], [-121.14344, 37.46118], [-121.14351, 37.4612], [-121.14357, 37.4612], [-121.14365, 37.46116], [-121.1449, 37.46116], [-121.14493, 37.46191]]]} | Open Access 1 | Meadow Rue Park | 22078 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.784 | Meadow Rue Park | ||
7353 | 7353 | 7352 | {"type": "Polygon", "coordinates": [[[-121.14527, 37.47444], [-121.14472, 37.47469], [-121.14451, 37.47482], [-121.14451, 37.47484], [-121.14457, 37.47488], [-121.14435, 37.47509], [-121.14375, 37.47469], [-121.14375, 37.47462], [-121.14395, 37.47443], [-121.14407, 37.47433], [-121.14432, 37.47419], [-121.14487, 37.47396], [-121.14497, 37.47398], [-121.14527, 37.47444]]]} | Open Access 1 | Newcastle Park | 22719 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.055 | Newcastle Park | ||
14385 | 14385 | 14384 | {"type": "Polygon", "coordinates": [[[-121.14539, 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.14539, 37.46398]]]} | Open Access 1 | Unknown Park - Patterson, City of | 33386 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.121 | |||
1672 | 1672 | 1671 | {"type": "Polygon", "coordinates": [[[-121.1459, 37.47051], [-121.14458, 37.47106], [-121.14385, 37.46995], [-121.14391, 37.4699], [-121.1459, 37.47051]]]} | Open Access 1 | Autumn Royal Park | 15718 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 2.417 | Autumn Royal Park | ||
1690 | 1690 | 1689 | {"type": "Polygon", "coordinates": [[[-121.14743, 37.47816], [-121.14709, 37.47823], [-121.14693, 37.47771], [-121.14719, 37.47764], [-121.14726, 37.47767], [-121.14743, 37.47816]]]} | Open Access 1 | Aurora Park | 15710 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.447 | Aurora Park | ||
7284 | 7284 | 7283 | {"type": "Polygon", "coordinates": [[[-121.149, 37.4605], [-121.149, 37.4608], [-121.14896, 37.46084], [-121.14742, 37.46083], [-121.14725, 37.46078], [-121.14714, 37.46081], [-121.1471, 37.46088], [-121.14639, 37.46087], [-121.14636, 37.46073], [-121.14638, 37.46068], [-121.14671, 37.46044], [-121.1471, 37.46005], [-121.14716, 37.46004], [-121.14729, 37.46008], [-121.14771, 37.46025], [-121.148, 37.46034], [-121.14847, 37.46043], [-121.14895, 37.46046], [-121.149, 37.4605]]]} | Open Access 1 | Mustang Clover Park | 22616 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 3.252 | Mustang Clover Park | ||
8018 | 8018 | 8017 | {"type": "Polygon", "coordinates": [[[-121.14932, 37.45758], [-121.14932, 37.45788], [-121.14927, 37.45789], [-121.14921, 37.45785], [-121.14914, 37.45783], [-121.14898, 37.45788], [-121.14862, 37.45787], [-121.14863, 37.45757], [-121.14932, 37.45758]]]} | Open Access 1 | Patterson Gardens Parks | 23518 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 0.496 | Patterson Gardens Parks | ||
10084 | 10084 | 10083 | {"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 | Sunglow Park | 25996 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.956 | Sunglow Park | ||
2062 | 2062 | 2061 | {"type": "Polygon", "coordinates": [[[-121.14984, 37.4662], [-121.14978, 37.46625], [-121.14941, 37.46624], [-121.14942, 37.46456], [-121.1496, 37.46457], [-121.14966, 37.46461], [-121.14965, 37.46506], [-121.14967, 37.46526], [-121.1497, 37.46547], [-121.14981, 37.46593], [-121.14984, 37.4662]]]} | Open Access 1 | Blenheim Park | 16159 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1.244 | Blenheim 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]);