superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 5 and YR_EST = 2014
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15320 | 15320 | 15319 | {"type": "MultiPolygon", "coordinates": [[[[-118.0362, 35.3479], [-118.03618, 35.35503], [-118.03587, 35.36078], [-118.02227, 35.36093], [-118.02225, 35.37268], [-118.01273, 35.37258], [-118.01328, 35.37134], [-118.00941, 35.36101], [-118.01842, 35.36094], [-118.01852, 35.35432], [-118.0184, 35.34712], [-118.00965, 35.34718], [-118.00429, 35.34742], [-118.00073, 35.33791], [-118.00063, 35.33312], [-118.00952, 35.33307], [-118.01846, 35.33271], [-118.01855, 35.32552], [-118.01823, 35.31888], [-118.01917, 35.31887], [-118.01978, 35.31939], [-118.02019, 35.32032], [-118.02142, 35.32138], [-118.02182, 35.32229], [-118.02158, 35.32309], [-118.0221, 35.32467], [-118.02217, 35.325], [-118.02218, 35.32533], [-118.02214, 35.32567], [-118.02207, 35.32591], [-118.02158, 35.32705], [-118.02268, 35.32825], [-118.02374, 35.33163], [-118.02405, 35.33299], [-118.01847, 35.33273], [-118.01836, 35.33991], [-118.01841, 35.3471], [-118.02733, 35.34786], [-118.0362, 35.3479]]], [[[-118.00343, 35.34746], [-118.00094, 35.34757], [-118.00078, 35.34039], [-118.00078, 35.34039], [-118.00343, 35.34746]]], [[[-118.01051, 35.30115], [-118.00788, 35.3084], [-118.00786, 35.30831], [-118.00345, 35.30826], [-118.00343, 35.30111], [-118.01051, 35.30115]]], [[[-118.00662, 35.31188], [-118.00533, 35.31544], [-118.00347, 35.31541], [-118.00346, 35.31184], [-118.00662, 35.31188]]], [[[-118.017, 35.31562], [-118.0062, 35.31545], [-118.00749, 35.31189], [-118.00788, 35.31188], [-118.00788, 35.3108], [-118.01138, 35.30115], [-118.01402, 35.30116], [-118.01553, 35.30397], [-118.01532, 35.31007], [-118.01532, 35.3106], [-118.01537, 35.31112], [-118.01541, 35.31138], [-118.01552, 35.3119], [-118.01568, 35.31241], [-118.01588, 35.31291], [-118.01691, 35.31526], [-118.017, 35.31562]]], [[[-118.01239, 35.37133], [-118.01184, 35.37257], [-118.00878, 35.37255], [-118.00868, 35.36143], [-118.01239, 35.37133]]], [[[-118.02119, 35.30119], [-118.02116, 35.31568], [-118.01768, 35.31563], [-118.01756, 35.31511], [-118.01651, 35.31272], [-118.01632, 35.31226], [-118.01618, 35.31179], [-118.01607, 35.31131], [-118.01604, 35.31106], [-118.01599, 35.31058], [-118.01599, 35.31009], [-118.0162, 35.30387], [-118.01476, 35.30116], [-118.02119, 35.30119]]], [[[-118.04909, 35.30498], [-118.04812, 35.30564], [-118.04669, 35.30749], [-118.0444, 35.31531], [-118.04461, 35.31878], [-118.03596, 35.3188], [-118.03604, 35.32597], [-118.0361, 35.33318], [-118.04328, 35.33335], [-118.04322, 35.3337], [-118.04311, 35.33409], [-118.04296, 35.33448], [-118.04279, 35.33479], [-118.04263, 35.33502], [-118.04241, 35.33531], [-118.04172, 35.33603], [-118.04147, 35.33633], [-118.04115, 35.33682], [-118.04101, 35.33707], [-118.04085, 35.33741], [-118.04067, 35.33795], [-118.04055, 35.33849], [-118.04051, 35.3389], [-118.04052, 35.33942], [-118.04048, 35.33975], [-118.04043, 35.34007], [-118.0401, 35.34073], [-118.03956, 35.34158], [-118.03922, 35.34216], [-118.03892, 35.34275], [-118.03874, 35.34316], [-118.03843, 35.34397], [-118.03825, 35.3446], [-118.0381, 35.34522], [-118.03799, 35.34595], [-118.0377, 35.34568], [-118.03616, 35.34415], [-118.0361, 35.3332], [-118.02709, 35.33314], [-118.02473, 35.33303], [-118.0244, 35.33151], [-118.0233, 35.32801], [-118.02233, 35.32696], [-118.02271, 35.32606], [-118.02282, 35.32566], [-118.02285, 35.32536], [-118.02284, 35.32495], [-118.02278, 35.32464], [-118.02227, 35.32308], [-118.02251, 35.32226], [-118.022, 35.32109], [-118.02078, 35.32002], [-118.02036, 35.31909], [-118.02008, 35.31885], [-118.02724, 35.31874], [-118.03595, 35.31878], [-118.0361, 35.31156], [-118.0362, 35.304], [-118.02722, 35.30437], [-118.02801, 35.29647], [-118.01931, 35.29651], [-118.02018, 35.28868], [-118.03743, 35.28886], [-118.03621, 35.30398], [-118.04521, 35.30501], [-118.04909, 35.30498]]], [[[-118.28957, 35.42176], [-118.27153, 35.42156], [-118.27123, 35.40692], [-118.25333, 35.40691], [-118.25358, 35.42148], [-118.24467, 35.42139], [-118.24483, 35.42866], [-118.23592, 35.4286], [-118.2359, 35.42861], [-118.23609, 35.43584], [-118.25392, 35.43605], [-118.25422, 35.45063], [-118.23638, 35.45036], [-118.23606, 35.43584], [-118.21824, 35.43565], [-118.2183, 35.43927], [-118.21385, 35.43922], [-118.21377, 35.4356], [-118.21822, 35.43564], [-118.21788, 35.42119], [-118.20013, 35.42102], [-118.20042, 35.43545], [-118.20487, 35.43551], [-118.20496, 35.43912], [-118.2094, 35.43917], [-118.20957, 35.44639], [-118.21402, 35.44645], [-118.2141, 35.45002], [-118.20241, 35.44985], [-118.20245, 35.44988], [-118.20234, 35.44984], [-118.20074, 35.44982], [-118.20073, 35.44926], [-118.20071, 35.44924], [-118.20073, 35.44923], [-118.2004, 35.43546], [-118.1826, 35.4352], [-118.18292, 35.44955], [-118.16511, 35.44928], [-118.16483, 35.43492], [-118.14695, 35.43469], [-118.14669, 35.42036], [-118.1289, 35.42023], [-118.12908, 35.4345], [-118.1114, 35.43428], [-118.11158, 35.44848], [-118.09373, 35.44821], [-118.09364, 35.43411], [-118.07589, 35.4334], [-118.07588, 35.43341], [-118.07588, 35.44794], [-118.06231, 35.44774], [-118.05803, 35.44774], [-118.05815, 35.43325], [-118.07588, 35.43339], [-118.07592, 35.41887], [-118.05827, 35.41875], [-118.05837, 35.40428], [-118.07597, 35.40432], [-118.07601, 35.38979], [-118.05846, 35.38979], [-118.05857, 35.37529], [-118.04026, 35.37531], [-118.03977, 35.38255], [-118.03055, 35.3835], [-118.03059, 35.38305], [-118.03182, 35.38103], [-118.03189, 35.38083], [-118.03192, 35.38065], [-118.03191, 35.38044], [-118.03184, 35.38011], [-118.03185, 35.38], [-118.03188, 35.37986], [-118.03198, 35.37967], [-118.03264, 35.37878], [-118.03279, 35.37851], [-118.03292, 35.37815], [-118.03305, 35.37745], [-118.03313, 35.37727], [-118.03326, 35.3771], [-118.03459, 35.37599], [-118.03486, 35.3757], [-118.04024, 35.3753], [-118.04031, 35.36929], [-118.04272, 35.36733], [-118.04333, 35.36582], [-118.04389, 35.36287], [-118.04623, 35.36082], [-118.05867, 35.36076], [-118.05861, 35.35361], [-118.06717, 35.35357], [-118.06675, 35.34644], [-118.07496, 35.3464], [-118.07533, 35.33215], [-118.05837, 35.33215], [-118.05821, 35.31783], [-118.07503, 35.31785], [-118.07534, 35.33213], [-118.09218, 35.33396], [-118.09141, 35.34866], [-118.07497, 35.34643], [-118.07651, 35.36069], [-118.09144, 35.3633], [-118.09136, 35.37053], [-118.09151, 35.37779], [-118.10945, 35.37742], [-118.11393, 35.37742], [-118.11466, 35.38454], [-118.11022, 35.38454], [-118.11101, 35.39163], [-118.12852, 35.3917], [-118.12824, 35.38813], [-118.13711, 35.38815], [-118.13735, 35.39172], [-118.12853, 35.39171], [-118.1287, 35.40595], [-118.1464, 35.40603], [-118.14623, 35.39531], [-118.15062, 35.39534], [-118.15069, 35.39891], [-118.15509, 35.39896], [-118.15517, 35.40255], [-118.15955, 35.40259], [-118.15949, 35.399], [-118.16405, 35.39905], [-118.16422, 35.40624], [-118.18198, 35.40639], [-118.18168, 35.39199], [-118.1639, 35.39186], [-118.16356, 35.37747], [-118.18138, 35.37756], [-118.18169, 35.39197], [-118.19951, 35.3921], [-118.19952, 35.39209], [-118.19922, 35.37765], [-118.21707, 35.37774], [-118.21732, 35.39223], [-118.19953, 35.39211], [-118.1998, 35.40654], [-118.2176, 35.40671], [-118.21791, 35.42119], [-118.23571, 35.42129], [-118.23544, 35.40676], [-118.25331, 35.4069], [-118.25305, 35.39234], [-118.23517, 35.39224], [-118.23492, 35.37773], [-118.25278, 35.37771], [-118.25307, 35.39232], [-118.271, 35.39225], [-118.27078, 35.37763], [-118.28847, 35.37768], [-118.28937, 35.39241], [-118.27102, 35.39226], [-118.27112, 35.39959], [-118.26656, 35.3996], [-118.26661, 35.40323], [-118.27118, 35.40325], [-118.27126, 35.40692], [-118.28945, 35.40707], [-118.28957, 35.42176]], [[-118.07497, 35.37161], [-118.07549, 35.36798], [-118.07128, 35.36799], [-118.0709, 35.37162], [-118.07497, 35.37161]], [[-118.07601, 35.38976], [-118.09351, 35.39185], [-118.0915, 35.3778], [-118.08247, 35.37781], [-118.07449, 35.37525], [-118.07601, 35.38976]], [[-118.12887, 35.42022], [-118.12889, 35.42021], [-118.12867, 35.40595], [-118.11114, 35.40585], [-118.11098, 35.39163], [-118.09353, 35.39185], [-118.09352, 35.39529], [-118.0804, 35.39391], [-118.08037, 35.40473], [-118.07597, 35.40434], [-118.07594, 35.41887], [-118.0936, 35.42003], [-118.09356, 35.40593], [-118.09808, 35.40589], [-118.0981, 35.40933], [-118.10247, 35.40938], [-118.1025, 35.41309], [-118.10693, 35.41309], [-118.10693, 35.41651], [-118.11122, 35.41657], [-118.11126, 35.42006], [-118.12887, 35.42022]], [[-118.11125, 35.42008], [-118.09361, 35.42004], [-118.09365, 35.4341], [-118.11138, 35.43428], [-118.11125, 35.42008]], [[-118.16452, 35.42058], [-118.16453, 35.42056], [-118.1642, 35.40624], [-118.14641, 35.40604], [-118.14672, 35.42036], [-118.16452, 35.42058]], [[-118.18232, 35.42082], [-118.16454, 35.42058], [-118.16484, 35.43491], [-118.18258, 35.4352], [-118.18232, 35.42082]], [[-118.20012, 35.42101], [-118.20013, 35.42099], [-118.19979, 35.40656], [-118.182, 35.4064], [-118.18233, 35.4208], [-118.20012, 35.42101]]], [[[-118.0542, 35.34845], [-118.04002, 35.348], [-118.03993, 35.34784], [-118.03976, 35.34746], [-118.03964, 35.34729], [-118.03951, 35.34712], [-118.03924, 35.34688], [-118.03861, 35.34642], [-118.0387, 35.34562], [-118.03882, 35.34502], [-118.03898, 35.34442], [-118.03925, 35.34363], [-118.03949, 35.34305], [-118.03978, 35.34248], [-118.0401, 35.34192], [-118.04065, 35.34105], [-118.04087, 35.34064], [-118.04107, 35.34021], [-118.04114, 35.33986], [-118.04118, 35.33944], [-118.04118, 35.33891], [-118.04121, 35.33858], [-118.04131, 35.33809], [-118.04147, 35.33762], [-118.04173, 35.33708], [-118.04202, 35.33665], [-118.04225, 35.33636], [-118.043, 35.33557], [-118.04325, 35.33525], [-118.04342, 35.33498], [-118.0436, 35.33463], [-118.04377, 35.33419], [-118.04386, 35.33381], [-118.04393, 35.33336], [-118.04481, 35.33338], [-118.05384, 35.33371], [-118.0542, 35.34845]]], [[[-118.05422, 35.30494], [-118.05421, 35.319], [-118.04939, 35.31888], [-118.04941, 35.31538], [-118.0451, 35.31527], [-118.04732, 35.30771], [-118.04863, 35.30601], [-118.05015, 35.30497], [-118.05422, 35.30494]]], [[[-118.1458, 35.38458], [-118.13688, 35.38457], [-118.13664, 35.38101], [-118.13216, 35.381], [-118.13189, 35.37743], [-118.14543, 35.37743], [-118.1458, 35.38458]]]]} | Open Access 1 | Eastern Kern County Onyx Ranch State Vehicular Recreation Area | http://ohv.parks.ca.gov/?page_id=28617 | 30689 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 25140.426 | Eastern Kern County Onyx Ranch SVRA | 2014 |
15390 | 15390 | 15389 | {"type": "MultiPolygon", "coordinates": [[[[-119.41373, 38.41613], [-119.39436, 38.41565], [-119.39436, 38.40839], [-119.40361, 38.40862], [-119.40385, 38.41226], [-119.41351, 38.4125], [-119.41373, 38.41613]]], [[[-119.41593, 38.35438], [-119.41093, 38.35364], [-119.40939, 38.35339], [-119.40726, 38.35299], [-119.40676, 38.35286], [-119.40674, 38.3522], [-119.41129, 38.35222], [-119.4159, 38.35211], [-119.41593, 38.35438]]], [[[-119.41595, 38.35572], [-119.41136, 38.35582], [-119.40681, 38.35578], [-119.40677, 38.35329], [-119.40713, 38.35339], [-119.40928, 38.3538], [-119.41083, 38.35404], [-119.41594, 38.3548], [-119.41595, 38.35572]]], [[[-119.43863, 38.33091], [-119.43407, 38.33098], [-119.43408, 38.33449], [-119.42958, 38.33456], [-119.42964, 38.33802], [-119.42497, 38.33802], [-119.4249, 38.33451], [-119.42483, 38.32729], [-119.42942, 38.32753], [-119.43397, 38.32747], [-119.43391, 38.32397], [-119.42934, 38.32391], [-119.42474, 38.32378], [-119.42016, 38.32377], [-119.42018, 38.32728], [-119.41558, 38.32727], [-119.41554, 38.32377], [-119.42013, 38.32377], [-119.42014, 38.32376], [-119.42005, 38.32028], [-119.41546, 38.32022], [-119.4154, 38.31696], [-119.41999, 38.31701], [-119.42008, 38.32027], [-119.42923, 38.32028], [-119.42917, 38.31703], [-119.43375, 38.31708], [-119.43384, 38.32034], [-119.43838, 38.32039], [-119.43863, 38.33091]]], [[[-119.42945, 38.37713], [-119.42547, 38.3772], [-119.42541, 38.37362], [-119.42701, 38.37359], [-119.42727, 38.37458], [-119.42788, 38.37539], [-119.42886, 38.37624], [-119.42914, 38.37653], [-119.42933, 38.37686], [-119.42945, 38.37713]]], [[[-119.42903, 38.38424], [-119.42772, 38.38609], [-119.42755, 38.38641], [-119.4274, 38.38673], [-119.42727, 38.38708], [-119.42709, 38.38776], [-119.42568, 38.38776], [-119.42561, 38.38427], [-119.42903, 38.38424]]], [[[-119.43485, 38.38774], [-119.43028, 38.38778], [-119.42751, 38.38777], [-119.42761, 38.38736], [-119.42777, 38.38686], [-119.42792, 38.38646], [-119.4286, 38.3855], [-119.42979, 38.38374], [-119.42996, 38.38347], [-119.43009, 38.3832], [-119.43085, 38.38054], [-119.43093, 38.38032], [-119.43082, 38.37917], [-119.4307, 38.37881], [-119.42971, 38.37661], [-119.42954, 38.37635], [-119.42931, 38.37612], [-119.42836, 38.37515], [-119.42784, 38.37459], [-119.42766, 38.37421], [-119.42747, 38.37358], [-119.43, 38.37354], [-119.43001, 38.37343], [-119.43447, 38.37352], [-119.43485, 38.38774]]], [[[-119.43857, 38.33795], [-119.43855, 38.34153], [-119.43413, 38.34155], [-119.43415, 38.34507], [-119.42978, 38.34504], [-119.42971, 38.34155], [-119.43412, 38.34154], [-119.43411, 38.33801], [-119.43857, 38.33795]]], [[[-119.43015, 38.38132], [-119.43014, 38.38071], [-119.4301, 38.3787], [-119.43032, 38.37917], [-119.43039, 38.37968], [-119.43045, 38.38028], [-119.43015, 38.38132]]], [[[-119.45453, 38.45495], [-119.45452, 38.45516], [-119.45051, 38.45528], [-119.45051, 38.45455], [-119.45082, 38.45467], [-119.45105, 38.45474], [-119.45152, 38.45479], [-119.45185, 38.4548], [-119.45216, 38.45465], [-119.45257, 38.45452], [-119.45295, 38.45459], [-119.45315, 38.45464], [-119.45329, 38.45472], [-119.45343, 38.45477], [-119.45395, 38.45488], [-119.45401, 38.45493], [-119.45422, 38.45495], [-119.45453, 38.45495]]], [[[-119.45464, 38.45171], [-119.45453, 38.45477], [-119.45404, 38.45476], [-119.45387, 38.45467], [-119.45349, 38.45463], [-119.45331, 38.45458], [-119.45324, 38.45448], [-119.45281, 38.4544], [-119.45241, 38.45441], [-119.45226, 38.45445], [-119.45192, 38.45457], [-119.45171, 38.45467], [-119.45147, 38.45464], [-119.45108, 38.45456], [-119.45093, 38.45451], [-119.45071, 38.45443], [-119.45051, 38.45433], [-119.45054, 38.45183], [-119.45464, 38.45171]]]]} | Open Access 1 | Burcham & Wheeler Flats Wildlife Area | 30524 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/ | California Department of Fish and Wildlife 6 | 1185.319 | Burcham & Wheeler Flats Wildlife Area | 2014 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);