units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
214 rows where DES_TP = 14 and MNG_AG_TYP = 3 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY 20
- Butte, County of 52
- Santa Barbara, County of 39
- Lake, County of 36
- Orange, County of 21
- Monterey, County of 12
- Sacramento, County of 6
- Ventura, County of 5
- Santa Cruz, County of 4
- San Diego, County of 4
- Tulare, County of 3
- Riverside, County of 3
- Placer, County of 1
- San Bernardino, County of 1
- Napa, County of 1
- Yolo, County of 1
- Humboldt, County of 1
- Tehama, County of 1
- Trinity, County of 1
- Marin, County of 1
- Solano, County of 1
ACCESS_TYP 4
MNG_AG_TYP 1
- County Agency · 194 ✖
DES_TP 1
- Local Other or Unknown · 194 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
4650 | 4650 | 4649 | {"type": "Polygon", "coordinates": [[[-121.90096, 36.35309], [-121.89652, 36.35301], [-121.89685, 36.34938], [-121.89704, 36.34983], [-121.89728, 36.35025], [-121.89757, 36.35064], [-121.89782, 36.35091], [-121.89787, 36.35099], [-121.89789, 36.35107], [-121.89789, 36.35116], [-121.89776, 36.35145], [-121.89774, 36.35164], [-121.89779, 36.35183], [-121.89792, 36.352], [-121.89808, 36.35211], [-121.89827, 36.35217], [-121.89948, 36.35225], [-121.89969, 36.35229], [-121.89984, 36.35234], [-121.90001, 36.35241], [-121.90016, 36.3525], [-121.90057, 36.35287], [-121.90079, 36.35301], [-121.90096, 36.35309]]]} | Open Access 1 | 36548 | 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 | 13.341 | 0 | Local Other or Unknown 14 | 4 | ||
15457 | 15457 | 15456 | {"type": "Polygon", "coordinates": [[[-121.81456, 36.23949], [-121.81456, 36.24039], [-121.81229, 36.24037], [-121.81231, 36.23946], [-121.81456, 36.23949]]]} | Open Access 1 | 35231 | 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 | 5.03 | 0 | Local Other or Unknown 14 | 4 | ||
15461 | 15461 | 15460 | {"type": "Polygon", "coordinates": [[[-121.401, 35.84146], [-121.3966, 35.84156], [-121.39657, 35.83792], [-121.3984, 35.83787], [-121.39972, 35.83944], [-121.39983, 35.83955], [-121.39999, 35.83965], [-121.40016, 35.83973], [-121.40085, 35.83989], [-121.40098, 35.83997], [-121.40107, 35.84006], [-121.40114, 35.84019], [-121.40116, 35.84033], [-121.40111, 35.84059], [-121.40099, 35.84105], [-121.40098, 35.84124], [-121.401, 35.84146]]]} | Open Access 1 | 36551 | 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 | 31.36 | 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 | ||
15466 | 15466 | 15465 | {"type": "Polygon", "coordinates": [[[-121.34733, 35.79694], [-121.34424, 35.79863], [-121.34379, 35.79865], [-121.34383, 35.79529], [-121.34684, 35.79558], [-121.34699, 35.79641], [-121.34733, 35.79694]]]} | Open Access 1 | 36558 | 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 | 20.188 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
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 | ||
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 | ||
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 | ||
15476 | 15476 | 15475 | {"type": "Polygon", "coordinates": [[[-121.35212, 35.80298], [-121.34988, 35.80295], [-121.34903, 35.80124], [-121.34883, 35.80017], [-121.34817, 35.7994], [-121.34796, 35.79837], [-121.34807, 35.7977], [-121.34733, 35.79694], [-121.34699, 35.79641], [-121.34684, 35.79558], [-121.34813, 35.79558], [-121.34826, 35.79568], [-121.34862, 35.79567], [-121.34853, 35.79581], [-121.34868, 35.7961], [-121.34886, 35.79617], [-121.34903, 35.79615], [-121.34918, 35.79643], [-121.34927, 35.79657], [-121.34966, 35.79698], [-121.34969, 35.79726], [-121.34978, 35.7974], [-121.34993, 35.79754], [-121.35009, 35.79783], [-121.35028, 35.79793], [-121.35046, 35.79797], [-121.35042, 35.79814], [-121.35058, 35.79841], [-121.35062, 35.79855], [-121.35059, 35.79885], [-121.35056, 35.79897], [-121.35057, 35.79911], [-121.35065, 35.79925], [-121.35084, 35.79932], [-121.35101, 35.79933], [-121.35116, 35.79948], [-121.35134, 35.79961], [-121.35152, 35.79964], [-121.35187, 35.79961], [-121.35204, 35.79968], [-121.35205, 35.79982], [-121.35212, 35.80298]]]} | Open Access 1 | 36627 | 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 | 46.882 | 0 | Local Other or Unknown 14 | 4 | ||
3141 | 3141 | 3140 | {"type": "Polygon", "coordinates": [[[-122.22656, 38.37413], [-122.20765, 38.37399], [-122.20771, 38.35953], [-122.21237, 38.35957], [-122.21237, 38.36318], [-122.22173, 38.36325], [-122.22177, 38.36686], [-122.22646, 38.3669], [-122.22656, 38.37413]]]} | No Public Access 3 | 25801 | Milliken Reservoir Property | 22251 | 311 | Napa, County of 498 | County 3 | County Agency 3 | http://www.napaoutdoors.org/ | County 3 | 311 | Napa, County of 489 | County 3 | County Agency 3 | Napa 11 | 489.122 | Milliken Reservoir Property | 2000 | Local Other or Unknown 14 | 4 | |
392 | 392 | 391 | {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} | Open Access 1 | 35760 | Orange holding 14 | 23161 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.99 | Orange holding 14 | 0 | Local Other or Unknown 14 | 4 | |
393 | 393 | 392 | {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} | Open Access 1 | 35761 | Orange holding 15 | 23162 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.023 | Orange holding 15 | 0 | Local Other or Unknown 14 | 4 | |
3887 | 3887 | 3886 | {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} | Open Access 1 | 35755 | Orange holding 9 | 23176 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.436 | Orange holding 9 | 0 | Local Other or Unknown 14 | 4 | |
12496 | 12496 | 12495 | {"type": "Polygon", "coordinates": [[[-117.77687, 33.7649], [-117.77713, 33.76457], [-117.77646, 33.76411], [-117.77593, 33.76388], [-117.77537, 33.76368], [-117.77447, 33.76339], [-117.77528, 33.76258], [-117.77535, 33.76253], [-117.77543, 33.76254], [-117.77665, 33.76339], [-117.77667, 33.76338], [-117.77774, 33.76413], [-117.77775, 33.76416], [-117.77773, 33.7642], [-117.7774, 33.76452], [-117.77704, 33.76493], [-117.77697, 33.76495], [-117.77687, 33.7649]]]} | Open Access 1 | 36503 | Orange holding 19 | 23166 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 6.636 | Orange holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13370 | 13370 | 13369 | {"type": "Polygon", "coordinates": [[[-117.64456, 33.55733], [-117.64456, 33.55832], [-117.64446, 33.55917], [-117.64411, 33.55996], [-117.64407, 33.55994], [-117.64408, 33.55991], [-117.64401, 33.55988], [-117.64398, 33.55992], [-117.64392, 33.55989], [-117.64387, 33.55995], [-117.64407, 33.56004], [-117.64406, 33.56007], [-117.64384, 33.55998], [-117.64352, 33.55741], [-117.64456, 33.55733]]]} | Open Access 1 | 35454 | Orange holding 11 | 23158 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.148 | Orange holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13372 | 13372 | 13371 | {"type": "Polygon", "coordinates": [[[-117.63857, 33.57457], [-117.63787, 33.57431], [-117.63727, 33.57449], [-117.63726, 33.57438], [-117.63751, 33.574], [-117.63751, 33.57405], [-117.63754, 33.57408], [-117.63777, 33.57416], [-117.63788, 33.57415], [-117.63799, 33.57409], [-117.63806, 33.57413], [-117.63814, 33.57414], [-117.63825, 33.57418], [-117.63855, 33.57422], [-117.63857, 33.57457]]]} | Open Access 1 | 35456 | Orange holding 5 | 23172 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.869 | Orange holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13373 | 13373 | 13372 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57537], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | 35457 | Orange holding 6 | 23173 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.925 | Orange holding 6 | 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]);