units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
19 rows where ACCESS_TYP = 1 and UNIT_NAME = "Centennial Park"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, DES_TP
MNG_AG_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
407 | 407 | 406 | {"type": "Polygon", "coordinates": [[[-119.35321, 36.21913], [-119.3532, 36.22023], [-119.35146, 36.22027], [-119.351, 36.21817], [-119.35206, 36.21818], [-119.35301, 36.21816], [-119.3532, 36.21824], [-119.35321, 36.21913]]]} | Open Access 1 | 1252 | Centennial Park | 17030 | 1398 | Tulare, City of 163 | City 2 | City Agency 2 | http://www.ci.tulare.ca.us/local_government/departments/rec_parks_library/parks.htm | City 2 | 1398 | Tulare, City of 159 | City 2 | City Agency 2 | Tulare 29 | 10.109 | Centennial Park | 0 | Local Park 2 | 4 | |
1445 | 1445 | 1444 | {"type": "MultiPolygon", "coordinates": [[[[-121.96952, 38.368], [-121.96865, 38.36697], [-121.96865, 38.36697], [-121.96936, 38.36672], [-121.96952, 38.36784], [-121.96952, 38.368]]], [[[-121.97601, 38.37279], [-121.97442, 38.37692], [-121.97337, 38.37952], [-121.97228, 38.38237], [-121.97079, 38.38635], [-121.96709, 38.38651], [-121.96528, 38.38665], [-121.96512, 38.38613], [-121.96489, 38.38546], [-121.96482, 38.38545], [-121.96457, 38.38384], [-121.96459, 38.38369], [-121.96442, 38.38233], [-121.96462, 38.38185], [-121.96554, 38.38052], [-121.96572, 38.38021], [-121.96574, 38.38021], [-121.96579, 38.38014], [-121.96578, 38.38012], [-121.96631, 38.3794], [-121.96673, 38.37888], [-121.96773, 38.37756], [-121.96778, 38.37744], [-121.96781, 38.37706], [-121.96776, 38.3766], [-121.96784, 38.37624], [-121.96789, 38.37461], [-121.96788, 38.37444], [-121.9679, 38.37261], [-121.96792, 38.37188], [-121.96794, 38.3716], [-121.9681, 38.36995], [-121.96855, 38.36817], [-121.96846, 38.36803], [-121.96818, 38.36764], [-121.96796, 38.36765], [-121.96759, 38.36733], [-121.96833, 38.36707], [-121.96974, 38.36866], [-121.97015, 38.36908], [-121.9703, 38.36922], [-121.9706, 38.36942], [-121.97061, 38.36955], [-121.97019, 38.36997], [-121.96982, 38.3703], [-121.96968, 38.37047], [-121.96961, 38.37061], [-121.96957, 38.3708], [-121.96956, 38.37095], [-121.96958, 38.37108], [-121.96972, 38.37102], [-121.96974, 38.37084], [-121.9698, 38.37071], [-121.96986, 38.37062], [-121.97002, 38.37046], [-121.97081, 38.36971], [-121.97084, 38.36969], [-121.97098, 38.36968], [-121.97138, 38.36993], [-121.97098, 38.37041], [-121.97098, 38.37043], [-121.97166, 38.37012], [-121.97189, 38.36999], [-121.97317, 38.3709], [-121.976, 38.37276], [-121.97601, 38.37279]]]]} | Open Access 1 | 9627 | Centennial Park | 14382 | 1364 | Vacaville, City of 151 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=128 | Solano 26 | 283.173 | Centennial Park | 0 | Local Park 2 | 4 |
1451 | 1451 | 1450 | {"type": "Polygon", "coordinates": [[[-122.09749, 37.66354], [-122.09714, 37.66357], [-122.09618, 37.66266], [-122.09563, 37.66224], [-122.09518, 37.66185], [-122.0948, 37.66148], [-122.0965, 37.6607], [-122.09689, 37.66105], [-122.0972, 37.66164], [-122.09739, 37.66218], [-122.09747, 37.66261], [-122.09753, 37.66314], [-122.09749, 37.66354]]]} | Open Access 1 | 9747 | Centennial Park | 17031 | 2045 | Hayward Area Recreation and Park District 257 | Special District 4 | Recreation/Parks District 4 | http://www.haywardrec.org/ | Special District 4 | 2045 | Hayward Area Recreation and Park District 253 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 9.492 | Centennial Park | 0 | Local Park 2 | 4 | |
1583 | 1583 | 1582 | {"type": "Polygon", "coordinates": [[[-117.44667, 34.00615], [-117.44289, 34.00706], [-117.44289, 34.00515], [-117.44331, 34.00483], [-117.44348, 34.00473], [-117.44506, 34.00402], [-117.44583, 34.0036], [-117.44659, 34.00317], [-117.44661, 34.00468], [-117.44667, 34.00615]]]} | Open Access 1 | 12177 | Centennial Park | 17032 | 2051 | Jurupa Area Recreation and Park District 364 | Special District 4 | Recreation/Parks District 4 | http://www.jarpd.org/ | Special District 4 | 2051 | Jurupa Area Recreation and Park District 360 | Special District 4 | Recreation/Parks District 4 | Riverside 10 | 23.351 | Centennial Park | 0 | Local Park 2 | 4 | |
1962 | 1962 | 1961 | {"type": "Polygon", "coordinates": [[[-122.53386, 37.92951], [-122.53344, 37.92993], [-122.53223, 37.92992], [-122.53201, 37.92936], [-122.5319, 37.92936], [-122.53147, 37.92871], [-122.531, 37.92809], [-122.53218, 37.92813], [-122.53313, 37.92911], [-122.53386, 37.92951]]]} | Open Access 1 | 15080 | Centennial Park | 17021 | 1170 | Larkspur, City of 450 | City 2 | City Agency 2 | http://www.ci.larkspur.ca.us/index.aspx?nid=207 | City 2 | 1170 | Larkspur, City of 444 | City 2 | City Agency 2 | Marin 23 | 6.074 | Centennial Park | 0 | Local Park 2 | 4 | |
2040 | 2040 | 2039 | {"type": "MultiPolygon", "coordinates": [[[[-119.01395, 35.37273], [-119.01395, 35.37311], [-119.01318, 35.37311], [-119.01346, 35.37273], [-119.01395, 35.37273]]], [[[-119.05443, 35.35901], [-119.05445, 35.36059], [-119.05436, 35.36107], [-119.05426, 35.36139], [-119.05419, 35.36153], [-119.05255, 35.3611], [-119.05321, 35.35937], [-119.05339, 35.359], [-119.05351, 35.35899], [-119.05443, 35.35901]]]]} | Open Access 1 | 15572 | Centennial Park | 17017 | 1019 | Bakersfield, City of 248 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | Kern 36 | 9.321 | Centennial Park | 0 | Local Park 2 | 4 | |
5263 | 5263 | 5262 | {"type": "Polygon", "coordinates": [[[-120.05541, 36.9684], [-120.05477, 36.96843], [-120.05413, 36.96854], [-120.05328, 36.96772], [-120.05413, 36.96716], [-120.05541, 36.9684]]]} | Open Access 1 | 24540 | Centennial Park | 17024 | 1192 | Madera, City of 463 | City 2 | City Agency 2 | http://www.cityofmadera.org/ | City 2 | 1192 | Madera, City of 456 | City 2 | City Agency 2 | Madera 48 | 3.541 | Centennial Park | 0 | Local Park 2 | 4 | |
6071 | 6071 | 6070 | {"type": "Polygon", "coordinates": [[[-117.17247, 32.69894], [-117.17197, 32.69981], [-117.17153, 32.69964], [-117.17205, 32.69877], [-117.17247, 32.69894]]]} | Open Access 1 | 809 | Centennial Park | 33718 | 1069 | Coronado, City of 105 | City 2 | City Agency 2 | http://www.coronado.ca.us/category/subcategory-rec.php | City 2 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | https://www.coronado.ca.us/cms/one.aspx?portalId=746090&pageId=3814369 | San Diego 4 | 1.186 | Centennial Park | 0 | Local Park 2 | 4 |
6779 | 6779 | 6778 | {"type": "Polygon", "coordinates": [[[-121.44009, 36.50594], [-121.43895, 36.50682], [-121.43877, 36.50688], [-121.43813, 36.50635], [-121.43732, 36.50376], [-121.43739, 36.5037], [-121.44009, 36.50594]]]} | Open Access 1 | 5259 | Centennial Park | 17019 | 1122 | Gonzales, City of 458 | City 2 | City Agency 2 | http://www.ci.gonzales.ca.us/parks-and-facilities.php | City 2 | 1122 | Gonzales, City of 452 | City 2 | City Agency 2 | Monterey 14 | 8.727 | Centennial Park | 0 | Local Park 2 | 4 | |
6793 | 6793 | 6792 | {"type": "MultiPolygon", "coordinates": [[[[-120.45773, 34.63741], [-120.45773, 34.63769], [-120.45726, 34.63768], [-120.45727, 34.63741], [-120.45773, 34.63741]]], [[[-120.45774, 34.63692], [-120.45773, 34.63719], [-120.45727, 34.63719], [-120.45727, 34.63692], [-120.45774, 34.63692]]]]} | Open Access 1 | 5299 | Centennial Park | 17023 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1183 | Lompoc, City of 38 | City 2 | City Agency 2 | Santa Barbara 7 | 0.643 | Centennial Park | 0 | Local Park 2 | 4 | |
8470 | 8470 | 8469 | {"type": "Polygon", "coordinates": [[[-121.94855, 37.72697], [-121.94802, 37.72737], [-121.94747, 37.72752], [-121.94722, 37.7271], [-121.9467, 37.7264], [-121.94669, 37.72636], [-121.94658, 37.72614], [-121.94652, 37.72592], [-121.94646, 37.72549], [-121.94641, 37.72526], [-121.94638, 37.72523], [-121.94627, 37.72499], [-121.94613, 37.72477], [-121.94586, 37.72446], [-121.94572, 37.72427], [-121.94539, 37.72367], [-121.94653, 37.72513], [-121.94832, 37.72678], [-121.94855, 37.72697]]]} | Open Access 1 | 13199 | Centennial Park | 17028 | 1313 | San Ramon, City of 70 | City 2 | City Agency 2 | http://www.ci.san-ramon.ca.us/Parks/default.htm | City 2 | 1313 | San Ramon, City of 68 | City 2 | City Agency 2 | Contra Costa 12 | 5.528 | Centennial Park | 0 | Local Park 2 | 4 | |
9030 | 9030 | 9029 | {"type": "Polygon", "coordinates": [[[-117.64133, 34.02033], [-117.63924, 34.02034], [-117.63923, 34.01948], [-117.64132, 34.01947], [-117.64133, 34.02033]]]} | Open Access 1 | 14946 | Centennial Park | 17025 | 1232 | Ontario, City of 126 | City 2 | City Agency 2 | http://www.ci.ontario.ca.us/index.aspx?page=456 | City 2 | 1232 | Ontario, City of 123 | City 2 | City Agency 2 | San Bernardino 22 | 4.568 | Centennial Park | 0 | Local Park 2 | 4 | |
9162 | 9162 | 9161 | {"type": "Polygon", "coordinates": [[[-121.88315, 37.65081], [-121.88088, 37.65354], [-121.88039, 37.65411], [-121.87997, 37.65455], [-121.88071, 37.65064], [-121.88077, 37.65061], [-121.88254, 37.65081], [-121.88315, 37.65081]]]} | Open Access 1 | 15268 | Centennial Park | 17027 | 1257 | Pleasanton, City of 32 | City 2 | City Agency 2 | http://www.cityofpleasantonca.gov/ | City 2 | 1257 | Pleasanton, City of 31 | City 2 | City Agency 2 | Alameda 17 | 11.901 | Centennial Park | 0 | Local Park 2 | 4 | |
14191 | 14191 | 14190 | {"type": "Polygon", "coordinates": [[[-121.77956, 37.67602], [-121.77956, 37.67602], [-121.77934, 37.67698], [-121.77899, 37.67624], [-121.77931, 37.67614], [-121.77956, 37.67602]]]} | Open Access 1 | 44024 | Centennial Park | 17022 | 1178 | Livermore, City of 256 | City 2 | City Agency 2 | http://www.larpd.org/parks/parks.html | City 2 | 1178 | Livermore, City of 252 | City 2 | City Agency 2 | Alameda 17 | 0.579 | Centennial Park | 0 | Local Park 2 | 4 | |
14207 | 14207 | 14206 | {"type": "Polygon", "coordinates": [[[-120.67156, 35.62056], [-120.67153, 35.62077], [-120.67139, 35.62097], [-120.67131, 35.62119], [-120.67099, 35.623], [-120.67099, 35.62312], [-120.67067, 35.62315], [-120.67046, 35.62335], [-120.66796, 35.62268], [-120.66794, 35.62125], [-120.67018, 35.62103], [-120.67156, 35.62056]]]} | Open Access 1 | 44070 | Centennial Park | 17026 | 1247 | Paso Robles, City of 118 | City 2 | City Agency 2 | http://www.prcity.com/government/departments/recreation/facilities/index.asp | City 2 | 1247 | Paso Robles, City of 115 | City 2 | City Agency 2 | San Luis Obispo 1 | 16.173 | Centennial Park | 0 | Local Park 2 | 4 | |
14309 | 14309 | 14308 | {"type": "Polygon", "coordinates": [[[-119.66811, 36.31337], [-119.66563, 36.31335], [-119.66578, 36.31164], [-119.66584, 36.31145], [-119.66599, 36.31129], [-119.66668, 36.31092], [-119.66697, 36.31082], [-119.66712, 36.31078], [-119.66734, 36.31075], [-119.66808, 36.31083], [-119.66811, 36.31337]]]} | Open Access 1 | 44254 | Centennial Park | 17020 | 1129 | Hanford, City of 349 | City 2 | City Agency 2 | http://www.ci.hanford.ca.us/depts/rec/default.asp | City 2 | 1129 | Hanford, City of 346 | City 2 | City Agency 2 | Kings 44 | 14.091 | Centennial Park | 0 | Local Park 2 | 4 | |
14924 | 14924 | 14923 | {"type": "Polygon", "coordinates": [[[-120.34947, 36.15563], [-120.34947, 36.15568], [-120.34939, 36.1559], [-120.34935, 36.15607], [-120.34936, 36.15689], [-120.34932, 36.15692], [-120.34789, 36.15693], [-120.34787, 36.15565], [-120.34947, 36.15563]]]} | Open Access 1 | 45497 | Centennial Park | 28331 | 1683 | Coalinga, City of 786 | City 2 | City Agency 2 | http://www.coalinga.com/ | City 2 | 1683 | Coalinga, City of 765 | City 2 | City Agency 2 | Fresno 9 | 4.716 | Centennial Park | 0 | Local Park 2 | 4 | |
15137 | 15137 | 15136 | {"type": "Polygon", "coordinates": [[[-116.9606, 32.79678], [-116.96032, 32.79678], [-116.96032, 32.79689], [-116.95979, 32.79688], [-116.95965, 32.79672], [-116.96009, 32.7965], [-116.95992, 32.79629], [-116.95972, 32.79637], [-116.95953, 32.79614], [-116.95923, 32.79631], [-116.95913, 32.79619], [-116.95913, 32.79608], [-116.95922, 32.79601], [-116.95923, 32.7959], [-116.9594, 32.7959], [-116.95973, 32.79595], [-116.95997, 32.79581], [-116.95997, 32.79558], [-116.95964, 32.79521], [-116.95907, 32.79548], [-116.95898, 32.79527], [-116.95895, 32.79507], [-116.96017, 32.79506], [-116.96017, 32.79558], [-116.9601, 32.79558], [-116.96006, 32.79561], [-116.96002, 32.79566], [-116.96001, 32.79572], [-116.96006, 32.79578], [-116.96012, 32.79581], [-116.96018, 32.79581], [-116.96024, 32.79578], [-116.96039, 32.79578], [-116.96039, 32.79586], [-116.96048, 32.79593], [-116.96054, 32.79601], [-116.96056, 32.79605], [-116.9606, 32.79678]]]} | Open Access 1 | 45962 | Centennial Park | 29083 | 1092 | El Cajon, City of 73 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/dept/rec/_Parks.html | City 2 | 1092 | El Cajon, City of 71 | City 2 | City Agency 2 | http://www.ci.el-cajon.ca.us/your-government/departments/recreation/parks-playgrounds-sports-fields | San Diego 4 | 3.528 | Centennial Park | 0 | Local Park 2 | 4 |
15337 | 15337 | 15336 | {"type": "Polygon", "coordinates": [[[-117.74783, 34.05789], [-117.74741, 34.0579], [-117.74739, 34.05748], [-117.74782, 34.05747], [-117.74783, 34.05789]]]} | Open Access 1 | 46519 | Centennial Park | 29806 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | http://www.ci.pomona.ca.us/index.php/contact-us-home/contact-community-services/60-centennial-park | Los Angeles 6 | 0.461 | Centennial 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]);