superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 435
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
4889 | 4889 | 4888 | {"type": "Polygon", "coordinates": [[[-121.64956, 39.10344], [-121.64952, 39.10348], [-121.64949, 39.10348], [-121.64721, 39.10349], [-121.64717, 39.10348], [-121.64714, 39.10343], [-121.64712, 39.10229], [-121.64715, 39.10226], [-121.64938, 39.10226], [-121.64942, 39.1023], [-121.64945, 39.10304], [-121.64956, 39.10344]]]} | Open Access 1 | Happy Park | 19657 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 6.765 | Happy 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
8623 | 8623 | 8622 | {"type": "Polygon", "coordinates": [[[-121.64413, 39.16632], [-121.64419, 39.16629], [-121.64451, 39.16629], [-121.64484, 39.16633], [-121.64514, 39.16644], [-121.64532, 39.16654], [-121.64547, 39.16667], [-121.64559, 39.16681], [-121.64568, 39.16697], [-121.64574, 39.16714], [-121.64576, 39.16731], [-121.64574, 39.16749], [-121.64568, 39.16765], [-121.64559, 39.16781], [-121.64546, 39.16795], [-121.64531, 39.16808], [-121.64513, 39.16818], [-121.64493, 39.16826], [-121.64461, 39.16832], [-121.64417, 39.16833], [-121.64412, 39.16832], [-121.64406, 39.16826], [-121.64406, 39.16807], [-121.6441, 39.16805], [-121.6441, 39.16788], [-121.64412, 39.16782], [-121.64417, 39.16776], [-121.64426, 39.16771], [-121.64435, 39.16764], [-121.6444, 39.16755], [-121.64442, 39.16746], [-121.64438, 39.16731], [-121.64431, 39.16723], [-121.64417, 39.16712], [-121.64411, 39.16699], [-121.6441, 39.16637], [-121.64413, 39.16632]]]} | Open Access 1 | Regency Park | 24272 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 6.256 | Regency 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 | ||
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 | ||
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 |
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]);