units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where COUNTY = 48 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9795 | 9795 | 9794 | {"type": "Polygon", "coordinates": [[[-119.72323, 37.37351], [-119.72298, 37.37385], [-119.72257, 37.37463], [-119.72247, 37.37476], [-119.72228, 37.37495], [-119.72211, 37.37509], [-119.72171, 37.37532], [-119.72112, 37.37552], [-119.72068, 37.37571], [-119.7202, 37.37595], [-119.72001, 37.37608], [-119.72007, 37.37454], [-119.72066, 37.37453], [-119.72068, 37.37385], [-119.72013, 37.37385], [-119.72023, 37.37099], [-119.72187, 37.37102], [-119.72323, 37.37351]]]} | Open Access 1 | 16685 | Wassama Round House State Historic Park | 1784 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=586 | Madera 48 | 25.939 | Wassama Round House SHP | 1978 | State Historic or Cultural Area 132 | 4 |
| 9842 | 9842 | 9841 | {"type": "Polygon", "coordinates": [[[-119.36612, 37.19507], [-119.36606, 37.19869], [-119.35702, 37.19876], [-119.35696, 37.20221], [-119.35866, 37.20221], [-119.35879, 37.21129], [-119.35889, 37.21299], [-119.36341, 37.21303], [-119.36352, 37.21468], [-119.35898, 37.21468], [-119.348, 37.21472], [-119.34812, 37.20776], [-119.35257, 37.20772], [-119.35252, 37.20219], [-119.35043, 37.20219], [-119.35053, 37.19525], [-119.36612, 37.19507]]]} | Open Access 1 | 16816 | Kinsman Flat Wildlife Area | 30460 | 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 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Kinsman-Flat-WA | Madera 48 | 474.291 | Kinsman Flat Wildlife Area | 1987 | State Conservation Area 8 | 2 |
| 12593 | 12593 | 12592 | {"type": "Polygon", "coordinates": [[[-119.70781, 37.00394], [-119.70761, 37.00403], [-119.70749, 37.00415], [-119.70762, 37.00437], [-119.70758, 37.00492], [-119.70715, 37.00587], [-119.70635, 37.00643], [-119.70559, 37.0068], [-119.70556, 37.00677], [-119.7054, 37.00678], [-119.70517, 37.00688], [-119.70509, 37.00704], [-119.70505, 37.00706], [-119.70473, 37.00759], [-119.70472, 37.00755], [-119.70471, 37.00754], [-119.70468, 37.00767], [-119.7047, 37.00807], [-119.70464, 37.00816], [-119.70463, 37.0083], [-119.70472, 37.00865], [-119.70474, 37.00917], [-119.70482, 37.00927], [-119.70476, 37.00933], [-119.70468, 37.00947], [-119.70437, 37.0096], [-119.70439, 37.00982], [-119.70481, 37.01054], [-119.70492, 37.01065], [-119.70566, 37.01065], [-119.70558, 37.0108], [-119.70589, 37.0113], [-119.7061, 37.0114], [-119.70645, 37.0114], [-119.70666, 37.01137], [-119.70662, 37.01166], [-119.70676, 37.01187], [-119.70697, 37.01194], [-119.70713, 37.01206], [-119.70758, 37.01206], [-119.70743, 37.01221], [-119.70732, 37.01237], [-119.7075, 37.01255], [-119.70763, 37.0127], [-119.70766, 37.01287], [-119.7076, 37.01296], [-119.70748, 37.01284], [-119.7073, 37.01259], [-119.70704, 37.01238], [-119.70676, 37.01232], [-119.70654, 37.01247], [-119.70641, 37.01261], [-119.70631, 37.01254], [-119.70637, 37.01235], [-119.70636, 37.01216], [-119.70613, 37.01204], [-119.7053, 37.01185], [-119.70503, 37.0119], [-119.7049, 37.01197], [-119.70488, 37.01179], [-119.70503, 37.01158], [-119.70498, 37.01137], [-119.70471, 37.01118], [-119.70462, 37.011], [-119.70444, 37.01084], [-119.7041, 37.01064], [-119.70376, 37.0104], [-119.70331, 37.01033], [-119.70306, 37.0104], [-119.70292, 37.01057], [-119.70313, 37.01067], [-119.70284, 37.01068], [-119.7028, 37.01085], [-119.70261, 37.01095], [-119.70261, 37.01119], [-119.70232, 37.01122], [-119.70229, 37.01102], [-119.70225, 37.01084], [-119.70226, 37.01068], [-119.70225, 37.01067], [-119.70093, 37.01067], [-119.70076, 37.01109], [-119.70077, 37.0111], [-119.70082, 37.0111], [-119.70078, 37.01128], [-119.70077, 37.0115], [-119.70092, 37.01161], [-119.70065, 37.01206], [-119.70056, 37.01232], [-119.70043, 37.01237], [-119.70042, 37.01246], [-119.70047, 37.01264], [-119.70093, 37.01255], [-119.70114, 37.01248], [-119.7012, 37.01256], [-119.701, 37.01287], [-119.70089, 37.01315], [-119.70113, 37.01331], [-119.70129, 37.01364], [-119.70161, 37.01385], [-119.70194, 37.01394], [-119.70233, 37.01399], [-119.70218, 37.01412], [-119.70165, 37.01422], [-119.70138, 37.0142], [-119.70129, 37.01545], [-119.70127, 37.01547], [-119.70136, 37.01554], [-119.70131, 37.01576], [-119.70114, 37.01583], [-119.70102, 37.01584], [-119.70074, 37.01626], [-119.70067, 37.01668], [-119.70076, 37.0167], [-119.701, 37.01667], [-119.70119, 37.01652], [-119.70132, 37.01645], [-119.70151, 37.01646], [-119.70142, 37.01669], [-119.70128, 37.01694], [-119.7013, 37.01717], [-119.70145, 37.01729], [-119.70175, 37.01739], [-119.70195, 37.01739], [-119.70213, 37.01747], [-119.70196, 37.01753], [-119.70163, 37.01759], [-119.70152, 37.01776], [-119.70105, 37.01759], [-119.70093, 37.0175], [-119.70091, 37.01751], [-119.70192, 37.01934], [-119.7021, 37.01919], [-119.70224, 37.01938], [-119.70247, 37.01946], [-119.70278, 37.01947], [-119.70302, 37.01963], [-119.70344, 37.0198], [-119.70376, 37.01976], [-119.70411, 37.01982], [-119.70426, 37.01978], [-119.7045, 37.0199], [-119.7048, 37.01991], [-119.70475, 37.02006], [-119.7045, 37.02013], [-119.70443, 37.02041], [-119.70406, 37.02008], [-119.70382, 37.02002], [-119.70307, 37.02016], [-119.70289, 37.02016], [-119.70275, 37.0203], [-119.70245, 37.02013], [-119.70199, 37.02017], [-119.70198, 37.0216], [-119.70183, 37.02188], [-119.702, 37.02232], [-119.70192, 37.02253], [-119.702, 37.02278], [-119.70205, 37.02316], [-119.70164, 37.02274], [-119.7014, 37.02273], [-119.70131, 37.02251], [-119.70115, 37.02257], [-119.70029, 37.02236], [-119.699, 37.02157], [-119.69846, 37.02091], [-119.69812, 37.0213], [-119.69815, 37.02148], [-119.69847, 37.0221], [-119.69826, 37.02204], [-119.69797, 37.02184], [-119.69787, 37.02162], [-119.69708, 37.02256], [-119.69583, 37.02226], [-119.69491, 37.02154], [-119.69451, 37.0207], [-119.69429, 37.02017], [-119.69399, 37.02047], [-119.69369, 37.02031], [-119.6937, 37.02008], [-119.69393, 37.01989], [-119.69398, 37.01966], [-119.69397, 37.01965], [-119.69374, 37.0197], [-119.69337, 37.01966], [-119.69325, 37.01948], [-119.69254, 37.0194], [-119.69261, 37.01917], [-119.69241, 37.01915], [-119.69124, 37.01876], [-119.69106, 37.01862], [-119.69082, 37.01855], [-119.69047, 37.01852], [-119.69034, 37.01855], [-119.69024, 37.01861], [-119.69001, 37.01861], [-119.69001, 37.01812], [-119.68991, 37.018], [-119.68982, 37.01795], [-119.68946, 37.0179], [-119.68896, 37.01786], [-119.68842, 37.01785], [-119.68831, 37.01786], [-119.6881, 37.01826], [-119.68759, 37.01881], [-119.68699, 37.01899], [-119.68651, 37.01938], [-119.68608, 37.01945], [-119.68604, 37.01944], [-119.68593, 37.01963], [-119.68585, 37.01968], [-119.68553, 37.01972], [-119.68527, 37.01979], [-119.68516, 37.01986], [-119.68505, 37.01996], [-119.685, 37.02007], [-119.68492, 37.0204], [-119.68502, 37.02042], [-119.68509, 37.02494], [-119.68049, 37.02494], [-119.68049, 37.02495], [-119.68129, 37.0254], [-119.68076, 37.02556], [-119.68074, 37.02859], [-119.67623, 37.02862], [-119.67622, 37.03031], [-119.67174, 37.03036], [-119.67173, 37.03046], [-119.66284, 37.03038], [-119.66281, 37.03056], [-119.66288, 37.03067], [-119.66301, 37.03111], [-119.66294, 37.03164], [-119.66292, 37.03229], [-119.66269, 37.03224], [-119.66239, 37.03184], [-119.66219, 37.03165], [-119.66178, 37.03205], [-119.66172, 37.03205], [-119.66182, 37.03226], [-119.66176, 37.03277], [-119.66165, 37.03346], [-119.66167, 37.03404], [-119.66181, 37.03461], [-119.66211, 37.03502], [-119.66237, 37.03512], [-119.66237, 37.03538], [-119.66208, 37.03571], [-119.66176, 37.03587], [-119.66177, 37.03636], [-119.66206, 37.03679], [-119.66226, 37.03705], [-119.66261, 37.03712], [-119.66259, 37.03758], [-119.66238, 37.03776], [-119.66257, 37.03823], [-119.66259, 37.03877], [-119.6625, 37.03905], [-119.66268, 37.03977], [-119.66268, 37.04011], [-119.66278, 37.04037], [-119.66225, 37.04054], [-119.66201, 37.04083], [-119.66182, 37.04102], [-119.66133, 37.0413], [-119.66133, 37.04132], [-119.66157, 37.04143], [-119.66144, 37.04168], [-119.66095, 37.04197], [-119.66063, 37.04211], [-119.6604, 37.04206], [-119.66001, 37.0421], [-119.65969, 37.04226], [-119.65914, 37.04249], [-119.65876, 37.04266], [-119.65856, 37.04298], [-119.65825, 37.04299], [-119.65794, 37.04313], [-119.65813, 37.04336], [-119.65833, 37.04355], [-119.65807, 37.04371], [-119.65816, 37.04388], [-119.65819, 37.0439], [-119.65868, 37.04387], [-119.65885, 37.04402], [-119.65884, 37.04433], [-119.6587, 37.04464], [-119.65882, 37.04487], [-119.65794, 37.04467], [-119.65711, 37.04468], [-119.65705, 37.04472], [-119.65682, 37.04499], [-119.65669, 37.0451], [-119.65635, 37.04522], [-119.65615, 37.04535], [-119.65604, 37.04547], [-119.65574, 37.04595], [-119.65567, 37.0463], [-119.65568, 37.04654], [-119.65564, 37.04661], [-119.65556, 37.04665], [-119.65551, 37.04674], [-119.65543, 37.04684], [-119.65538, 37.04697], [-119.65533, 37.04719], [-119.65536, 37.04739], [-119.65527, 37.04748], [-119.6552, 37.04751], [-119.65452, 37.04794], [-119.65455, 37.04716], [-119.6543, 37.04688], [-119.65466, 37.04649], [-119.65467, 37.04634], [-119.65452, 37.04619], [-119.6541, 37.04599], [-119.65398, 37.0455], [-119.65377, 37.04533], [-119.65356, 37.04477], [-119.65318, 37.04463], [-119.65269, 37.04503], [-119.65262, 37.046], [-119.6528, 37.04632], [-119.65271, 37.04655], [-119.65304, 37.04759], [-119.65281, 37.04779], [-119.65256, 37.04778], [-119.65213, 37.04808], [-119.65194, 37.04826], [-119.6519, 37.04873], [-119.65195, 37.04887], [-119.6519, 37.04893], [-119.65161, 37.04836], [-119.65179, 37.04785], [-119.65171, 37.04731], [-119.65164, 37.0471], [-119.65154, 37.04692], [-119.65157, 37.04675], [-119.65157, 37.04661], [-119.65118, 37.04637], [-119.65071, 37.04614], [-119.65033, 37.04625], [-119.64971, 37.04636], [-119.64948, 37.04684], [-119.64922, 37.04673], [-119.64896, 37.04676], [-119.64879, 37.04692], [-119.64866, 37.04739], [-119.64826, 37.04738], [-119.64799, 37.04763], [-119.64847, 37.04839], [-119.64736, 37.04832], [-119.64674, 37.04786], [-119.64646, 37.04799], [-119.64606, 37.04775], [-119.64559, 37.04778], [-119.64539, 37.04793], [-119.6454, 37.04817], [-119.6441, 37.04813], [-119.64378, 37.04787], [-119.64346, 37.04793], [-119.64324, 37.04802], [-119.64315, 37.04785], [-119.64292, 37.04779], [-119.64244, 37.04784], [-119.64207, 37.04808], [-119.64177, 37.04846], [-119.64162, 37.04923], [-119.64161, 37.04941], [-119.64172, 37.05021], [-119.64213, 37.05093], [-119.64169, 37.05115], [-119.64163, 37.05133], [-119.64172, 37.05176], [-119.64187, 37.05206], [-119.64383, 37.0541], [-119.64417, 37.05419], [-119.6443, 37.05433], [-119.64466, 37.05454], [-119.64545, 37.05476], [-119.64566, 37.05477], [-119.64586, 37.05475], [-119.64605, 37.05492], [-119.64616, 37.05498], [-119.64632, 37.05497], [-119.64648, 37.05521], [-119.64684, 37.05557], [-119.64751, 37.05606], [-119.6478, 37.05604], [-119.64798, 37.05623], [-119.64832, 37.05646], [-119.64873, 37.05661], [-119.64899, 37.05652], [-119.64903, 37.05672], [-119.64932, 37.05686], [-119.64952, 37.05698], [-119.64972, 37.05698], [-119.64973, 37.05721], [-119.64996, 37.05748], [-119.64986, 37.05791], [-119.65003, 37.05815], [-119.65036, 37.05825], [-119.65048, 37.05875], [-119.65048, 37.05896], [-119.65064, 37.05925], [-119.65096, 37.05924], [-119.6508, 37.05948], [-119.65099, 37.05981], [-119.65094, 37.06009], [-119.65092, 37.06034], [-119.65093, 37.06041], [-119.65174, 37.06197], [-119.65166, 37.06234], [-119.65151, 37.06273], [-119.65152, 37.06315], [-119.65117, 37.06333], [-119.65051, 37.06319], [-119.65048, 37.063], [-119.65074, 37.06296], [-119.65108, 37.063], [-119.65114, 37.0625], [-119.65127, 37.06211], [-119.65113, 37.06158], [-119.65074, 37.06087], [-119.65071, 37.06076], [-119.65058, 37.06085], [-119.65016, 37.06064], [-119.65022, 37.06019], [-119.65024, 37.05986], [-119.65011, 37.0597], [-119.64993, 37.05954], [-119.64999, 37.05943], [-119.64991, 37.05929], [-119.6498, 37.059], [-119.64917, 37.05849], [-119.64878, 37.05812], [-119.64828, 37.05787], [-119.64746, 37.05767], [-119.64649, 37.05762], [-119.64623, 37.05771], [-119.64632, 37.05755], [-119.64647, 37.0567], [-119.64605, 37.05626], [-119.64575, 37.05609], [-119.64518, 37.05592], [-119.64467, 37.05587], [-119.64456, 37.05593], [-119.64445, 37.05564], [-119.64414, 37.05549], [-119.64368, 37.05533], [-119.64338, 37.05528], [-119.64319, 37.05515], [-119.64242, 37.05471], [-119.64209, 37.05451], [-119.64189, 37.05453], [-119.64168, 37.05442], [-119.64166, 37.05429], [-119.64155, 37.05409], [-119.64137, 37.05397], [-119.64091, 37.05368], [-119.64084, 37.05329], [-119.64067, 37.05309], [-119.64049, 37.053], [-119.64034, 37.05295], [-119.64026, 37.05296], [-119.64012, 37.05307], [-119.64004, 37.0531], [-119.63996, 37.0531], [-119.63987, 37.05304], [-119.63979, 37.05301], [-119.63959, 37.05301], [-119.63917, 37.05267], [-119.63897, 37.05258], [-119.63899, 37.05248], [-119.63906, 37.05228], [-119.63903, 37.05221], [-119.63877, 37.05195], [-119.63862, 37.05167], [-119.63856, 37.05161], [-119.63854, 37.05148], [-119.63851, 37.05142], [-119.63843, 37.05137], [-119.63806, 37.05124], [-119.63799, 37.05119], [-119.63794, 37.05112], [-119.63837, 37.05087], [-119.63869, 37.05075], [-119.63879, 37.05067], [-119.63885, 37.05044], [-119.63896, 37.05036], [-119.63923, 37.0502], [-119.63928, 37.05012], [-119.63929, 37.04999], [-119.63936, 37.04977], [-119.63957, 37.04941], [-119.63954, 37.04934], [-119.63943, 37.04927], [-119.63941, 37.0492], [-119.63949, 37.04898], [-119.63968, 37.0487], [-119.63971, 37.04863], [-119.6397, 37.04848], [-119.63959, 37.04831], [-119.63952, 37.04826], [-119.63948, 37.0482], [-119.63946, 37.04781], [-119.6391, 37.0474], [-119.63899, 37.04723], [-119.6389, 37.04696], [-119.62323, 37.04723], [-119.62321, 37.047], [-119.61941, 37.04704], [-119.61939, 37.05025], [-119.6188, 37.05026], [-119.6188, 37.05057], [-119.61452, 37.05058], [-119.61546, 37.05172], [-119.61563, 37.05227], [-119.61569, 37.05273], [-119.61594, 37.0533], [-119.61626, 37.05378], [-119.61629, 37.05419], [-119.61597, 37.05458], [-119.61586, 37.05485], [-119.61563, 37.05495], [-119.61497, 37.05449], [-119.61472, 37.05447], [-119.61437, 37.05461], [-119.61389, 37.05511], [-119.61398, 37.05637], [-119.61358, 37.05685], [-119.61235, 37.05769], [-119.61178, 37.05834], [-119.61144, 37.05966], [-119.61169, 37.06146], [-119.6148, 37.06147], [-119.61458, 37.0688], [-119.61004, 37.06877], [-119.61, 37.07214], [-119.61002, 37.07601], [-119.60592, 37.07602], [-119.59104, 37.07559], [-119.59073, 37.07202], [-119.58132, 37.07166], [-119.58059, 37.06737], [-119.58077, 37.06688], [-119.57803, 37.06704], [-119.57692, 37.06592], [-119.57652, 37.06569], [-119.57581, 37.06569], [-119.57546, 37.06537], [-119.57375, 37.06514], [-119.57135, 37.06437], [-119.5709, 37.06436], [-119.57075, 37.06448], [-119.56887, 37.06425], [-119.56404, 37.06452], [-119.5623, 37.06503], [-119.56193, 37.06544], [-119.56182, 37.06572], [-119.5619, 37.06617], [-119.56216, 37.06684], [-119.56241, 37.0686], [-119.56236, 37.06896], [-119.56202, 37.06942], [-119.56099, 37.07034], [-119.56096, 37.07107], [-119.56119, 37.07128], [-119.56133, 37.07164], [-119.56124, 37.07194], [-119.56107, 37.07192], [-119.56036, 37.07096], [-119.56039, 37.07048], [-119.56067, 37.07002], [-119.56121, 37.06965], [-119.56141, 37.0694], [-119.56147, 37.0691], [-119.56127, 37.06842], [-119.56047, 37.06725], [-119.56044, 37.067], [-119.56036, 37.06695], [-119.56039, 37.06643], [-119.56153, 37.06494], [-119.56159, 37.06468], [-119.56241, 37.06395], [-119.56378, 37.06372], [-119.5659, 37.06366], [-119.56681, 37.06384], [-119.5673, 37.06368], [-119.56775, 37.06331], [-119.56827, 37.06267], [-119.5685, 37.06272], [-119.56913, 37.06331], [-119.5703, 37.06343], [-119.57144, 37.06377], [-119.57515, 37.06464], [-119.57604, 37.06475], [-119.57749, 37.06468], [-119.57838, 37.0643], [-119.57866, 37.06429], [-119.57943, 37.06512], [-119.58003, 37.06544], [-119.58072, 37.06562], [-119.58194, 37.06553], [-119.58214, 37.06528], [-119.58226, 37.06487], [-119.58237, 37.06475], [-119.58274, 37.06485], [-119.58299, 37.06479], [-119.58325, 37.06449], [-119.58374, 37.06424], [-119.58422, 37.06417], [-119.58448, 37.0636], [-119.58528, 37.06364], [-119.58528, 37.06431], [-119.58542, 37.06453], [-119.58562, 37.0647], [-119.58639, 37.06497], [-119.58756, 37.06495], [-119.58831, 37.06509], [-119.58871, 37.06479], [-119.58885, 37.06447], [-119.58916, 37.06447], [-119.5893, 37.0649], [-119.58945, 37.06504], [-119.58962, 37.06504], [-119.58973, 37.06492], [-119.58999, 37.06493], [-119.59022, 37.06532], [-119.59057, 37.06551], [-119.59142, 37.06546], [-119.59145, 37.06587], [-119.59165, 37.06612], [-119.5918, 37.06685], [-119.59166, 37.06709], [-119.59169, 37.06765], [-119.59205, 37.06772], [-119.5924, 37.06747], [-119.59271, 37.06665], [-119.59285, 37.06649], [-119.59302, 37.06644], [-119.59371, 37.06717], [-119.59411, 37.06727], [-119.5944, 37.06743], [-119.59448, 37.06781], [-119.59482, 37.06839], [-119.59485, 37.06919], [-119.59537, 37.06987], [-119.59737, 37.07086], [-119.59817, 37.07104], [-119.59905, 37.07111], [-119.59965, 37.07099], [-119.60054, 37.07063], [-119.60239, 37.07051], [-119.60265, 37.07042], [-119.60391, 37.07042], [-119.60468, 37.07028], [-119.60496, 37.07001], [-119.60502, 37.06976], [-119.60522, 37.0695], [-119.60522, 37.06914], [-119.60476, 37.06889], [-119.60473, 37.06836], [-119.60516, 37.06794], [-119.60516, 37.0674], [-119.6049, 37.06715], [-119.6049, 37.06699], [-119.60545, 37.06642], [-119.60587, 37.06632], [-119.6061, 37.06616], [-119.60619, 37.06575], [-119.60653, 37.06552], [-119.60679, 37.0652], [-119.60736, 37.06495], [-119.60813, 37.06449], [-119.60881, 37.06392], [-119.6093, 37.06328], [-119.6099, 37.0623], [-119.61012, 37.06134], [-119.60941, 37.06051], [-119.60895, 37.05989], [-119.60907, 37.05964], [-119.60907, 37.05907], [-119.60898, 37.05879], [-119.60855, 37.05829], [-119.60838, 37.05802], [-119.60912, 37.05742], [-119.60912, 37.05685], [-119.60984, 37.0563], [-119.61009, 37.05589], [-119.61009, 37.05543], [-119.60941, 37.05502], [-119.60865, 37.05419], [-119.60866, 37.05418], [-119.60864, 37.05415], [-119.60861, 37.05399], [-119.60915, 37.05385], [-119.60923, 37.05376], [-119.60924, 37.05285], [-119.60992, 37.05282], [-119.61015, 37.05261], [-119.61021, 37.05225], [-119.60998, 37.05191], [-119.61009, 37.05166], [-119.61009, 37.05127], [-119.60978, 37.05097], [-119.60995, 37.05028], [-119.61054, 37.0498], [-119.61057, 37.04958], [-119.61034, 37.0494], [-119.61017, 37.04902], [-119.61015, 37.049], [-119.60982, 37.04891], [-119.60969, 37.04875], [-119.61009, 37.04822], [-119.61009, 37.04793], [-119.60983, 37.04774], [-119.60983, 37.04763], [-119.61017, 37.04736], [-119.6102, 37.04718], [-119.61017, 37.04715], [-119.60942, 37.04695], [-119.609, 37.046], [-119.60957, 37.04552], [-119.60954, 37.04498], [-119.60946, 37.04482], [-119.60894, 37.04441], [-119.60889, 37.0441], [-119.60909, 37.04365], [-119.60941, 37.04334], [-119.61006, 37.04334], [-119.61006, 37.04695], [-119.61126, 37.04696], [-119.61081, 37.04572], [-119.61061, 37.04474], [-119.61164, 37.04311], [-119.61358, 37.04114], [-119.6138, 37.04059], [-119.61375, 37.0401], [-119.6141, 37.03916], [-119.61499, 37.03798], [-119.61524, 37.03607], [-119.61553, 37.035], [-119.61612, 37.03372], [-119.61732, 37.03282], [-119.618, 37.03245], [-119.61832, 37.03213], [-119.61919, 37.02953], [-119.61947, 37.02902], [-119.61987, 37.02798], [-119.62013, 37.02751], [-119.62095, 37.02655], [-119.62134, 37.02631], [-119.62313, 37.02584], [-119.62467, 37.02523], [-119.62466, 37.02522], [-119.62042, 37.02518], [-119.62091, 37.02512], [-119.62129, 37.025], [-119.62197, 37.02491], [-119.62257, 37.02468], [-119.62331, 37.02411], [-119.62363, 37.02413], [-119.6238, 37.02431], [-119.62442, 37.02445], [-119.62495, 37.02432], [-119.62597, 37.02381], [-119.62682, 37.02349], [-119.62705, 37.02315], [-119.62708, 37.02255], [-119.62754, 37.02246], [-119.62802, 37.02205], [-119.62813, 37.02162], [-119.62885, 37.02141], [-119.62919, 37.02116], [-119.62942, 37.02063], [-119.62962, 37.02033], [-119.6297, 37.01981], [-119.6305, 37.01978], [-119.63116, 37.01919], [-119.63207, 37.01935], [-119.63273, 37.01935], [-119.6337, 37.01864], [-119.63424, 37.01846], [-119.63427, 37.01928], [-119.63455, 37.01951], [-119.63538, 37.01976], [-119.63636, 37.02063], [-119.63729, 37.02079], [-119.63735, 37.02138], [-119.63744, 37.02143], [-119.63747, 37.02173], [-119.63738, 37.02198], [-119.63727, 37.02214], [-119.63721, 37.02271], [-119.63792, 37.02399], [-119.63792, 37.02422], [-119.63744, 37.02466], [-119.63741, 37.025], [-119.63752, 37.02516], [-119.63778, 37.02534], [-119.63775, 37.02603], [-119.63787, 37.02635], [-119.63707, 37.0269], [-119.63693, 37.02708], [-119.6369, 37.02756], [-119.63704, 37.02797], [-119.63624, 37.0285], [-119.63589, 37.0288], [-119.6357, 37.0288], [-119.63576, 37.0253], [-119.63506, 37.02531], [-119.63502, 37.02631], [-119.63473, 37.02708], [-119.63436, 37.02801], [-119.63387, 37.02881], [-119.63252, 37.03004], [-119.63092, 37.03049], [-119.63056, 37.03076], [-119.62973, 37.03153], [-119.62924, 37.03243], [-119.63106, 37.03241], [-119.63099, 37.03269], [-119.63045, 37.03392], [-119.63033, 37.03475], [-119.63033, 37.03489], [-119.63059, 37.0353], [-119.63099, 37.03566], [-119.6315, 37.03596], [-119.63151, 37.03607], [-119.63169, 37.03607], [-119.63182, 37.03615], [-119.6329, 37.03701], [-119.63376, 37.03782], [-119.63493, 37.03875], [-119.63606, 37.03952], [-119.63607, 37.03968], [-119.6363, 37.03968], [-119.63638, 37.03974], [-119.63659, 37.04001], [-119.63704, 37.04042], [-119.6379, 37.04093], [-119.63875, 37.04175], [-119.63904, 37.04191], [-119.63981, 37.04207], [-119.64024, 37.04193], [-119.64067, 37.04164], [-119.64095, 37.04161], [-119.64229, 37.04127], [-119.64295, 37.04097], [-119.64372, 37.04079], [-119.64421, 37.04038], [-119.64463, 37.0402], [-119.64518, 37.03978], [-119.64586, 37.03949], [-119.64609, 37.03944], [-119.64638, 37.03965], [-119.64675, 37.03969], [-119.64692, 37.03955], [-119.64723, 37.03905], [-119.64794, 37.03914], [-119.64837, 37.03864], [-119.64855, 37.03864], [-119.64971, 37.03967], [-119.64986, 37.04004], [-119.65006, 37.04017], [-119.65049, 37.04022], [-119.65165, 37.03986], [-119.65248, 37.03931], [-119.65283, 37.03919], [-119.65348, 37.03917], [-119.65437, 37.0394], [-119.65537, 37.03908], [-119.65565, 37.03892], [-119.65571, 37.03842], [-119.65602, 37.0378], [-119.65602, 37.03718], [-119.65565, 37.03681], [-119.65531, 37.03679], [-119.65482, 37.03697], [-119.65428, 37.03736], [-119.65388, 37.03741], [-119.65323, 37.03729], [-119.65217, 37.03793], [-119.65197, 37.03793], [-119.65171, 37.0377], [-119.65171, 37.03754], [-119.6536, 37.03661], [-119.65408, 37.03626], [-119.65408, 37.03592], [-119.65326, 37.03562], [-119.65317, 37.03544], [-119.65331, 37.03521], [-119.65377, 37.03514], [-119.65425, 37.03494], [-119.65465, 37.03462], [-119.65471, 37.03437], [-119.6546, 37.03429], [-119.65446, 37.03372], [-119.65486, 37.03315], [-119.65523, 37.03278], [-119.65548, 37.03237], [-119.65562, 37.03199], [-119.65551, 37.03148], [-119.65511, 37.031], [-119.65466, 37.03066], [-119.65466, 37.03052], [-119.6556, 37.02963], [-119.65557, 37.02933], [-119.65449, 37.02853], [-119.65317, 37.02789], [-119.65332, 37.02768], [-119.6544, 37.02718], [-119.65491, 37.02685], [-119.65551, 37.0264], [-119.65561, 37.02623], [-119.65557, 37.02575], [-119.65534, 37.02544], [-119.65549, 37.0252], [-119.65551, 37.02492], [-119.6576, 37.02487], [-119.65747, 37.02443], [-119.65712, 37.02396], [-119.65705, 37.02251], [-119.65649, 37.02169], [-119.6567, 37.02021], [-119.65681, 37.01966], [-119.65663, 37.01859], [-119.65677, 37.01797], [-119.65662, 37.01608], [-119.65698, 37.01539], [-119.65684, 37.01465], [-119.6573, 37.01385], [-119.65796, 37.01327], [-119.65901, 37.01262], [-119.65949, 37.0117], [-119.66019, 37.01192], [-119.6609, 37.01159], [-119.66241, 37.01147], [-119.66314, 37.01099], [-119.66395, 37.01073], [-119.66483, 37.01039], [-119.66915, 37.01049], [-119.67, 37.01027], [-119.67088, 37.0102], [-119.67178, 37.01045], [-119.67209, 37.0104], [-119.67223, 37.0104], [-119.67246, 37.0104], [-119.6727, 37.01044], [-119.67304, 37.01053], [-119.67338, 37.0107], [-119.67342, 37.0107], [-119.69397, 37.01082], [-119.69504, 37.01028], [-119.6961, 37.00984], [-119.69689, 37.00955], [-119.69747, 37.0094], [-119.69801, 37.00923], [-119.6988, 37.00894], [-119.69906, 37.00881], [-119.69929, 37.00868], [-119.69967, 37.0084], [-119.69989, 37.00819], [-119.70008, 37.00797], [-119.70029, 37.00769], [-119.70046, 37.00744], [-119.70067, 37.00705], [-119.70137, 37.00556], [-119.70167, 37.00506], [-119.70202, 37.00459], [-119.70226, 37.0043], [-119.70408, 37.00231], [-119.70652, 36.99988], [-119.70563, 37.00164], [-119.70781, 37.00394]]]} | Open Access 1 | 37020 | Millerton Lake State Recreation Area | 13825 | 103 | United States Bureau of Reclamation 369 | Federal 1 | Federal Agency 1 | http://www.usbr.gov/ | Other Federal 13 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=587 | Madera 48 | 4429.696 | Millerton Lake SRA | 1957 | State Recreation Area 39 | 4 |
| 13751 | 13751 | 13750 | {"type": "Polygon", "coordinates": [[[-119.79203, 36.87905], [-119.79109, 36.87905], [-119.79022, 36.87875], [-119.79019, 36.87791], [-119.78789, 36.87794], [-119.7874, 36.87857], [-119.78724, 36.87929], [-119.78642, 36.87929], [-119.78673, 36.87858], [-119.78817, 36.87701], [-119.79199, 36.87641], [-119.79203, 36.87905]]]} | Open Access 1 | 36261 | Other State 39 | 23262 | 299 | Other State 131 | State 5 | State Agency 5 | Other State 5 | 299 | Other State 128 | State 5 | State Agency 5 | Madera 48 | 19.314 | Other State 39 | None 1184 | ||||
| 16834 | 16834 | 16833 | {"type": "Polygon", "coordinates": [[[-119.9027, 37.22836], [-119.90274, 37.22877], [-119.90272, 37.22927], [-119.90266, 37.22968], [-119.90248, 37.23018], [-119.9021, 37.23082], [-119.90181, 37.23124], [-119.9015, 37.23159], [-119.90102, 37.23201], [-119.90008, 37.2326], [-119.89985, 37.23279], [-119.89973, 37.23295], [-119.89961, 37.23347], [-119.89943, 37.23413], [-119.89898, 37.2347], [-119.89853, 37.23526], [-119.89787, 37.23589], [-119.89667, 37.23681], [-119.8961, 37.23705], [-119.89555, 37.23721], [-119.89432, 37.2372], [-119.89379, 37.23705], [-119.89303, 37.23669], [-119.89233, 37.23613], [-119.89202, 37.23595], [-119.89153, 37.23577], [-119.89115, 37.23556], [-119.89085, 37.23549], [-119.8906, 37.23546], [-119.89015, 37.23545], [-119.88983, 37.23546], [-119.88925, 37.23573], [-119.88862, 37.23611], [-119.88862, 37.23476], [-119.88945, 37.23437], [-119.89016, 37.23435], [-119.89074, 37.23437], [-119.89115, 37.23442], [-119.89175, 37.23456], [-119.8922, 37.23481], [-119.89273, 37.235], [-119.89323, 37.23531], [-119.89388, 37.23582], [-119.89438, 37.23605], [-119.89457, 37.23611], [-119.89531, 37.23611], [-119.89554, 37.23604], [-119.89585, 37.23591], [-119.89687, 37.23514], [-119.89742, 37.23461], [-119.89813, 37.23372], [-119.89826, 37.23325], [-119.89842, 37.23256], [-119.89874, 37.23213], [-119.89915, 37.23179], [-119.90008, 37.2312], [-119.90042, 37.2309], [-119.90064, 37.23066], [-119.90087, 37.23032], [-119.90119, 37.22978], [-119.90131, 37.22946], [-119.90135, 37.22919], [-119.90137, 37.22879], [-119.90132, 37.22836], [-119.9027, 37.22836]]]} | Open Access 1 | 44771 | 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 | Madera 48 | 55.076 | SLC | 0 | State Resource Management Area 55 | 3 | |
| 16840 | 16840 | 16839 | {"type": "MultiPolygon", "coordinates": [[[[-119.76601, 36.91962], [-119.7636, 36.92003], [-119.76289, 36.9203], [-119.76261, 36.91997], [-119.76318, 36.91981], [-119.76576, 36.919], [-119.76601, 36.91962]]], [[[-119.76278, 36.92035], [-119.76224, 36.92064], [-119.75912, 36.92058], [-119.75532, 36.92228], [-119.75435, 36.92355], [-119.75383, 36.9233], [-119.75406, 36.92285], [-119.75457, 36.92223], [-119.7565, 36.92094], [-119.7579, 36.92044], [-119.75879, 36.92034], [-119.7601, 36.91999], [-119.76219, 36.92011], [-119.76246, 36.92003], [-119.76278, 36.92035]]], [[[-119.7554, 36.93223], [-119.7545, 36.93259], [-119.75399, 36.93406], [-119.75335, 36.93405], [-119.75361, 36.93256], [-119.75229, 36.93156], [-119.75185, 36.9301], [-119.75138, 36.92834], [-119.75133, 36.92752], [-119.75223, 36.92685], [-119.75258, 36.92621], [-119.75267, 36.92492], [-119.75326, 36.92447], [-119.75379, 36.9234], [-119.75425, 36.92364], [-119.75347, 36.9264], [-119.75359, 36.92689], [-119.75403, 36.92733], [-119.75444, 36.92871], [-119.75448, 36.92903], [-119.75459, 36.92926], [-119.755, 36.92976], [-119.75507, 36.93094], [-119.7554, 36.93223]]]]} | Open Access 1 | 16689 | 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 | Madera 48 | 65.906 | 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]);