units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where COUNTY = 3, LAYER = 7 and MNG_AG_TYP = 1
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2423 | 2423 | 2422 | {"type": "MultiPolygon", "coordinates": [[[[-117.6688, 33.80019], [-117.66752, 33.80083], [-117.66193, 33.80084], [-117.66195, 33.79684], [-117.6618, 33.79677], [-117.66174, 33.7968], [-117.66167, 33.79703], [-117.6616, 33.79715], [-117.6615, 33.79724], [-117.66141, 33.79728], [-117.66134, 33.79728], [-117.66128, 33.79726], [-117.66113, 33.79712], [-117.66106, 33.79708], [-117.66091, 33.79706], [-117.65965, 33.79725], [-117.65953, 33.79732], [-117.65939, 33.79753], [-117.65927, 33.79763], [-117.65917, 33.79767], [-117.65856, 33.79782], [-117.6585, 33.79783], [-117.65837, 33.79781], [-117.65812, 33.79763], [-117.65798, 33.79759], [-117.65741, 33.79767], [-117.65731, 33.79772], [-117.65722, 33.79779], [-117.65718, 33.79784], [-117.65715, 33.79793], [-117.65715, 33.79809], [-117.65721, 33.79826], [-117.6573, 33.79837], [-117.65742, 33.79847], [-117.65757, 33.79855], [-117.65794, 33.79864], [-117.6583, 33.79877], [-117.65838, 33.79884], [-117.65841, 33.79893], [-117.65839, 33.79899], [-117.65825, 33.79938], [-117.65822, 33.79964], [-117.6582, 33.79969], [-117.65816, 33.79974], [-117.6581, 33.79978], [-117.65784, 33.79982], [-117.65776, 33.79985], [-117.65771, 33.79989], [-117.65766, 33.79996], [-117.65742, 33.80054], [-117.65733, 33.80076], [-117.65732, 33.80084], [-117.65733, 33.80102], [-117.6574, 33.80135], [-117.63928, 33.80152], [-117.63901, 33.81518], [-117.62353, 33.81486], [-117.62314, 33.81499], [-117.62018, 33.81164], [-117.60499, 33.79469], [-117.59583, 33.78528], [-117.58898, 33.7782], [-117.57798, 33.76693], [-117.54859, 33.75934], [-117.54845, 33.75939], [-117.5484, 33.75929], [-117.53615, 33.75613], [-117.53419, 33.71063], [-117.51927, 33.70855], [-117.48346, 33.70345], [-117.4751, 33.70228], [-117.44788, 33.68351], [-117.43544, 33.67499], [-117.43299, 33.67325], [-117.43298, 33.67126], [-117.42983, 33.67115], [-117.41478, 33.66084], [-117.41483, 33.65662], [-117.41533, 33.65607], [-117.43294, 33.65714], [-117.43272, 33.6421], [-117.42612, 33.64214], [-117.42955, 33.63795], [-117.42958, 33.63922], [-117.45111, 33.63952], [-117.45099, 33.63159], [-117.43488, 33.63115], [-117.4375, 33.62766], [-117.46109, 33.59734], [-117.46221, 33.59706], [-117.46249, 33.59705], [-117.46288, 33.59715], [-117.46319, 33.59726], [-117.46343, 33.5973], [-117.46363, 33.59731], [-117.46384, 33.59728], [-117.46421, 33.5971], [-117.46436, 33.5969], [-117.4645, 33.5966], [-117.46457, 33.59621], [-117.46456, 33.59584], [-117.46457, 33.59525], [-117.46476, 33.5946], [-117.46492, 33.59435], [-117.46578, 33.59352], [-117.46602, 33.59345], [-117.46686, 33.59356], [-117.46799, 33.59361], [-117.46823, 33.59358], [-117.4685, 33.59347], [-117.46875, 33.59326], [-117.46889, 33.59305], [-117.46919, 33.59217], [-117.46937, 33.59196], [-117.46965, 33.59181], [-117.46988, 33.59172], [-117.47016, 33.59167], [-117.47041, 33.59169], [-117.47078, 33.5918], [-117.47103, 33.59193], [-117.47152, 33.59215], [-117.47199, 33.59232], [-117.4724, 33.5924], [-117.47271, 33.59237], [-117.47301, 33.5923], [-117.47325, 33.59216], [-117.47344, 33.59209], [-117.47375, 33.59201], [-117.47404, 33.59201], [-117.47496, 33.59219], [-117.47553, 33.59235], [-117.47787, 33.59308], [-117.47834, 33.59331], [-117.47878, 33.59362], [-117.47941, 33.59413], [-117.47981, 33.59441], [-117.48028, 33.59461], [-117.48158, 33.59489], [-117.48221, 33.59506], [-117.48283, 33.59527], [-117.48325, 33.59532], [-117.48353, 33.59532], [-117.48385, 33.59522], [-117.48426, 33.59503], [-117.4849, 33.59445], [-117.48524, 33.59408], [-117.48556, 33.59394], [-117.48577, 33.59395], [-117.48648, 33.59405], [-117.48697, 33.59416], [-117.48739, 33.59415], [-117.48779, 33.59405], [-117.48837, 33.59381], [-117.48914, 33.59353], [-117.48957, 33.59346], [-117.49046, 33.59353], [-117.49088, 33.59351], [-117.49117, 33.59335], [-117.49161, 33.59282], [-117.4918, 33.59264], [-117.49206, 33.59256], [-117.49244, 33.5925], [-117.49287, 33.59248], [-117.49324, 33.59252], [-117.49359, 33.5926], [-117.49465, 33.5928], [-117.49501, 33.59282], [-117.49528, 33.59277], [-117.49555, 33.59266], [-117.49595, 33.59255], [-117.49643, 33.59248], [-117.49686, 33.59244], [-117.49712, 33.59225], [-117.49733, 33.59186], [-117.49745, 33.59145], [-117.49775, 33.59106], [-117.4983, 33.59073], [-117.49914, 33.5905], [-117.49968, 33.59048], [-117.50056, 33.59075], [-117.50097, 33.59074], [-117.50141, 33.59062], [-117.50188, 33.59052], [-117.50238, 33.59035], [-117.50288, 33.59024], [-117.50329, 33.59026], [-117.5038, 33.59043], [-117.50491, 33.5909], [-117.50606, 33.5915], [-117.50663, 33.59161], [-117.50817, 33.59153], [-117.50871, 33.59163], [-117.50933, 33.59192], [-117.51024, 33.59224], [-117.51093, 33.59239], [-117.51099, 33.59581], [-117.51162, 33.59626], [-117.51164, 33.59625], [-117.52808, 33.60734], [-117.528, 33.60743], [-117.53558, 33.6126], [-117.5405, 33.61572], [-117.5406, 33.62251], [-117.54422, 33.62264], [-117.54861, 33.62268], [-117.54826, 33.62995], [-117.55241, 33.62993], [-117.55224, 33.63716], [-117.55223, 33.64071], [-117.54793, 33.64076], [-117.54794, 33.64433], [-117.54795, 33.64434], [-117.55626, 33.64418], [-117.55625, 33.65136], [-117.5521, 33.65137], [-117.55203, 33.65674], [-117.55204, 33.65675], [-117.55526, 33.65674], [-117.55526, 33.65852], [-117.55621, 33.65853], [-117.55625, 33.66953], [-117.55222, 33.66958], [-117.55225, 33.67325], [-117.54799, 33.67328], [-117.54805, 33.67684], [-117.55626, 33.67685], [-117.55627, 33.67886], [-117.55597, 33.68382], [-117.55591, 33.68584], [-117.59109, 33.68597], [-117.60694, 33.68596], [-117.60714, 33.68606], [-117.6073, 33.68611], [-117.60781, 33.68616], [-117.60763, 33.70026], [-117.61631, 33.70049], [-117.61849, 33.70059], [-117.62499, 33.70052], [-117.62701, 33.70056], [-117.62577, 33.70101], [-117.62582, 33.70315], [-117.62596, 33.70316], [-117.62598, 33.70358], [-117.62596, 33.70536], [-117.62698, 33.70544], [-117.6265, 33.70631], [-117.62619, 33.70653], [-117.62611, 33.70685], [-117.6258, 33.70711], [-117.62573, 33.70742], [-117.62581, 33.70756], [-117.62577, 33.70787], [-117.62538, 33.70789], [-117.62537, 33.70762], [-117.61874, 33.70763], [-117.60784, 33.70771], [-117.60775, 33.71494], [-117.60794, 33.72201], [-117.60774, 33.7289], [-117.61633, 33.72934], [-117.61604, 33.74405], [-117.60516, 33.74389], [-117.60204, 33.7439], [-117.59515, 33.74388], [-117.58719, 33.74378], [-117.58717, 33.747], [-117.59525, 33.74705], [-117.59885, 33.74736], [-117.59885, 33.74754], [-117.60466, 33.74773], [-117.60944, 33.74772], [-117.6094, 33.74809], [-117.60959, 33.7481], [-117.60958, 33.7507], [-117.60959, 33.75071], [-117.62302, 33.7507], [-117.62304, 33.74832], [-117.62522, 33.74834], [-117.62519, 33.74754], [-117.62664, 33.74744], [-117.62665, 33.74737], [-117.62679, 33.74739], [-117.62679, 33.7476], [-117.62715, 33.74764], [-117.62718, 33.74745], [-117.62797, 33.7474], [-117.62926, 33.74717], [-117.62973, 33.74714], [-117.62992, 33.74718], [-117.63006, 33.7473], [-117.63004, 33.74736], [-117.63035, 33.74748], [-117.63042, 33.7473], [-117.63088, 33.74749], [-117.63095, 33.74733], [-117.63124, 33.74745], [-117.63144, 33.74751], [-117.63145, 33.74757], [-117.6316, 33.74759], [-117.6316, 33.74749], [-117.6334, 33.74794], [-117.63349, 33.75591], [-117.63365, 33.75592], [-117.63373, 33.75817], [-117.62298, 33.7582], [-117.62286, 33.77438], [-117.6395, 33.77441], [-117.63912, 33.78615], [-117.66104, 33.78624], [-117.66102, 33.78738], [-117.66137, 33.78734], [-117.66167, 33.78736], [-117.66183, 33.78739], [-117.66225, 33.78727], [-117.66244, 33.78718], [-117.66271, 33.78716], [-117.66313, 33.78733], [-117.66353, 33.78761], [-117.66759, 33.78776], [-117.66808, 33.79481], [-117.6688, 33.80019]], [[-117.43296, 33.65715], [-117.43296, 33.6642], [-117.44161, 33.66418], [-117.44162, 33.65697], [-117.43879, 33.65702], [-117.43296, 33.65715]], [[-117.49311, 33.68442], [-117.49311, 33.6844], [-117.48844, 33.67738], [-117.48505, 33.67885], [-117.48271, 33.67554], [-117.4794, 33.67705], [-117.48419, 33.68401], [-117.48576, 33.68326], [-117.48725, 33.68546], [-117.49096, 33.68541], [-117.49311, 33.68442]], [[-117.51391, 33.61388], [-117.51392, 33.61387], [-117.51387, 33.60771], [-117.50956, 33.60779], [-117.50962, 33.61036], [-117.50536, 33.61046], [-117.50562, 33.61753], [-117.50981, 33.61748], [-117.50971, 33.61387], [-117.51391, 33.61388]], [[-117.58125, 33.74559], [-117.58102, 33.74525], [-117.58085, 33.74514], [-117.58079, 33.74503], [-117.57925, 33.74444], [-117.57943, 33.74436], [-117.57929, 33.74403], [-117.57926, 33.74376], [-117.57902, 33.74338], [-117.57915, 33.74315], [-117.57804, 33.74361], [-117.58064, 33.74676], [-117.58066, 33.74675], [-117.58093, 33.74616], [-117.58128, 33.74587], [-117.58145, 33.7458], [-117.58146, 33.74578], [-117.58148, 33.74558], [-117.58146, 33.7455], [-117.58125, 33.74559]], [[-117.57966, 33.74425], [-117.57953, 33.74393], [-117.57949, 33.74365], [-117.57935, 33.74343], [-117.57963, 33.74296], [-117.57962, 33.74295], [-117.57924, 33.74311], [-117.57907, 33.74338], [-117.5793, 33.74374], [-117.57934, 33.74403], [-117.57946, 33.74432], [-117.57993, 33.74447], [-117.5801, 33.7444], [-117.58009, 33.74439], [-117.57966, 33.74425]], [[-117.58143, 33.74549], [-117.58143, 33.74547], [-117.58123, 33.74517], [-117.58106, 33.74505], [-117.581, 33.74495], [-117.5807, 33.74472], [-117.57984, 33.74449], [-117.57947, 33.74437], [-117.57932, 33.74443], [-117.58082, 33.74502], [-117.58088, 33.74513], [-117.58103, 33.74524], [-117.58126, 33.74555], [-117.58143, 33.74549]], [[-117.5822, 33.74498], [-117.58215, 33.74479], [-117.58204, 33.74466], [-117.58159, 33.74494], [-117.57992, 33.74283], [-117.57969, 33.74292], [-117.57938, 33.74343], [-117.57952, 33.74365], [-117.57955, 33.74393], [-117.57967, 33.74423], [-117.58021, 33.74441], [-117.58086, 33.74458], [-117.58087, 33.74456], [-117.58059, 33.74421], [-117.58061, 33.7442], [-117.58092, 33.74459], [-117.58096, 33.74461], [-117.58126, 33.74485], [-117.58132, 33.74495], [-117.5815, 33.74508], [-117.58168, 33.74515], [-117.582, 33.74509], [-117.5822, 33.74498]], [[-117.5817, 33.74535], [-117.58171, 33.74534], [-117.58168, 33.74517], [-117.58148, 33.74509], [-117.58146, 33.74507], [-117.5813, 33.74496], [-117.58124, 33.74485], [-117.58094, 33.74462], [-117.58015, 33.74441], [-117.57998, 33.74448], [-117.57999, 33.7445], [-117.58071, 33.74468], [-117.58103, 33.74493], [-117.58109, 33.74503], [-117.58126, 33.74514], [-117.58137, 33.74531], [-117.5814, 33.74533], [-117.58145, 33.74535], [-117.5817, 33.74535]], [[-117.58108, 33.7465], [-117.5811, 33.74645], [-117.58172, 33.74596], [-117.58172, 33.74594], [-117.58155, 33.74593], [-117.58146, 33.74589], [-117.58138, 33.74588], [-117.58132, 33.7459], [-117.58097, 33.74618], [-117.58069, 33.7468], [-117.58077, 33.74691], [-117.58092, 33.7468], [-117.58108, 33.7465]], [[-117.58167, 33.74672], [-117.58138, 33.74649], [-117.58129, 33.74657], [-117.58111, 33.74692], [-117.5809, 33.74707], [-117.58101, 33.74719], [-117.5816, 33.74682], [-117.58167, 33.74672]], [[-117.58333, 33.74569], [-117.58332, 33.74568], [-117.58315, 33.74561], [-117.58242, 33.74599], [-117.58209, 33.74639], [-117.58227, 33.74654], [-117.58225, 33.74656], [-117.58207, 33.74642], [-117.58171, 33.7467], [-117.58161, 33.74683], [-117.58102, 33.74722], [-117.58123, 33.74746], [-117.58298, 33.74673], [-117.58298, 33.74672], [-117.58256, 33.74617], [-117.58333, 33.74569]], [[-117.5819, 33.7463], [-117.5819, 33.74628], [-117.58177, 33.74619], [-117.58141, 33.74648], [-117.58154, 33.74658], [-117.5819, 33.7463]], [[-117.5815, 33.74549], [-117.58153, 33.74549], [-117.58158, 33.74545], [-117.5816, 33.74542], [-117.5816, 33.74539], [-117.58146, 33.74539], [-117.58145, 33.74543], [-117.5815, 33.74549]], [[-117.58383, 33.74538], [-117.58383, 33.74537], [-117.58355, 33.74501], [-117.58338, 33.74498], [-117.58288, 33.74495], [-117.5825, 33.74479], [-117.58247, 33.74479], [-117.58246, 33.74481], [-117.58252, 33.74507], [-117.5825, 33.74511], [-117.58212, 33.74531], [-117.58176, 33.74538], [-117.58166, 33.74544], [-117.58155, 33.74555], [-117.58153, 33.74561], [-117.58151, 33.74586], [-117.58154, 33.74589], [-117.58158, 33.7459], [-117.58179, 33.7459], [-117.58195, 33.74578], [-117.58291, 33.7454], [-117.5831, 33.74541], [-117.58352, 33.74557], [-117.58383, 33.74538]], [[-117.58205, 33.74641], [-117.58204, 33.74639], [-117.58193, 33.74631], [-117.58157, 33.7466], [-117.58169, 33.74669], [-117.58205, 33.74641]], [[-117.58223, 33.74499], [-117.58201, 33.74511], [-117.5817, 33.74517], [-117.58174, 33.74534], [-117.58213, 33.74528], [-117.58247, 33.74508], [-117.58241, 33.74481], [-117.58243, 33.74478], [-117.58247, 33.74474], [-117.58231, 33.7445], [-117.58206, 33.74465], [-117.58218, 33.74479], [-117.58223, 33.74499]], [[-117.58311, 33.74561], [-117.58311, 33.74559], [-117.58303, 33.74556], [-117.58298, 33.74557], [-117.58209, 33.74593], [-117.5818, 33.74617], [-117.58207, 33.74638], [-117.5824, 33.74598], [-117.58311, 33.74561]], [[-117.58349, 33.74496], [-117.5835, 33.74495], [-117.58287, 33.74415], [-117.58235, 33.74447], [-117.58255, 33.74478], [-117.58281, 33.7449], [-117.58288, 33.74492], [-117.58335, 33.74494], [-117.58349, 33.74496]], [[-117.6303, 33.79318], [-117.63029, 33.79317], [-117.62204, 33.79309], [-117.62172, 33.8003], [-117.63004, 33.80031], [-117.6303, 33.79318]]], [[[-117.51093, 33.59217], [-117.51051, 33.59207], [-117.51024, 33.59194], [-117.50948, 33.59166], [-117.50883, 33.59136], [-117.5082, 33.59125], [-117.50665, 33.59133], [-117.50619, 33.59124], [-117.50507, 33.59066], [-117.50393, 33.59018], [-117.50336, 33.58999], [-117.50284, 33.58996], [-117.50228, 33.59009], [-117.50178, 33.59026], [-117.50132, 33.59035], [-117.50091, 33.59046], [-117.50062, 33.59047], [-117.49973, 33.5902], [-117.49908, 33.59022], [-117.49814, 33.59048], [-117.4975, 33.59087], [-117.49714, 33.59134], [-117.49701, 33.59177], [-117.49685, 33.59208], [-117.49672, 33.59217], [-117.49587, 33.59228], [-117.49543, 33.5924], [-117.49517, 33.5925], [-117.49498, 33.59254], [-117.49469, 33.59252], [-117.49367, 33.59234], [-117.49331, 33.59225], [-117.49288, 33.5922], [-117.4924, 33.59223], [-117.49197, 33.59229], [-117.49161, 33.5924], [-117.49135, 33.59265], [-117.49093, 33.59315], [-117.49077, 33.59324], [-117.49047, 33.59325], [-117.48955, 33.59318], [-117.48904, 33.59326], [-117.48823, 33.59356], [-117.48767, 33.59379], [-117.48734, 33.59387], [-117.487, 33.59388], [-117.48655, 33.59378], [-117.48581, 33.59367], [-117.48548, 33.59366], [-117.48502, 33.59387], [-117.48465, 33.59427], [-117.48406, 33.59481], [-117.48368, 33.59498], [-117.48348, 33.59504], [-117.48327, 33.59504], [-117.48292, 33.595], [-117.48233, 33.5948], [-117.48168, 33.59462], [-117.4804, 33.59435], [-117.48, 33.59418], [-117.47963, 33.59392], [-117.479, 33.59341], [-117.47853, 33.59308], [-117.47801, 33.59282], [-117.47564, 33.59209], [-117.47505, 33.59192], [-117.47407, 33.59173], [-117.47371, 33.59174], [-117.47332, 33.59183], [-117.47308, 33.59192], [-117.47287, 33.59204], [-117.47264, 33.5921], [-117.47242, 33.59212], [-117.47209, 33.59206], [-117.47166, 33.5919], [-117.4712, 33.59169], [-117.47093, 33.59155], [-117.47049, 33.59142], [-117.47014, 33.59139], [-117.46977, 33.59145], [-117.46948, 33.59157], [-117.46914, 33.59176], [-117.46889, 33.59204], [-117.4687, 33.59252], [-117.46858, 33.59295], [-117.46848, 33.5931], [-117.46831, 33.59324], [-117.46813, 33.59331], [-117.46798, 33.59333], [-117.46775, 33.59332], [-117.46752, 33.5933], [-117.46689, 33.59328], [-117.46598, 33.59317], [-117.46559, 33.59328], [-117.46498, 33.59385], [-117.46464, 33.5942], [-117.46444, 33.5945], [-117.46424, 33.59522], [-117.46423, 33.59584], [-117.46423, 33.59619], [-117.46417, 33.59653], [-117.46406, 33.59678], [-117.46397, 33.5969], [-117.46373, 33.59701], [-117.4636, 33.59703], [-117.46347, 33.59703], [-117.46329, 33.597], [-117.46299, 33.59689], [-117.46253, 33.59677], [-117.462, 33.59667], [-117.4614, 33.59695], [-117.49872, 33.54893], [-117.51031, 33.54881], [-117.51053, 33.56363], [-117.51093, 33.59217]]], [[[-117.62299, 33.79456], [-117.62281, 33.79465], [-117.6227, 33.79447], [-117.6229, 33.7944], [-117.62299, 33.79456]]], [[[-117.67336, 33.8596], [-117.66248, 33.85958], [-117.66197, 33.85902], [-117.65724, 33.85343], [-117.65047, 33.84643], [-117.6504, 33.84478], [-117.64892, 33.84482], [-117.63952, 33.8351], [-117.64117, 33.83461], [-117.64259, 33.83477], [-117.64279, 33.83415], [-117.64342, 33.83407], [-117.64388, 33.83405], [-117.64392, 33.83358], [-117.64835, 33.83406], [-117.64836, 33.83405], [-117.64779, 33.83249], [-117.64367, 33.83065], [-117.64261, 33.83156], [-117.64241, 33.8272], [-117.64237, 33.82718], [-117.64217, 33.82284], [-117.64078, 33.81519], [-117.64923, 33.8153], [-117.66203, 33.81542], [-117.66204, 33.80819], [-117.66207, 33.80469], [-117.66205, 33.8028], [-117.669, 33.80277], [-117.67006, 33.81655], [-117.66204, 33.81652], [-117.662, 33.8347], [-117.66635, 33.83472], [-117.66635, 33.83835], [-117.67078, 33.83835], [-117.67076, 33.84196], [-117.67201, 33.84198], [-117.67336, 33.8596]], [[-117.64739, 33.83573], [-117.65004, 33.83567], [-117.64997, 33.83431], [-117.6472, 33.83441], [-117.64739, 33.83573]], [[-117.65201, 33.83869], [-117.65196, 33.83576], [-117.65006, 33.83579], [-117.65007, 33.83622], [-117.65009, 33.83623], [-117.65009, 33.83647], [-117.65008, 33.83648], [-117.65017, 33.83872], [-117.65201, 33.83869]], [[-117.65587, 33.84164], [-117.65588, 33.84163], [-117.65579, 33.84012], [-117.65414, 33.84019], [-117.65413, 33.84026], [-117.65396, 33.84026], [-117.65395, 33.84019], [-117.65023, 33.84033], [-117.65036, 33.84334], [-117.65087, 33.84332], [-117.6508, 33.84177], [-117.65403, 33.8417], [-117.65587, 33.84164]]], [[[-117.64968, 33.7657], [-117.64964, 33.77442], [-117.64231, 33.77441], [-117.64221, 33.7657], [-117.64968, 33.7657]]]]} | Open Access 1 | 5619 | Cleveland National Forest | 14013 | 107 | United States Forest Service 38 | Federal 1 | Federal Agency 1 | http://www.fs.fed.us/ | US Forest Service 7 | 107 | United States Forest Service 37 | Federal 1 | Federal Agency 1 | http://www.fs.usda.gov/cleveland/ | Orange 3 | 54653.954 | Cleveland NF | 1908 | National Forest 11 | 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]);