superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 435 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10834 | 10834 | 10833 | {"type": "Polygon", "coordinates": [[[-121.60752, 39.13829], [-121.60735, 39.13835], [-121.60706, 39.13815], [-121.60737, 39.13805], [-121.60752, 39.13829]]]} | Open Access 1 | Veterans Park | 27052 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.169 | Veterans Park | ||
2116 | 2116 | 2115 | {"type": "Polygon", "coordinates": [[[-121.61015, 39.10206], [-121.61014, 39.10211], [-121.60953, 39.10226], [-121.60946, 39.10224], [-121.60928, 39.10179], [-121.60998, 39.10162], [-121.61015, 39.10206]]]} | Open Access 1 | Bogue Park | 16231 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.88 | Bogue Park | ||
9552 | 9552 | 9551 | {"type": "Polygon", "coordinates": [[[-121.61105, 39.09477], [-121.61097, 39.09481], [-121.611, 39.09488], [-121.61101, 39.09497], [-121.61096, 39.0951], [-121.61086, 39.09518], [-121.61077, 39.09522], [-121.60998, 39.09523], [-121.60865, 39.09535], [-121.60852, 39.09439], [-121.60914, 39.09434], [-121.61052, 39.09399], [-121.61105, 39.09477]]]} | Open Access 1 | Shanghai Garden Park | 25357 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 5.811 | Shanghai Garden Park | ||
4526 | 4526 | 4525 | {"type": "Polygon", "coordinates": [[[-121.6119, 39.13282], [-121.61189, 39.13285], [-121.61184, 39.13289], [-121.61107, 39.133], [-121.61105, 39.13299], [-121.61082, 39.13305], [-121.61068, 39.13312], [-121.61008, 39.13353], [-121.60968, 39.13273], [-121.60943, 39.13272], [-121.60934, 39.13202], [-121.60979, 39.1316], [-121.61069, 39.13156], [-121.61082, 39.13162], [-121.61095, 39.13208], [-121.61168, 39.13197], [-121.6119, 39.13282]]]} | Open Access 1 | Gauche Aquatics Park | 19242 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 7.325 | Gauche Aquatics Park | ||
9835 | 9835 | 9834 | {"type": "Polygon", "coordinates": [[[-121.61228, 39.12647], [-121.61174, 39.12669], [-121.61154, 39.1264], [-121.61196, 39.12598], [-121.61228, 39.12647]]]} | Open Access 1 | Southside Park | 25700 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.638 | Southside Park | ||
10422 | 10422 | 10421 | {"type": "Polygon", "coordinates": [[[-121.61371, 39.13268], [-121.61371, 39.13273], [-121.61366, 39.13277], [-121.61316, 39.13292], [-121.61308, 39.13291], [-121.61289, 39.13254], [-121.61289, 39.13248], [-121.61294, 39.13245], [-121.61344, 39.1323], [-121.61351, 39.13231], [-121.61355, 39.13234], [-121.61371, 39.13268]]]} | Open Access 1 | Town Square | 26491 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.809 | Town Square | ||
8260 | 8260 | 8259 | {"type": "Polygon", "coordinates": [[[-121.61593, 39.13589], [-121.61565, 39.13588], [-121.61555, 39.13567], [-121.61591, 39.13562], [-121.61593, 39.13589]]]} | Open Access 1 | Plumas Tower | 23816 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.187 | Plumas Tower | ||
2040 | 2040 | 2039 | {"type": "Polygon", "coordinates": [[[-121.61651, 39.10747], [-121.61644, 39.10752], [-121.61438, 39.10802], [-121.61381, 39.10659], [-121.61375, 39.1059], [-121.61622, 39.10531], [-121.61651, 39.10739], [-121.61651, 39.10747]]]} | Open Access 1 | Blackburn-Talley Sports Complex | 16142 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 12.757 | Blackburn-Talley Sports Complex | ||
6611 | 6611 | 6610 | {"type": "Polygon", "coordinates": [[[-121.62254, 39.1424], [-121.62255, 39.14244], [-121.62251, 39.14352], [-121.6225, 39.14356], [-121.62246, 39.14358], [-121.62221, 39.14359], [-121.62217, 39.14357], [-121.62214, 39.14352], [-121.62219, 39.14242], [-121.62224, 39.14238], [-121.6225, 39.14238], [-121.62254, 39.1424]]]} | Open Access 1 | Maple Park | 21780 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1.047 | Maple Park | ||
7190 | 7190 | 7189 | {"type": "Polygon", "coordinates": [[[-121.62418, 39.13285], [-121.62349, 39.13287], [-121.62346, 39.13284], [-121.62345, 39.13259], [-121.62347, 39.13257], [-121.62384, 39.13244], [-121.62415, 39.13236], [-121.62418, 39.13285]]]} | Open Access 1 | Moore Park | 22461 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.686 | Moore Park | ||
5158 | 5158 | 5157 | {"type": "Polygon", "coordinates": [[[-121.62492, 39.11528], [-121.62489, 39.11654], [-121.62262, 39.11652], [-121.62262, 39.11635], [-121.62267, 39.11633], [-121.6227, 39.11526], [-121.62492, 39.11528]]]} | Open Access 1 | Hillcrest Park | 19971 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 6.668 | Hillcrest Park | ||
8016 | 8016 | 8015 | {"type": "Polygon", "coordinates": [[[-121.62558, 39.15171], [-121.6253, 39.15171], [-121.62525, 39.15169], [-121.62523, 39.15165], [-121.62523, 39.15141], [-121.62558, 39.15141], [-121.62558, 39.15171]]]} | Open Access 1 | Patriot Park | 23516 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.251 | Patriot Park | ||
2985 | 2985 | 2984 | {"type": "Polygon", "coordinates": [[[-121.6258, 39.1439], [-121.62555, 39.1439], [-121.62555, 39.14372], [-121.62559, 39.14374], [-121.6258, 39.1439]]]} | Open Access 1 | Clark-Ainsley Mini-Park | 17385 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 0.056 | Clark-Ainsley Mini-Park | ||
7486 | 7486 | 7485 | {"type": "Polygon", "coordinates": [[[-121.62692, 39.16361], [-121.62551, 39.16361], [-121.62552, 39.16227], [-121.6269, 39.16227], [-121.62693, 39.16257], [-121.62692, 39.16361]]]} | Open Access 1 | Northridge Park | 22888 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 4.483 | Northridge Park | ||
6313 | 6313 | 6312 | {"type": "Polygon", "coordinates": [[[-121.62793, 39.13357], [-121.62737, 39.13356], [-121.6273, 39.13234], [-121.62787, 39.13235], [-121.62793, 39.13357]]]} | Open Access 1 | Lloyd Park | 21389 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1.631 | Lloyd Park | ||
5755 | 5755 | 5754 | {"type": "Polygon", "coordinates": [[[-121.63011, 39.1475], [-121.62898, 39.1475], [-121.62898, 39.14596], [-121.6293, 39.14596], [-121.62948, 39.14591], [-121.6301, 39.14591], [-121.63011, 39.1475]]]} | Open Access 1 | Kingwood Park | 20673 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 4.208 | Kingwood Park | ||
9139 | 9139 | 9138 | {"type": "Polygon", "coordinates": [[[-121.63287, 39.13619], [-121.63284, 39.13732], [-121.63264, 39.13733], [-121.63262, 39.13799], [-121.63027, 39.13713], [-121.63023, 39.13614], [-121.63287, 39.13619]]]} | Open Access 1 | Sam Brannan Park | 24815 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 8.515 | Sam Brannan Park | ||
4553 | 4553 | 4552 | {"type": "Polygon", "coordinates": [[[-121.63325, 39.13444], [-121.63323, 39.1362], [-121.63228, 39.13617], [-121.63229, 39.13444], [-121.63325, 39.13444]]]} | Open Access 1 | Geweke Field | 19282 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 3.951 | Geweke Field | ||
4747 | 4747 | 4746 | {"type": "Polygon", "coordinates": [[[-121.64098, 39.15332], [-121.64098, 39.15415], [-121.64093, 39.15433], [-121.64076, 39.15472], [-121.64073, 39.15486], [-121.64072, 39.15502], [-121.6407, 39.15506], [-121.64065, 39.15507], [-121.64037, 39.15505], [-121.64019, 39.15502], [-121.6398, 39.15491], [-121.63955, 39.15487], [-121.63954, 39.15332], [-121.64098, 39.15332]]]} | Open Access 1 | Greenwood Park | 19490 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 5.412 | Greenwood Park | ||
5218 | 5218 | 5217 | {"type": "Polygon", "coordinates": [[[-121.6428, 39.11996], [-121.64279, 39.12147], [-121.64156, 39.12147], [-121.64156, 39.12051], [-121.64169, 39.12051], [-121.64185, 39.12048], [-121.64206, 39.12039], [-121.64219, 39.1203], [-121.64267, 39.11987], [-121.6428, 39.11996]]]} | Open Access 1 | Holly Tree Park | 20046 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 3.561 | Holly Tree 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]);