units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
46 rows where AGNCY_TYP = 3 and MNG_AGENCY = 23 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | ||
13926 | 13926 | 13925 | {"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 | 36553 | Aromas Community Park | 28587 | 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.23 | Aromas Community Park | 0 | Local Park 2 | 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 | ||
12081 | 12081 | 12080 | {"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 | 24867 | Larkin Park | 21030 | 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.462 | Larkin Park | 0 | Local Park 2 | 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 | ||
5120 | 5120 | 5119 | {"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 | 16856 | Hicks Park | 19900 | 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.672 | Hicks 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 | ||
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 | |
15473 | 15473 | 15472 | {"type": "Polygon", "coordinates": [[[-121.7617, 36.22543], [-121.76139, 36.22544], [-121.76115, 36.22548], [-121.76088, 36.22556], [-121.76062, 36.22567], [-121.76046, 36.22533], [-121.76054, 36.22531], [-121.76059, 36.22526], [-121.7606, 36.22514], [-121.76067, 36.225], [-121.76074, 36.22495], [-121.76083, 36.22494], [-121.7609, 36.22496], [-121.76142, 36.22518], [-121.76151, 36.2252], [-121.7616, 36.22518], [-121.7617, 36.22543]]]} | Open Access 1 | 36574 | 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.192 | 0 | Local Other or Unknown 14 | 4 | ||
15464 | 15464 | 15463 | {"type": "Polygon", "coordinates": [[[-121.71069, 36.59096], [-121.71022, 36.59121], [-121.70993, 36.5914], [-121.70981, 36.59157], [-121.70982, 36.59176], [-121.71021, 36.59166], [-121.71022, 36.59169], [-121.70983, 36.59179], [-121.70983, 36.59181], [-121.71042, 36.59224], [-121.71028, 36.59237], [-121.71058, 36.59259], [-121.71055, 36.59262], [-121.71025, 36.5924], [-121.71016, 36.59247], [-121.70955, 36.59203], [-121.70937, 36.59204], [-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]]]} | Open Access 1 | 36556 | 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 | 1.854 | 0 | Local Other or Unknown 14 | 4 | ||
15471 | 15471 | 15470 | {"type": "Polygon", "coordinates": [[[-121.90419, 36.38901], [-121.90287, 36.3893], [-121.90271, 36.38876], [-121.90415, 36.38841], [-121.90417, 36.38847], [-121.90417, 36.38854], [-121.90413, 36.38869], [-121.90414, 36.38878], [-121.90419, 36.38896], [-121.90419, 36.38901]]]} | Open Access 1 | 36572 | 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.999 | 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 | ||
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 | ||
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 | |||
15468 | 15468 | 15467 | {"type": "Polygon", "coordinates": [[[-121.62098, 36.09595], [-121.62085, 36.09623], [-121.61957, 36.09614], [-121.6195, 36.0954], [-121.62088, 36.09525], [-121.62077, 36.09561], [-121.62098, 36.09595]]]} | Open Access 1 | 36560 | 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.843 | 0 | Local Other or Unknown 14 | 4 | ||
5017 | 5017 | 5016 | {"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 | 1035 | Spreckels Memorial Park | 25734 | 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.034 | Spreckels Memorial Park | 0 | Local Park 2 | 4 | |
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 | |||
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 | |
15472 | 15472 | 15471 | {"type": "Polygon", "coordinates": [[[-121.6933, 36.61264], [-121.6929, 36.61307], [-121.6923, 36.6138], [-121.69151, 36.61351], [-121.6914, 36.6137], [-121.69117, 36.61361], [-121.69156, 36.61257], [-121.69193, 36.61264], [-121.69221, 36.61237], [-121.69266, 36.61244], [-121.69285, 36.61242], [-121.69303, 36.61237], [-121.69314, 36.61254], [-121.6933, 36.61264]]]} | Open Access 1 | 36573 | 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 | 4.43 | 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]);