units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where MNG_AGENCY = 23 and MNG_AG_TYP = 3 sorted by GAP_STS
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, YR_EST, GAP_STS
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5339 | 5339 | 5338 | {"type": "Polygon", "coordinates": [[[-121.76487, 36.22671], [-121.76455, 36.22693], [-121.76407, 36.227], [-121.76385, 36.22719], [-121.76369, 36.22707], [-121.76348, 36.22697], [-121.76368, 36.22607], [-121.76441, 36.22592], [-121.76478, 36.22637], [-121.76487, 36.22671]]]} | Unknown Access 4 | 15853 | First Growth | 18915 | 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 | 2.843 | First Growth | None 434 | |||
9431 | 9431 | 9430 | {"type": "Polygon", "coordinates": [[[-121.81231, 36.23946], [-121.8123, 36.24002], [-121.81077, 36.23999], [-121.81078, 36.23944], [-121.81113, 36.23944], [-121.81114, 36.23898], [-121.81198, 36.23899], [-121.81197, 36.23945], [-121.81231, 36.23946]]]} | Unknown Access 4 | 15771 | Falotico | 18839 | 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 | 3.051 | Falotico | None 778 | |||
679 | 679 | 678 | {"type": "Polygon", "coordinates": [[[-121.92514, 36.53043], [-121.92439, 36.53053], [-121.92438, 36.5305], [-121.92514, 36.53041], [-121.92514, 36.53043]]]} | Open Access 1 | 3434 | Carmel River Lagoon & Wetlands Natural Preserve | 16874 | 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 | 0.044 | Carmel River Lagoon & Wetlands Natural Preserve | 0 | Local Conservation Area 4 | 2 | |
9222 | 9222 | 9221 | {"type": "Polygon", "coordinates": [[[-121.74481, 36.84148], [-121.74245, 36.84316], [-121.74184, 36.84299], [-121.74343, 36.84161], [-121.74317, 36.84141], [-121.74385, 36.84096], [-121.74425, 36.84118], [-121.74481, 36.84148]]]} | Open Access 1 | 15341 | Elkhorn Slough | 18570 | 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 | 5.157 | Elkhorn Slough | 0 | Local Conservation Area 4 | 2 | |
15772 | 15772 | 15771 | {"type": "Polygon", "coordinates": [[[-121.75829, 36.65049], [-121.75826, 36.65096], [-121.75819, 36.65109], [-121.75816, 36.6512], [-121.75807, 36.65183], [-121.75806, 36.65201], [-121.75811, 36.65229], [-121.75831, 36.65285], [-121.75843, 36.65362], [-121.75848, 36.65401], [-121.75847, 36.65412], [-121.75819, 36.65486], [-121.75817, 36.65494], [-121.7579, 36.65558], [-121.75703, 36.65555], [-121.7571, 36.65542], [-121.75709, 36.6554], [-121.75624, 36.65543], [-121.74772, 36.65543], [-121.74657, 36.6554], [-121.74183, 36.65517], [-121.74167, 36.65507], [-121.74157, 36.65493], [-121.74153, 36.6547], [-121.74153, 36.65457], [-121.74156, 36.65448], [-121.74185, 36.65405], [-121.74188, 36.65398], [-121.74188, 36.65391], [-121.74182, 36.6538], [-121.74175, 36.65374], [-121.7415, 36.65361], [-121.74136, 36.65358], [-121.7414, 36.65302], [-121.74138, 36.65188], [-121.7413, 36.6513], [-121.74126, 36.65109], [-121.7412, 36.65089], [-121.74076, 36.651], [-121.73974, 36.65121], [-121.73931, 36.65132], [-121.73901, 36.65136], [-121.7388, 36.65134], [-121.73865, 36.65131], [-121.73791, 36.65105], [-121.73768, 36.65101], [-121.73745, 36.651], [-121.73629, 36.64792], [-121.73691, 36.64783], [-121.73739, 36.64771], [-121.73761, 36.64764], [-121.73829, 36.64735], [-121.73875, 36.64718], [-121.73943, 36.64698], [-121.73976, 36.64691], [-121.73998, 36.64689], [-121.74017, 36.6469], [-121.74104, 36.64702], [-121.74115, 36.64706], [-121.74168, 36.64713], [-121.74321, 36.64687], [-121.74484, 36.64683], [-121.74556, 36.64678], [-121.74671, 36.6468], [-121.74781, 36.64724], [-121.74861, 36.64695], [-121.74939, 36.64676], [-121.75021, 36.64666], [-121.75056, 36.64656], [-121.75106, 36.64636], [-121.75164, 36.64623], [-121.75172, 36.6462], [-121.75216, 36.64585], [-121.75221, 36.64584], [-121.75256, 36.64579], [-121.75285, 36.6457], [-121.75302, 36.64571], [-121.75319, 36.64569], [-121.75354, 36.64548], [-121.754, 36.64537], [-121.75433, 36.64539], [-121.75485, 36.64523], [-121.75516, 36.64547], [-121.75558, 36.64614], [-121.75605, 36.6466], [-121.7564, 36.64714], [-121.75641, 36.64714], [-121.75651, 36.64702], [-121.75654, 36.64705], [-121.75668, 36.64717], [-121.75683, 36.64733], [-121.75708, 36.64767], [-121.75727, 36.64819], [-121.75747, 36.64839], [-121.75753, 36.64849], [-121.75766, 36.64884], [-121.75789, 36.64906], [-121.75795, 36.64914], [-121.75795, 36.64921], [-121.75785, 36.64936], [-121.75786, 36.64948], [-121.75811, 36.64986], [-121.75814, 36.64996], [-121.75815, 36.6501], [-121.75825, 36.65034], [-121.75826, 36.65042], [-121.75829, 36.65049]]]} | Unknown Access 4 | 15914 | Fort Ord National Monument | 19009 | 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 | 401.403 | Fort Ord NM | 2012 | National Monument or Landmark 80 | 3 | |
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 | |
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 | |
1479 | 1479 | 1478 | {"type": "Polygon", "coordinates": [[[-121.62993, 36.69624], [-121.62762, 36.69442], [-121.62979, 36.69262], [-121.63183, 36.6944], [-121.63188, 36.69446], [-121.63189, 36.69452], [-121.63188, 36.69459], [-121.63186, 36.69463], [-121.62993, 36.69624]]]} | Open Access 1 | 10118 | Constitution Soccer Complex | 17603 | 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 | 19.339 | Constitution Soccer Complex | 0 | Local Recreation Area 3 | 4 | |
2062 | 2062 | 2061 | {"type": "Polygon", "coordinates": [[[-121.61958, 36.0915], [-121.61863, 36.09223], [-121.61856, 36.09184], [-121.61851, 36.09168], [-121.61843, 36.0915], [-121.61829, 36.09127], [-121.61771, 36.09052], [-121.61762, 36.09034], [-121.61756, 36.09016], [-121.61754, 36.08997], [-121.61756, 36.0898], [-121.61759, 36.08966], [-121.61774, 36.08925], [-121.61781, 36.08885], [-121.61781, 36.08862], [-121.61779, 36.0884], [-121.61767, 36.08791], [-121.6187, 36.08785], [-121.61869, 36.08803], [-121.61867, 36.08811], [-121.61868, 36.08859], [-121.61876, 36.08874], [-121.61882, 36.089], [-121.61889, 36.08915], [-121.6189, 36.08924], [-121.61886, 36.08933], [-121.61877, 36.08939], [-121.61861, 36.08956], [-121.61858, 36.08964], [-121.61855, 36.08971], [-121.61857, 36.08995], [-121.6186, 36.09004], [-121.61868, 36.09011], [-121.61871, 36.09019], [-121.61874, 36.09027], [-121.61876, 36.09045], [-121.61885, 36.09067], [-121.61891, 36.09076], [-121.61906, 36.09092], [-121.61936, 36.09109], [-121.61944, 36.09117], [-121.61956, 36.09142], [-121.61958, 36.0915]]]} | Open Access 1 | 15721 | Evans Park | 18752 | 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 | 10.332 | Evans Park | 0 | Local Park 2 | 4 | |
2432 | 2432 | 2431 | {"type": "Polygon", "coordinates": [[[-121.66142, 36.69671], [-121.66133, 36.69757], [-121.66133, 36.69766], [-121.66086, 36.69771], [-121.66103, 36.69656], [-121.66131, 36.6966], [-121.66138, 36.69665], [-121.66142, 36.69671]]]} | Open Access 1 | 17307 | Laurel Park | 21098 | 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 | 1.141 | Laurel Park | 0 | Local Park 2 | 4 | |
3832 | 3832 | 3831 | {"type": "Polygon", "coordinates": [[[-121.93195, 36.46898], [-121.92968, 36.47], [-121.92918, 36.46978], [-121.92903, 36.46952], [-121.92991, 36.46851], [-121.93056, 36.46842], [-121.9307, 36.46829], [-121.93172, 36.46882], [-121.93195, 36.46898]]]} | Open Access 1 | 45334 | County Park | 17715 | 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 | 6.297 | County Park | 0 | Local Park 2 | 4 | |
4193 | 4193 | 4192 | {"type": "Polygon", "coordinates": [[[-121.7011, 36.60301], [-121.6999, 36.60383], [-121.69965, 36.60353], [-121.69903, 36.60325], [-121.69957, 36.60245], [-121.7004, 36.60282], [-121.7011, 36.60301]]]} | Open Access 1 | 48870 | Kelton Park | 33591 | 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 | 3.333 | Kelton Park | 0 | Local Park 2 | 4 | |
4569 | 4569 | 4568 | {"type": "Polygon", "coordinates": [[[-121.90092, 36.38111], [-121.90068, 36.38151], [-121.89991, 36.38153], [-121.90026, 36.38083], [-121.90092, 36.38111]]]} | Open Access 1 | 35213 | Unnamed site - Monterey, County of | 28641 | 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 | 1.072 | 0 | Local Other or Unknown 14 | 4 | ||
4570 | 4570 | 4569 | {"type": "Polygon", "coordinates": [[[-121.79587, 36.24479], [-121.79216, 36.24477], [-121.79223, 36.24187], [-121.79275, 36.24205], [-121.79412, 36.24162], [-121.79434, 36.24172], [-121.79457, 36.24166], [-121.79584, 36.24162], [-121.79587, 36.24479]]]} | Open Access 1 | 35214 | Unnamed site - Monterey, County of | 28641 | 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 | 27.202 | 0 | Local Other or Unknown 14 | 4 | ||
4571 | 4571 | 4570 | {"type": "Polygon", "coordinates": [[[-121.75824, 36.76732], [-121.75755, 36.76792], [-121.75679, 36.76735], [-121.75748, 36.76675], [-121.75824, 36.76732]]]} | Open Access 1 | 35215 | Unknown park - Monterey, County of | 28642 | 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 | 2.087 | 0 | Local Other or Unknown 14 | 4 | ||
4572 | 4572 | 4571 | {"type": "Polygon", "coordinates": [[[-121.68837, 36.61717], [-121.68833, 36.6172], [-121.68814, 36.61791], [-121.68767, 36.61774], [-121.68798, 36.6174], [-121.68817, 36.6171], [-121.68837, 36.61717]]]} | Open Access 1 | 35222 | Unnamed site - Monterey, County of | 28641 | 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 | 0.614 | 0 | Local Other or Unknown 14 | 4 | ||
4573 | 4573 | 4572 | {"type": "Polygon", "coordinates": [[[-121.68761, 36.61869], [-121.68717, 36.61899], [-121.68712, 36.61905], [-121.687, 36.61903], [-121.68706, 36.61882], [-121.68721, 36.61854], [-121.68761, 36.61869]]]} | Open Access 1 | 35223 | Unnamed site - Monterey, County of | 28641 | 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 | 0.347 | 0 | Local Other or Unknown 14 | 4 | ||
4576 | 4576 | 4575 | {"type": "Polygon", "coordinates": [[[-121.90098, 36.38732], [-121.9, 36.38737], [-121.8999, 36.38682], [-121.89994, 36.38646], [-121.90076, 36.38641], [-121.90098, 36.38732]]]} | Open Access 1 | 35237 | Unnamed site - Monterey, County of | 28641 | 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 | 2.104 | 0 | Local Other or Unknown 14 | 4 | ||
4640 | 4640 | 4639 | {"type": "Polygon", "coordinates": [[[-121.76878, 36.88577], [-121.76854, 36.88632], [-121.76869, 36.88648], [-121.76648, 36.88819], [-121.76471, 36.88798], [-121.7647, 36.88784], [-121.76557, 36.88755], [-121.76873, 36.88508], [-121.76878, 36.88577]]]} | No Public Access 3 | 36489 | Unnamed site - Monterey, County of | 28701 | 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 | 10.195 | 0 | Local Other or Unknown 14 | 4 | ||
4641 | 4641 | 4640 | {"type": "Polygon", "coordinates": [[[-121.75081, 36.90111], [-121.75066, 36.90121], [-121.75048, 36.90119], [-121.75054, 36.90103], [-121.75057, 36.90098], [-121.75061, 36.90096], [-121.75067, 36.90097], [-121.75081, 36.90111]]]} | Open Access 1 | 36490 | Unnamed site - Monterey, County of | 28641 | 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 | 0.126 | 0 | Local Other or Unknown 14 | 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]);