units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1,190 rows where DES_TP = 14 sorted by AGNCY_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Mountains Recreation and Conservation Authority 132
- Ventura, City of 106
- Butte, County of 52
- Yuba County Water Agency 48
- Roseville, City of 46
- Santa Barbara, County of 39
- Lake, County of 36
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Orange, County of 21
- Napa, City of 21
- Monterey, County of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Los Angeles County Flood Control District 13
- Santa Cruz, City of 12
- Santa Barbara Flood Control and Water Conserv. District 12
- Oroville, City of 12
- Los Angeles, County of 11
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Santa Maria, City of 9
- Escondido, City of 9
- …
MNG_AG_TYP 15
- City Agency 663
- County Agency 214
- Open Space District 135
- Water District 78
- Flood District 32
- Recreation/Parks District 28
- County Agency - Other 6
- Irrigation District 4
- Sanitation District 3
- Community Services District 2
- County Agency - Parks 1
- Special District - Other 1
- Metropolitan Planning Organization 1
- Conservation District 1
- Transportation Agency 1
ACCESS_TYP 4
- Open Access 849
- Unknown Access 194
- No Public Access 96
- Restricted Access 31
DES_TP 1
- Local Other or Unknown · 1,170 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15516 | 15516 | 15515 | {"type": "MultiPolygon", "coordinates": [[[[-118.32788, 34.25114], [-118.32274, 34.2498], [-118.32247, 34.24892], [-118.32243, 34.24892], [-118.32214, 34.24798], [-118.32193, 34.24741], [-118.32174, 34.24699], [-118.32152, 34.24658], [-118.3211, 34.24592], [-118.32081, 34.24554], [-118.32051, 34.24517], [-118.32018, 34.24482], [-118.31982, 34.24448], [-118.31945, 34.24416], [-118.31906, 34.24385], [-118.31864, 34.24356], [-118.31808, 34.24321], [-118.31762, 34.24296], [-118.317, 34.24267], [-118.31652, 34.24247], [-118.31585, 34.24224], [-118.315, 34.24201], [-118.31212, 34.2414], [-118.31148, 34.24125], [-118.31101, 34.24111], [-118.31055, 34.24095], [-118.3101, 34.24077], [-118.30966, 34.24057], [-118.30896, 34.24019], [-118.3083, 34.23977], [-118.30374, 34.23646], [-118.30332, 34.23618], [-118.30289, 34.23591], [-118.30244, 34.23566], [-118.30198, 34.23543], [-118.30152, 34.23523], [-118.30087, 34.23499], [-118.30019, 34.23478], [-118.2996, 34.23463], [-118.2989, 34.2345], [-118.29819, 34.23441], [-118.29765, 34.23437], [-118.29693, 34.23435], [-118.29623, 34.23437], [-118.2962, 34.2339], [-118.29657, 34.23322], [-118.29648, 34.23295], [-118.29674, 34.2329], [-118.29728, 34.23289], [-118.29747, 34.23286], [-118.29763, 34.23282], [-118.29824, 34.23261], [-118.2986, 34.23263], [-118.29898, 34.23269], [-118.2993, 34.23277], [-118.2997, 34.23291], [-118.3001, 34.23309], [-118.3003, 34.23316], [-118.30163, 34.23351], [-118.30227, 34.23364], [-118.30351, 34.23379], [-118.30382, 34.23387], [-118.30402, 34.23394], [-118.30418, 34.23403], [-118.30515, 34.2347], [-118.30533, 34.2348], [-118.30569, 34.23494], [-118.30608, 34.23501], [-118.30641, 34.23501], [-118.30674, 34.23496], [-118.307, 34.23488], [-118.30749, 34.23467], [-118.30766, 34.23463], [-118.31037, 34.23445], [-118.31057, 34.23439], [-118.31098, 34.23419], [-118.31116, 34.23415], [-118.31135, 34.23416], [-118.31289, 34.23452], [-118.31307, 34.23452], [-118.31358, 34.23445], [-118.31375, 34.23446], [-118.31383, 34.23448], [-118.31383, 34.23581], [-118.31381, 34.23755], [-118.3198, 34.23758], [-118.31981, 34.23711], [-118.32024, 34.23729], [-118.32023, 34.23766], [-118.31938, 34.23839], [-118.31912, 34.23875], [-118.31955, 34.23953], [-118.32114, 34.23952], [-118.32237, 34.24026], [-118.32233, 34.24325], [-118.32411, 34.2432], [-118.32788, 34.25114]]], [[[-118.31383, 34.23431], [-118.31357, 34.23429], [-118.31305, 34.23435], [-118.3129, 34.23435], [-118.31139, 34.234], [-118.31115, 34.23399], [-118.31089, 34.23404], [-118.31048, 34.23424], [-118.31033, 34.23428], [-118.30762, 34.23446], [-118.30741, 34.23452], [-118.30691, 34.23473], [-118.30671, 34.23479], [-118.30642, 34.23484], [-118.30615, 34.23485], [-118.30578, 34.23479], [-118.30543, 34.23466], [-118.30528, 34.23457], [-118.30432, 34.23391], [-118.30407, 34.23378], [-118.3045, 34.23382], [-118.30494, 34.2338], [-118.30523, 34.23376], [-118.30632, 34.23354], [-118.30675, 34.2335], [-118.30719, 34.23352], [-118.30817, 34.23368], [-118.30847, 34.2337], [-118.30883, 34.23369], [-118.30913, 34.23366], [-118.30942, 34.2336], [-118.31019, 34.2334], [-118.31044, 34.23334], [-118.31074, 34.23331], [-118.31109, 34.23331], [-118.31157, 34.23338], [-118.31215, 34.23354], [-118.3125, 34.23362], [-118.31346, 34.23371], [-118.31383, 34.23378], [-118.31383, 34.23431]]], [[[-118.32181, 34.24954], [-118.32023, 34.24912], [-118.32023, 34.24885], [-118.31914, 34.24884], [-118.31477, 34.24768], [-118.31483, 34.24349], [-118.31371, 34.24354], [-118.31366, 34.24739], [-118.31147, 34.2468], [-118.31149, 34.24357], [-118.30931, 34.24364], [-118.3093, 34.24484], [-118.30829, 34.24484], [-118.30829, 34.24596], [-118.30491, 34.24506], [-118.30492, 34.24378], [-118.30503, 34.24377], [-118.30502, 34.24296], [-118.30556, 34.24288], [-118.30665, 34.24141], [-118.3061, 34.24015], [-118.30692, 34.2396], [-118.30796, 34.24034], [-118.30853, 34.2407], [-118.30929, 34.2411], [-118.31008, 34.24145], [-118.31091, 34.24174], [-118.3116, 34.24192], [-118.31467, 34.24257], [-118.31546, 34.24278], [-118.31608, 34.24299], [-118.31668, 34.24323], [-118.31722, 34.24349], [-118.31778, 34.2438], [-118.31818, 34.24405], [-118.31856, 34.24432], [-118.31892, 34.2446], [-118.31927, 34.2449], [-118.3196, 34.24521], [-118.3199, 34.24554], [-118.32019, 34.24588], [-118.32045, 34.24624], [-118.32069, 34.2466], [-118.32091, 34.24697], [-118.32122, 34.24762], [-118.32142, 34.24814], [-118.32171, 34.24907], [-118.32167, 34.24909], [-118.32181, 34.24954]]], [[[-118.30829, 34.24639], [-118.30829, 34.24709], [-118.30809, 34.24704], [-118.30747, 34.2467], [-118.30743, 34.24663], [-118.30739, 34.24634], [-118.30736, 34.24627], [-118.30728, 34.24618], [-118.30716, 34.24613], [-118.30707, 34.24612], [-118.30698, 34.24614], [-118.30615, 34.24647], [-118.30606, 34.24651], [-118.30591, 34.24663], [-118.30534, 34.24562], [-118.30829, 34.24639]]], [[[-118.30725, 34.24657], [-118.3072, 34.24639], [-118.3072, 34.24639], [-118.30723, 34.24639], [-118.30725, 34.24657]]], [[[-118.31366, 34.24782], [-118.31365, 34.24835], [-118.31337, 34.24831], [-118.31268, 34.24835], [-118.31256, 34.24832], [-118.31245, 34.24826], [-118.31261, 34.24754], [-118.31366, 34.24782]]], [[[-118.31743, 34.24883], [-118.31475, 34.24882], [-118.31476, 34.24811], [-118.31476, 34.24811], [-118.31743, 34.24883]]], [[[-118.32258, 34.25247], [-118.32018, 34.25246], [-118.32023, 34.24955], [-118.32195, 34.25001], [-118.32237, 34.25136], [-118.32258, 34.25192], [-118.32258, 34.25247]]], [[[-118.32851, 34.25262], [-118.32832, 34.25597], [-118.32778, 34.25641], [-118.32748, 34.25627], [-118.32733, 34.25616], [-118.32721, 34.25603], [-118.32672, 34.25592], [-118.32647, 34.25565], [-118.32649, 34.25532], [-118.32629, 34.25541], [-118.32623, 34.25541], [-118.32616, 34.25533], [-118.32665, 34.25502], [-118.3269, 34.25475], [-118.3272, 34.25454], [-118.3281, 34.254], [-118.32798, 34.2536], [-118.32812, 34.25287], [-118.32776, 34.25256], [-118.32709, 34.25239], [-118.32678, 34.25225], [-118.32659, 34.25202], [-118.32646, 34.25156], [-118.32619, 34.25128], [-118.32592, 34.25118], [-118.32529, 34.25124], [-118.32518, 34.25131], [-118.32498, 34.25174], [-118.32479, 34.25207], [-118.32461, 34.25251], [-118.32433, 34.25283], [-118.32486, 34.25394], [-118.32485, 34.25396], [-118.32449, 34.25355], [-118.32413, 34.25309], [-118.32389, 34.25272], [-118.32361, 34.25222], [-118.32342, 34.25184], [-118.32326, 34.25145], [-118.32289, 34.25027], [-118.32805, 34.25162], [-118.32851, 34.25262]]]]} | Unknown Access 4 | 46477 | Unnamed site - Desert and Mountain Conservation Authority | 29750 | 235 | Desert and Mountain Conservation Authority 713 | State 5 | State Agency 5 | http://www.dmca.ca.gov/ | Other State 5 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 570.486 | 0 | Local Other or Unknown 14 | 4 | ||
4828 | 4828 | 4827 | {"type": "MultiPolygon", "coordinates": [[[[-114.72351, 33.36382], [-114.72351, 33.36382], [-114.72214, 33.36582], [-114.7221, 33.36382], [-114.72351, 33.36382]]], [[[-114.73058, 33.37111], [-114.72656, 33.37111], [-114.7265, 33.36719], [-114.72216, 33.36718], [-114.72215, 33.36635], [-114.72389, 33.36382], [-114.73052, 33.36382], [-114.73058, 33.37111]]], [[[-114.73064, 33.37842], [-114.72848, 33.37842], [-114.72845, 33.3749], [-114.73062, 33.3749], [-114.73064, 33.37842]]], [[[-114.74359, 33.38218], [-114.74357, 33.38602], [-114.73924, 33.38605], [-114.73926, 33.38223], [-114.74359, 33.38218]]], [[[-114.75277, 33.39501], [-114.75277, 33.39725], [-114.75115, 33.39723], [-114.75114, 33.39677], [-114.74792, 33.39672], [-114.74793, 33.39445], [-114.75061, 33.39452], [-114.75062, 33.39407], [-114.75223, 33.39411], [-114.75223, 33.395], [-114.75277, 33.39501]]]]} | Open Access 1 | 49012 | Unnamed Site - Imperial, County of | 33710 | 302 | Imperial, County of 348 | County 3 | County Agency 3 | http://www.icpds.com/?pid=1048 | County 3 | 302 | Imperial, County of 345 | County 3 | County Agency 3 | Imperial 20 | 202.814 | 0 | Local Other or Unknown 14 | 4 | ||
472 | 472 | 471 | {"type": "Polygon", "coordinates": [[[-118.60788, 34.06942], [-118.60718, 34.06977], [-118.60688, 34.06935], [-118.60758, 34.069], [-118.60788, 34.06942]]]} | Open Access 1 | 35762 | Los Angeles holding 8 | 21495 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.024 | Los Angeles holding 8 | 0 | Local Other or Unknown 14 | 4 | |
3454 | 3454 | 3453 | {"type": "Polygon", "coordinates": [[[-118.63309, 34.12589], [-118.63308, 34.12624], [-118.63243, 34.12624], [-118.63244, 34.12598], [-118.63309, 34.12589]]]} | Open Access 1 | 35562 | Los Angeles holding 5 | 21492 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.502 | Los Angeles holding 5 | 0 | Local Other or Unknown 14 | 4 | |
4613 | 4613 | 4612 | {"type": "Polygon", "coordinates": [[[-118.63997, 34.08326], [-118.63997, 34.08356], [-118.63947, 34.08386], [-118.6392, 34.08385], [-118.63897, 34.08343], [-118.63935, 34.08326], [-118.63997, 34.08326]]]} | No Public Access 3 | 35763 | Unnamed site - Los Angeles County Waterworks | 30320 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.128 | 0 | Local Other or Unknown 14 | 4 | ||
4694 | 4694 | 4693 | {"type": "Polygon", "coordinates": [[[-117.90308, 34.64234], [-117.90298, 34.64592], [-117.89442, 34.64592], [-117.89406, 34.64594], [-117.89415, 34.64234], [-117.89864, 34.64232], [-117.90308, 34.64234]]]} | Restricted Access 2 | 45942 | Unnamed site - Los Angeles, County of | 29046 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 80.519 | 0 | Local Other or Unknown 14 | 4 | ||
13374 | 13374 | 13373 | {"type": "Polygon", "coordinates": [[[-118.16425, 34.20803], [-118.16421, 34.20806], [-118.16415, 34.20814], [-118.16402, 34.20843], [-118.16389, 34.20862], [-118.1638, 34.2087], [-118.16379, 34.20873], [-118.16361, 34.20889], [-118.1632, 34.20918], [-118.16302, 34.20934], [-118.16295, 34.20945], [-118.16292, 34.20946], [-118.16283, 34.20965], [-118.16273, 34.20979], [-118.16243, 34.21008], [-118.16238, 34.21009], [-118.1623, 34.21009], [-118.1622, 34.21004], [-118.16216, 34.20998], [-118.16216, 34.20979], [-118.16218, 34.2096], [-118.16225, 34.20936], [-118.16241, 34.20908], [-118.16248, 34.20891], [-118.16251, 34.20874], [-118.1625, 34.20838], [-118.16293, 34.208], [-118.16425, 34.20803]]]} | Open Access 1 | 35458 | Los Angeles holding 6 | 21493 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 5.183 | Los Angeles holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13458 | 13458 | 13457 | {"type": "Polygon", "coordinates": [[[-118.16322, 34.20967], [-118.16308, 34.21031], [-118.16183, 34.21032], [-118.1618, 34.20908], [-118.16226, 34.2091], [-118.16218, 34.20921], [-118.16211, 34.20936], [-118.16205, 34.20959], [-118.16203, 34.20973], [-118.16203, 34.21], [-118.16209, 34.2101], [-118.1622, 34.21018], [-118.16229, 34.2102], [-118.1624, 34.2102], [-118.16254, 34.21015], [-118.16284, 34.20986], [-118.16294, 34.20972], [-118.16298, 34.20963], [-118.16322, 34.20967]]]} | Open Access 1 | 35757 | Los Angeles holding 7 | 21494 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.731 | Los Angeles holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13480 | 13480 | 13479 | {"type": "Polygon", "coordinates": [[[-118.61573, 34.06931], [-118.61507, 34.06932], [-118.61506, 34.06843], [-118.61534, 34.06856], [-118.6155, 34.0687], [-118.61554, 34.06878], [-118.61559, 34.06896], [-118.61573, 34.06931]]]} | Open Access 1 | 35764 | Los Angeles holding 10 | 21485 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 1.032 | Los Angeles holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13481 | 13481 | 13480 | {"type": "Polygon", "coordinates": [[[-118.16406, 34.20859], [-118.16399, 34.20877], [-118.16379, 34.20908], [-118.16333, 34.20952], [-118.16322, 34.20967], [-118.16298, 34.20963], [-118.16307, 34.20948], [-118.16318, 34.20935], [-118.16368, 34.20899], [-118.16383, 34.20886], [-118.16406, 34.20859]]]} | Open Access 1 | 35765 | Los Angeles holding 11 | 21486 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.54 | Los Angeles holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13488 | 13488 | 13487 | {"type": "Polygon", "coordinates": [[[-118.65013, 34.12534], [-118.65007, 34.12907], [-118.64741, 34.12906], [-118.64738, 34.12533], [-118.65013, 34.12534]]]} | Open Access 1 | 35773 | Los Angeles holding 4 | 21491 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 25.539 | Los Angeles holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13489 | 13489 | 13488 | {"type": "Polygon", "coordinates": [[[-118.64802, 34.12172], [-118.64795, 34.12533], [-118.64416, 34.12532], [-118.64422, 34.1217], [-118.64802, 34.12172]]]} | Open Access 1 | 35774 | Los Angeles holding 3 | 21489 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 34.755 | Los Angeles holding 3 | 0 | Local Other or Unknown 14 | 4 | |
15525 | 15525 | 15524 | {"type": "MultiPolygon", "coordinates": [[[[-118.58035, 34.11227], [-118.58025, 34.11227], [-118.58023, 34.11233], [-118.5802, 34.11236], [-118.57999, 34.11236], [-118.57998, 34.1123], [-118.57991, 34.1123], [-118.57991, 34.11249], [-118.58008, 34.1125], [-118.58007, 34.11255], [-118.58003, 34.11259], [-118.57985, 34.11268], [-118.57972, 34.1127], [-118.57972, 34.11257], [-118.57977, 34.11256], [-118.57977, 34.11244], [-118.57971, 34.11243], [-118.57971, 34.11257], [-118.57964, 34.11258], [-118.57964, 34.11271], [-118.57943, 34.11282], [-118.57933, 34.11284], [-118.57928, 34.11288], [-118.57925, 34.11295], [-118.57926, 34.11309], [-118.57916, 34.11312], [-118.579, 34.11312], [-118.57899, 34.11299], [-118.57892, 34.11298], [-118.57891, 34.11312], [-118.57885, 34.11312], [-118.57885, 34.11202], [-118.57916, 34.11202], [-118.57916, 34.11216], [-118.57908, 34.11217], [-118.57908, 34.11243], [-118.57916, 34.11243], [-118.57916, 34.11256], [-118.57924, 34.11257], [-118.57925, 34.11271], [-118.57931, 34.1127], [-118.57931, 34.11257], [-118.57938, 34.11257], [-118.57938, 34.1127], [-118.5795, 34.11271], [-118.57951, 34.11257], [-118.57964, 34.11256], [-118.57964, 34.11244], [-118.57951, 34.11243], [-118.57951, 34.1123], [-118.5797, 34.11229], [-118.57971, 34.11217], [-118.57938, 34.11216], [-118.57938, 34.11202], [-118.57957, 34.11202], [-118.57957, 34.1119], [-118.5797, 34.11193], [-118.57971, 34.11188], [-118.5799, 34.11187], [-118.5799, 34.11175], [-118.57931, 34.11175], [-118.5793, 34.11168], [-118.57912, 34.11168], [-118.57911, 34.11169], [-118.57912, 34.11173], [-118.57899, 34.11175], [-118.57885, 34.11175], [-118.57885, 34.11147], [-118.57901, 34.11148], [-118.57915, 34.11158], [-118.57931, 34.11152], [-118.57932, 34.11161], [-118.58015, 34.11161], [-118.58015, 34.11175], [-118.58007, 34.11175], [-118.58007, 34.11187], [-118.5803, 34.11188], [-118.58035, 34.11227]], [[-118.579, 34.11272], [-118.57891, 34.11271], [-118.57892, 34.11284], [-118.57899, 34.11284], [-118.579, 34.11272]], [[-118.57916, 34.11258], [-118.579, 34.11257], [-118.579, 34.1127], [-118.57916, 34.11271], [-118.57916, 34.11258]], [[-118.57983, 34.11229], [-118.57984, 34.11216], [-118.57978, 34.11216], [-118.57977, 34.11229], [-118.57983, 34.11229]], [[-118.58022, 34.11223], [-118.58023, 34.11221], [-118.58019, 34.11216], [-118.57999, 34.11217], [-118.57999, 34.11223], [-118.58022, 34.11223]]], [[[-118.58574, 34.11329], [-118.58526, 34.11347], [-118.58507, 34.11332], [-118.58499, 34.11339], [-118.58492, 34.11326], [-118.5852, 34.11315], [-118.58516, 34.11301], [-118.58496, 34.11305], [-118.58495, 34.11302], [-118.58481, 34.11305], [-118.58481, 34.11307], [-118.58489, 34.11321], [-118.58454, 34.1133], [-118.58457, 34.11338], [-118.58413, 34.11356], [-118.58427, 34.11384], [-118.58405, 34.11393], [-118.58396, 34.11362], [-118.58362, 34.11375], [-118.58369, 34.1139], [-118.58377, 34.11388], [-118.58384, 34.11401], [-118.58362, 34.11409], [-118.58355, 34.11396], [-118.58339, 34.11402], [-118.5833, 34.11386], [-118.58265, 34.11411], [-118.58262, 34.11388], [-118.58282, 34.11368], [-118.5827, 34.1136], [-118.58259, 34.11371], [-118.58255, 34.11351], [-118.58293, 34.1134], [-118.58284, 34.11315], [-118.5825, 34.11323], [-118.58239, 34.11258], [-118.58372, 34.1124], [-118.58372, 34.11236], [-118.58384, 34.11234], [-118.58387, 34.11239], [-118.58425, 34.1123], [-118.58425, 34.11227], [-118.58546, 34.11206], [-118.58565, 34.11259], [-118.58547, 34.11264], [-118.58553, 34.11284], [-118.58534, 34.1129], [-118.58541, 34.11307], [-118.58558, 34.113], [-118.58574, 34.11329]], [[-118.58331, 34.11326], [-118.58315, 34.11329], [-118.58315, 34.11346], [-118.58336, 34.11341], [-118.58331, 34.11326]], [[-118.58283, 34.11252], [-118.58263, 34.11257], [-118.58275, 34.11288], [-118.58293, 34.11283], [-118.58283, 34.11252]]], [[[-118.58782, 34.11394], [-118.58771, 34.11406], [-118.58766, 34.1142], [-118.58761, 34.11415], [-118.58735, 34.11428], [-118.58719, 34.11408], [-118.58743, 34.11396], [-118.58737, 34.11387], [-118.58769, 34.1137], [-118.5878, 34.11385], [-118.58777, 34.11387], [-118.58782, 34.11394]]], [[[-118.57951, 34.11422], [-118.57926, 34.11422], [-118.57932, 34.11415], [-118.57932, 34.11395], [-118.57951, 34.11395], [-118.57951, 34.11422]]], [[[-118.58057, 34.11409], [-118.58044, 34.11409], [-118.58044, 34.11422], [-118.58037, 34.11423], [-118.58037, 34.11436], [-118.58024, 34.11436], [-118.58024, 34.11396], [-118.58016, 34.11395], [-118.58015, 34.11381], [-118.58008, 34.11381], [-118.58007, 34.11395], [-118.57991, 34.11395], [-118.57991, 34.11381], [-118.57971, 34.11381], [-118.57965, 34.11377], [-118.57968, 34.1137], [-118.57968, 34.11335], [-118.57965, 34.1133], [-118.57961, 34.11326], [-118.57943, 34.11319], [-118.57943, 34.11312], [-118.58045, 34.11312], [-118.5805, 34.11353], [-118.58036, 34.11354], [-118.58035, 34.11366], [-118.58052, 34.11367], [-118.58057, 34.11409]], [[-118.57999, 34.11354], [-118.57991, 34.11354], [-118.57991, 34.11367], [-118.57999, 34.11367], [-118.57999, 34.11354]]], [[[-118.57849, 34.11463], [-118.57832, 34.11463], [-118.57832, 34.1145], [-118.57819, 34.11449], [-118.57819, 34.11395], [-118.57832, 34.11395], [-118.57832, 34.11421], [-118.5784, 34.11422], [-118.5784, 34.11436], [-118.57849, 34.11463]]], [[[-118.58818, 34.11381], [-118.58816, 34.11383], [-118.58807, 34.11371], [-118.58797, 34.11376], [-118.58794, 34.11374], [-118.58786, 34.11378], [-118.58766, 34.11352], [-118.58762, 34.11354], [-118.58759, 34.11351], [-118.58753, 34.11354], [-118.58755, 34.11357], [-118.58727, 34.11372], [-118.58733, 34.11381], [-118.58684, 34.11406], [-118.58698, 34.11426], [-118.58716, 34.11418], [-118.58725, 34.11429], [-118.58729, 34.11427], [-118.58768, 34.11478], [-118.58723, 34.11504], [-118.58669, 34.11434], [-118.58586, 34.11478], [-118.58541, 34.1142], [-118.58562, 34.11409], [-118.58551, 34.11394], [-118.58554, 34.11392], [-118.58544, 34.11378], [-118.58509, 34.11396], [-118.58504, 34.11391], [-118.58487, 34.11399], [-118.58491, 34.11405], [-118.58478, 34.11412], [-118.58469, 34.11401], [-118.58462, 34.11404], [-118.58451, 34.1139], [-118.58565, 34.11347], [-118.58575, 34.11361], [-118.58562, 34.11369], [-118.58572, 34.11383], [-118.58559, 34.11391], [-118.58569, 34.11404], [-118.58577, 34.11401], [-118.58588, 34.11415], [-118.58609, 34.11405], [-118.5862, 34.11419], [-118.58647, 34.11404], [-118.58637, 34.11391], [-118.5863, 34.11394], [-118.58619, 34.11379], [-118.58625, 34.11375], [-118.58615, 34.11361], [-118.58642, 34.11346], [-118.58626, 34.11325], [-118.58616, 34.11328], [-118.5861, 34.11315], [-118.58783, 34.11253], [-118.58808, 34.11344], [-118.588, 34.11334], [-118.5878, 34.11345], [-118.5879, 34.11359], [-118.58807, 34.1135], [-118.58806, 34.11347], [-118.58808, 34.11345], [-118.58818, 34.11381]], [[-118.58654, 34.11362], [-118.58647, 34.11365], [-118.58658, 34.11379], [-118.58664, 34.11375], [-118.58654, 34.11362]], [[-118.5872, 34.11367], [-118.5872, 34.11366], [-118.5871, 34.11352], [-118.587, 34.11357], [-118.58689, 34.11343], [-118.58682, 34.11346], [-118.58704, 34.11375], [-118.5872, 34.11367]], [[-118.58667, 34.11314], [-118.5866, 34.11318], [-118.58671, 34.11331], [-118.58677, 34.11328], [-118.58667, 34.11314]], [[-118.58716, 34.11289], [-118.58699, 34.11297], [-118.5871, 34.11311], [-118.58726, 34.11302], [-118.58716, 34.11289]]], [[[-118.58065, 34.11477], [-118.58057, 34.11477], [-118.58057, 34.11491], [-118.58031, 34.11491], [-118.58031, 34.11504], [-118.58024, 34.11504], [-118.58024, 34.11477], [-118.58018, 34.11478], [-118.58018, 34.11491], [-118.58004, 34.11491], [-118.58004, 34.11477], [-118.57998, 34.11477], [-118.57998, 34.11464], [-118.57992, 34.11463], [-118.57991, 34.11477], [-118.57971, 34.11477], [-118.57971, 34.11491], [-118.57938, 34.11491], [-118.57938, 34.11504], [-118.57945, 34.11504], [-118.57945, 34.11518], [-118.57938, 34.11518], [-118.57937, 34.11511], [-118.57892, 34.11511], [-118.57892, 34.11505], [-118.57885, 34.11505], [-118.57885, 34.11493], [-118.57884, 34.11492], [-118.57872, 34.11505], [-118.57859, 34.11505], [-118.57859, 34.11531], [-118.57865, 34.11531], [-118.57865, 34.11518], [-118.57886, 34.11518], [-118.57886, 34.11561], [-118.57606, 34.1156], [-118.57606, 34.11546], [-118.57696, 34.11546], [-118.57696, 34.11533], [-118.5768, 34.11532], [-118.5768, 34.11519], [-118.57713, 34.11518], [-118.57712, 34.11505], [-118.57696, 34.11505], [-118.57696, 34.11478], [-118.57705, 34.11477], [-118.57705, 34.11463], [-118.57778, 34.11463], [-118.57778, 34.11505], [-118.57771, 34.11505], [-118.57771, 34.11519], [-118.57794, 34.11518], [-118.57794, 34.11505], [-118.57802, 34.11504], [-118.57802, 34.11492], [-118.57794, 34.11491], [-118.57794, 34.11463], [-118.57802, 34.11463], [-118.57803, 34.11477], [-118.57811, 34.11476], [-118.57811, 34.11463], [-118.57825, 34.11463], [-118.57826, 34.11477], [-118.57832, 34.11477], [-118.57832, 34.1147], [-118.57851, 34.1147], [-118.57854, 34.11477], [-118.57878, 34.11477], [-118.57878, 34.11463], [-118.57898, 34.11463], [-118.57899, 34.11449], [-118.57905, 34.11449], [-118.57906, 34.11477], [-118.5797, 34.11477], [-118.57971, 34.11449], [-118.57978, 34.11449], [-118.57978, 34.11462], [-118.57984, 34.11462], [-118.57984, 34.11436], [-118.58011, 34.11436], [-118.58011, 34.11449], [-118.58004, 34.1145], [-118.58005, 34.11463], [-118.58017, 34.11463], [-118.58017, 34.11449], [-118.58062, 34.1145], [-118.58065, 34.11477]], [[-118.57872, 34.11533], [-118.57866, 34.11532], [-118.57866, 34.11546], [-118.57872, 34.11545], [-118.57872, 34.11533]], [[-118.57851, 34.11532], [-118.57852, 34.11519], [-118.57846, 34.11518], [-118.57846, 34.11531], [-118.57851, 34.11532]], [[-118.57839, 34.11492], [-118.57832, 34.11492], [-118.57833, 34.11505], [-118.57839, 34.11504], [-118.57839, 34.11492]], [[-118.57885, 34.11478], [-118.57879, 34.11477], [-118.57879, 34.11491], [-118.57885, 34.1149], [-118.57885, 34.11478]], [[-118.57761, 34.11505], [-118.57762, 34.11491], [-118.57746, 34.11491], [-118.57746, 34.11504], [-118.57761, 34.11505]], [[-118.57706, 34.11478], [-118.57705, 34.1149], [-118.57712, 34.11491], [-118.57713, 34.11478], [-118.57706, 34.11478]], [[-118.57737, 34.11479], [-118.57721, 34.11478], [-118.57721, 34.11491], [-118.57737, 34.11491], [-118.57737, 34.11479]]]]} | Open Access 1 | 48524 | Unnamed site - Los Angeles, County of | 33238 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 28.583 | 0 | Local Other or Unknown 14 | 4 | ||
3927 | 3927 | 3926 | {"type": "Polygon", "coordinates": [[[-120.60126, 37.35998], [-120.60123, 37.36033], [-120.59996, 37.36035], [-120.59996, 37.35936], [-120.60081, 37.35938], [-120.60081, 37.36], [-120.60126, 37.35998]]]} | Open Access 1 | 36303 | Merced holding 1 | 22161 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.379 | Merced holding 1 | 0 | Local Other or Unknown 14 | 4 | |
4825 | 4825 | 4824 | {"type": "Polygon", "coordinates": [[[-120.78357, 37.42217], [-120.78354, 37.42276], [-120.78299, 37.42273], [-120.78253, 37.42266], [-120.78176, 37.42243], [-120.78172, 37.42236], [-120.78187, 37.42206], [-120.78357, 37.42217]]]} | Open Access 1 | 48932 | Unknown park - Merced, County of | 33652 | 308 | Merced, County of 476 | County 3 | County Agency 3 | http://www.co.merced.ca.us/index.aspx?NID=757 | County 3 | 308 | Merced, County of 469 | County 3 | County Agency 3 | Merced 37 | 2.299 | 0 | Local Other or Unknown 14 | 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 |
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]);