superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 23 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES ▼ | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11869 | 11869 | 11868 | {"type": "Polygon", "coordinates": [[[-121.64339, 36.88847], [-121.64319, 36.88849], [-121.64313, 36.88847], [-121.6431, 36.88843], [-121.64306, 36.88816], [-121.64333, 36.88813], [-121.64339, 36.88847]]]} | Open Access 1 | Aromas Community Park | 28587 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 0.229 | Aromas Community Park | ||
5987 | 5987 | 5986 | {"type": "MultiPolygon", "coordinates": [[[[-121.90054, 36.60409], [-121.90047, 36.60429], [-121.90007, 36.60419], [-121.90015, 36.604], [-121.90054, 36.60409]]], [[[-121.90115, 36.60419], [-121.90106, 36.60443], [-121.90066, 36.60433], [-121.90075, 36.6041], [-121.90115, 36.60419]]]]} | Open Access 1 | Larkin Park | 21030 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 0.462 | Larkin Park | ||
5105 | 5105 | 5104 | {"type": "Polygon", "coordinates": [[[-121.24609, 36.32233], [-121.24567, 36.32256], [-121.24529, 36.32211], [-121.2457, 36.32188], [-121.24609, 36.32233]]]} | Open Access 1 | Hicks Park | 19900 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 0.672 | Hicks Park | ||
6045 | 6045 | 6044 | {"type": "Polygon", "coordinates": [[[-121.66142, 36.69671], [-121.66133, 36.69756], [-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 | Laurel Park | 21098 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 1.14 | Laurel Park | ||
4238 | 4238 | 4237 | {"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 | First Growth | 18915 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 2.843 | First Growth | ||
9864 | 9864 | 9863 | {"type": "MultiPolygon", "coordinates": [[[[-121.64783, 36.62502], [-121.64765, 36.62532], [-121.64599, 36.62469], [-121.64617, 36.62439], [-121.64783, 36.62502]]], [[[-121.64803, 36.62469], [-121.64785, 36.625], [-121.64619, 36.62436], [-121.64637, 36.62405], [-121.64803, 36.62469]]]]} | Open Access 1 | Spreckels Memorial Park | 25734 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 3.033 | Spreckels Memorial Park | ||
4174 | 4174 | 4173 | {"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.81198, 36.23945], [-121.81231, 36.23946]]]} | Unknown Access 4 | Falotico | 18839 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 3.056 | Falotico | ||
957 | 957 | 956 | {"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 | Kelton Park | 33591 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 3.333 | Kelton Park | ||
10289 | 10289 | 10288 | {"type": "MultiPolygon", "coordinates": [[[[-121.71069, 36.59096], [-121.71022, 36.59121], [-121.70993, 36.5914], [-121.70981, 36.59157], [-121.70983, 36.59175], [-121.71021, 36.59166], [-121.71022, 36.59169], [-121.70984, 36.59179], [-121.70983, 36.59181], [-121.71042, 36.59224], [-121.71029, 36.59238], [-121.71058, 36.59259], [-121.71055, 36.59262], [-121.71025, 36.5924], [-121.71016, 36.59247], [-121.70955, 36.59203], [-121.70937, 36.59205], [-121.70937, 36.59239], [-121.70933, 36.59239], [-121.70932, 36.59205], [-121.70925, 36.59204], [-121.70905, 36.59215], [-121.70863, 36.59263], [-121.70843, 36.59279], [-121.70833, 36.5927], [-121.70832, 36.59267], [-121.70834, 36.59264], [-121.70903, 36.59209], [-121.70948, 36.59163], [-121.70975, 36.5914], [-121.70997, 36.59125], [-121.7103, 36.59107], [-121.71061, 36.59094], [-121.71066, 36.59094], [-121.71069, 36.59096]]], [[[-121.75824, 36.76732], [-121.75755, 36.76792], [-121.75679, 36.76735], [-121.75748, 36.76675], [-121.75824, 36.76732]]]]} | Open Access 1 | 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 | 3.952 | |||
11570 | 11570 | 11569 | {"type": "Polygon", "coordinates": [[[-121.75315, 36.90224], [-121.75183, 36.90359], [-121.75152, 36.9037], [-121.75165, 36.90351], [-121.75167, 36.90345], [-121.75166, 36.90338], [-121.75163, 36.90333], [-121.75133, 36.90298], [-121.75119, 36.90276], [-121.75111, 36.90261], [-121.75226, 36.90162], [-121.75315, 36.90224]]]} | Open Access 1 | Pajaro Neighborhood Park | http://www.co.monterey.ca.us/planning/docs/eirs/Pajaro%20Neighborhood%20Park/11%20-%20Figures.pdf | 28072 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 4.873 | Pajaro Neighborhood Park | |
3944 | 3944 | 3943 | {"type": "Polygon", "coordinates": [[[-121.74481, 36.84148], [-121.74245, 36.84316], [-121.74184, 36.84299], [-121.74342, 36.84161], [-121.74317, 36.84141], [-121.74385, 36.84096], [-121.74425, 36.84118], [-121.74481, 36.84148]]]} | Open Access 1 | Elkhorn Slough | 18570 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 5.161 | Elkhorn Slough | ||
3251 | 3251 | 3250 | {"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 | County Park | 17715 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 6.296 | County Park | ||
7147 | 7147 | 7146 | {"type": "MultiPolygon", "coordinates": [[[[-121.62949, 36.69255], [-121.62807, 36.69314], [-121.62759, 36.69261], [-121.62828, 36.69163], [-121.62949, 36.69255]]], [[[-121.63889, 36.69555], [-121.63869, 36.6957], [-121.63826, 36.69613], [-121.63693, 36.69582], [-121.63739, 36.69534], [-121.63679, 36.69491], [-121.63689, 36.69488], [-121.63697, 36.69493], [-121.63754, 36.69473], [-121.63767, 36.69474], [-121.63889, 36.69555]]]]} | Open Access 1 | Monterey County Cemetery | 22419 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 7.406 | Monterey County Cemetery | ||
14927 | 14927 | 14926 | {"type": "Polygon", "coordinates": [[[-121.91447, 36.40305], [-121.91245, 36.40298], [-121.90908, 36.40296], [-121.90857, 36.40259], [-121.90933, 36.40276], [-121.91028, 36.40253], [-121.91086, 36.40245], [-121.9112, 36.4013], [-121.91124, 36.40129], [-121.91126, 36.40127], [-121.91128, 36.40122], [-121.91128, 36.40113], [-121.91136, 36.40097], [-121.91139, 36.40085], [-121.91139, 36.40066], [-121.91143, 36.40062], [-121.91148, 36.40063], [-121.91154, 36.40079], [-121.91158, 36.40081], [-121.91164, 36.40081], [-121.91168, 36.40078], [-121.91169, 36.40075], [-121.9116, 36.40068], [-121.9116, 36.40063], [-121.91168, 36.40056], [-121.91181, 36.40052], [-121.91187, 36.40053], [-121.91188, 36.40056], [-121.9118, 36.40075], [-121.91178, 36.40089], [-121.9118, 36.40092], [-121.91183, 36.40092], [-121.91186, 36.4009], [-121.91186, 36.40081], [-121.91191, 36.40073], [-121.91204, 36.40065], [-121.91213, 36.40064], [-121.91221, 36.40065], [-121.91228, 36.4007], [-121.91232, 36.40076], [-121.91235, 36.40101], [-121.91234, 36.40105], [-121.9123, 36.40108], [-121.91216, 36.40106], [-121.91203, 36.40108], [-121.91199, 36.40115], [-121.91197, 36.40125], [-121.91201, 36.40128], [-121.91208, 36.40127], [-121.91217, 36.40128], [-121.91227, 36.40134], [-121.9123, 36.40141], [-121.91232, 36.40157], [-121.91237, 36.40169], [-121.91169, 36.40201], [-121.91129, 36.40227], [-121.91129, 36.40229], [-121.91144, 36.40242], [-121.91154, 36.40263], [-121.9119, 36.40267], [-121.91199, 36.40274], [-121.91216, 36.40292], [-121.91246, 36.40263], [-121.913, 36.40236], [-121.91303, 36.40247], [-121.91302, 36.40265], [-121.91309, 36.40289], [-121.91313, 36.40293], [-121.91321, 36.40294], [-121.9133, 36.40287], [-121.91336, 36.40278], [-121.91339, 36.40266], [-121.91334, 36.40258], [-121.91344, 36.40252], [-121.91347, 36.4024], [-121.9135, 36.40238], [-121.91354, 36.40238], [-121.91362, 36.40254], [-121.91366, 36.40256], [-121.91369, 36.40254], [-121.91365, 36.40235], [-121.91366, 36.40219], [-121.91369, 36.40215], [-121.91375, 36.40214], [-121.9138, 36.40217], [-121.91386, 36.40229], [-121.91389, 36.40242], [-121.91388, 36.40253], [-121.91386, 36.40258], [-121.91383, 36.40261], [-121.91366, 36.40263], [-121.91364, 36.40266], [-121.91365, 36.40269], [-121.91376, 36.40271], [-121.91383, 36.40274], [-121.91394, 36.40276], [-121.91404, 36.40279], [-121.91416, 36.40278], [-121.9143, 36.40281], [-121.91437, 36.40285], [-121.91443, 36.4029], [-121.91447, 36.40305]]]} | Open Access 1 | Rocky Point Open Space | 24545 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 8.894 | Rocky Point OS | ||
14311 | 14311 | 14310 | {"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 | 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 | 10.196 | |||
4092 | 4092 | 4091 | {"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.61869, 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.0894], [-121.61862, 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 | Evans Park | 18752 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 10.332 | Evans Park | ||
8814 | 8814 | 8813 | {"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.54213], [-121.86807, 36.5408], [-121.86878, 36.54061], [-121.8696, 36.54123]]]} | Open Access 1 | Roach Canyon Park | 24474 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 15.005 | Roach Canyon Park | ||
15080 | 15080 | 15079 | {"type": "MultiPolygon", "coordinates": [[[[-121.72109, 36.49067], [-121.72044, 36.49119], [-121.72042, 36.49117], [-121.72107, 36.49065], [-121.72109, 36.49067]]], [[[-121.72883, 36.47453], [-121.72871, 36.47454], [-121.72855, 36.47436], [-121.72855, 36.47425], [-121.72883, 36.47453]]], [[[-121.73601, 36.4765], [-121.73588, 36.47648], [-121.73573, 36.47649], [-121.73524, 36.47665], [-121.73509, 36.47668], [-121.73497, 36.47668], [-121.73488, 36.47667], [-121.73493, 36.47654], [-121.73492, 36.47653], [-121.73462, 36.47648], [-121.7341, 36.47648], [-121.73393, 36.47633], [-121.73366, 36.476], [-121.73328, 36.47561], [-121.73308, 36.47549], [-121.73283, 36.4754], [-121.73253, 36.47547], [-121.73226, 36.47545], [-121.73306, 36.47396], [-121.73378, 36.47533], [-121.73601, 36.4765]]], [[[-121.76813, 36.50991], [-121.76779, 36.51032], [-121.7668, 36.51017], [-121.76648, 36.51027], [-121.76642, 36.51027], [-121.7662, 36.51023], [-121.76592, 36.51013], [-121.76578, 36.51003], [-121.76561, 36.50977], [-121.7651, 36.50951], [-121.76474, 36.50961], [-121.76444, 36.50934], [-121.76414, 36.50899], [-121.76416, 36.50882], [-121.76393, 36.50863], [-121.76369, 36.508], [-121.76361, 36.50791], [-121.7635, 36.50763], [-121.76345, 36.50736], [-121.7633, 36.50706], [-121.76313, 36.50656], [-121.76286, 36.50603], [-121.76273, 36.50588], [-121.76248, 36.50537], [-121.76294, 36.5059], [-121.76314, 36.50586], [-121.76317, 36.50601], [-121.76334, 36.506], [-121.7634, 36.50639], [-121.76352, 36.50685], [-121.76366, 36.50723], [-121.76385, 36.5076], [-121.76412, 36.50802], [-121.76439, 36.50835], [-121.76469, 36.50866], [-121.76503, 36.50894], [-121.76532, 36.50916], [-121.76566, 36.50937], [-121.76813, 36.50991]]]]} | Open Access 1 | Garland Ranch Regional Park | 19222 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 15.288 | Garland Ranch RP | ||
3167 | 3167 | 3166 | {"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 | Constitution Soccer Complex | 17603 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 19.337 | Constitution Soccer Complex | ||
10786 | 10786 | 10785 | {"type": "Polygon", "coordinates": [[[-121.65535, 36.14492], [-121.65525, 36.14864], [-121.65386, 36.14763], [-121.65385, 36.14752], [-121.65399, 36.14735], [-121.65389, 36.14607], [-121.65374, 36.14584], [-121.65341, 36.14576], [-121.65314, 36.14575], [-121.65293, 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.65079, 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.65169, 36.14305], [-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.14345], [-121.65332, 36.14351], [-121.65359, 36.14366], [-121.65385, 36.14418], [-121.65378, 36.1444], [-121.65365, 36.1441], [-121.65331, 36.14395], [-121.65324, 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 | Veren Park | 26993 | 310 | Monterey, County of 23 | County 3 | County Agency 3 | http://www.co.monterey.ca.us/parks/ | County 3 | 28.056 | Veren Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);