units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
199 rows where COUNTY = 14 and MNG_AG_TYP = 2 sorted by SUID_NMA
This data as json, copyable, CSV (advanced)
DES_TP 17
- Local Park 134
- Local Other or Unknown 28
- Local Recreation Area 20
- Local Conservation Area 3
- Local Historic or Cultural Area 2
- None 1
- National Monument or Landmark 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 12
ACCESS_TYP 4
MNG_AG_TYP 1
- City Agency · 199 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1516 | 1516 | 1515 | {"type": "Polygon", "coordinates": [[[-121.91031, 36.62062], [-121.91016, 36.62096], [-121.90987, 36.6208], [-121.90954, 36.62069], [-121.9097, 36.62033], [-121.90994, 36.6204], [-121.90991, 36.62051], [-121.91031, 36.62062]]]} | Open Access 1 | 10994 | Andy Jacobson Park | 15489 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 0.587 | Andy Jacobson Park | 0 | Local Park 2 | 4 | |
1985 | 1985 | 1984 | {"type": "MultiPolygon", "coordinates": [[[[-121.92614, 36.60509], [-121.92613, 36.60525], [-121.92523, 36.60561], [-121.92512, 36.60544], [-121.92474, 36.60504], [-121.92428, 36.60474], [-121.92402, 36.60465], [-121.924, 36.60454], [-121.92422, 36.60448], [-121.92435, 36.60441], [-121.92446, 36.60431], [-121.92455, 36.6043], [-121.92474, 36.60436], [-121.92474, 36.60442], [-121.92496, 36.60459], [-121.92502, 36.60456], [-121.92515, 36.60463], [-121.92565, 36.60478], [-121.92575, 36.60484], [-121.92594, 36.60501], [-121.92614, 36.60509]]], [[[-121.92617, 36.60484], [-121.92615, 36.605], [-121.92605, 36.60498], [-121.92597, 36.60493], [-121.92585, 36.60482], [-121.92617, 36.60484]]]]} | Open Access 1 | 15184 | Arnett Park | 15601 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 3.016 | Arnett Park | 0 | Local Park 2 | 4 | |
2250 | 2250 | 2249 | {"type": "Polygon", "coordinates": [[[-121.93548, 36.61625], [-121.9351, 36.61657], [-121.93498, 36.6167], [-121.9349, 36.61682], [-121.93433, 36.6178], [-121.93421, 36.61812], [-121.93407, 36.61853], [-121.934, 36.61893], [-121.93384, 36.61889], [-121.93398, 36.61786], [-121.93416, 36.61788], [-121.9348, 36.61678], [-121.93494, 36.6166], [-121.93509, 36.61645], [-121.93532, 36.61626], [-121.93548, 36.61625]]]} | Open Access 1 | 16680 | Asilomar Conference Grounds | 15659 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 1.059 | Asilomar Conference Grounds | None 187 | |||
9984 | 9984 | 9983 | {"type": "Polygon", "coordinates": [[[-121.93003, 36.62468], [-121.92951, 36.62492], [-121.92939, 36.62482], [-121.9294, 36.62475], [-121.9285, 36.62451], [-121.92873, 36.62399], [-121.92882, 36.62387], [-121.92892, 36.6238], [-121.92902, 36.62376], [-121.92915, 36.62373], [-121.92928, 36.62373], [-121.92948, 36.6238], [-121.92963, 36.62391], [-121.92968, 36.62399], [-121.92976, 36.62422], [-121.92984, 36.6244], [-121.93003, 36.62468]]]} | Open Access 1 | 17218 | Baseball Park | 15847 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 2.631 | Baseball Park | 0 | Local Park 2 | 4 | |
2433 | 2433 | 2432 | {"type": "Polygon", "coordinates": [[[-121.24674, 36.33072], [-121.24636, 36.33094], [-121.24588, 36.33048], [-121.2463, 36.33025], [-121.24657, 36.33041], [-121.24654, 36.33047], [-121.24655, 36.33054], [-121.2466, 36.33059], [-121.24667, 36.33063], [-121.24674, 36.33072]]]} | Open Access 1 | 17316 | Baywood Park | 15904 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 0.745 | Baywood Park | 0 | Local Park 2 | 4 | |
10227 | 10227 | 10226 | {"type": "Polygon", "coordinates": [[[-121.912, 36.62206], [-121.91195, 36.62241], [-121.91158, 36.6223], [-121.91129, 36.62217], [-121.91101, 36.62199], [-121.91078, 36.62179], [-121.91101, 36.62186], [-121.91149, 36.62195], [-121.912, 36.62206]]]} | Open Access 1 | 17889 | Berwick Park | 16040 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 0.726 | Berwick Park | 0 | Local Park 2 | 4 | |
2590 | 2590 | 2589 | {"type": "MultiPolygon", "coordinates": [[[[-121.83143, 36.60704], [-121.83142, 36.60731], [-121.83117, 36.6073], [-121.83118, 36.60703], [-121.83143, 36.60704]]], [[[-121.83204, 36.60701], [-121.83203, 36.60732], [-121.83152, 36.60731], [-121.83153, 36.60701], [-121.83158, 36.60704], [-121.83199, 36.60705], [-121.83203, 36.60703], [-121.83204, 36.60701]]]]} | Open Access 1 | 17968 | Beta Park | 16044 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.502 | Beta Park | 0 | Local Park 2 | 4 | |
10353 | 10353 | 10352 | {"type": "Polygon", "coordinates": [[[-121.32753, 36.42763], [-121.32738, 36.42778], [-121.32736, 36.42796], [-121.3273, 36.42802], [-121.3269, 36.42776], [-121.32723, 36.42744], [-121.32753, 36.42763]]]} | Open Access 1 | 18263 | Bill Ramos Park | 16110 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 0.446 | Bill Ramos Park | 0 | Local Park 2 | 4 | |
2357 | 2357 | 2356 | {"type": "Polygon", "coordinates": [[[-121.32319, 36.43509], [-121.32314, 36.43612], [-121.32196, 36.43612], [-121.32176, 36.43613], [-121.3217, 36.43611], [-121.32159, 36.43585], [-121.32137, 36.43549], [-121.32127, 36.43527], [-121.32131, 36.43521], [-121.32205, 36.4351], [-121.32287, 36.43506], [-121.32319, 36.43509]]]} | Open Access 1 | 18512 | Blas Santana Park | 16158 | 1336 | Soledad, City of 485 | City 2 | City Agency 2 | http://www.cityofsoledad.com/ | City 2 | 1336 | Soledad, City of 476 | City 2 | City Agency 2 | Monterey 14 | 4.221 | Blas Santana Park | 0 | Local Park 2 | 4 | |
470 | 470 | 469 | {"type": "Polygon", "coordinates": [[[-121.92036, 36.62297], [-121.92035, 36.62307], [-121.92023, 36.62325], [-121.91992, 36.62355], [-121.91966, 36.62389], [-121.91955, 36.62412], [-121.91955, 36.62421], [-121.91957, 36.62432], [-121.91954, 36.6244], [-121.91946, 36.62445], [-121.91912, 36.62454], [-121.91936, 36.62407], [-121.91954, 36.6235], [-121.91963, 36.62328], [-121.91977, 36.62302], [-121.9199, 36.62284], [-121.92036, 36.62297]]]} | Open Access 1 | 1519 | Caledonia Park | 16678 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 1.521 | Caledonia Park | 0 | Local Park 2 | 4 | |
651 | 651 | 650 | {"type": "Polygon", "coordinates": [[[-121.83147, 36.60522], [-121.83145, 36.60586], [-121.83095, 36.60585], [-121.83097, 36.60522], [-121.83147, 36.60522]]]} | Open Access 1 | 3181 | Capra Park | 16842 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.791 | Capra Park | 0 | Local Park 2 | 4 | |
6549 | 6549 | 6548 | {"type": "MultiPolygon", "coordinates": [[[[-121.93106, 36.5564], [-121.92991, 36.55721], [-121.92971, 36.5571], [-121.92961, 36.55715], [-121.92951, 36.55686], [-121.92923, 36.55678], [-121.92927, 36.55638], [-121.92792, 36.55621], [-121.92792, 36.55521], [-121.9307, 36.55521], [-121.93092, 36.55578], [-121.93102, 36.55608], [-121.93106, 36.5564]]], [[[-121.93065, 36.55493], [-121.92958, 36.55493], [-121.92958, 36.55326], [-121.92943, 36.55257], [-121.9298, 36.55257], [-121.93016, 36.55356], [-121.93053, 36.55472], [-121.93065, 36.55493]]], [[[-121.9311, 36.54475], [-121.93106, 36.54493], [-121.93099, 36.5449], [-121.93091, 36.54482], [-121.93084, 36.54479], [-121.93073, 36.54481], [-121.93052, 36.54491], [-121.92985, 36.54537], [-121.92983, 36.54533], [-121.92987, 36.54526], [-121.92995, 36.54519], [-121.92995, 36.54515], [-121.92999, 36.54511], [-121.92998, 36.54508], [-121.93029, 36.54488], [-121.93058, 36.54474], [-121.93071, 36.54469], [-121.93078, 36.54469], [-121.93093, 36.5447], [-121.9311, 36.54475]]], [[[-121.93174, 36.55731], [-121.93131, 36.55751], [-121.93137, 36.55714], [-121.93113, 36.5568], [-121.93123, 36.55676], [-121.93174, 36.55731]]]]} | Open Access 1 | 3274 | Carmel Beach City Park | 16866 | 1046 | Carmel-by-the-Sea, City of 535 | City 2 | City Agency 2 | http://www.carmelcalifornia.com/ | City 2 | 1046 | Carmel-by-the-Sea, City of 528 | City 2 | City Agency 2 | Monterey 14 | 15.194 | Carmel Beach City Park | 0 | Local Park 2 | 4 | |
762 | 762 | 761 | {"type": "Polygon", "coordinates": [[[-121.85224, 36.59449], [-121.85177, 36.59488], [-121.85075, 36.59406], [-121.85181, 36.59419], [-121.85195, 36.59425], [-121.85224, 36.59449]]]} | Open Access 1 | 4961 | Casanova Oak Knoll Park | 16933 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 1.296 | Casanova Oak Knoll Park | 0 | Local Park 2 | 4 | |
6732 | 6732 | 6731 | {"type": "Polygon", "coordinates": [[[-121.88549, 36.5946], [-121.88475, 36.59709], [-121.88351, 36.597], [-121.8834, 36.59675], [-121.88338, 36.59643], [-121.88343, 36.59604], [-121.88338, 36.59542], [-121.88332, 36.59527], [-121.88304, 36.59496], [-121.88291, 36.59479], [-121.88284, 36.59456], [-121.88276, 36.59438], [-121.88338, 36.59412], [-121.88549, 36.5946]]]} | Open Access 1 | 5146 | Cementerio El Encinal | 17006 | 1212 | Monterey, City of 37 | City 2 | City Agency 2 | http://monterey.org/en-us/Departments/Monterey-Recreation/Parks-and-Beaches | City 2 | 1212 | Monterey, City of 36 | City 2 | City Agency 2 | Monterey 14 | 12.673 | Cementerio El Encinal | None 545 | |||
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 | |
832 | 832 | 831 | {"type": "Polygon", "coordinates": [[[-121.63752, 36.67956], [-121.63746, 36.67966], [-121.63621, 36.68089], [-121.63611, 36.68096], [-121.63597, 36.68103], [-121.6358, 36.68108], [-121.63508, 36.6812], [-121.63494, 36.68121], [-121.63422, 36.68115], [-121.63433, 36.68028], [-121.63237, 36.67947], [-121.63175, 36.67992], [-121.62945, 36.68037], [-121.62906, 36.68053], [-121.6288, 36.68027], [-121.6285, 36.68005], [-121.62853, 36.68001], [-121.62833, 36.67989], [-121.62875, 36.67962], [-121.62899, 36.67954], [-121.62933, 36.6792], [-121.6294, 36.67897], [-121.62938, 36.67876], [-121.62926, 36.67865], [-121.62909, 36.67845], [-121.62997, 36.67864], [-121.62997, 36.67868], [-121.63031, 36.67883], [-121.63081, 36.67887], [-121.6314, 36.67873], [-121.63142, 36.6787], [-121.63148, 36.67869], [-121.63156, 36.67813], [-121.63279, 36.6784], [-121.63486, 36.67951], [-121.63503, 36.67953], [-121.63501, 36.67958], [-121.63502, 36.67959], [-121.6353, 36.67964], [-121.63635, 36.67962], [-121.63752, 36.67956]]]} | Open Access 1 | 5409 | Cesar Chavez Community Park | 17092 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 27.823 | Cesar Chavez Community Park | 0 | Local Park 2 | 4 | |
6850 | 6850 | 6849 | {"type": "Polygon", "coordinates": [[[-121.6295, 36.67854], [-121.62937, 36.67851], [-121.62925, 36.6784], [-121.62832, 36.67814], [-121.62813, 36.67793], [-121.6274, 36.67797], [-121.62741, 36.67795], [-121.6281, 36.6779], [-121.628, 36.67779], [-121.62827, 36.67726], [-121.62832, 36.67693], [-121.62815, 36.67652], [-121.62822, 36.67652], [-121.62839, 36.67693], [-121.62834, 36.67727], [-121.62868, 36.67723], [-121.62893, 36.67724], [-121.62893, 36.67726], [-121.62872, 36.67727], [-121.62881, 36.67758], [-121.62878, 36.67759], [-121.62867, 36.67726], [-121.62833, 36.6773], [-121.62809, 36.67778], [-121.62837, 36.67809], [-121.62932, 36.67836], [-121.6295, 36.67854]]]} | Open Access 1 | 5501 | Cesar Chavez Park Access | 17101 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.594 | Cesar Chavez Park Access | 0 | Local Recreation Area 3 | 4 | |
775 | 775 | 774 | {"type": "Polygon", "coordinates": [[[-121.91806, 36.62456], [-121.91784, 36.6251], [-121.91745, 36.6249], [-121.91761, 36.62454], [-121.91788, 36.62453], [-121.91806, 36.62456]]]} | Open Access 1 | 5711 | Chase Park | 17157 | 1238 | Pacific Grove, City of 177 | City 2 | City Agency 2 | http://www.ci.pg.ca.us/index.aspx?page=140 | City 2 | 1238 | Pacific Grove, City of 173 | City 2 | City Agency 2 | Monterey 14 | 0.521 | Chase Park | 0 | Local Park 2 | 4 | |
7535 | 7535 | 7534 | {"type": "Polygon", "coordinates": [[[-121.64974, 36.65505], [-121.64922, 36.65654], [-121.64854, 36.65624], [-121.64808, 36.65611], [-121.64804, 36.65608], [-121.64804, 36.65605], [-121.6485, 36.65476], [-121.64974, 36.65505]]]} | Open Access 1 | 7115 | Claremont Manor Park | 17382 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 4.607 | Claremont Manor Park | 0 | Local Park 2 | 4 | |
1133 | 1133 | 1132 | {"type": "Polygon", "coordinates": [[[-121.6595, 36.67057], [-121.65909, 36.67063], [-121.659, 36.67022], [-121.65942, 36.67016], [-121.6595, 36.67057]]]} | Open Access 1 | 7220 | Clay Park | 17397 | 1291 | Salinas, City of 56 | City 2 | City Agency 2 | http://www.ci.salinas.ca.us/services/recreation/recreation.cfm | City 2 | 1291 | Salinas, City of 54 | City 2 | City Agency 2 | Monterey 14 | 0.426 | Clay 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]);