units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

295 rows where COUNTY = 14 and GAP_STS = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, MNG_AG_LEV, PARK_URL, YR_EST

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
42 42 41 {"type": "Polygon", "coordinates": [[[-121.8696, 36.54123], [-121.86858, 36.54357], [-121.8688, 36.54399], [-121.86843, 36.54483], [-121.86836, 36.54672], [-121.86702, 36.54676], [-121.86669, 36.54657], [-121.86686, 36.54615], [-121.86861, 36.54212], [-121.86807, 36.5408], [-121.86878, 36.54061], [-121.8696, 36.54123]]]} Open Access 1 97 Roach Canyon Park 24474 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 15.0 Roach Canyon Park 0 Local Park 2 4
89 89 88 {"type": "MultiPolygon", "coordinates": [[[[-121.8271, 36.58062], [-121.82287, 36.58502], [-121.81841, 36.58218], [-121.82009, 36.58191], [-121.82254, 36.57939], [-121.82254, 36.57938], [-121.81988, 36.57848], [-121.81974, 36.57825], [-121.82001, 36.57814], [-121.82023, 36.57809], [-121.82059, 36.57806], [-121.82087, 36.57809], [-121.82109, 36.57814], [-121.82169, 36.57835], [-121.82197, 36.5784], [-121.82225, 36.5784], [-121.82261, 36.57836], [-121.82277, 36.57835], [-121.82365, 36.5784], [-121.82406, 36.57838], [-121.82441, 36.57832], [-121.82476, 36.57821], [-121.82509, 36.57804], [-121.82647, 36.57976], [-121.8271, 36.58062]]], [[[-121.82489, 36.57785], [-121.82473, 36.57794], [-121.82453, 36.57802], [-121.82383, 36.57666], [-121.82432, 36.57715], [-121.82462, 36.5775], [-121.82469, 36.57768], [-121.82489, 36.57785]]]]} Open Access 1 231 Ryan Ranch Park 24759 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 75.676 Ryan Ranch Park 0 Local Park 2 4
112 112 111 {"type": "MultiPolygon", "coordinates": [[[[-121.89676, 36.61064], [-121.89648, 36.61079], [-121.89639, 36.61069], [-121.8964, 36.61049], [-121.89638, 36.61044], [-121.89628, 36.61029], [-121.89611, 36.6101], [-121.89602, 36.61002], [-121.89595, 36.61], [-121.8958, 36.61], [-121.89572, 36.60995], [-121.8956, 36.60978], [-121.89551, 36.6097], [-121.89543, 36.60948], [-121.89573, 36.60943], [-121.89676, 36.61064]]], [[[-121.89709, 36.61029], [-121.89683, 36.61043], [-121.89595, 36.60939], [-121.89629, 36.60934], [-121.89709, 36.61029]]]]} Open Access 1 327 San Carlos Beach Park 24846 2085 Monterey Peninsula Regional Park District 47 Special District 4 Recreation/Parks District 4 http://www.mprpd.org/ Special District 4 2085 Monterey Peninsula Regional Park District 46 Special District 4 Recreation/Parks District 4   Monterey 14 1.92 San Carlos Beach Park 0 Local Park 2 4
129 129 128 {"type": "Polygon", "coordinates": [[[-121.897, 36.61092], [-121.89662, 36.61113], [-121.89653, 36.61109], [-121.8965, 36.61109], [-121.89645, 36.61117], [-121.89637, 36.6112], [-121.89631, 36.61117], [-121.8963, 36.61114], [-121.8963, 36.61112], [-121.89633, 36.6111], [-121.89646, 36.61107], [-121.89655, 36.61095], [-121.89656, 36.61087], [-121.89648, 36.61079], [-121.89676, 36.61064], [-121.897, 36.61092]]]} Open Access 1 322 San Carlos Beach Park 24845 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 0.398 San Carlos Beach Park 0 Local Park 2 4
139 139 138 {"type": "Polygon", "coordinates": [[[-121.62037, 36.68583], [-121.61877, 36.68675], [-121.61779, 36.68563], [-121.61818, 36.68539], [-121.61827, 36.68538], [-121.61842, 36.6853], [-121.61842, 36.68528], [-121.61852, 36.68526], [-121.6186, 36.68529], [-121.61865, 36.68536], [-121.61874, 36.68537], [-121.61916, 36.68584], [-121.61999, 36.68539], [-121.62037, 36.68583]]]} Open Access 1 442 Sanborn Neighborhood Park 25004 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.539 Sanborn Neighborhood Park 0 Local Park 2 4
188 188 187 {"type": "Polygon", "coordinates": [[[-121.65097, 36.72554], [-121.65096, 36.72568], [-121.65085, 36.72602], [-121.6503, 36.72616], [-121.64992, 36.72621], [-121.64989, 36.7262], [-121.64984, 36.72593], [-121.64986, 36.72575], [-121.65001, 36.72574], [-121.65097, 36.72554]]]} Open Access 1 603 Santa Rita Park 25125 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 1.227 Santa Rita Park 0 Local Park 2 4
263 263 262 {"type": "Polygon", "coordinates": [[[-121.60427, 36.6889], [-121.60339, 36.68923], [-121.60329, 36.68903], [-121.60316, 36.68881], [-121.60301, 36.6886], [-121.60264, 36.68816], [-121.60264, 36.68811], [-121.60325, 36.68776], [-121.60427, 36.6889]]]} Open Access 1 897 Soberanes Park 25586 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 2.722 Soberanes Park 0 Local Park 2 4
291 291 290 {"type": "Polygon", "coordinates": [[[-121.65217, 36.69015], [-121.65159, 36.69783], [-121.64807, 36.6977], [-121.64676, 36.69741], [-121.64651, 36.69696], [-121.64646, 36.69678], [-121.64645, 36.6966], [-121.64683, 36.69195], [-121.6462, 36.69108], [-121.64785, 36.69036], [-121.64948, 36.69], [-121.6521, 36.69007], [-121.65215, 36.6901], [-121.65217, 36.69015]]]} Open Access 1 790 Sherwood Park 25403 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 96.826 Sherwood Park 0 Local Park 2 4
332 332 331 {"type": "Polygon", "coordinates": [[[-121.31293, 36.42631], [-121.31293, 36.42822], [-121.31184, 36.42912], [-121.3115, 36.42912], [-121.3115, 36.42606], [-121.31293, 36.42631]]]} Open Access 1 911 Soledad Cemetery 25597 2153 Soledad Cemetery District 135 Special District 4 Cemetery District 11   Special District 4 2153 Soledad Cemetery District 132 Special District 4 Cemetery District 11   Monterey 14 9.116 Soledad Cemetery 0 Local Historic or Cultural Area 19 4
390 390 389 {"type": "Polygon", "coordinates": [[[-121.85037, 36.60465], [-121.85037, 36.60469], [-121.85035, 36.60473], [-121.85031, 36.60476], [-121.85025, 36.60477], [-121.84884, 36.60476], [-121.84876, 36.60472], [-121.84874, 36.60465], [-121.84877, 36.60459], [-121.84886, 36.60456], [-121.85026, 36.60458], [-121.85032, 36.6046], [-121.85037, 36.60465]]]} Open Access 1 1422 Trinity Park 26541 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.754 Trinity Park 0 Local Park 2 4
428 428 427 {"type": "Polygon", "coordinates": [[[-121.84692, 36.60162], [-121.84692, 36.60208], [-121.84657, 36.60207], [-121.84657, 36.60162], [-121.84692, 36.60162]]]} Open Access 1 48914 Ellis Park 33635 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 http://www.ci.seaside.ca.us/Facilities/Facility/Details/Ellis-Park-28 Monterey 14 0.391 Ellis Park 0 Local Park 2 4
468 468 467 {"type": "Polygon", "coordinates": [[[-121.23985, 36.31529], [-121.23985, 36.31529], [-121.23866, 36.31569], [-121.23912, 36.31545], [-121.23943, 36.31521], [-121.23967, 36.31506], [-121.23985, 36.31529]]]} Open Access 1 1515 Tyler Park 26628 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.38 Tyler 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
520 520 519 {"type": "Polygon", "coordinates": [[[-121.65535, 36.14492], [-121.65525, 36.14864], [-121.65386, 36.14763], [-121.65385, 36.14752], [-121.65399, 36.14736], [-121.65389, 36.14607], [-121.65374, 36.14584], [-121.6534, 36.14576], [-121.65314, 36.14575], [-121.65294, 36.1453], [-121.65272, 36.14538], [-121.65239, 36.14573], [-121.65235, 36.14542], [-121.65198, 36.14474], [-121.65177, 36.14463], [-121.65147, 36.14463], [-121.65137, 36.14468], [-121.65116, 36.14459], [-121.65078, 36.14454], [-121.65052, 36.14463], [-121.65059, 36.1445], [-121.65066, 36.14424], [-121.65068, 36.14402], [-121.6505, 36.14395], [-121.6499, 36.1439], [-121.64972, 36.14395], [-121.64996, 36.14376], [-121.65037, 36.14371], [-121.65056, 36.1435], [-121.6513, 36.14321], [-121.65163, 36.14301], [-121.65168, 36.14306], [-121.65195, 36.14289], [-121.65201, 36.14294], [-121.65211, 36.14287], [-121.65237, 36.14286], [-121.65256, 36.14307], [-121.65324, 36.14282], [-121.65369, 36.14283], [-121.65387, 36.14319], [-121.65407, 36.14339], [-121.65407, 36.14365], [-121.65414, 36.14379], [-121.65407, 36.14384], [-121.65378, 36.14355], [-121.65334, 36.14344], [-121.65331, 36.14351], [-121.65359, 36.14366], [-121.65385, 36.14418], [-121.65378, 36.1444], [-121.65366, 36.1441], [-121.6533, 36.14395], [-121.65323, 36.144], [-121.65348, 36.1442], [-121.65351, 36.14468], [-121.65363, 36.14478], [-121.65396, 36.14481], [-121.65438, 36.14473], [-121.65458, 36.1449], [-121.65465, 36.14506], [-121.65535, 36.14492]]]} Open Access 1 1721 Veren Park 26993 310 Monterey, County of 23 County 3 County Agency 3 http://www.co.monterey.ca.us/parks/ County 3 310 Monterey, County of 23 County 3 County Agency 3   Monterey 14 28.032 Veren Park 0 Local Park 2 4
561 561 560 {"type": "MultiPolygon", "coordinates": [[[[-121.89934, 36.58954], [-121.89907, 36.58978], [-121.8988, 36.59009], [-121.8983, 36.58996], [-121.89825, 36.58981], [-121.89898, 36.58939], [-121.89929, 36.58932], [-121.89934, 36.58954]]], [[[-121.90001, 36.58937], [-121.90007, 36.58941], [-121.90009, 36.58947], [-121.90007, 36.58958], [-121.90002, 36.58967], [-121.89991, 36.58979], [-121.89972, 36.5899], [-121.8996, 36.59001], [-121.89922, 36.59052], [-121.89907, 36.59044], [-121.89912, 36.59037], [-121.89885, 36.59024], [-121.89916, 36.58987], [-121.89947, 36.5896], [-121.89971, 36.58945], [-121.89988, 36.5894], [-121.90001, 36.58937]]]]} Open Access 1 1860 Whispering Pines Park 27458 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 2.381 Whispering Pines Park 0 Local Park 2 4
585 585 584 {"type": "Polygon", "coordinates": [[[-121.78891, 36.69064], [-121.78837, 36.69136], [-121.78768, 36.69128], [-121.78804, 36.69079], [-121.78789, 36.69057], [-121.78813, 36.69027], [-121.78891, 36.69064]]]} Open Access 1 1953 Windyhill Park 27644 1197 Marina, City of 216 City 2 City Agency 2 http://www.ci.marina.ca.us/index.aspx?NID=25 City 2 1197 Marina, City of 212 City 2 City Agency 2   Monterey 14 1.767 Windyhill 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
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
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
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);