calands: units_with_maps: 1 row where ACCESS_TYP = 1, COUNTY = 54 and DES

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where ACCESS_TYP = 1, COUNTY = 54 and DES_TP = 55

Search:

descending

This data as json, copyable, CSV (advanced)

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
3265	3265	3264	{"type": "MultiPolygon", "coordinates": [[[[-120.11423, 40.1436], [-120.11421, 40.14423], [-120.11185, 40.14489], [-120.1108, 40.14513], [-120.10968, 40.14526], [-120.10867, 40.1453], [-120.07636, 40.14481], [-120.07586, 40.17238], [-120.07578, 40.17962], [-120.05679, 40.17943], [-120.05667, 40.18675], [-120.05653, 40.20138], [-120.04723, 40.20126], [-120.04733, 40.19391], [-120.05208, 40.19394], [-120.05223, 40.18671], [-120.0438, 40.18664], [-120.04379, 40.18662], [-120.02782, 40.18644], [-120.0278, 40.17918], [-120.01837, 40.1791], [-120.0183, 40.20084], [-120.01084, 40.20077], [-120.01098, 40.19352], [-120.01361, 40.19351], [-120.01363, 40.17181], [-120.00437, 40.17169], [-120.00436, 40.17166], [-119.99972, 40.17159], [-119.99963, 40.16809], [-119.99692, 40.16808], [-119.99688, 40.168], [-119.99687, 40.15722], [-119.99696, 40.1572], [-119.99943, 40.15722], [-119.99927, 40.16446], [-119.99928, 40.16447], [-120.00637, 40.1645], [-120.0064, 40.15726], [-120.0138, 40.1573], [-120.02796, 40.15745], [-120.02794, 40.14299], [-120.0385, 40.14311], [-120.05744, 40.14314], [-120.07632, 40.14325], [-120.09504, 40.14345], [-120.11423, 40.1436]], [[-120.05691, 40.17218], [-120.057, 40.16854], [-120.05246, 40.16851], [-120.05252, 40.16489], [-120.0478, 40.16486], [-120.04793, 40.15761], [-120.03849, 40.15756], [-120.03824, 40.17202], [-120.05691, 40.17218]]], [[[-120.01331, 40.21164], [-120.01322, 40.21522], [-120.00884, 40.21523], [-120.0089, 40.21164], [-120.01331, 40.21164]]], [[[-120.02556, 39.8814], [-120.02217, 39.88539], [-120.02045, 39.88748], [-120.02003, 39.88803], [-120.01947, 39.88883], [-120.01905, 39.88956], [-120.01657, 39.89408], [-120.01542, 39.89659], [-120.01543, 39.89453], [-120.01526, 39.88132], [-120.02457, 39.88138], [-120.02556, 39.8814]]], [[[-120.02492, 39.88864], [-120.02028, 39.88855], [-120.02023, 39.89217], [-120.02227, 39.89219], [-120.02203, 39.89242], [-120.02105, 39.89322], [-120.02008, 39.89411], [-120.01997, 39.8943], [-120.01994, 39.89453], [-120.02, 39.89471], [-120.02008, 39.89486], [-120.02012, 39.89499], [-120.0201, 39.89516], [-120.02008, 39.89528], [-120.01983, 39.89574], [-120.01619, 39.89575], [-120.01691, 39.89417], [-120.01938, 39.88967], [-120.0198, 39.88895], [-120.02034, 39.88816], [-120.02075, 39.88762], [-120.02247, 39.88554], [-120.02466, 39.88295], [-120.02492, 39.88864]]], [[[-120.02757, 39.89224], [-120.02742, 39.89233], [-120.02677, 39.89261], [-120.02552, 39.89308], [-120.02477, 39.89338], [-120.02424, 39.89363], [-120.02391, 39.8938], [-120.02332, 39.89415], [-120.02271, 39.89463], [-120.02228, 39.89502], [-120.02178, 39.89561], [-120.02171, 39.89574], [-120.02006, 39.89574], [-120.02029, 39.89531], [-120.02031, 39.89518], [-120.02034, 39.89496], [-120.02028, 39.8948], [-120.0202, 39.89465], [-120.02015, 39.8945], [-120.02018, 39.89433], [-120.02026, 39.89419], [-120.02121, 39.89333], [-120.0222, 39.89253], [-120.02253, 39.8922], [-120.02757, 39.89224]]], [[[-120.0338, 39.89572], [-120.0248, 39.89573], [-120.02252, 39.89574], [-120.02287, 39.89533], [-120.02325, 39.895], [-120.02381, 39.89455], [-120.02434, 39.89424], [-120.02463, 39.89409], [-120.02513, 39.89385], [-120.02584, 39.89357], [-120.02711, 39.8931], [-120.02784, 39.89278], [-120.02872, 39.89223], [-120.0293, 39.89223], [-120.02932, 39.8916], [-120.02965, 39.89117], [-120.02989, 39.8907], [-120.03095, 39.88801], [-120.03135, 39.88687], [-120.03155, 39.88646], [-120.03188, 39.88602], [-120.03213, 39.88572], [-120.03228, 39.88556], [-120.03268, 39.88526], [-120.03305, 39.885], [-120.03349, 39.88477], [-120.03375, 39.88467], [-120.0338, 39.89572]]], [[[-120.03185, 39.88511], [-120.03173, 39.88522], [-120.03154, 39.88541], [-120.03105, 39.88601], [-120.03088, 39.88625], [-120.03067, 39.88672], [-120.03026, 39.88786], [-120.0294, 39.8899], [-120.0295, 39.88679], [-120.02996, 39.88639], [-120.03051, 39.88575], [-120.03068, 39.88544], [-120.03078, 39.88514], [-120.03185, 39.88511]]], [[[-120.03055, 39.88514], [-120.03047, 39.8854], [-120.03031, 39.88568], [-120.02979, 39.88629], [-120.02951, 39.88653], [-120.02956, 39.88516], [-120.03055, 39.88514]]], [[[-120.06529, 40.24155], [-120.06528, 40.24523], [-120.05601, 40.24511], [-120.05598, 40.24145], [-120.06529, 40.24155]]], [[[-120.07543, 40.20157], [-120.07534, 40.20519], [-120.06595, 40.2051], [-120.06603, 40.20148], [-120.07543, 40.20157]]], [[[-120.07547, 40.01954], [-120.07541, 40.02676], [-120.07065, 40.02674], [-120.07079, 40.01956], [-120.07547, 40.01954]]], [[[-120.11138, 40.27467], [-120.11132, 40.27825], [-120.10697, 40.2782], [-120.107, 40.2746], [-120.11138, 40.27467]]], [[[-120.12935, 40.32353], [-120.11037, 40.32349], [-120.11048, 40.32196], [-120.11055, 40.31838], [-120.12935, 40.3185], [-120.12935, 40.32353]]], [[[-120.14301, 40.14401], [-120.143, 40.14429], [-120.14265, 40.14428], [-120.14265, 40.14401], [-120.14301, 40.14401]]], [[[-120.16072, 40.18067], [-120.16067, 40.18481], [-120.16016, 40.18448], [-120.15966, 40.18422], [-120.15915, 40.18399], [-120.1586, 40.18379], [-120.15804, 40.18364], [-120.15746, 40.18352], [-120.15667, 40.18342], [-120.15607, 40.18339], [-120.15736, 40.18065], [-120.16072, 40.18067]]], [[[-120.18073, 40.5559], [-120.1614, 40.55587], [-120.16155, 40.54205], [-120.16179, 40.5423], [-120.16227, 40.54314], [-120.1625, 40.54346], [-120.16273, 40.54364], [-120.16319, 40.54411], [-120.16338, 40.54439], [-120.16349, 40.5445], [-120.16377, 40.54461], [-120.1663, 40.54601], [-120.1669, 40.54654], [-120.16731, 40.54678], [-120.16747, 40.54694], [-120.16836, 40.54747], [-120.16862, 40.54765], [-120.16904, 40.54772], [-120.16949, 40.54792], [-120.17014, 40.5483], [-120.17053, 40.54837], [-120.17086, 40.54846], [-120.17169, 40.54873], [-120.1722, 40.54895], [-120.17255, 40.54909], [-120.1729, 40.54919], [-120.17316, 40.54934], [-120.17341, 40.54945], [-120.1739, 40.54953], [-120.17428, 40.54963], [-120.1751, 40.54968], [-120.17553, 40.54978], [-120.17653, 40.54971], [-120.17732, 40.5497], [-120.17772, 40.54972], [-120.17908, 40.55], [-120.17953, 40.55012], [-120.17982, 40.55026], [-120.1807, 40.55058], [-120.18073, 40.5559]]], [[[-120.1807, 40.5504], [-120.17992, 40.55012], [-120.17962, 40.54997], [-120.17914, 40.54984], [-120.17774, 40.54956], [-120.17732, 40.54953], [-120.17652, 40.54955], [-120.17554, 40.54962], [-120.17513, 40.54951], [-120.17431, 40.54946], [-120.17395, 40.54937], [-120.17348, 40.54929], [-120.17328, 40.5492], [-120.17299, 40.54904], [-120.17263, 40.54894], [-120.17178, 40.54858], [-120.17094, 40.5483], [-120.17058, 40.54821], [-120.17022, 40.54814], [-120.16994, 40.54797], [-120.1696, 40.54778], [-120.1691, 40.54756], [-120.1687, 40.54749], [-120.1685, 40.54734], [-120.16761, 40.54682], [-120.16745, 40.54665], [-120.16703, 40.54641], [-120.16644, 40.54589], [-120.16388, 40.54447], [-120.16362, 40.54436], [-120.16356, 40.5443], [-120.16337, 40.54401], [-120.16289, 40.54353], [-120.16266, 40.54335], [-120.16247, 40.54307], [-120.16197, 40.54221], [-120.16177, 40.542], [-120.16155, 40.54173], [-120.16156, 40.5413], [-120.18064, 40.54129], [-120.1807, 40.5504]]], [[[-120.17735, 40.29992], [-120.17708, 40.29984], [-120.17653, 40.29975], [-120.17593, 40.29971], [-120.17494, 40.29975], [-120.17376, 40.29986], [-120.17315, 40.29989], [-120.17252, 40.29985], [-120.17201, 40.2998], [-120.17121, 40.29966], [-120.16806, 40.29873], [-120.16758, 40.29863], [-120.1675, 40.29731], [-120.17544, 40.29744], [-120.17674, 40.29814], [-120.17734, 40.2985], [-120.17735, 40.29992]]], [[[-120.17739, 40.3047], [-120.16793, 40.30447], [-120.16759, 40.29881], [-120.168, 40.29888], [-120.17115, 40.29982], [-120.17198, 40.29996], [-120.17251, 40.30002], [-120.17316, 40.30005], [-120.17379, 40.30002], [-120.17495, 40.29992], [-120.17593, 40.29987], [-120.17651, 40.29992], [-120.17702, 40.3], [-120.17735, 40.3001], [-120.17739, 40.3047]]], [[[-120.17733, 40.29815], [-120.17695, 40.29792], [-120.17609, 40.29745], [-120.17733, 40.29747], [-120.17733, 40.29815]]], [[[-120.18913, 40.2008], [-120.18449, 40.19603], [-120.18349, 40.19501], [-120.18913, 40.19501], [-120.18913, 40.2008]]], [[[-120.19207, 40.29408], [-120.19192, 40.29773], [-120.1919, 40.29953], [-120.19194, 40.30005], [-120.19187, 40.30096], [-120.19186, 40.30135], [-120.18714, 40.30126], [-120.18725, 40.29402], [-120.19207, 40.29408]]], [[[-120.26493, 40.17904], [-120.26464, 40.18847], [-120.25522, 40.18835], [-120.25519, 40.19201], [-120.24582, 40.19183], [-120.2457, 40.19907], [-120.22672, 40.19873], [-120.22666, 40.20225], [-120.20777, 40.20224], [-120.20788, 40.19495], [-120.18876, 40.19446], [-120.18883, 40.19246], [-120.18853, 40.19255], [-120.189, 40.18753], [-120.19372, 40.18757], [-120.19397, 40.18043], [-120.19396, 40.18033], [-120.18925, 40.18028], [-120.1895, 40.17304], [-120.19895, 40.17313], [-120.19871, 40.18037], [-120.20342, 40.18041], [-120.20355, 40.17679], [-120.20831, 40.17683], [-120.20801, 40.18769], [-120.20802, 40.1877], [-120.22687, 40.18786], [-120.24585, 40.1882], [-120.24593, 40.17729], [-120.25502, 40.17766], [-120.25595, 40.17535], [-120.25681, 40.17618], [-120.26493, 40.17904]]], [[[-120.2141, 40.56321], [-120.21125, 40.56322], [-120.2109, 40.56321], [-120.21035, 40.56316], [-120.20985, 40.56299], [-120.20919, 40.56272], [-120.20825, 40.56237], [-120.20754, 40.56198], [-120.20723, 40.56173], [-120.20695, 40.56162], [-120.20633, 40.5614], [-120.20348, 40.56057], [-120.20317, 40.56042], [-120.20295, 40.56037], [-120.20269, 40.56026], [-120.20235, 40.56006], [-120.20207, 40.55987], [-120.20186, 40.5597], [-120.20159, 40.55935], [-120.20135, 40.55908], [-120.20113, 40.55894], [-120.20089, 40.55886], [-120.20052, 40.55876], [-120.19996, 40.55867], [-120.19973, 40.55847], [-120.19965, 40.55579], [-120.19957, 40.55222], [-120.19494, 40.55221], [-120.19494, 40.54859], [-120.20425, 40.54861], [-120.20426, 40.5486], [-120.20412, 40.54136], [-120.19489, 40.54133], [-120.19484, 40.534], [-120.20048, 40.53401], [-120.20086, 40.53418], [-120.20124, 40.53428], [-120.20136, 40.53434], [-120.20151, 40.53452], [-120.2017, 40.53464], [-120.20201, 40.53473], [-120.20224, 40.53489], [-120.20235, 40.53514], [-120.20246, 40.53524], [-120.20273, 40.53542], [-120.20307, 40.53559], [-120.20355, 40.53579], [-120.20379, 40.53583], [-120.20389, 40.53587], [-120.20415, 40.53611], [-120.20445, 40.53648], [-120.20479, 40.53677], [-120.20513, 40.53699], [-120.20536, 40.53711], [-120.20556, 40.53748], [-120.2056, 40.53762], [-120.20555, 40.53776], [-120.20552, 40.53797], [-120.20558, 40.53824], [-120.20566, 40.53847], [-120.20593, 40.53877], [-120.20628, 40.53908], [-120.20704, 40.53964], [-120.20734, 40.53981], [-120.20775, 40.54], [-120.20784, 40.54007], [-120.20793, 40.54024], [-120.20805, 40.5404], [-120.20812, 40.54045], [-120.20813, 40.54069], [-120.20823, 40.54121], [-120.20834, 40.54147], [-120.20851, 40.54169], [-120.20872, 40.54188], [-120.20888, 40.54199], [-120.20893, 40.545], [-120.2117, 40.54501], [-120.21215, 40.54528], [-120.21304, 40.54591], [-120.21338, 40.54626], [-120.21356, 40.54648], [-120.21372, 40.54671], [-120.2139, 40.55596], [-120.2141, 40.56321]]], [[[-120.20979, 40.56315], [-120.19985, 40.56304], [-120.19973, 40.55874], [-120.19988, 40.55882], [-120.20047, 40.55892], [-120.20081, 40.55901], [-120.20102, 40.55908], [-120.2012, 40.5592], [-120.20141, 40.55944], [-120.2017, 40.5598], [-120.20192, 40.55999], [-120.20221, 40.56019], [-120.20258, 40.56041], [-120.20287, 40.56052], [-120.20309, 40.56057], [-120.20339, 40.56072], [-120.20625, 40.56155], [-120.20685, 40.56177], [-120.20711, 40.56187], [-120.20741, 40.56211], [-120.20814, 40.56252], [-120.20909, 40.56286], [-120.20979, 40.56315]]], [[[-120.20968, 40.0971], [-120.20485, 40.09711], [-120.20003, 40.09704], [-120.19985, 40.09011], [-120.20954, 40.08991], [-120.20968, 40.0971]]], [[[-120.20926, 40.53405], [-120.20897, 40.53439], [-120.20875, 40.53471], [-120.20863, 40.53519], [-120.20857, 40.53595], [-120.20843, 40.53677], [-120.20836, 40.53752], [-120.2083, 40.53775], [-120.20808, 40.53908], [-120.20808, 40.53964], [-120.20811, 40.54014], [-120.20803, 40.54], [-120.20789, 40.53988], [-120.20746, 40.53967], [-120.20717, 40.53952], [-120.20643, 40.53896], [-120.2061, 40.53867], [-120.20585, 40.5384], [-120.20574, 40.53796], [-120.20577, 40.53779], [-120.20581, 40.53764], [-120.20578, 40.53744], [-120.20554, 40.53702], [-120.20525, 40.53686], [-120.20494, 40.53665], [-120.20462, 40.53638], [-120.20433, 40.53602], [-120.20405, 40.53576], [-120.20389, 40.53568], [-120.20361, 40.53563], [-120.20318, 40.53545], [-120.20285, 40.53529], [-120.20261, 40.53512], [-120.20254, 40.53505], [-120.20244, 40.53482], [-120.20214, 40.5346], [-120.2018, 40.53449], [-120.20166, 40.5344], [-120.20152, 40.53424], [-120.20135, 40.53414], [-120.2009, 40.53401], [-120.20926, 40.53405]]], [[[-120.20775, 40.20569], [-120.20773, 40.21046], [-120.20495, 40.20987], [-120.20265, 40.20879], [-120.20278, 40.2057], [-120.20775, 40.20569]]], [[[-120.21369, 40.53408], [-120.21365, 40.5377], [-120.20891, 40.53768], [-120.20888, 40.54137], [-120.20852, 40.54137], [-120.20844, 40.54116], [-120.20834, 40.54067], [-120.2083, 40.53964], [-120.2083, 40.53909], [-120.20851, 40.53778], [-120.20857, 40.53753], [-120.20864, 40.53679], [-120.20878, 40.53597], [-120.20885, 40.53521], [-120.20895, 40.53478], [-120.20915, 40.53448], [-120.20953, 40.53405], [-120.21369, 40.53408]]], [[[-120.21371, 40.54635], [-120.21356, 40.54616], [-120.21319, 40.5458], [-120.21229, 40.54516], [-120.21205, 40.54501], [-120.21368, 40.54501], [-120.21371, 40.54635]]], [[[-120.21745, 40.84844], [-120.21266, 40.84843], [-120.21265, 40.84477], [-120.21744, 40.84478], [-120.21745, 40.84844]]], [[[-120.22339, 40.52482], [-120.22316, 40.52481], [-120.22241, 40.52493], [-120.22155, 40.52514], [-120.22088, 40.5254], [-120.22041, 40.52572], [-120.21994, 40.52591], [-120.21951, 40.52604], [-120.21874, 40.52604], [-120.21865, 40.52605], [-120.21864, 40.52587], [-120.21863, 40.52586], [-120.218, 40.52615], [-120.21752, 40.52654], [-120.21728, 40.52685], [-120.21656, 40.52685], [-120.21643, 40.527], [-120.21642, 40.52709], [-120.21644, 40.52725], [-120.21642, 40.52746], [-120.21632, 40.52758], [-120.21614, 40.52766], [-120.21581, 40.52786], [-120.21517, 40.52838], [-120.21483, 40.52875], [-120.21469, 40.52888], [-120.21418, 40.5291], [-120.21376, 40.52912], [-120.21379, 40.52682], [-120.21373, 40.52309], [-120.21862, 40.5231], [-120.22337, 40.52309], [-120.22339, 40.52482]]], [[[-120.21724, 40.52697], [-120.21711, 40.52759], [-120.21705, 40.52775], [-120.21675, 40.52813], [-120.21652, 40.52856], [-120.2162, 40.52893], [-120.21552, 40.52942], [-120.21534, 40.52961], [-120.21515, 40.52971], [-120.2146, 40.5299], [-120.21427, 40.53012], [-120.21387, 40.53033], [-120.21374, 40.53046], [-120.21376, 40.52929], [-120.21423, 40.52927], [-120.21481, 40.52902], [-120.215, 40.52886], [-120.21534, 40.52849], [-120.21595, 40.52799], [-120.21625, 40.5278], [-120.21645, 40.52771], [-120.21661, 40.52754], [-120.21665, 40.52725], [-120.21663, 40.5271], [-120.21693, 40.527], [-120.21724, 40.52697]]], [[[-120.22343, 40.53047], [-120.21869, 40.53047], [-120.214, 40.53046], [-120.21441, 40.53025], [-120.21471, 40.53004], [-120.21498, 40.52994], [-120.21527, 40.52985], [-120.2155, 40.52971], [-120.21568, 40.52954], [-120.21637, 40.52903], [-120.21672, 40.52863], [-120.21694, 40.52821], [-120.21725, 40.52781], [-120.21732, 40.52761], [-120.21746, 40.52699], [-120.21753, 40.52685], [-120.21774, 40.52656], [-120.21808, 40.52633], [-120.21837, 40.52623], [-120.21865, 40.52622], [-120.21877, 40.5262], [-120.21935, 40.52621], [-120.21957, 40.5262], [-120.22004, 40.52606], [-120.22054, 40.52585], [-120.22102, 40.52553], [-120.22164, 40.52529], [-120.22247, 40.52509], [-120.22319, 40.52498], [-120.22339, 40.52499], [-120.22343, 40.53047]]], [[[-120.23755, 40.5992], [-120.21844, 40.59914], [-120.21843, 40.58468], [-120.2375, 40.58458], [-120.23755, 40.5992]]], [[[-120.23758, 40.49764], [-120.23752, 40.51216], [-120.22494, 40.51221], [-120.21853, 40.51218], [-120.21862, 40.49761], [-120.23758, 40.49764]]], [[[-120.23595, 40.21717], [-120.23595, 40.21846], [-120.23375, 40.21717], [-120.23595, 40.21717], [-120.23595, 40.21717]]], [[[-120.24159, 40.15888], [-120.23994, 40.16022], [-120.24136, 40.16251], [-120.23681, 40.16251], [-120.23687, 40.15888], [-120.24159, 40.15888]]], [[[-120.24604, 40.16546], [-120.24604, 40.16615], [-120.2414, 40.16614], [-120.2414, 40.16258], [-120.24195, 40.16346], [-120.24604, 40.16546]]], [[[-120.25808, 40.4977], [-120.25754, 40.50287], [-120.25743, 40.50355], [-120.25737, 40.50438], [-120.25691, 40.50858], [-120.25682, 40.50919], [-120.25677, 40.50938], [-120.25674, 40.50994], [-120.25658, 40.51151], [-120.25653, 40.51177], [-120.25654, 40.51184], [-120.25645, 40.51193], [-120.25658, 40.5068], [-120.25677, 40.4977], [-120.25808, 40.4977]]], [[[-120.26909, 40.49768], [-120.26604, 40.5117], [-120.25673, 40.51172], [-120.25679, 40.51153], [-120.25695, 40.50995], [-120.25698, 40.50939], [-120.25703, 40.50921], [-120.25713, 40.50859], [-120.25758, 40.50439], [-120.25764, 40.50357], [-120.25775, 40.50289], [-120.25806, 40.50005], [-120.25811, 40.49945], [-120.2582, 40.4987], [-120.25831, 40.49865], [-120.25952, 40.49857], [-120.2601, 40.49849], [-120.26049, 40.49838], [-120.26081, 40.49819], [-120.26122, 40.4977], [-120.26909, 40.49768]]], [[[-120.26096, 40.4977], [-120.26063, 40.49809], [-120.26038, 40.49824], [-120.26004, 40.49833], [-120.25949, 40.49841], [-120.25871, 40.49845], [-120.25821, 40.4985], [-120.2583, 40.49769], [-120.26096, 40.4977]]], [[[-120.30518, 40.23891], [-120.30363, 40.24232], [-120.30177, 40.24409], [-120.29961, 40.24551], [-120.29703, 40.24608], [-120.29149, 40.24393], [-120.2892, 40.24265], [-120.2878, 40.24108], [-120.28726, 40.23979], [-120.28776, 40.23805], [-120.28805, 40.23714], [-120.29143, 40.23681], [-120.29044, 40.23357], [-120.29037, 40.23337], [-120.28996, 40.23275], [-120.28954, 40.23204], [-120.27795, 40.23201], [-120.27658, 40.23198], [-120.27398, 40.23375], [-120.2731, 40.23395], [-120.27162, 40.23427], [-120.26429, 40.23342], [-120.26129, 40.23298], [-120.25862, 40.23186], [-120.26421, 40.23193], [-120.26882, 40.23195], [-120.26891, 40.22843], [-120.27357, 40.22848], [-120.27365, 40.22468], [-120.27823, 40.22472], [-120.27824, 40.2285], [-120.28319, 40.22851], [-120.29244, 40.22858], [-120.2927, 40.22126], [-120.30198, 40.22125], [-120.30194, 40.22491], [-120.2973, 40.22484], [-120.29724, 40.22864], [-120.29725, 40.22865], [-120.30191, 40.22868], [-120.30188, 40.23211], [-120.29279, 40.23205], [-120.29281, 40.24239], [-120.30184, 40.2425], [-120.30188, 40.2388], [-120.30228, 40.23888], [-120.30518, 40.23891]]], [[[-120.26391, 40.52668], [-120.26132, 40.53768], [-120.25985, 40.53768], [-120.26245, 40.52666], [-120.26391, 40.52668]]], [[[-120.30444, 40.51223], [-120.29493, 40.51222], [-120.2949, 40.52674], [-120.29491, 40.53036], [-120.28521, 40.53039], [-120.28521, 40.52675], [-120.27572, 40.52676], [-120.27559, 40.51192], [-120.26733, 40.51203], [-120.27045, 40.49768], [-120.27703, 40.49776], [-120.27888, 40.49774], [-120.28092, 40.49778], [-120.28373, 40.49781], [-120.2846, 40.49798], [-120.28624, 40.49833], [-120.28712, 40.49849], [-120.29174, 40.4995], [-120.29203, 40.49963], [-120.29508, 40.50118], [-120.30191, 40.50486], [-120.3025, 40.50522], [-120.3027, 40.50597], [-120.30355, 40.50879], [-120.30444, 40.51223]]], [[[-120.29291, 40.20311], [-120.29285, 40.21054], [-120.29254, 40.21762], [-120.28327, 40.21757], [-120.28332, 40.20304], [-120.27395, 40.20297], [-120.27407, 40.19592], [-120.28345, 40.1959], [-120.28333, 40.20303], [-120.29291, 40.20311]]], [[[-120.27642, 40.16987], [-120.2743, 40.16988], [-120.27441, 40.16621], [-120.27522, 40.16621], [-120.27535, 40.16795], [-120.27642, 40.16987]]], [[[-120.28795, 40.2212], [-120.28788, 40.22475], [-120.28321, 40.22478], [-120.2832, 40.22119], [-120.28795, 40.2212]]], [[[-120.30243, 40.50494], [-120.2952, 40.50104], [-120.29214, 40.49949], [-120.29181, 40.49935], [-120.28717, 40.49833], [-120.2863, 40.49818], [-120.28466, 40.49783], [-120.2839, 40.49768], [-120.3005, 40.49766], [-120.30089, 40.49899], [-120.30196, 40.50297], [-120.30243, 40.50494]]], [[[-120.30449, 40.49766], [-120.30449, 40.49766], [-120.30443, 40.51037], [-120.30402, 40.50872], [-120.30322, 40.50586], [-120.30243, 40.50289], [-120.30162, 40.49996], [-120.30103, 40.49766], [-120.30449, 40.49766]]], [[[-120.35239, 40.50137], [-120.35236, 40.5067], [-120.35225, 40.5123], [-120.33316, 40.51224], [-120.33318, 40.50131], [-120.35239, 40.50137]]], [[[-120.39623, 41.06484], [-120.39586, 41.07573], [-120.38635, 41.07583], [-120.38643, 41.07222], [-120.38173, 41.07225], [-120.38188, 41.06497], [-120.39623, 41.06484]]], [[[-120.41191, 41.11825], [-120.40711, 41.11828], [-120.40705, 41.11102], [-120.41178, 41.11101], [-120.41191, 41.11825]]], [[[-120.49333, 41.13633], [-120.47411, 41.13636], [-120.47411, 41.12184], [-120.48582, 41.12184], [-120.48652, 41.12384], [-120.48672, 41.12427], [-120.48698, 41.12463], [-120.48763, 41.12527], [-120.48819, 41.12579], [-120.4883, 41.12903], [-120.48827, 41.12995], [-120.49308, 41.13002], [-120.49333, 41.13633]]], [[[-120.48816, 41.12489], [-120.48758, 41.12432], [-120.48738, 41.12403], [-120.48721, 41.12367], [-120.48657, 41.12184], [-120.48802, 41.12185], [-120.48816, 41.12489]]], [[[-120.75624, 40.37021], [-120.74682, 40.37011], [-120.74672, 40.36646], [-120.75614, 40.36656], [-120.75624, 40.37021]]], [[[-120.94273, 41.12488], [-120.94262, 41.13213], [-120.93288, 41.13219], [-120.93288, 41.12489], [-120.94273, 41.12488]]], [[[-120.9793, 40.89677], [-120.96972, 40.89676], [-120.96974, 40.90037], [-120.96496, 40.90037], [-120.96497, 40.90398], [-120.96054, 40.90397], [-120.96029, 40.89687], [-120.96014, 40.89686], [-120.96008, 40.88954], [-120.965, 40.88954], [-120.96501, 40.88961], [-120.96636, 40.88963], [-120.97926, 40.88974], [-120.9793, 40.89677]]], [[[-120.9781, 40.2943], [-120.97799, 40.29856], [-120.9726, 40.29847], [-120.97271, 40.29444], [-120.9781, 40.2943]]], [[[-121.00892, 40.90551], [-121.00881, 40.91981], [-121.00001, 40.91961], [-121.0, 40.91979], [-120.99746, 40.91974], [-120.98967, 40.91938], [-120.98968, 40.91418], [-120.98965, 40.91132], [-120.98967, 40.9111], [-120.98964, 40.90543], [-120.99619, 40.90559], [-120.99864, 40.90567], [-120.99923, 40.90563], [-121.00892, 40.90551]]], [[[-121.23877, 41.121], [-121.23395, 41.12099], [-121.23391, 41.11737], [-121.23873, 41.11736], [-121.23877, 41.121]]], [[[-121.33092, 40.95668], [-121.32168, 40.95677], [-121.32157, 40.95313], [-121.32862, 40.95305], [-121.33065, 40.95305], [-121.33066, 40.95303], [-121.33081, 40.95303], [-121.33092, 40.95668]]]]}	Open Access 1	23087	California State Lands Commission	16724	209	California State Lands Commission 75	State 5	State Agency 5	http://www.slc.ca.gov/	Other State 5	209	California State Lands Commission 73	State 5	State Agency 5		Lassen 54	19310.606	SLC	0	State Resource Management Area 55	3

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]);