units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where COUNTY = 47 and MNG_AGENCY = 435
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 20
- Local Recreation Area 2
- None 1
MNG_AG_TYP 1
- City Agency 23
MNG_AGENCY 1
- Yuba City, City of · 23 ✖
ACCESS_TYP 1
- Open Access 23
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1871 | 1871 | 1870 | {"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 | 16020 | Southside Park | 25700 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.639 | Southside Park | 0 | Local Park 2 | 4 | |
1899 | 1899 | 1898 | {"type": "Polygon", "coordinates": [[[-121.64406, 39.16807], [-121.6441, 39.16806], [-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.64442, 39.16741], [-121.64438, 39.16731], [-121.64431, 39.16723], [-121.64417, 39.16712], [-121.64411, 39.16699], [-121.6441, 39.16637], [-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.16748], [-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]]]} | Open Access 1 | 16231 | Regency Park | 24272 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 6.254 | Regency Park | 0 | Local Park 2 | 4 | |
2106 | 2106 | 2105 | {"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 | 15884 | Patriot Park | 23516 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.251 | Patriot Park | 0 | Local Park 2 | 4 | |
2108 | 2108 | 2107 | {"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 | 15892 | Sam Brannan Park | 24815 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 8.514 | Sam Brannan Park | 0 | Local Park 2 | 4 | |
2110 | 2110 | 2109 | {"type": "Polygon", "coordinates": [[[-121.61622, 39.10531], [-121.61651, 39.10739], [-121.61651, 39.10747], [-121.61644, 39.10752], [-121.61438, 39.10802], [-121.61381, 39.10659], [-121.61375, 39.1059], [-121.61622, 39.10531]]]} | Open Access 1 | 15897 | Blackburn-Talley Sports Complex | 16142 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 12.758 | Blackburn-Talley Sports Complex | 0 | Local Recreation Area 3 | 4 | |
2112 | 2112 | 2111 | {"type": "Polygon", "coordinates": [[[-121.60998, 39.10162], [-121.61015, 39.10206], [-121.61014, 39.10211], [-121.60953, 39.10226], [-121.60946, 39.10224], [-121.60928, 39.10179], [-121.60998, 39.10162]]]} | Open Access 1 | 15903 | Bogue Park | 16231 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.88 | Bogue Park | 0 | Local Park 2 | 4 | |
2125 | 2125 | 2124 | {"type": "Polygon", "coordinates": [[[-121.62492, 39.11528], [-121.62489, 39.11654], [-121.62262, 39.11652], [-121.62262, 39.11635], [-121.62267, 39.11634], [-121.6227, 39.11526], [-121.62492, 39.11528]]]} | Open Access 1 | 15937 | Hillcrest Park | 19971 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 6.668 | Hillcrest Park | 0 | Local Park 2 | 4 | |
2129 | 2129 | 2128 | {"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 | 15955 | Lloyd Park | 21389 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 1.632 | Lloyd Park | 0 | Local Park 2 | 4 | |
2145 | 2145 | 2144 | {"type": "Polygon", "coordinates": [[[-121.61105, 39.09477], [-121.61096, 39.09481], [-121.611, 39.09488], [-121.61101, 39.09497], [-121.611, 39.09502], [-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.60913, 39.09434], [-121.61052, 39.09399], [-121.61105, 39.09477]]]} | Open Access 1 | 16009 | Shanghai Garden Park | 25357 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 5.812 | Shanghai Garden Park | 0 | Local Park 2 | 4 | |
8832 | 8832 | 8831 | {"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 | 16040 | Clark-Ainsley Mini-Park | 17385 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.056 | Clark-Ainsley Mini-Park | 0 | Local Park 2 | 4 | |
9044 | 9044 | 9043 | {"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 | 15879 | Northridge Park | 22888 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 4.484 | Northridge Park | 0 | Local Park 2 | 4 | |
9477 | 9477 | 9476 | {"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 | 15888 | Kingwood Park | 20673 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 4.209 | Kingwood Park | 0 | Local Park 2 | 4 | |
9480 | 9480 | 9479 | {"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 | 15874 | Greenwood Park | 19490 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 5.412 | Greenwood Park | 0 | Local Park 2 | 4 | |
9486 | 9486 | 9485 | {"type": "Polygon", "coordinates": [[[-121.64715, 39.10226], [-121.64938, 39.10226], [-121.64942, 39.1023], [-121.64945, 39.10304], [-121.64956, 39.10344], [-121.64952, 39.10348], [-121.64949, 39.10348], [-121.64721, 39.10349], [-121.64717, 39.10348], [-121.64714, 39.10344], [-121.64711, 39.10232], [-121.64712, 39.10229], [-121.64715, 39.10226]]]} | Open Access 1 | 15915 | Happy Park | 19657 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 6.778 | Happy Park | 0 | Local Park 2 | 4 | |
9518 | 9518 | 9517 | {"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 | 15973 | Moore Park | 22461 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.687 | Moore Park | 0 | Local Park 2 | 4 | |
9531 | 9531 | 9530 | {"type": "Polygon", "coordinates": [[[-121.62224, 39.14238], [-121.6225, 39.14238], [-121.62254, 39.1424], [-121.62255, 39.14244], [-121.62252, 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]]]} | Open Access 1 | 15993 | Maple Park | 21780 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 1.047 | Maple Park | 0 | Local Park 2 | 4 | |
9552 | 9552 | 9551 | {"type": "Polygon", "coordinates": [[[-121.61344, 39.1323], [-121.61351, 39.13231], [-121.61355, 39.13234], [-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]]]} | Open Access 1 | 16087 | Town Square | 26491 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.809 | Town Square | 0 | Local Park 2 | 4 | |
9559 | 9559 | 9558 | {"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 | 16063 | Plumas Tower | 23816 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.188 | Plumas Tower | None 794 | |||
9579 | 9579 | 9578 | {"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 | 16109 | Geweke Field | 19282 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 3.951 | Geweke Field | 0 | Local Recreation Area 3 | 4 | |
9595 | 9595 | 9594 | {"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 | 16136 | Veterans Park | 27052 | 1386 | Yuba City, City of 441 | City 2 | City Agency 2 | http://www.yubacity.net/city-services/parks-and-recreation.html | City 2 | 1386 | Yuba City, City of 435 | City 2 | City Agency 2 | Sutter 47 | 0.169 | Veterans Park | 0 | Local Park 2 | 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]);