superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=490"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
132 | 132 | 131 | {"type": "Polygon", "coordinates": [[[-121.65725, 38.05304], [-121.65705, 38.05323], [-121.65689, 38.05329], [-121.65649, 38.05369], [-121.65623, 38.05386], [-121.65611, 38.05401], [-121.65594, 38.05409], [-121.65584, 38.05416], [-121.65575, 38.05424], [-121.65566, 38.05437], [-121.65556, 38.05445], [-121.65541, 38.05455], [-121.65515, 38.05465], [-121.65401, 38.05448], [-121.65358, 38.05448], [-121.65299, 38.05439], [-121.65238, 38.05435], [-121.65191, 38.05435], [-121.65165, 38.05433], [-121.65145, 38.05433], [-121.65123, 38.05437], [-121.6506, 38.05463], [-121.65033, 38.05467], [-121.65008, 38.05477], [-121.64951, 38.0549], [-121.64925, 38.05497], [-121.649, 38.055], [-121.64859, 38.05499], [-121.64799, 38.05486], [-121.6474, 38.05465], [-121.64706, 38.05458], [-121.6468, 38.05455], [-121.64631, 38.05439], [-121.64591, 38.05434], [-121.64551, 38.05425], [-121.64527, 38.05427], [-121.64512, 38.0542], [-121.64498, 38.05415], [-121.64436, 38.05401], [-121.64415, 38.05398], [-121.64359, 38.05384], [-121.64292, 38.05366], [-121.6422, 38.05344], [-121.64115, 38.05317], [-121.64078, 38.05313], [-121.64049, 38.05305], [-121.63928, 38.05296], [-121.63901, 38.05298], [-121.63868, 38.05295], [-121.63848, 38.05298], [-121.63805, 38.05289], [-121.63796, 38.05282], [-121.63781, 38.05262], [-121.63762, 38.0525], [-121.63727, 38.05211], [-121.63694, 38.05181], [-121.6368, 38.05163], [-121.63639, 38.0512], [-121.63614, 38.05087], [-121.636, 38.05073], [-121.63588, 38.05057], [-121.63557, 38.05032], [-121.63544, 38.05026], [-121.63494, 38.05013], [-121.63472, 38.05002], [-121.63394, 38.04985], [-121.63357, 38.04973], [-121.63264, 38.04953], [-121.6325, 38.04947], [-121.63228, 38.04934], [-121.63194, 38.04918], [-121.63102, 38.04883], [-121.63064, 38.04874], [-121.63028, 38.04867], [-121.62996, 38.04867], [-121.62962, 38.04871], [-121.62931, 38.04879], [-121.62875, 38.04899], [-121.62843, 38.04908], [-121.62828, 38.04907], [-121.62821, 38.04901], [-121.62795, 38.0486], [-121.62777, 38.04836], [-121.62773, 38.04832], [-121.6276, 38.04829], [-121.62736, 38.04816], [-121.6272, 38.0481], [-121.62696, 38.04808], [-121.62647, 38.04797], [-121.62626, 38.04797], [-121.62603, 38.04791], [-121.62584, 38.0479], [-121.62566, 38.04795], [-121.62555, 38.04794], [-121.62506, 38.04783], [-121.62491, 38.04782], [-121.62472, 38.04776], [-121.62445, 38.04772], [-121.6241, 38.04757], [-121.62401, 38.04761], [-121.62363, 38.04757], [-121.62328, 38.04759], [-121.62295, 38.04771], [-121.62261, 38.04794], [-121.62241, 38.04822], [-121.6224, 38.0483], [-121.62242, 38.04847], [-121.62238, 38.04856], [-121.62238, 38.04859], [-121.62255, 38.04881], [-121.62266, 38.0489], [-121.62289, 38.04903], [-121.62311, 38.04919], [-121.62351, 38.04938], [-121.62365, 38.04953], [-121.62384, 38.04962], [-121.62395, 38.0497], [-121.6241, 38.04984], [-121.62427, 38.05005], [-121.62464, 38.05036], [-121.62467, 38.05041], [-121.6247, 38.05056], [-121.6249, 38.05085], [-121.62494, 38.051], [-121.62504, 38.05115], [-121.62506, 38.05123], [-121.62505, 38.05131], [-121.62501, 38.05145], [-121.62495, 38.05158], [-121.62483, 38.05169], [-121.62478, 38.05211], [-121.62463, 38.0522], [-121.62457, 38.05239], [-121.62448, 38.05256], [-121.62445, 38.05283], [-121.6244, 38.05307], [-121.62442, 38.0532], [-121.62434, 38.05336], [-121.62427, 38.0537], [-121.62407, 38.05401], [-121.62404, 38.05415], [-121.62393, 38.05431], [-121.62374, 38.05474], [-121.62343, 38.05521], [-121.62336, 38.0554], [-121.62314, 38.05566], [-121.62306, 38.05588], [-121.62273, 38.05647], [-121.62244, 38.05686], [-121.62223, 38.05707], [-121.62205, 38.05723], [-121.62197, 38.0574], [-121.6218, 38.05754], [-121.62169, 38.05769], [-121.6215, 38.05782], [-121.62133, 38.05796], [-121.62126, 38.05807], [-121.62125, 38.05822], [-121.62118, 38.05839], [-121.6211, 38.05852], [-121.621, 38.05857], [-121.62098, 38.05859], [-121.62099, 38.05863], [-121.62107, 38.05864], [-121.6211, 38.05867], [-121.62119, 38.05904], [-121.62112, 38.05921], [-121.62107, 38.05942], [-121.62098, 38.05956], [-121.62093, 38.05969], [-121.62081, 38.06015], [-121.62077, 38.0602], [-121.6207, 38.06024], [-121.62021, 38.06038], [-121.62001, 38.0604], [-121.6197, 38.06038], [-121.61957, 38.06035], [-121.61945, 38.0603], [-121.61931, 38.0602], [-121.6192, 38.06009], [-121.61905, 38.05979], [-121.61894, 38.05971], [-121.6188, 38.05947], [-121.61871, 38.05939], [-121.61848, 38.05928], [-121.61827, 38.05914], [-121.61781, 38.05893], [-121.61681, 38.05842], [-121.61622, 38.05817], [-121.61598, 38.05799], [-121.61589, 38.05794], [-121.61576, 38.0579], [-121.61537, 38.05762], [-121.61532, 38.05755], [-121.61528, 38.05743], [-121.61531, 38.05729], [-121.6153, 38.05723], [-121.6151, 38.05676], [-121.61472, 38.05615], [-121.61462, 38.05603], [-121.61438, 38.05583], [-121.61425, 38.05573], [-121.61416, 38.05569], [-121.61374, 38.05567], [-121.61337, 38.05569], [-121.61292, 38.05594], [-121.61273, 38.05617], [-121.61262, 38.0567], [-121.61255, 38.05711], [-121.61246, 38.05723], [-121.61226, 38.05692], [-121.61163, 38.05716], [-121.61193, 38.05768], [-121.61159, 38.0578], [-121.61075, 38.05802], [-121.60976, 38.05856], [-121.60886, 38.05893], [-121.60724, 38.05953], [-121.60297, 38.06057], [-121.60113, 38.06103], [-121.59983, 38.06142], [-121.59914, 38.0618], [-121.59848, 38.06239], [-121.59691, 38.06365], [-121.5964, 38.06382], [-121.5958, 38.06388], [-121.59529, 38.06371], [-121.59492, 38.06345], [-121.59443, 38.06321], [-121.59327, 38.06309], [-121.59254, 38.06312], [-121.59175, 38.06293], [-121.59114, 38.06286], [-121.59032, 38.06293], [-121.58974, 38.063], [-121.58916, 38.06292], [-121.58897, 38.06282], [-121.5888, 38.06278], [-121.58865, 38.06277], [-121.58835, 38.06254], [-121.58825, 38.06253], [-121.58793, 38.06231], [-121.58782, 38.06226], [-121.58767, 38.06215], [-121.58755, 38.06208], [-121.58713, 38.06192], [-121.587, 38.06182], [-121.5868, 38.06173], [-121.58667, 38.06162], [-121.58635, 38.06143], [-121.58624, 38.06131], [-121.58583, 38.06114], [-121.58555, 38.06093], [-121.5853, 38.06085], [-121.58518, 38.06078], [-121.58485, 38.06051], [-121.5847, 38.06033], [-121.58445, 38.06015], [-121.58443, 38.06012], [-121.58443, 38.06003], [-121.58437, 38.05985], [-121.58428, 38.05966], [-121.58428, 38.05949], [-121.58425, 38.05938], [-121.58424, 38.05822], [-121.58414, 38.05663], [-121.584, 38.05499], [-121.58392, 38.05328], [-121.58387, 38.05271], [-121.58395, 38.05051], [-121.58432, 38.04922], [-121.58473, 38.04642], [-121.58502, 38.04431], [-121.58504, 38.04197], [-121.58573, 38.04213], [-121.58572, 38.04158], [-121.58502, 38.04139], [-121.58528, 38.0404], [-121.58536, 38.03917], [-121.5853, 38.03835], [-121.58517, 38.03742], [-121.58505, 38.03687], [-121.58493, 38.03648], [-121.58473, 38.03608], [-121.5845, 38.03578], [-121.58442, 38.0356], [-121.58417, 38.03495], [-121.58393, 38.03428], [-121.58379, 38.03397], [-121.58326, 38.0333], [-121.58309, 38.03314], [-121.58288, 38.03289], [-121.58275, 38.03283], [-121.58216, 38.03239], [-121.58207, 38.03221], [-121.58184, 38.03189], [-121.5818, 38.03178], [-121.5818, 38.0317], [-121.58184, 38.03163], [-121.58192, 38.03156], [-121.58213, 38.03144], [-121.58236, 38.03133], [-121.58249, 38.0312], [-121.58328, 38.03118], [-121.58333, 38.03123], [-121.58392, 38.03136], [-121.58408, 38.03137], [-121.58435, 38.03137], [-121.58509, 38.03129], [-121.58566, 38.03121], [-121.58622, 38.03109], [-121.58681, 38.031], [-121.58719, 38.03096], [-121.58805, 38.03101], [-121.58882, 38.03093], [-121.58977, 38.03074], [-121.58988, 38.03098], [-121.59066, 38.03073], [-121.59067, 38.03072], [-121.59061, 38.03064], [-121.59014, 38.03003], [-121.59047, 38.02966], [-121.59062, 38.02941], [-121.59103, 38.02886], [-121.59176, 38.02817], [-121.59213, 38.02786], [-121.59236, 38.0277], [-121.59252, 38.02762], [-121.59306, 38.02741], [-121.59376, 38.02722], [-121.5939, 38.02713], [-121.59408, 38.02696], [-121.59425, 38.02689], [-121.59439, 38.02688], [-121.59501, 38.02694], [-121.59566, 38.02697], [-121.59647, 38.02695], [-121.59657, 38.02693], [-121.59665, 38.02688], [-121.59678, 38.02677], [-121.59691, 38.0267], [-121.59745, 38.02648], [-121.59785, 38.02626], [-121.59816, 38.026], [-121.59832, 38.0257], [-121.59872, 38.02558], [-121.5992, 38.02538], [-121.59968, 38.02525], [-121.59994, 38.02505], [-121.60023, 38.02489], [-121.60036, 38.02475], [-121.60052, 38.02462], [-121.60061, 38.02444], [-121.60085, 38.02406], [-121.60086, 38.02382], [-121.60091, 38.02347], [-121.6009, 38.02324], [-121.60085, 38.0229], [-121.6008, 38.02274], [-121.60063, 38.02257], [-121.60059, 38.02252], [-121.60058, 38.02248], [-121.60064, 38.02235], [-121.60071, 38.02223], [-121.60077, 38.02219], [-121.60088, 38.02216], [-121.60092, 38.02211], [-121.60092, 38.02204], [-121.60088, 38.02189], [-121.60095, 38.02174], [-121.60092, 38.02141], [-121.60093, 38.02139], [-121.60106, 38.02138], [-121.60146, 38.02124], [-121.60162, 38.02122], [-121.60206, 38.02104], [-121.60228, 38.021], [-121.6025, 38.0209], [-121.60361, 38.02061], [-121.6041, 38.02051], [-121.60421, 38.02056], [-121.60424, 38.02054], [-121.60424, 38.0205], [-121.60426, 38.02047], [-121.60447, 38.02041], [-121.60495, 38.02032], [-121.60552, 38.02027], [-121.60576, 38.02022], [-121.60602, 38.02019], [-121.60659, 38.02], [-121.60673, 38.01997], [-121.60686, 38.01998], [-121.60693, 38.02002], [-121.60731, 38.02047], [-121.60793, 38.02104], [-121.60851, 38.0217], [-121.60873, 38.02206], [-121.60899, 38.02239], [-121.60921, 38.02276], [-121.60932, 38.02302], [-121.60937, 38.02319], [-121.60952, 38.02344], [-121.60954, 38.02356], [-121.60967, 38.02382], [-121.60972, 38.02394], [-121.60979, 38.02405], [-121.60988, 38.02426], [-121.60995, 38.02435], [-121.60997, 38.02446], [-121.61017, 38.02478], [-121.61036, 38.02522], [-121.61043, 38.02525], [-121.6105, 38.02548], [-121.61056, 38.02551], [-121.61069, 38.02569], [-121.61069, 38.0258], [-121.61078, 38.02583], [-121.61079, 38.0259], [-121.61106, 38.02636], [-121.61117, 38.02658], [-121.61129, 38.02677], [-121.61144, 38.02698], [-121.61146, 38.02706], [-121.61157, 38.02722], [-121.61166, 38.02741], [-121.61175, 38.02752], [-121.61177, 38.02759], [-121.61183, 38.02768], [-121.61187, 38.02778], [-121.61194, 38.02787], [-121.61201, 38.02801], [-121.61218, 38.02822], [-121.61229, 38.02843], [-121.61236, 38.0285], [-121.61265, 38.02892], [-121.61341, 38.0299], [-121.61396, 38.03042], [-121.61475, 38.03073], [-121.61523, 38.03106], [-121.61544, 38.03116], [-121.61552, 38.03118], [-121.61581, 38.03135], [-121.61709, 38.03198], [-121.61754, 38.0323], [-121.6177, 38.03235], [-121.61799, 38.03241], [-121.61824, 38.03253], [-121.61843, 38.03269], [-121.61867, 38.03308], [-121.61906, 38.0335], [-121.61914, 38.03355], [-121.6194, 38.03365], [-121.61944, 38.03376], [-121.61952, 38.03384], [-121.61971, 38.03393], [-121.61994, 38.03407], [-121.62013, 38.03424], [-121.62038, 38.03442], [-121.62082, 38.03456], [-121.62098, 38.03455], [-121.62145, 38.03469], [-121.62164, 38.03477], [-121.62179, 38.03488], [-121.62188, 38.03497], [-121.62194, 38.03521], [-121.62199, 38.03535], [-121.622, 38.03584], [-121.62199, 38.03596], [-121.62207, 38.0363], [-121.62214, 38.03642], [-121.6223, 38.03654], [-121.6226, 38.03687], [-121.62286, 38.03733], [-121.62304, 38.03799], [-121.62305, 38.03814], [-121.62332, 38.03844], [-121.62376, 38.03867], [-121.62407, 38.0388], [-121.62454, 38.03886], [-121.6247, 38.03887], [-121.62482, 38.03885], [-121.62532, 38.0387], [-121.62561, 38.03858], [-121.62577, 38.03841], [-121.62588, 38.03825], [-121.62619, 38.03814], [-121.62643, 38.0381], [-121.62666, 38.0381], [-121.62681, 38.03815], [-121.62696, 38.03825], [-121.62708, 38.03837], [-121.62717, 38.03851], [-121.62725, 38.03872], [-121.62725, 38.03881], [-121.62722, 38.03909], [-121.62717, 38.0392], [-121.62701, 38.03947], [-121.62688, 38.0396], [-121.62681, 38.03966], [-121.62679, 38.03969], [-121.62672, 38.04018], [-121.62673, 38.04059], [-121.62674, 38.04068], [-121.62683, 38.0409], [-121.62699, 38.0411], [-121.6272, 38.04125], [-121.62757, 38.04158], [-121.62815, 38.04197], [-121.62831, 38.04201], [-121.62858, 38.04216], [-121.62887, 38.04226], [-121.62901, 38.04228], [-121.62928, 38.04226], [-121.62964, 38.04228], [-121.62998, 38.04226], [-121.63018, 38.0422], [-121.63048, 38.04214], [-121.63082, 38.04203], [-121.63106, 38.04192], [-121.63127, 38.0419], [-121.63144, 38.04185], [-121.63188, 38.04175], [-121.63203, 38.04169], [-121.6323, 38.04168], [-121.63254, 38.04168], [-121.63267, 38.04172], [-121.6328, 38.04179], [-121.63303, 38.042], [-121.63308, 38.0421], [-121.63323, 38.04255], [-121.6332, 38.04314], [-121.63321, 38.0433], [-121.63325, 38.04353], [-121.63339, 38.04386], [-121.63351, 38.04409], [-121.63369, 38.04433], [-121.63375, 38.04445], [-121.63392, 38.04463], [-121.63401, 38.04479], [-121.63411, 38.04504], [-121.63415, 38.04566], [-121.63422, 38.04579], [-121.63425, 38.04589], [-121.63453, 38.0462], [-121.63502, 38.04651], [-121.63518, 38.04658], [-121.63549, 38.04661], [-121.63604, 38.04678], [-121.63627, 38.04679], [-121.63641, 38.04681], [-121.63695, 38.04694], [-121.63709, 38.04699], [-121.63719, 38.04701], [-121.63772, 38.04706], [-121.63829, 38.04713], [-121.63954, 38.04711], [-121.63977, 38.04712], [-121.63999, 38.04716], [-121.64015, 38.04721], [-121.64036, 38.04734], [-121.64062, 38.04769], [-121.64079, 38.04794], [-121.64112, 38.04826], [-121.64134, 38.04835], [-121.64157, 38.04849], [-121.64175, 38.04854], [-121.64233, 38.04878], [-121.64248, 38.04881], [-121.64335, 38.0488], [-121.64355, 38.04878], [-121.64398, 38.04869], [-121.64405, 38.04866], [-121.64417, 38.04856], [-121.64447, 38.04842], [-121.64475, 38.04816], [-121.64481, 38.04799], [-121.64491, 38.04781], [-121.64499, 38.04745], [-121.64501, 38.04704], [-121.64499, 38.04674], [-121.64505, 38.04664], [-121.6451, 38.04647], [-121.64519, 38.04634], [-121.64532, 38.04622], [-121.64545, 38.04617], [-121.64569, 38.04603], [-121.64586, 38.04596], [-121.64612, 38.04578], [-121.64625, 38.04573], [-121.64641, 38.04559], [-121.64656, 38.04553], [-121.647, 38.045], [-121.64712, 38.04457], [-121.64712, 38.04396], [-121.64714, 38.04381], [-121.6472, 38.04365], [-121.64718, 38.04349], [-121.64742, 38.04311], [-121.64749, 38.04307], [-121.64768, 38.04306], [-121.64813, 38.04293], [-121.64845, 38.04296], [-121.64857, 38.04299], [-121.64867, 38.04315], [-121.64877, 38.04336], [-121.64879, 38.04347], [-121.64878, 38.04358], [-121.6487, 38.04386], [-121.64851, 38.04421], [-121.64838, 38.04453], [-121.64835, 38.04473], [-121.64829, 38.04485], [-121.64826, 38.04499], [-121.64819, 38.04511], [-121.64818, 38.0453], [-121.64814, 38.04545], [-121.64806, 38.04565], [-121.64808, 38.04584], [-121.64809, 38.04623], [-121.6482, 38.04654], [-121.64831, 38.04666], [-121.64836, 38.04679], [-121.64843, 38.04687], [-121.64868, 38.0471], [-121.64902, 38.04727], [-121.6493, 38.04732], [-121.64954, 38.0474], [-121.64971, 38.04741], [-121.64984, 38.04747], [-121.65012, 38.0475], [-121.6509, 38.04749], [-121.65131, 38.04752], [-121.65185, 38.04753], [-121.652, 38.04755], [-121.65219, 38.04763], [-121.65227, 38.04768], [-121.65237, 38.04781], [-121.65245, 38.04797], [-121.65256, 38.04815], [-121.65262, 38.04834], [-121.65274, 38.04851], [-121.65281, 38.04867], [-121.65288, 38.04879], [-121.65296, 38.04889], [-121.65326, 38.04913], [-121.65342, 38.04923], [-121.65361, 38.04939], [-121.65375, 38.04947], [-121.65405, 38.0497], [-121.65418, 38.04978], [-121.65476, 38.05008], [-121.65509, 38.05019], [-121.65606, 38.05065], [-121.65679, 38.05106], [-121.65698, 38.05123], [-121.65724, 38.05139], [-121.65744, 38.05159], [-121.65754, 38.05172], [-121.6576, 38.05192], [-121.65763, 38.05218], [-121.65763, 38.05232], [-121.6575, 38.05262], [-121.65728, 38.05292], [-121.65725, 38.05304]], [[-121.61782, 38.04371], [-121.61781, 38.04369], [-121.61621, 38.04361], [-121.61602, 38.04487], [-121.61762, 38.04496], [-121.61782, 38.04371]]]} | Open Access 1 | Franks Tract State Recreation Area | http://www.parks.ca.gov/?page_id=490 | 1543 | 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 | 3588.925 | Franks Tract SRA | 1959 |
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]);