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 SUID_NMA
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_WEB, MNG_AG_ID, COUNTY
MNG_AGENCY 23
- Butte, County of 52
- Santa Barbara, County of 39
- Lake, County of 36
- Orange, County of 21
- Monterey, County of 18
- Los Angeles, County of 11
- 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
- Merced, County of 2
- Placer, County of 1
- Imperial, 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 · 214 ✖
DES_TP 1
- Local Other or Unknown · 214 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11201 | 11201 | 11200 | {"type": "MultiPolygon", "coordinates": [[[[-121.09032, 38.92752], [-121.08899, 38.92751], [-121.08904, 38.92737], [-121.08902, 38.9272], [-121.0891, 38.92715], [-121.08911, 38.92713], [-121.08952, 38.92692], [-121.09032, 38.92752]]], [[[-121.09322, 38.9114], [-121.09322, 38.9114], [-121.0932, 38.91235], [-121.0925, 38.91175], [-121.0924, 38.91161], [-121.09248, 38.91126], [-121.09322, 38.9114]]], [[[-121.10842, 38.96386], [-121.10841, 38.96587], [-121.10722, 38.96588], [-121.10724, 38.96468], [-121.10758, 38.96467], [-121.10759, 38.96454], [-121.10799, 38.96452], [-121.10802, 38.96429], [-121.10802, 38.96387], [-121.10842, 38.96386]]], [[[-121.11189, 38.8014], [-121.11129, 38.80193], [-121.11155, 38.80292], [-121.11143, 38.80298], [-121.11116, 38.80195], [-121.10944, 38.8023], [-121.10946, 38.80121], [-121.11121, 38.80077], [-121.11189, 38.8014]]], [[[-121.16524, 38.84815], [-121.16497, 38.84816], [-121.16501, 38.84911], [-121.16461, 38.85055], [-121.16491, 38.85065], [-121.16489, 38.85075], [-121.16443, 38.85121], [-121.16384, 38.85088], [-121.16331, 38.851], [-121.16317, 38.85102], [-121.16297, 38.85101], [-121.16256, 38.85092], [-121.1622, 38.85081], [-121.16191, 38.85069], [-121.16137, 38.85044], [-121.16121, 38.84943], [-121.16162, 38.84848], [-121.16182, 38.84796], [-121.16182, 38.84763], [-121.16523, 38.84793], [-121.16524, 38.84815]]], [[[-121.17036, 38.75056], [-121.17013, 38.75052], [-121.17018, 38.75032], [-121.17036, 38.75056], [-121.17036, 38.75056]]], [[[-121.19966, 38.71425], [-121.19966, 38.7143], [-121.19913, 38.71429], [-121.19896, 38.71447], [-121.1989, 38.71496], [-121.19866, 38.71422], [-121.19966, 38.71425]]], [[[-121.2107, 38.71589], [-121.21067, 38.71612], [-121.21065, 38.71616], [-121.21032, 38.71625], [-121.21011, 38.71588], [-121.21011, 38.71584], [-121.2107, 38.71589]]], [[[-121.21429, 38.91194], [-121.21429, 38.91241], [-121.21387, 38.9124], [-121.21387, 38.91194], [-121.21429, 38.91194]]], [[[-121.26446, 38.90157], [-121.26445, 38.90515], [-121.26425, 38.90515], [-121.26416, 38.90157], [-121.26446, 38.90157]]], [[[-121.36418, 38.73603], [-121.36416, 38.73794], [-121.36413, 38.73794], [-121.36398, 38.73784], [-121.3637, 38.73776], [-121.36349, 38.7376], [-121.363, 38.73749], [-121.36225, 38.73719], [-121.36215, 38.73719], [-121.36209, 38.73718], [-121.36184, 38.73704], [-121.36178, 38.73697], [-121.36125, 38.73676], [-121.36104, 38.73669], [-121.36089, 38.73666], [-121.36055, 38.73658], [-121.36024, 38.73656], [-121.3601, 38.73652], [-121.35969, 38.73639], [-121.35915, 38.73615], [-121.35571, 38.73612], [-121.35551, 38.73628], [-121.35536, 38.73637], [-121.35499, 38.73649], [-121.35455, 38.7367], [-121.35413, 38.73684], [-121.35403, 38.737], [-121.35382, 38.73711], [-121.35357, 38.73717], [-121.35312, 38.73724], [-121.35291, 38.73726], [-121.35251, 38.73725], [-121.35219, 38.73737], [-121.35185, 38.73743], [-121.35167, 38.73742], [-121.35154, 38.7374], [-121.3514, 38.73742], [-121.35115, 38.7374], [-121.3509, 38.73741], [-121.35078, 38.73747], [-121.35058, 38.73753], [-121.35036, 38.73758], [-121.3501, 38.73762], [-121.34916, 38.73764], [-121.34881, 38.73769], [-121.34848, 38.73776], [-121.34825, 38.73778], [-121.34801, 38.73778], [-121.34764, 38.73782], [-121.34759, 38.73785], [-121.34757, 38.73791], [-121.34729, 38.73818], [-121.34712, 38.73829], [-121.34699, 38.73835], [-121.34685, 38.73837], [-121.34659, 38.73839], [-121.34644, 38.73843], [-121.34627, 38.73843], [-121.34611, 38.73838], [-121.34604, 38.73834], [-121.34594, 38.73822], [-121.34608, 38.73822], [-121.34603, 38.73724], [-121.34469, 38.73735], [-121.34441, 38.73735], [-121.34441, 38.73758], [-121.3443, 38.73756], [-121.34416, 38.73757], [-121.34418, 38.73812], [-121.34405, 38.73811], [-121.34374, 38.73807], [-121.34346, 38.738], [-121.34308, 38.73784], [-121.34284, 38.73777], [-121.34262, 38.73774], [-121.34259, 38.73729], [-121.34152, 38.73724], [-121.34068, 38.73673], [-121.33915, 38.73671], [-121.33913, 38.7363], [-121.33922, 38.73629], [-121.33916, 38.73506], [-121.33718, 38.73512], [-121.33715, 38.73424], [-121.33717, 38.7342], [-121.33721, 38.73418], [-121.3379, 38.73419], [-121.33892, 38.73429], [-121.33902, 38.73434], [-121.3391, 38.73436], [-121.33922, 38.73434], [-121.3393, 38.73427], [-121.3401, 38.73437], [-121.34013, 38.73434], [-121.3402, 38.73437], [-121.34027, 38.73437], [-121.34028, 38.7344], [-121.34037, 38.73443], [-121.34106, 38.73449], [-121.3411, 38.73448], [-121.34115, 38.73452], [-121.34121, 38.73454], [-121.34129, 38.73453], [-121.34134, 38.73449], [-121.34153, 38.73454], [-121.34176, 38.73456], [-121.34204, 38.73456], [-121.34209, 38.73453], [-121.34214, 38.73457], [-121.3422, 38.73458], [-121.34228, 38.73457], [-121.3423, 38.73458], [-121.34305, 38.73467], [-121.34309, 38.73464], [-121.34334, 38.73567], [-121.34433, 38.73573], [-121.34442, 38.73547], [-121.34429, 38.7351], [-121.34423, 38.73478], [-121.34455, 38.73481], [-121.34481, 38.73468], [-121.34471, 38.73398], [-121.3447, 38.73376], [-121.34481, 38.73374], [-121.34483, 38.73387], [-121.34489, 38.73414], [-121.345, 38.73435], [-121.34523, 38.7345], [-121.34536, 38.73444], [-121.34543, 38.73446], [-121.3455, 38.73445], [-121.34569, 38.7346], [-121.34596, 38.73463], [-121.34601, 38.73656], [-121.34642, 38.73654], [-121.34667, 38.73655], [-121.34686, 38.73649], [-121.347, 38.73648], [-121.34711, 38.73652], [-121.34717, 38.73652], [-121.34743, 38.73649], [-121.34765, 38.73642], [-121.34776, 38.73641], [-121.34815, 38.73641], [-121.34836, 38.73638], [-121.34879, 38.73637], [-121.34961, 38.73621], [-121.34979, 38.73614], [-121.35002, 38.73609], [-121.35105, 38.736], [-121.35131, 38.73601], [-121.35181, 38.73609], [-121.35205, 38.73611], [-121.35227, 38.73609], [-121.35249, 38.73604], [-121.35278, 38.73593], [-121.35288, 38.73588], [-121.35315, 38.73579], [-121.35347, 38.73573], [-121.35377, 38.73563], [-121.35424, 38.73538], [-121.35453, 38.73531], [-121.35525, 38.73526], [-121.35527, 38.73533], [-121.3563, 38.73519], [-121.35759, 38.73512], [-121.35842, 38.73485], [-121.35855, 38.73486], [-121.35859, 38.73347], [-121.35997, 38.73348], [-121.35996, 38.73507], [-121.36418, 38.73603]]], [[[-121.35534, 38.7287], [-121.35473, 38.72871], [-121.35474, 38.72597], [-121.35533, 38.72601], [-121.35534, 38.7287]]], [[[-121.35947, 38.74338], [-121.3557, 38.74339], [-121.35569, 38.74319], [-121.35683, 38.74281], [-121.3573, 38.74261], [-121.35753, 38.74248], [-121.35756, 38.74227], [-121.35775, 38.74204], [-121.35778, 38.74191], [-121.3581, 38.7422], [-121.35805, 38.74223], [-121.35803, 38.74229], [-121.35803, 38.74234], [-121.35809, 38.74239], [-121.35805, 38.74253], [-121.35808, 38.74259], [-121.35878, 38.74283], [-121.35927, 38.74289], [-121.35932, 38.74295], [-121.35943, 38.74297], [-121.35947, 38.74338]]], [[[-121.36024, 38.74782], [-121.36, 38.74792], [-121.35993, 38.74793], [-121.35977, 38.74778], [-121.35954, 38.74764], [-121.35948, 38.74758], [-121.3593, 38.74753], [-121.35921, 38.74755], [-121.35871, 38.74751], [-121.35877, 38.74736], [-121.35876, 38.74731], [-121.35869, 38.74725], [-121.35854, 38.74724], [-121.35855, 38.74713], [-121.35841, 38.74712], [-121.35812, 38.74728], [-121.35793, 38.74732], [-121.35774, 38.74731], [-121.35747, 38.74724], [-121.3572, 38.74749], [-121.35754, 38.74771], [-121.35749, 38.74778], [-121.35748, 38.74783], [-121.3575, 38.74788], [-121.35645, 38.74844], [-121.35611, 38.74844], [-121.35591, 38.74848], [-121.35587, 38.7469], [-121.35583, 38.74667], [-121.35575, 38.7464], [-121.35671, 38.74638], [-121.3568, 38.74641], [-121.35698, 38.74641], [-121.35707, 38.74638], [-121.35812, 38.74637], [-121.35833, 38.74635], [-121.35851, 38.7463], [-121.35867, 38.74625], [-121.3588, 38.74617], [-121.35893, 38.74608], [-121.35903, 38.74598], [-121.35912, 38.74585], [-121.35918, 38.74571], [-121.35921, 38.74559], [-121.3602, 38.74559], [-121.36024, 38.74782]]], [[[-121.35831, 38.72866], [-121.35777, 38.72867], [-121.35777, 38.72865], [-121.35812, 38.72841], [-121.35831, 38.72841], [-121.35831, 38.72866]]], [[[-121.37271, 38.97789], [-121.37246, 38.97789], [-121.37226, 38.97768], [-121.37258, 38.97773], [-121.37271, 38.97789]]], [[[-121.38384, 38.89801], [-121.38331, 38.89801], [-121.38331, 38.89764], [-121.38383, 38.89764], [-121.38384, 38.89801]]]]} | Open Access 1 | 21471 | Placer County Land | 8673 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | Placer 35 | 180.682 | Placer County Land | 0 | Local Other or Unknown 14 | 4 | |
10361 | 10361 | 10360 | {"type": "Polygon", "coordinates": [[[-120.11686, 34.66391], [-120.11686, 34.66443], [-120.11666, 34.66443], [-120.11667, 34.6639], [-120.11686, 34.66391]]]} | Open Access 1 | 18384 | Alamo Pintado Creek | 15318 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 0.262 | Alamo Pintado Creek | 0 | Local Other or Unknown 14 | 4 | |
11138 | 11138 | 11137 | {"type": "Polygon", "coordinates": [[[-121.29786, 38.49822], [-121.29733, 38.49802], [-121.2969, 38.49796], [-121.29661, 38.49799], [-121.29634, 38.49832], [-121.29629, 38.49874], [-121.29647, 38.49922], [-121.29644, 38.49953], [-121.29651, 38.49982], [-121.29676, 38.49992], [-121.29701, 38.49988], [-121.29784, 38.49901], [-121.29783, 38.50332], [-121.29735, 38.50321], [-121.29714, 38.50313], [-121.29689, 38.50305], [-121.29688, 38.50306], [-121.29691, 38.50315], [-121.29703, 38.50326], [-121.29748, 38.50354], [-121.29428, 38.50352], [-121.29385, 38.50329], [-121.29323, 38.50315], [-121.29275, 38.50326], [-121.29239, 38.50351], [-121.28867, 38.50348], [-121.28869, 38.50214], [-121.2923, 38.50215], [-121.29546, 38.49847], [-121.29544, 38.49627], [-121.29762, 38.49629], [-121.29774, 38.49637], [-121.29785, 38.49753], [-121.29786, 38.49822]], [[-121.29624, 38.50255], [-121.29625, 38.50254], [-121.29618, 38.50232], [-121.29606, 38.50211], [-121.29588, 38.50192], [-121.29566, 38.50176], [-121.29541, 38.50164], [-121.29512, 38.50157], [-121.29483, 38.50154], [-121.29453, 38.50156], [-121.29425, 38.50162], [-121.29398, 38.50173], [-121.29374, 38.50176], [-121.29351, 38.50182], [-121.2933, 38.50192], [-121.29313, 38.50205], [-121.293, 38.50219], [-121.29301, 38.5022], [-121.29326, 38.50215], [-121.29354, 38.50213], [-121.29382, 38.50215], [-121.29409, 38.50221], [-121.29464, 38.50225], [-121.29519, 38.50231], [-121.29572, 38.50242], [-121.29624, 38.50255]]]} | Restricted Access 2 | 21429 | Arroyo Seco (florin Mitigation Bank) | 15628 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 66.229 | Arroyo Seco (florin Mitigation Bank) | 0 | Local Other or Unknown 14 | 4 | |
9811 | 9811 | 9810 | {"type": "MultiPolygon", "coordinates": [[[[-119.78388, 34.43252], [-119.78345, 34.43278], [-119.78231, 34.43354], [-119.78143, 34.43378], [-119.78052, 34.4337], [-119.78052, 34.43358], [-119.78135, 34.43364], [-119.78158, 34.43361], [-119.78213, 34.43346], [-119.78241, 34.43332], [-119.78376, 34.43242], [-119.78381, 34.43241], [-119.78385, 34.43243], [-119.78388, 34.43248], [-119.78388, 34.43252]]], [[[-119.79498, 34.42774], [-119.79162, 34.42959], [-119.7874, 34.43078], [-119.78626, 34.43109], [-119.78625, 34.43108], [-119.78589, 34.43127], [-119.78408, 34.43239], [-119.78411, 34.4321], [-119.78448, 34.43201], [-119.78536, 34.43149], [-119.78544, 34.43143], [-119.7857, 34.43115], [-119.7862, 34.43068], [-119.78689, 34.43049], [-119.78694, 34.43059], [-119.79145, 34.42935], [-119.79203, 34.42903], [-119.79202, 34.42901], [-119.79462, 34.42757], [-119.79483, 34.42761], [-119.79498, 34.42774]]]]} | Unknown Access 4 | 16760 | Atascadero Creek | 15661 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | http://cosb.countyofsb.org/parks/ | County 3 | 325 | Santa Barbara, County of 7 | County 3 | County Agency 3 | Santa Barbara 7 | 9.641 | Atascadero Creek | 0 | Local Other or Unknown 14 | 4 | |
13198 | 13198 | 13197 | {"type": "Polygon", "coordinates": [[[-121.48678, 39.51389], [-121.48532, 39.5139], [-121.48532, 39.51387], [-121.48603, 39.51387], [-121.48603, 39.51308], [-121.48676, 39.51308], [-121.48678, 39.51389]]]} | Open Access 1 | 36274 | Butte holding 1 | 16552 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.474 | Butte holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13594 | 13594 | 13593 | {"type": "Polygon", "coordinates": [[[-121.53726, 39.64644], [-121.53646, 39.64655], [-121.53638, 39.64653], [-121.53648, 39.6463], [-121.53726, 39.64644]]]} | Open Access 1 | 35930 | Butte holding 10 | 16553 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.247 | Butte holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13596 | 13596 | 13595 | {"type": "Polygon", "coordinates": [[[-121.80054, 39.64365], [-121.8001, 39.64376], [-121.80003, 39.64358], [-121.80048, 39.64347], [-121.80054, 39.64365]]]} | Open Access 1 | 35932 | Butte holding 11 | 16554 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.215 | Butte holding 11 | 0 | Local Other or Unknown 14 | 4 | |
14137 | 14137 | 14136 | {"type": "Polygon", "coordinates": [[[-121.52439, 39.72053], [-121.52374, 39.72109], [-121.52354, 39.72123], [-121.5232, 39.72088], [-121.52367, 39.72067], [-121.52403, 39.72031], [-121.52439, 39.72053]]]} | Open Access 1 | 43005 | Butte holding 12 | 16555 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.008 | Butte holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13777 | 13777 | 13776 | {"type": "Polygon", "coordinates": [[[-121.86042, 39.7738], [-121.86037, 39.77383], [-121.86008, 39.77354], [-121.86013, 39.77351], [-121.86042, 39.7738]]]} | Open Access 1 | 36323 | Butte holding 13 | 16556 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.054 | Butte holding 13 | 0 | Local Other or Unknown 14 | 4 | |
3939 | 3939 | 3938 | {"type": "Polygon", "coordinates": [[[-121.62744, 39.74865], [-121.62744, 39.74881], [-121.62673, 39.74875], [-121.62673, 39.74859], [-121.62744, 39.74865]]]} | Open Access 1 | 36311 | Butte holding 14 | 16557 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.271 | Butte holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13786 | 13786 | 13785 | {"type": "Polygon", "coordinates": [[[-121.62648, 39.76336], [-121.62653, 39.76339], [-121.62657, 39.76346], [-121.6266, 39.76354], [-121.62661, 39.76365], [-121.6266, 39.76373], [-121.62657, 39.76383], [-121.62646, 39.76397], [-121.62648, 39.76336]]]} | Open Access 1 | 36344 | Butte holding 15 | 16558 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.139 | Butte holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13753 | 13753 | 13752 | {"type": "Polygon", "coordinates": [[[-121.71803, 39.79871], [-121.71791, 39.79886], [-121.71767, 39.7988], [-121.71739, 39.79869], [-121.7172, 39.79858], [-121.71697, 39.7984], [-121.71647, 39.79786], [-121.71672, 39.79772], [-121.71708, 39.79811], [-121.71739, 39.79839], [-121.71771, 39.79858], [-121.71803, 39.79871]]]} | Open Access 1 | 36265 | Butte holding 16 | 16559 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.048 | Butte holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13627 | 13627 | 13626 | {"type": "Polygon", "coordinates": [[[-121.50093, 39.50411], [-121.50019, 39.50467], [-121.49951, 39.50467], [-121.49951, 39.50422], [-121.4996, 39.50418], [-121.49991, 39.50411], [-121.50093, 39.50411]]]} | Open Access 1 | 35973 | Butte holding 17 | 16560 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 1.342 | Butte holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13797 | 13797 | 13796 | {"type": "Polygon", "coordinates": [[[-121.8607, 39.77408], [-121.86065, 39.77411], [-121.86037, 39.77383], [-121.86042, 39.7738], [-121.8607, 39.77408]]]} | Open Access 1 | 36365 | Butte holding 18 | 16561 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.054 | Butte holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13796 | 13796 | 13795 | {"type": "Polygon", "coordinates": [[[-121.85077, 39.77573], [-121.85049, 39.77573], [-121.84981, 39.77506], [-121.84994, 39.77497], [-121.85039, 39.77543], [-121.85077, 39.77573]]]} | Open Access 1 | 36364 | Butte holding 19 | 16562 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.384 | Butte holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13388 | 13388 | 13387 | {"type": "Polygon", "coordinates": [[[-121.53269, 39.46596], [-121.53184, 39.46602], [-121.5318, 39.46567], [-121.53264, 39.4656], [-121.53269, 39.46596]]]} | Open Access 1 | 36275 | Butte holding 2 | 16563 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.717 | Butte holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13584 | 13584 | 13583 | {"type": "Polygon", "coordinates": [[[-121.57928, 39.81699], [-121.57902, 39.81678], [-121.57879, 39.8165], [-121.5787, 39.81607], [-121.57872, 39.81466], [-121.57854, 39.81417], [-121.57834, 39.81346], [-121.57847, 39.81298], [-121.5786, 39.81301], [-121.57885, 39.81322], [-121.57904, 39.81347], [-121.57916, 39.81374], [-121.57928, 39.81699]]]} | Open Access 1 | 35934 | Butte holding 20 | 16564 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 4.825 | Butte holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13597 | 13597 | 13596 | {"type": "Polygon", "coordinates": [[[-121.58711, 39.81342], [-121.58621, 39.81385], [-121.58619, 39.81385], [-121.58633, 39.81373], [-121.58677, 39.81349], [-121.58711, 39.81342]]]} | Open Access 1 | 35933 | Butte holding 21 | 16565 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.131 | Butte holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13628 | 13628 | 13627 | {"type": "Polygon", "coordinates": [[[-121.60388, 39.85695], [-121.60384, 39.85697], [-121.60383, 39.857], [-121.60382, 39.85735], [-121.60364, 39.85735], [-121.60365, 39.857], [-121.60362, 39.85695], [-121.60388, 39.85695]]]} | Open Access 1 | 35974 | Butte holding 22 | 16566 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.177 | Butte holding 22 | 0 | Local Other or Unknown 14 | 4 | |
4003 | 4003 | 4002 | {"type": "Polygon", "coordinates": [[[-121.74737, 39.49534], [-121.74694, 39.49534], [-121.74694, 39.49496], [-121.74736, 39.49496], [-121.74737, 39.49534]]]} | Open Access 1 | 43013 | Butte holding 23 | 16567 | 342 | Butte, County of 705 | County 3 | County Agency 3 | http://www.buttecounty.net/ | County 3 | 342 | Butte, County of 692 | County 3 | County Agency 3 | Butte 42 | 0.385 | Butte holding 23 | 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]);