calands: units_with_maps: 1 row where COUNTY = 52, MNG_AGENCY = 1 and MNG_AG

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

1 row where COUNTY = 52, MNG_AGENCY = 1 and MNG_AG_TYP = 1

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
2745	2745	2744	{"type": "MultiPolygon", "coordinates": [[[[-120.54073, 38.42302], [-120.54069, 38.42578], [-120.54042, 38.4263], [-120.5397, 38.42839], [-120.52668, 38.42828], [-120.52655, 38.43548], [-120.52152, 38.43545], [-120.5209, 38.43181], [-120.51885, 38.43182], [-120.51932, 38.43543], [-120.51729, 38.43542], [-120.51723, 38.43902], [-120.51721, 38.44289], [-120.51352, 38.44271], [-120.51019, 38.44267], [-120.50928, 38.44263], [-120.50803, 38.4426], [-120.50796, 38.44574], [-120.50798, 38.44615], [-120.50316, 38.44611], [-120.50301, 38.45331], [-120.4984, 38.45314], [-120.49831, 38.4602], [-120.48931, 38.45962], [-120.48914, 38.46329], [-120.48464, 38.46302], [-120.4849, 38.45933], [-120.48455, 38.45263], [-120.4846, 38.449], [-120.49384, 38.44935], [-120.49388, 38.44713], [-120.49397, 38.44719], [-120.49411, 38.44736], [-120.49419, 38.44752], [-120.4942, 38.4477], [-120.49411, 38.44821], [-120.49409, 38.44853], [-120.49425, 38.44884], [-120.49439, 38.44901], [-120.49462, 38.44922], [-120.49499, 38.44951], [-120.4953, 38.44962], [-120.4956, 38.44953], [-120.49579, 38.44943], [-120.49846, 38.44953], [-120.49849, 38.44823], [-120.4992, 38.44799], [-120.49966, 38.44778], [-120.49983, 38.44762], [-120.49996, 38.44742], [-120.5001, 38.44703], [-120.50003, 38.44677], [-120.49992, 38.44651], [-120.49985, 38.44638], [-120.49967, 38.44622], [-120.49909, 38.44597], [-120.49829, 38.4455], [-120.49811, 38.44533], [-120.49802, 38.44514], [-120.49797, 38.44497], [-120.49804, 38.44469], [-120.49814, 38.44451], [-120.49828, 38.4444], [-120.49882, 38.44431], [-120.50039, 38.44445], [-120.50065, 38.44445], [-120.50103, 38.44441], [-120.50104, 38.44438], [-120.50139, 38.44424], [-120.502, 38.44435], [-120.5023, 38.44446], [-120.50261, 38.44453], [-120.50286, 38.44456], [-120.50357, 38.44459], [-120.50387, 38.44456], [-120.50461, 38.4443], [-120.50484, 38.44421], [-120.50503, 38.44409], [-120.5052, 38.44395], [-120.50532, 38.44383], [-120.5056, 38.44325], [-120.50564, 38.4431], [-120.50552, 38.44252], [-120.5066, 38.44253], [-120.50664, 38.44257], [-120.50802, 38.4426], [-120.50794, 38.43895], [-120.50555, 38.43892], [-120.50583, 38.43875], [-120.50618, 38.43861], [-120.50711, 38.43818], [-120.50746, 38.43798], [-120.5077, 38.43782], [-120.50823, 38.4374], [-120.5085, 38.43713], [-120.50897, 38.43661], [-120.5094, 38.43601], [-120.50958, 38.43567], [-120.50982, 38.43535], [-120.51085, 38.43428], [-120.51237, 38.43233], [-120.51369, 38.43105], [-120.51404, 38.43079], [-120.51538, 38.42962], [-120.51609, 38.42915], [-120.51645, 38.42895], [-120.51687, 38.42875], [-120.51737, 38.42855], [-120.51928, 38.4277], [-120.52008, 38.42725], [-120.52045, 38.42697], [-120.52069, 38.4267], [-120.5209, 38.42644], [-120.52109, 38.42615], [-120.52121, 38.42588], [-120.52152, 38.42537], [-120.52183, 38.42493], [-120.52201, 38.42474], [-120.52215, 38.42451], [-120.52235, 38.42422], [-120.52255, 38.42377], [-120.52279, 38.42338], [-120.52288, 38.42321], [-120.52302, 38.42305], [-120.52324, 38.42288], [-120.52352, 38.42274], [-120.52376, 38.42266], [-120.52406, 38.42263], [-120.52442, 38.42265], [-120.52474, 38.42271], [-120.52538, 38.42288], [-120.52647, 38.42301], [-120.52767, 38.42261], [-120.52859, 38.42184], [-120.52878, 38.42159], [-120.52923, 38.42092], [-120.5296, 38.42033], [-120.52973, 38.41963], [-120.52987, 38.41926], [-120.52998, 38.41909], [-120.53012, 38.41897], [-120.53031, 38.41885], [-120.53062, 38.41877], [-120.53092, 38.41873], [-120.53168, 38.41874], [-120.53382, 38.41883], [-120.53454, 38.41872], [-120.53484, 38.4187], [-120.53532, 38.41863], [-120.53557, 38.41856], [-120.53576, 38.41845], [-120.53621, 38.41839], [-120.53649, 38.41833], [-120.53675, 38.41829], [-120.5372, 38.41828], [-120.53738, 38.41831], [-120.53791, 38.41853], [-120.53845, 38.41904], [-120.53871, 38.41941], [-120.5398, 38.42215], [-120.54017, 38.42285], [-120.54033, 38.42296], [-120.54058, 38.42305], [-120.54073, 38.42302]]], [[[-120.5679, 38.41851], [-120.56786, 38.42142], [-120.5678, 38.42368], [-120.5677, 38.42856], [-120.56353, 38.42845], [-120.55899, 38.42839], [-120.55441, 38.42839], [-120.55434, 38.4317], [-120.55366, 38.4317], [-120.54515, 38.43173], [-120.54512, 38.43197], [-120.54052, 38.43198], [-120.54054, 38.43097], [-120.54106, 38.43108], [-120.54369, 38.42281], [-120.54175, 38.42247], [-120.54204, 38.42226], [-120.54237, 38.42206], [-120.54295, 38.42181], [-120.54369, 38.42168], [-120.54593, 38.42111], [-120.54843, 38.42082], [-120.54947, 38.42063], [-120.55112, 38.42001], [-120.55147, 38.41964], [-120.55158, 38.41947], [-120.55175, 38.41871], [-120.55191, 38.4185], [-120.55232, 38.41825], [-120.55394, 38.4184], [-120.55433, 38.41825], [-120.55444, 38.41814], [-120.55465, 38.41782], [-120.55501, 38.41718], [-120.55532, 38.41712], [-120.5553, 38.41723], [-120.55508, 38.41778], [-120.55722, 38.41838], [-120.55778, 38.41703], [-120.55939, 38.4175], [-120.55964, 38.41972], [-120.56094, 38.41946], [-120.56079, 38.41632], [-120.56305, 38.41637], [-120.56332, 38.41505], [-120.5643, 38.41502], [-120.56599, 38.41515], [-120.56595, 38.4185], [-120.5679, 38.41851]], [[-120.5524, 38.4202], [-120.55038, 38.42029], [-120.55065, 38.42342], [-120.55048, 38.42443], [-120.55012, 38.42623], [-120.54818, 38.42592], [-120.54735, 38.4291], [-120.54836, 38.42926], [-120.54803, 38.42989], [-120.54804, 38.4299], [-120.54999, 38.42992], [-120.55213, 38.42627], [-120.55271, 38.42325], [-120.5524, 38.4202]], [[-120.56133, 38.42265], [-120.5605, 38.42067], [-120.55958, 38.42099], [-120.55851, 38.42132], [-120.55923, 38.42339], [-120.55929, 38.42571], [-120.56126, 38.42492], [-120.56133, 38.42265]], [[-120.56313, 38.42005], [-120.56298, 38.41851], [-120.56112, 38.41862], [-120.56133, 38.42264], [-120.56236, 38.42263], [-120.56252, 38.42423], [-120.56241, 38.42627], [-120.56223, 38.4283], [-120.56417, 38.42822], [-120.5643, 38.42619], [-120.56439, 38.42422], [-120.56408, 38.41999], [-120.56313, 38.42005]]], [[[-120.55156, 38.4464], [-120.54931, 38.44631], [-120.54941, 38.44421], [-120.55006, 38.44488], [-120.55156, 38.4464]]], [[[-120.56446, 38.43555], [-120.56442, 38.43646], [-120.5633, 38.43642], [-120.56215, 38.43641], [-120.56203, 38.43911], [-120.56313, 38.43913], [-120.5632, 38.44081], [-120.56272, 38.44082], [-120.56285, 38.44113], [-120.56125, 38.44148], [-120.5613, 38.44183], [-120.55994, 38.44206], [-120.56061, 38.445], [-120.56098, 38.44589], [-120.56101, 38.44601], [-120.56116, 38.44601], [-120.56118, 38.44607], [-120.56117, 38.44635], [-120.55857, 38.44632], [-120.55398, 38.44638], [-120.55365, 38.44643], [-120.55051, 38.44323], [-120.54946, 38.44321], [-120.54948, 38.44281], [-120.55396, 38.44277], [-120.55498, 38.44274], [-120.55499, 38.44273], [-120.55398, 38.44134], [-120.55398, 38.44131], [-120.55344, 38.44059], [-120.55402, 38.44058], [-120.55513, 38.44062], [-120.55588, 38.44061], [-120.55705, 38.44219], [-120.55716, 38.44269], [-120.55843, 38.44266], [-120.55856, 38.44054], [-120.55859, 38.43909], [-120.56067, 38.4391], [-120.56085, 38.43548], [-120.56446, 38.43555]]], [[[-120.57257, 38.47565], [-120.57252, 38.47926], [-120.56786, 38.47919], [-120.5678, 38.48281], [-120.56314, 38.48275], [-120.5632, 38.47912], [-120.56785, 38.47919], [-120.56792, 38.47557], [-120.57257, 38.47565]]], [[[-120.56778, 38.45019], [-120.56491, 38.45013], [-120.56491, 38.44907], [-120.56314, 38.44903], [-120.56319, 38.44637], [-120.56368, 38.44636], [-120.56755, 38.4464], [-120.56778, 38.45019]]], [[[-120.59617, 38.39968], [-120.59613, 38.40296], [-120.58255, 38.40342], [-120.58185, 38.41078], [-120.58178, 38.41318], [-120.58178, 38.4144], [-120.5818, 38.41565], [-120.58176, 38.41566], [-120.58179, 38.41793], [-120.57261, 38.41783], [-120.57256, 38.42154], [-120.57173, 38.42153], [-120.57202, 38.41454], [-120.57055, 38.41452], [-120.57151, 38.41395], [-120.5722, 38.41299], [-120.57227, 38.41272], [-120.5723, 38.41228], [-120.57229, 38.41197], [-120.57217, 38.41167], [-120.57194, 38.4112], [-120.57173, 38.41081], [-120.57156, 38.41057], [-120.57142, 38.4103], [-120.57135, 38.41005], [-120.57111, 38.40948], [-120.57073, 38.40867], [-120.57059, 38.40826], [-120.5705, 38.40785], [-120.57048, 38.40765], [-120.57057, 38.40723], [-120.57074, 38.40688], [-120.57088, 38.40665], [-120.57106, 38.40645], [-120.57147, 38.40606], [-120.57201, 38.40551], [-120.5725, 38.40488], [-120.57295, 38.40409], [-120.57328, 38.40311], [-120.57359, 38.40256], [-120.57388, 38.40216], [-120.57442, 38.40184], [-120.57477, 38.40168], [-120.57508, 38.40158], [-120.57578, 38.40142], [-120.57791, 38.40139], [-120.57877, 38.40154], [-120.57981, 38.4016], [-120.58041, 38.4016], [-120.58128, 38.40154], [-120.5826, 38.40127], [-120.58319, 38.4011], [-120.58368, 38.40088], [-120.58418, 38.40076], [-120.58479, 38.40066], [-120.58538, 38.4006], [-120.58698, 38.4005], [-120.58739, 38.40046], [-120.58819, 38.40008], [-120.58914, 38.39954], [-120.58962, 38.39938], [-120.59085, 38.39924], [-120.59123, 38.39922], [-120.59304, 38.39937], [-120.59588, 38.39967], [-120.59617, 38.39968]]], [[[-120.57602, 38.42307], [-120.57425, 38.42301], [-120.57384, 38.41888], [-120.57561, 38.41892], [-120.57602, 38.42307]]], [[[-120.59125, 38.49553], [-120.5866, 38.49568], [-120.58663, 38.49411], [-120.58665, 38.49362], [-120.59122, 38.49339], [-120.59125, 38.49553]]], [[[-120.58864, 38.454], [-120.58845, 38.45792], [-120.58735, 38.45793], [-120.58735, 38.45402], [-120.58864, 38.454]]], [[[-120.59549, 38.43104], [-120.5941, 38.4311], [-120.5923, 38.43139], [-120.59056, 38.43122], [-120.58942, 38.43127], [-120.58943, 38.42903], [-120.59101, 38.42905], [-120.59263, 38.42836], [-120.59281, 38.42868], [-120.59431, 38.42893], [-120.59456, 38.4293], [-120.59487, 38.42922], [-120.59521, 38.42905], [-120.59533, 38.42885], [-120.59549, 38.43104]]], [[[-120.6261, 38.4575], [-120.62601, 38.46114], [-120.62367, 38.46115], [-120.62367, 38.46477], [-120.61905, 38.4648], [-120.61903, 38.46843], [-120.61439, 38.46847], [-120.61442, 38.47205], [-120.61007, 38.47198], [-120.60599, 38.46665], [-120.60571, 38.46681], [-120.60966, 38.47198], [-120.60522, 38.47191], [-120.60523, 38.46833], [-120.60064, 38.46826], [-120.60063, 38.46463], [-120.60523, 38.46469], [-120.60523, 38.46106], [-120.60984, 38.46112], [-120.60982, 38.46839], [-120.61438, 38.46846], [-120.61444, 38.46118], [-120.6144, 38.45818], [-120.61524, 38.45932], [-120.61913, 38.45757], [-120.62367, 38.45755], [-120.6261, 38.4575]]], [[[-120.61059, 38.39189], [-120.61018, 38.39493], [-120.60976, 38.39493], [-120.61003, 38.39395], [-120.61028, 38.3929], [-120.61052, 38.39202], [-120.61059, 38.39189]]], [[[-120.6385, 38.34104], [-120.63849, 38.3414], [-120.63398, 38.34124], [-120.63391, 38.34512], [-120.63844, 38.34496], [-120.63839, 38.34852], [-120.63385, 38.34867], [-120.63369, 38.35224], [-120.63362, 38.35574], [-120.62916, 38.35564], [-120.62906, 38.35916], [-120.62133, 38.35897], [-120.6218, 38.36598], [-120.6196, 38.36593], [-120.62072, 38.37297], [-120.61621, 38.37273], [-120.61551, 38.37281], [-120.61586, 38.37447], [-120.61519, 38.37451], [-120.61515, 38.37442], [-120.61507, 38.37369], [-120.61489, 38.37294], [-120.61474, 38.37268], [-120.6146, 38.37254], [-120.61441, 38.37239], [-120.61415, 38.37226], [-120.61382, 38.37219], [-120.61343, 38.37214], [-120.61298, 38.37205], [-120.61222, 38.37199], [-120.61153, 38.37189], [-120.61097, 38.37179], [-120.6105, 38.37163], [-120.61036, 38.37155], [-120.61029, 38.37117], [-120.61033, 38.37102], [-120.61036, 38.37063], [-120.61052, 38.37016], [-120.61064, 38.36992], [-120.61082, 38.36972], [-120.61114, 38.3694], [-120.61158, 38.36903], [-120.61201, 38.36874], [-120.61278, 38.36838], [-120.61318, 38.36828], [-120.61462, 38.36808], [-120.61557, 38.36797], [-120.61613, 38.36787], [-120.61639, 38.36781], [-120.61658, 38.36775], [-120.61675, 38.36765], [-120.61731, 38.36724], [-120.61838, 38.36684], [-120.61878, 38.36634], [-120.61892, 38.36604], [-120.61896, 38.36589], [-120.61899, 38.36538], [-120.61883, 38.36494], [-120.61772, 38.36328], [-120.61765, 38.36304], [-120.61759, 38.36188], [-120.61759, 38.36163], [-120.61769, 38.36111], [-120.61804, 38.36031], [-120.61837, 38.35947], [-120.61869, 38.3588], [-120.61896, 38.35838], [-120.61937, 38.35777], [-120.61951, 38.35764], [-120.61977, 38.35746], [-120.62023, 38.35736], [-120.62064, 38.35733], [-120.62163, 38.35732], [-120.62258, 38.35743], [-120.62311, 38.35754], [-120.62335, 38.35757], [-120.62394, 38.35756], [-120.62413, 38.35749], [-120.62477, 38.35732], [-120.62536, 38.3571], [-120.62559, 38.35695], [-120.62604, 38.35702], [-120.62665, 38.35671], [-120.62783, 38.35619], [-120.62811, 38.35599], [-120.62825, 38.35583], [-120.62838, 38.35558], [-120.62849, 38.3553], [-120.62856, 38.35496], [-120.62856, 38.35463], [-120.62861, 38.35417], [-120.62871, 38.35367], [-120.62892, 38.35293], [-120.62901, 38.35218], [-120.62917, 38.35145], [-120.62934, 38.35104], [-120.62956, 38.35066], [-120.62967, 38.35044], [-120.62982, 38.35002], [-120.62986, 38.34981], [-120.62993, 38.34963], [-120.63008, 38.34934], [-120.63021, 38.34917], [-120.63047, 38.34861], [-120.63059, 38.34841], [-120.63066, 38.34824], [-120.63069, 38.34808], [-120.63123, 38.34722], [-120.63147, 38.34695], [-120.63187, 38.34636], [-120.63194, 38.34621], [-120.63201, 38.34594], [-120.632, 38.34576], [-120.63192, 38.34558], [-120.63188, 38.34551], [-120.6318, 38.34541], [-120.63121, 38.34483], [-120.63108, 38.34462], [-120.63078, 38.344], [-120.63069, 38.34378], [-120.63061, 38.34349], [-120.63047, 38.3429], [-120.63047, 38.34263], [-120.63062, 38.34198], [-120.63073, 38.3417], [-120.63087, 38.34148], [-120.63099, 38.34113], [-120.63397, 38.34124], [-120.634, 38.34008], [-120.63443, 38.34022], [-120.63601, 38.34059], [-120.63715, 38.34092], [-120.63797, 38.34104], [-120.6385, 38.34104]]], [[[-120.63407, 38.38841], [-120.63396, 38.38918], [-120.63406, 38.38921], [-120.63398, 38.38941], [-120.63368, 38.39206], [-120.62907, 38.39177], [-120.62726, 38.39163], [-120.62449, 38.39146], [-120.62512, 38.38785], [-120.61617, 38.38732], [-120.61549, 38.39111], [-120.6112, 38.39118], [-120.61141, 38.39104], [-120.61177, 38.39083], [-120.6121, 38.39069], [-120.61245, 38.39057], [-120.61338, 38.39035], [-120.61375, 38.39023], [-120.61456, 38.3898], [-120.61477, 38.38965], [-120.615, 38.38939], [-120.61515, 38.38911], [-120.61524, 38.3888], [-120.61526, 38.38861], [-120.61519, 38.38812], [-120.61502, 38.38769], [-120.61453, 38.3867], [-120.61443, 38.38637], [-120.61428, 38.38559], [-120.61423, 38.38513], [-120.6142, 38.38419], [-120.61423, 38.38328], [-120.61422, 38.38275], [-120.61427, 38.38235], [-120.61447, 38.38186], [-120.61458, 38.38149], [-120.6147, 38.38115], [-120.61488, 38.38084], [-120.61505, 38.38058], [-120.61522, 38.38042], [-120.61553, 38.3802], [-120.61661, 38.37952], [-120.61698, 38.37917], [-120.61724, 38.37875], [-120.61732, 38.37853], [-120.61738, 38.37821], [-120.61737, 38.37793], [-120.61732, 38.37759], [-120.61714, 38.37712], [-120.61701, 38.37692], [-120.61682, 38.37666], [-120.61647, 38.37623], [-120.61684, 38.37621], [-120.62128, 38.3765], [-120.62184, 38.38003], [-120.62622, 38.38036], [-120.62513, 38.38785], [-120.63407, 38.38841]]], [[[-120.62826, 38.49513], [-120.62819, 38.49877], [-120.62372, 38.49886], [-120.62384, 38.49523], [-120.62826, 38.49513]]], [[[-120.66073, 38.4802], [-120.65146, 38.482], [-120.64217, 38.48217], [-120.63751, 38.48223], [-120.63748, 38.47874], [-120.63646, 38.47874], [-120.64101, 38.47768], [-120.64097, 38.47624], [-120.63596, 38.4774], [-120.63601, 38.47875], [-120.63517, 38.47876], [-120.63516, 38.477], [-120.63746, 38.47696], [-120.63745, 38.4752], [-120.64206, 38.47515], [-120.64201, 38.4717], [-120.64397, 38.47167], [-120.64404, 38.47187], [-120.64676, 38.47131], [-120.64677, 38.47163], [-120.65152, 38.47156], [-120.65382, 38.47148], [-120.6538, 38.4749], [-120.65381, 38.47491], [-120.65841, 38.47466], [-120.65842, 38.47132], [-120.66072, 38.47124], [-120.66073, 38.4802]]], [[[-120.64572, 38.44462], [-120.64361, 38.44625], [-120.64161, 38.44633], [-120.64147, 38.44611], [-120.64128, 38.44634], [-120.64036, 38.44638], [-120.63923, 38.44582], [-120.642, 38.44233], [-120.64378, 38.44321], [-120.64244, 38.44489], [-120.64244, 38.44491], [-120.64482, 38.44315], [-120.64572, 38.44462]]], [[[-120.64211, 38.45892], [-120.64208, 38.46085], [-120.63982, 38.46092], [-120.6398, 38.459], [-120.64211, 38.45892]]], [[[-120.65003, 38.44487], [-120.64789, 38.44608], [-120.64465, 38.44621], [-120.64444, 38.44601], [-120.64868, 38.4436], [-120.65003, 38.44487]]], [[[-120.65117, 38.49243], [-120.65109, 38.49526], [-120.64649, 38.4952], [-120.64656, 38.49246], [-120.65117, 38.49243]]], [[[-120.65618, 38.41743], [-120.65609, 38.42101], [-120.65337, 38.42103], [-120.65146, 38.42101], [-120.64677, 38.42108], [-120.64672, 38.4203], [-120.64669, 38.41902], [-120.64661, 38.41743], [-120.65123, 38.41737], [-120.65618, 38.41743]]], [[[-120.65598, 38.41378], [-120.65588, 38.41389], [-120.65346, 38.41595], [-120.65215, 38.41711], [-120.65127, 38.4165], [-120.65133, 38.41536], [-120.65308, 38.41383], [-120.65598, 38.41378]]], [[[-120.65685, 38.33076], [-120.65673, 38.3337], [-120.65252, 38.33373], [-120.65272, 38.3336], [-120.65311, 38.33329], [-120.65347, 38.33296], [-120.65408, 38.33256], [-120.65455, 38.3322], [-120.65497, 38.33194], [-120.65532, 38.33167], [-120.65559, 38.33149], [-120.65606, 38.33111], [-120.65627, 38.33098], [-120.6566, 38.33082], [-120.65685, 38.33076]]], [[[-120.6697, 38.4881], [-120.6695, 38.49548], [-120.66261, 38.4954], [-120.66269, 38.49219], [-120.66499, 38.49214], [-120.66504, 38.49023], [-120.66045, 38.49039], [-120.6604, 38.49172], [-120.6558, 38.49174], [-120.65588, 38.48875], [-120.6697, 38.4881]]], [[[-120.66554, 38.39246], [-120.66488, 38.39265], [-120.66502, 38.39201], [-120.66099, 38.39139], [-120.6609, 38.39168], [-120.65623, 38.39167], [-120.65625, 38.38805], [-120.65962, 38.38805], [-120.6596, 38.39079], [-120.66167, 38.39081], [-120.66374, 38.39088], [-120.66377, 38.38888], [-120.66546, 38.38888], [-120.66547, 38.38986], [-120.66553, 38.39163], [-120.66554, 38.39246]]], [[[-120.67003, 38.38799], [-120.66657, 38.38805], [-120.66657, 38.38723], [-120.66379, 38.38723], [-120.66379, 38.38698], [-120.66402, 38.38698], [-120.66403, 38.3864], [-120.664, 38.38593], [-120.66277, 38.38592], [-120.66277, 38.38697], [-120.66174, 38.38694], [-120.66088, 38.38693], [-120.66086, 38.38445], [-120.66503, 38.38447], [-120.66507, 38.38581], [-120.66613, 38.3859], [-120.66614, 38.38589], [-120.66607, 38.38447], [-120.66998, 38.38448], [-120.67003, 38.38799]]], [[[-120.69796, 38.43802], [-120.69789, 38.43852], [-120.69778, 38.43989], [-120.6974, 38.44363], [-120.69734, 38.4454], [-120.69472, 38.44537], [-120.69475, 38.44401], [-120.69473, 38.44397], [-120.69373, 38.44419], [-120.69288, 38.44433], [-120.6905, 38.44479], [-120.69048, 38.44523], [-120.68833, 38.44526], [-120.68371, 38.44542], [-120.6838, 38.44183], [-120.67906, 38.442], [-120.67911, 38.43849], [-120.66994, 38.43886], [-120.67002, 38.43713], [-120.67684, 38.43668], [-120.67681, 38.43499], [-120.6791, 38.43489], [-120.67913, 38.43849], [-120.68844, 38.43802], [-120.69796, 38.43802]]], [[[-120.67497, 38.33717], [-120.67494, 38.34081], [-120.67037, 38.34079], [-120.67039, 38.33715], [-120.67497, 38.33717]]], [[[-120.76216, 38.46376], [-120.76215, 38.46743], [-120.75754, 38.46744], [-120.75754, 38.46376], [-120.75291, 38.46376], [-120.75289, 38.46744], [-120.74372, 38.46746], [-120.72937, 38.46719], [-120.72933, 38.47064], [-120.74358, 38.47077], [-120.74822, 38.47077], [-120.74804, 38.47434], [-120.74351, 38.47436], [-120.73412, 38.47423], [-120.73398, 38.47777], [-120.72912, 38.4777], [-120.72917, 38.47415], [-120.71982, 38.474], [-120.71982, 38.47052], [-120.71515, 38.47044], [-120.71519, 38.46693], [-120.71052, 38.46684], [-120.71054, 38.46311], [-120.70585, 38.46311], [-120.69505, 38.46341], [-120.69502, 38.45976], [-120.68839, 38.45993], [-120.6791, 38.46012], [-120.67913, 38.45641], [-120.67456, 38.45648], [-120.6746, 38.45273], [-120.6792, 38.45269], [-120.67919, 38.45069], [-120.67916, 38.44914], [-120.68832, 38.44892], [-120.6883, 38.45258], [-120.68835, 38.45626], [-120.70585, 38.45579], [-120.71545, 38.45593], [-120.7153, 38.45957], [-120.73429, 38.45984], [-120.74374, 38.46009], [-120.74823, 38.46016], [-120.74823, 38.46375], [-120.7529, 38.46376], [-120.75292, 38.46013], [-120.75756, 38.4601], [-120.75755, 38.46376], [-120.76216, 38.46376]]], [[[-120.71143, 38.31544], [-120.71141, 38.31586], [-120.71125, 38.31589], [-120.71058, 38.31595], [-120.71035, 38.31591], [-120.70963, 38.31594], [-120.70946, 38.31593], [-120.70801, 38.31594], [-120.70742, 38.31599], [-120.70694, 38.31608], [-120.70681, 38.3161], [-120.70678, 38.31927], [-120.69312, 38.31912], [-120.69337, 38.32279], [-120.68902, 38.3228], [-120.68902, 38.3264], [-120.68437, 38.32636], [-120.68425, 38.32369], [-120.68491, 38.32273], [-120.68509, 38.32242], [-120.68543, 38.32173], [-120.68564, 38.32108], [-120.68585, 38.32056], [-120.68603, 38.32029], [-120.68618, 38.32011], [-120.68639, 38.31996], [-120.68661, 38.31978], [-120.68691, 38.31959], [-120.6874, 38.31936], [-120.6879, 38.31916], [-120.6888, 38.31886], [-120.69064, 38.31843], [-120.69105, 38.31829], [-120.69188, 38.31806], [-120.6928, 38.31793], [-120.69514, 38.31797], [-120.69551, 38.31803], [-120.69639, 38.31824], [-120.69696, 38.31826], [-120.69768, 38.31826], [-120.69823, 38.31828], [-120.6989, 38.31827], [-120.69962, 38.31811], [-120.70002, 38.31795], [-120.70049, 38.31764], [-120.7012, 38.31713], [-120.70172, 38.31684], [-120.70283, 38.31641], [-120.70337, 38.31624], [-120.70453, 38.31598], [-120.70505, 38.3159], [-120.7054, 38.31587], [-120.70717, 38.31556], [-120.70971, 38.31542], [-120.71032, 38.31547], [-120.71129, 38.31545], [-120.71143, 38.31544]]], [[[-120.69278, 38.47075], [-120.68832, 38.47092], [-120.68833, 38.46732], [-120.69278, 38.46718], [-120.69278, 38.47075]]], [[[-120.70661, 38.44141], [-120.7058, 38.44489], [-120.70158, 38.44501], [-120.70197, 38.44196], [-120.70205, 38.44149], [-120.70661, 38.44141]]], [[[-120.72068, 38.44519], [-120.72054, 38.44871], [-120.71582, 38.44863], [-120.71597, 38.44513], [-120.72068, 38.44519]]], [[[-120.73831, 38.32284], [-120.73452, 38.32283], [-120.73758, 38.32137], [-120.73688, 38.31898], [-120.7382, 38.31888], [-120.73831, 38.32284]]], [[[-120.74754, 38.48499], [-120.74754, 38.48869], [-120.74288, 38.48868], [-120.74302, 38.48499], [-120.74754, 38.48499]]], [[[-120.74851, 38.45294], [-120.74838, 38.45661], [-120.74376, 38.45666], [-120.74377, 38.45282], [-120.74851, 38.45294]]], [[[-120.74881, 38.44211], [-120.74876, 38.44324], [-120.74871, 38.44579], [-120.744, 38.44576], [-120.74399, 38.44212], [-120.74881, 38.44211]]], [[[-120.75413, 38.31175], [-120.75392, 38.31188], [-120.75406, 38.31225], [-120.75178, 38.31222], [-120.75121, 38.31046], [-120.75116, 38.3096], [-120.75016, 38.30606], [-120.752, 38.30608], [-120.75209, 38.30531], [-120.75323, 38.30789], [-120.75325, 38.30876], [-120.75345, 38.31152], [-120.75404, 38.31161], [-120.75413, 38.31175]]], [[[-120.76413, 38.49615], [-120.75201, 38.49604], [-120.75209, 38.4925], [-120.7547, 38.49254], [-120.75471, 38.49428], [-120.7593, 38.49431], [-120.75933, 38.49245], [-120.76184, 38.49251], [-120.76316, 38.49244], [-120.76397, 38.49249], [-120.76413, 38.49615]]], [[[-120.75439, 38.32197], [-120.75374, 38.3221], [-120.75358, 38.32153], [-120.75204, 38.3218], [-120.75206, 38.32116], [-120.75341, 38.32106], [-120.75257, 38.31695], [-120.75273, 38.31692], [-120.75261, 38.31635], [-120.75271, 38.31633], [-120.75312, 38.31632], [-120.75414, 38.32036], [-120.75439, 38.32197]]], [[[-120.75717, 38.48722], [-120.75716, 38.48871], [-120.75218, 38.4887], [-120.75229, 38.48496], [-120.75229, 38.48351], [-120.75464, 38.48353], [-120.75463, 38.48715], [-120.75717, 38.48722]]], [[[-120.76495, 38.29838], [-120.76047, 38.29838], [-120.76035, 38.29477], [-120.76476, 38.29477], [-120.76495, 38.29838]]], [[[-120.77066, 38.30228], [-120.77062, 38.30578], [-120.76995, 38.30592], [-120.7699, 38.30392], [-120.76891, 38.30265], [-120.76579, 38.30288], [-120.76572, 38.3022], [-120.77066, 38.30228]]], [[[-120.77129, 38.43134], [-120.77127, 38.43489], [-120.77116, 38.43849], [-120.76669, 38.43847], [-120.76685, 38.43127], [-120.77129, 38.43134]]], [[[-120.79145, 38.50402], [-120.79024, 38.50401], [-120.79013, 38.50048], [-120.79135, 38.50047], [-120.79145, 38.50402]]], [[[-120.81499, 38.5617], [-120.81396, 38.56214], [-120.81362, 38.56223], [-120.81329, 38.56224], [-120.81237, 38.56208], [-120.81207, 38.562], [-120.8115, 38.56196], [-120.81089, 38.56186], [-120.81056, 38.56179], [-120.81028, 38.5617], [-120.81499, 38.5617]]], [[[-120.82519, 38.556], [-120.82474, 38.55632], [-120.82462, 38.55647], [-120.82447, 38.55661], [-120.82417, 38.55701], [-120.82407, 38.55725], [-120.82402, 38.55781], [-120.82405, 38.55808], [-120.81821, 38.55806], [-120.81797, 38.55804], [-120.8176, 38.55806], [-120.81617, 38.55804], [-120.81619, 38.55454], [-120.82057, 38.55453], [-120.82519, 38.55467], [-120.82519, 38.556]]], [[[-120.82002, 38.42444], [-120.81787, 38.42439], [-120.81785, 38.4219], [-120.81735, 38.42103], [-120.81965, 38.42101], [-120.82, 38.42169], [-120.82002, 38.42444]]], [[[-120.84498, 38.45437], [-120.84498, 38.45482], [-120.84322, 38.45473], [-120.84321, 38.45474], [-120.84331, 38.45815], [-120.84477, 38.45828], [-120.84467, 38.46103], [-120.84272, 38.46105], [-120.84259, 38.45949], [-120.84054, 38.45957], [-120.84065, 38.46104], [-120.83545, 38.46094], [-120.83767, 38.46083], [-120.83768, 38.46082], [-120.83762, 38.46065], [-120.8384, 38.46065], [-120.83854, 38.46073], [-120.83951, 38.46052], [-120.83938, 38.45897], [-120.841, 38.45898], [-120.84043, 38.45526], [-120.8386, 38.45517], [-120.83836, 38.45398], [-120.83869, 38.45395], [-120.8387, 38.45393], [-120.83774, 38.45215], [-120.8379, 38.45203], [-120.83728, 38.45154], [-120.83858, 38.45082], [-120.83881, 38.45065], [-120.83881, 38.45049], [-120.84108, 38.45047], [-120.84088, 38.4543], [-120.84498, 38.45437]]], [[[-120.84216, 38.50443], [-120.84114, 38.50689], [-120.83885, 38.50691], [-120.83991, 38.50436], [-120.84216, 38.50443]]], [[[-120.84794, 38.46706], [-120.84795, 38.46807], [-120.84789, 38.46893], [-120.84616, 38.46889], [-120.84616, 38.46805], [-120.84339, 38.468], [-120.84334, 38.46778], [-120.84435, 38.46757], [-120.84312, 38.46449], [-120.84544, 38.46448], [-120.84606, 38.46702], [-120.84623, 38.46701], [-120.8478, 38.46702], [-120.84794, 38.46706]]], [[[-120.85667, 38.54735], [-120.8525, 38.54733], [-120.85244, 38.54392], [-120.85568, 38.54394], [-120.85555, 38.54441], [-120.8556, 38.54466], [-120.85568, 38.54488], [-120.85619, 38.54562], [-120.85655, 38.54632], [-120.85664, 38.54667], [-120.85664, 38.54683], [-120.85669, 38.5472], [-120.85667, 38.54735]]], [[[-120.8639, 38.32379], [-120.86389, 38.32723], [-120.85915, 38.32714], [-120.85923, 38.32369], [-120.8639, 38.32379]]], [[[-120.87138, 38.53647], [-120.8712, 38.53634], [-120.87096, 38.53623], [-120.87074, 38.53609], [-120.8703, 38.53592], [-120.86976, 38.53585], [-120.8695, 38.53578], [-120.86929, 38.53577], [-120.86903, 38.53572], [-120.86867, 38.53562], [-120.86803, 38.53558], [-120.86766, 38.53557], [-120.86733, 38.5355], [-120.86692, 38.53544], [-120.86657, 38.53542], [-120.86619, 38.53536], [-120.86584, 38.53532], [-120.86553, 38.53526], [-120.86494, 38.5352], [-120.86456, 38.53517], [-120.86419, 38.53512], [-120.86397, 38.53512], [-120.8637, 38.53522], [-120.8635, 38.53531], [-120.86325, 38.53561], [-120.86306, 38.53596], [-120.86303, 38.5361], [-120.86301, 38.53655], [-120.86297, 38.53702], [-120.86202, 38.53698], [-120.86196, 38.53363], [-120.87133, 38.53372], [-120.87138, 38.53647]]], [[[-120.87251, 38.31305], [-120.8678, 38.31318], [-120.86763, 38.30976], [-120.86786, 38.30975], [-120.86772, 38.30624], [-120.87234, 38.30619], [-120.87238, 38.30976], [-120.87251, 38.31305]]], [[[-120.9, 38.24074], [-120.89539, 38.24081], [-120.89541, 38.2445], [-120.89086, 38.24461], [-120.89091, 38.24822], [-120.88627, 38.24815], [-120.88613, 38.24454], [-120.88602, 38.24081], [-120.89079, 38.24087], [-120.89074, 38.23717], [-120.89994, 38.23699], [-120.9, 38.24074]]], [[[-120.89893, 38.28567], [-120.89891, 38.28681], [-120.89793, 38.28682], [-120.89792, 38.28763], [-120.89542, 38.28759], [-120.89537, 38.28842], [-120.8918, 38.28835], [-120.89182, 38.28759], [-120.89181, 38.28758], [-120.88623, 38.28755], [-120.88622, 38.28493], [-120.88623, 38.28393], [-120.8909, 38.28391], [-120.89093, 38.28499], [-120.89535, 38.28499], [-120.89538, 38.28572], [-120.89893, 38.28567]]], [[[-120.90057, 38.26666], [-120.90051, 38.26989], [-120.89563, 38.26999], [-120.89583, 38.26677], [-120.90057, 38.26666]]], [[[-120.90635, 38.39056], [-120.9063, 38.39401], [-120.90397, 38.39399], [-120.90405, 38.3919], [-120.90493, 38.39132], [-120.90546, 38.39092], [-120.90607, 38.39036], [-120.90635, 38.39056]]], [[[-120.90654, 38.38641], [-120.90638, 38.38972], [-120.90604, 38.39012], [-120.90594, 38.39], [-120.90588, 38.38989], [-120.90582, 38.3897], [-120.90582, 38.38954], [-120.90565, 38.38954], [-120.90565, 38.38971], [-120.90567, 38.38982], [-120.90406, 38.38984], [-120.90409, 38.38637], [-120.90654, 38.38641]]], [[[-120.92362, 38.51677], [-120.92362, 38.51692], [-120.92357, 38.51711], [-120.92359, 38.51736], [-120.92369, 38.51774], [-120.92367, 38.51798], [-120.92359, 38.51819], [-120.92345, 38.51865], [-120.92334, 38.5188], [-120.92326, 38.51887], [-120.9231, 38.51906], [-120.92298, 38.51917], [-120.92277, 38.51927], [-120.92258, 38.51933], [-120.92232, 38.51942], [-120.92175, 38.51953], [-120.92117, 38.51957], [-120.92084, 38.51954], [-120.92023, 38.51958], [-120.92002, 38.51958], [-120.91918, 38.51973], [-120.91872, 38.51992], [-120.91863, 38.51656], [-120.92107, 38.51671], [-120.92192, 38.51661], [-120.92362, 38.51677]]], [[[-120.94759, 38.52257], [-120.94756, 38.52307], [-120.94734, 38.52313], [-120.94714, 38.52312], [-120.94666, 38.52322], [-120.9461, 38.52351], [-120.94586, 38.52366], [-120.9457, 38.52377], [-120.94531, 38.52434], [-120.94503, 38.52459], [-120.9448, 38.52484], [-120.94472, 38.52497], [-120.94325, 38.52405], [-120.94166, 38.5277], [-120.94238, 38.52818], [-120.94182, 38.52838], [-120.94152, 38.52853], [-120.94107, 38.52868], [-120.94069, 38.52864], [-120.94003, 38.52845], [-120.93954, 38.52828], [-120.93923, 38.52809], [-120.93895, 38.5279], [-120.93831, 38.52726], [-120.93815, 38.52699], [-120.93779, 38.52603], [-120.93756, 38.52558], [-120.93751, 38.52537], [-120.93749, 38.52486], [-120.93756, 38.52433], [-120.93772, 38.5239], [-120.93777, 38.52361], [-120.93775, 38.52348], [-120.9377, 38.52344], [-120.93761, 38.52334], [-120.93748, 38.52328], [-120.93739, 38.52321], [-120.93718, 38.52298], [-120.93709, 38.52282], [-120.93702, 38.52261], [-120.93694, 38.52209], [-120.93681, 38.52184], [-120.93666, 38.52161], [-120.9365, 38.52143], [-120.93633, 38.52107], [-120.93633, 38.52087], [-120.9364, 38.52072], [-120.93648, 38.52063], [-120.94512, 38.52068], [-120.94525, 38.52256], [-120.94759, 38.52257]]], [[[-120.99674, 38.42704], [-120.99669, 38.42882], [-120.99206, 38.42872], [-120.99208, 38.42696], [-120.98794, 38.42677], [-120.988, 38.42297], [-120.99223, 38.42301], [-120.9921, 38.42696], [-120.99674, 38.42704]]], [[[-120.99602, 38.47019], [-120.99602, 38.47201], [-120.99137, 38.47197], [-120.99132, 38.47015], [-120.99602, 38.47019]]], [[[-121.01243, 38.46723], [-121.01027, 38.46715], [-121.01019, 38.46352], [-121.01234, 38.4636], [-121.01243, 38.46723]]], [[[-121.02411, 38.45676], [-121.02411, 38.45863], [-121.01935, 38.45847], [-121.01932, 38.4566], [-121.02411, 38.45676]]]]}	Open Access 1	21463	BLM	16162	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1	http://www.blm.gov/wo/st/en.html	US Bureau of Land Management 1	102	United States Bureau of Land Management 1	Federal 1	Federal Agency 1		Amador 52	8769.468	BLM	1899	National Public Lands 1	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]);