units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where MNG_AGENCY = 47 and YR_EST = 1962
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, PARK_URL, COUNTY, LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10804 | 10804 | 10803 | {"type": "MultiPolygon", "coordinates": [[[[-119.02102, 38.20596], [-119.0187, 38.20593], [-119.01888, 38.21321], [-119.01658, 38.21318], [-119.01656, 38.21394], [-119.0155, 38.21345], [-119.01513, 38.21375], [-119.01475, 38.21386], [-119.01429, 38.21394], [-119.01408, 38.21401], [-119.01375, 38.21443], [-119.01346, 38.21463], [-119.0129, 38.21482], [-119.01253, 38.21491], [-119.01169, 38.21543], [-119.01113, 38.21575], [-119.01102, 38.21626], [-119.01094, 38.21676], [-119.01027, 38.21779], [-119.00921, 38.21891], [-119.00887, 38.21938], [-119.00817, 38.22067], [-119.0077, 38.22125], [-119.00738, 38.22194], [-119.00709, 38.22238], [-119.00699, 38.21995], [-119.00706, 38.21975], [-119.00705, 38.21844], [-119.00707, 38.21322], [-119.00727, 38.21298], [-119.00724, 38.21094], [-119.00631, 38.21248], [-119.00615, 38.21244], [-119.00477, 38.21466], [-119.00394, 38.21584], [-119.00384, 38.21581], [-119.00263, 38.21695], [-119.00264, 38.21697], [-119.00457, 38.21755], [-119.00285, 38.22138], [-119.00264, 38.22132], [-119.00024, 38.22428], [-118.99826, 38.22363], [-118.99864, 38.22319], [-118.99864, 38.22318], [-118.99689, 38.22228], [-118.99714, 38.22202], [-118.99714, 38.22201], [-118.99541, 38.22109], [-118.99647, 38.21992], [-118.99455, 38.21914], [-118.99745, 38.21581], [-118.99931, 38.21654], [-119.00114, 38.21273], [-118.99802, 38.21143], [-119.00021, 38.20863], [-119.00091, 38.20888], [-119.00216, 38.20643], [-119.00058, 38.2053], [-119.00304, 38.20303], [-119.00303, 38.20302], [-119.00297, 38.20301], [-119.00458, 38.19908], [-119.00631, 38.19953], [-119.00787, 38.19572], [-119.00839, 38.19581], [-119.00786, 38.19184], [-119.00987, 38.19162], [-119.00998, 38.19351], [-119.00999, 38.19352], [-119.01082, 38.19313], [-119.01135, 38.19027], [-119.01163, 38.19002], [-119.01343, 38.18999], [-119.01249, 38.19402], [-119.01115, 38.19402], [-119.01169, 38.19598], [-119.01109, 38.19623], [-119.01109, 38.19624], [-119.01207, 38.19632], [-119.01215, 38.19477], [-119.01247, 38.19478], [-119.0124, 38.19635], [-119.01297, 38.19641], [-119.01286, 38.19726], [-119.01374, 38.19735], [-119.01375, 38.19859], [-119.02085, 38.19867], [-119.02102, 38.20596]], [[-119.00401, 38.20568], [-119.00419, 38.20572], [-119.00487, 38.2038], [-119.00319, 38.2054], [-119.0032, 38.20541], [-119.00387, 38.20562], [-119.0021, 38.20934], [-119.0022, 38.20937], [-119.00401, 38.20568]], [[-119.00262, 38.21699], [-119.0026, 38.21698], [-119.00236, 38.21723], [-119.00255, 38.2173], [-119.00262, 38.21699]], [[-119.01181, 38.20815], [-119.01161, 38.20198], [-119.01115, 38.20198], [-119.01066, 38.20427], [-119.00916, 38.20349], [-119.00738, 38.20654], [-119.00711, 38.20642], [-119.00886, 38.20341], [-119.00885, 38.20333], [-119.00884, 38.20332], [-119.00775, 38.20516], [-119.00743, 38.20503], [-119.00753, 38.20482], [-119.00722, 38.20469], [-119.00791, 38.20357], [-119.00744, 38.20339], [-119.0065, 38.20484], [-119.00753, 38.20521], [-119.00684, 38.20645], [-119.0052, 38.20589], [-119.00462, 38.20752], [-119.00464, 38.20753], [-119.00579, 38.20617], [-119.00605, 38.20635], [-119.00588, 38.20658], [-119.00588, 38.2066], [-119.00696, 38.20699], [-119.00579, 38.20895], [-119.00674, 38.20945], [-119.00661, 38.20972], [-119.00722, 38.20998], [-119.00723, 38.20997], [-119.00722, 38.20942], [-119.00931, 38.20944], [-119.00942, 38.20948], [-119.01054, 38.20949], [-119.01056, 38.20947], [-119.01055, 38.20946], [-119.0114, 38.20947], [-119.0115, 38.20951], [-119.01169, 38.20951], [-119.01172, 38.20947], [-119.01184, 38.20947], [-119.01181, 38.20815]], [[-119.00563, 38.21244], [-119.00593, 38.21193], [-119.00562, 38.21179], [-119.00495, 38.21329], [-119.0051, 38.21332], [-119.00563, 38.21244]], [[-119.00642, 38.21121], [-119.00634, 38.21082], [-119.00612, 38.21074], [-119.00573, 38.21156], [-119.00642, 38.21121]]], [[[-118.99833, 38.2125], [-118.99645, 38.2154], [-118.99712, 38.21569], [-118.99687, 38.21621], [-118.99504, 38.21567], [-118.99683, 38.21204], [-118.99833, 38.2125]]], [[[-119.01658, 38.21681], [-119.01657, 38.21683], [-119.01201, 38.21676], [-119.01196, 38.21697], [-119.012, 38.2197], [-119.01198, 38.22471], [-119.00709, 38.22472], [-119.00709, 38.22287], [-119.00761, 38.22211], [-119.0078, 38.22169], [-119.00893, 38.21984], [-119.00927, 38.21933], [-119.01062, 38.21774], [-119.01107, 38.21714], [-119.01129, 38.2167], [-119.0114, 38.21599], [-119.01149, 38.21581], [-119.01196, 38.21558], [-119.01246, 38.21522], [-119.01302, 38.21503], [-119.0136, 38.21485], [-119.01398, 38.2146], [-119.01438, 38.21411], [-119.015, 38.21403], [-119.01543, 38.21385], [-119.01572, 38.21399], [-119.01642, 38.21426], [-119.01658, 38.21681]]], [[[-119.01143, 38.20523], [-119.0091, 38.20893], [-119.00879, 38.20877], [-119.00909, 38.20828], [-119.00848, 38.208], [-119.0108, 38.20431], [-119.01143, 38.20458], [-119.01111, 38.20508], [-119.01143, 38.20523]]]]} | Open Access 1 | 20459 | Bodie State Historic Park | 1442 | 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=509 | Mono 32 | 984.405 | Bodie SHP | 1962 | State Historic or Cultural Area 132 | 4 |
16484 | 16484 | 16483 | {"type": "MultiPolygon", "coordinates": [[[[-119.01057, 38.20947], [-119.01055, 38.20949], [-119.00942, 38.20948], [-119.00928, 38.20943], [-119.00946, 38.20913], [-119.01015, 38.20939], [-119.01026, 38.20928], [-119.01057, 38.20947]]], [[[-119.01178, 38.20939], [-119.01169, 38.20951], [-119.0115, 38.20951], [-119.01103, 38.20932], [-119.01116, 38.20913], [-119.01178, 38.20939]]], [[[-119.01184, 38.2092], [-119.01121, 38.20895], [-119.01181, 38.20814], [-119.01183, 38.20889], [-119.01184, 38.2092]]], [[[-119.01512, 38.22152], [-119.0145, 38.22283], [-119.01199, 38.2221], [-119.012, 38.2197], [-119.01512, 38.22152]]]]} | Open Access 1 | 20763 | Bodie State Historic Park | 1442 | 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 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=509 | Mono 32 | 15.241 | Bodie SHP | 1962 | State Historic or Cultural Area 132 | 4 |
16509 | 16509 | 16508 | {"type": "Polygon", "coordinates": [[[-120.64909, 38.42104], [-120.64907, 38.42195], [-120.64676, 38.42199], [-120.64671, 38.42471], [-120.64681, 38.42831], [-120.64223, 38.42849], [-120.63446, 38.42851], [-120.63451, 38.42737], [-120.6362, 38.42683], [-120.63659, 38.42675], [-120.63708, 38.42658], [-120.63793, 38.42617], [-120.63841, 38.42602], [-120.6386, 38.4259], [-120.63929, 38.42559], [-120.63982, 38.42532], [-120.64025, 38.42502], [-120.64043, 38.42485], [-120.64127, 38.4242], [-120.64157, 38.42391], [-120.64167, 38.42379], [-120.64219, 38.4228], [-120.64234, 38.42244], [-120.64239, 38.4222], [-120.64249, 38.42187], [-120.64257, 38.42169], [-120.64272, 38.42125], [-120.64676, 38.42119], [-120.64677, 38.42108], [-120.64909, 38.42104]]]} | Open Access 1 | 20488 | Indian Grinding Rock State Historic Park | 1576 | 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=553 | Amador 52 | 132.408 | Indian Grinding Rock SHP | 1962 | State Historic or Cultural Area 132 | 4 |
16573 | 16573 | 16572 | {"type": "Polygon", "coordinates": [[[-121.6988, 36.17511], [-121.69835, 36.17552], [-121.69823, 36.17692], [-121.69782, 36.17702], [-121.69701, 36.17723], [-121.69664, 36.17726], [-121.69616, 36.17718], [-121.69564, 36.17701], [-121.69541, 36.17699], [-121.69411, 36.17711], [-121.69437, 36.1779], [-121.69286, 36.17957], [-121.6927, 36.17933], [-121.69259, 36.17935], [-121.69241, 36.17945], [-121.69222, 36.17952], [-121.6917, 36.1798], [-121.6917, 36.1799], [-121.69196, 36.17996], [-121.69179, 36.18013], [-121.69181, 36.18037], [-121.69173, 36.18083], [-121.69034, 36.18081], [-121.69017, 36.181], [-121.68987, 36.18115], [-121.68967, 36.1813], [-121.68951, 36.18157], [-121.68934, 36.18209], [-121.68927, 36.18219], [-121.68842, 36.18276], [-121.68599, 36.18357], [-121.68483, 36.18427], [-121.68395, 36.18444], [-121.68309, 36.18454], [-121.68206, 36.18498], [-121.68174, 36.18485], [-121.68091, 36.1846], [-121.67985, 36.18421], [-121.67925, 36.18417], [-121.67891, 36.1842], [-121.67875, 36.18441], [-121.67847, 36.18482], [-121.67836, 36.18514], [-121.67327, 36.18507], [-121.67318, 36.19252], [-121.66876, 36.19246], [-121.66879, 36.185], [-121.6688, 36.17412], [-121.66445, 36.17402], [-121.66434, 36.1813], [-121.65557, 36.18111], [-121.65563, 36.17748], [-121.65998, 36.17756], [-121.66009, 36.17027], [-121.65135, 36.17001], [-121.6508, 36.15575], [-121.65083, 36.1522], [-121.64187, 36.15204], [-121.64191, 36.14842], [-121.64638, 36.14849], [-121.6464, 36.14758], [-121.65386, 36.14763], [-121.65526, 36.14864], [-121.65961, 36.14871], [-121.65964, 36.14688], [-121.65993, 36.14689], [-121.66003, 36.14692], [-121.66038, 36.14713], [-121.66059, 36.14723], [-121.66078, 36.14737], [-121.66085, 36.14745], [-121.66095, 36.14748], [-121.6611, 36.14763], [-121.66114, 36.14771], [-121.66124, 36.14777], [-121.66134, 36.1478], [-121.66151, 36.14794], [-121.66162, 36.14801], [-121.66168, 36.14809], [-121.66174, 36.14824], [-121.66182, 36.14832], [-121.66191, 36.14831], [-121.66191, 36.14824], [-121.66202, 36.14824], [-121.66221, 36.14835], [-121.6623, 36.14838], [-121.66249, 36.14836], [-121.66258, 36.14839], [-121.66277, 36.14862], [-121.66278, 36.14877], [-121.65962, 36.14872], [-121.65958, 36.15234], [-121.65521, 36.15227], [-121.65517, 36.15589], [-121.66391, 36.15604], [-121.66393, 36.15422], [-121.66854, 36.1543], [-121.66846, 36.1544], [-121.66847, 36.15455], [-121.66851, 36.15462], [-121.66858, 36.1547], [-121.66868, 36.15476], [-121.66877, 36.15487], [-121.66886, 36.15493], [-121.66893, 36.155], [-121.66904, 36.15505], [-121.66913, 36.15504], [-121.66933, 36.15501], [-121.66943, 36.15504], [-121.66954, 36.1551], [-121.66974, 36.15516], [-121.66981, 36.15524], [-121.66981, 36.15531], [-121.66997, 36.15555], [-121.67016, 36.15566], [-121.67027, 36.15567], [-121.67046, 36.15558], [-121.67068, 36.15555], [-121.67077, 36.15558], [-121.6708, 36.15566], [-121.67086, 36.15573], [-121.67105, 36.15576], [-121.67123, 36.15575], [-121.67133, 36.15579], [-121.67151, 36.15602], [-121.67168, 36.15618], [-121.67188, 36.15625], [-121.67209, 36.15637], [-121.67214, 36.15645], [-121.67215, 36.15677], [-121.67218, 36.15684], [-121.67224, 36.15692], [-121.6723, 36.15707], [-121.67238, 36.15714], [-121.67249, 36.15715], [-121.67259, 36.1571], [-121.67252, 36.15694], [-121.67252, 36.15678], [-121.67261, 36.15671], [-121.67265, 36.15679], [-121.67264, 36.15687], [-121.67283, 36.15697], [-121.67292, 36.15698], [-121.67301, 36.15694], [-121.67309, 36.15687], [-121.67319, 36.15695], [-121.67323, 36.15703], [-121.67325, 36.1571], [-121.67323, 36.15718], [-121.67304, 36.15725], [-121.67297, 36.15734], [-121.67301, 36.15741], [-121.6731, 36.15744], [-121.67319, 36.15744], [-121.6733, 36.15741], [-121.67339, 36.15737], [-121.6735, 36.15738], [-121.6736, 36.15743], [-121.67368, 36.1575], [-121.6737, 36.15773], [-121.67361, 36.1578], [-121.6733, 36.15788], [-121.67321, 36.15788], [-121.67301, 36.15783], [-121.67292, 36.15776], [-121.67285, 36.15769], [-121.67276, 36.15754], [-121.67274, 36.15746], [-121.67268, 36.15739], [-121.67259, 36.15739], [-121.67239, 36.15746], [-121.67228, 36.15761], [-121.67226, 36.15778], [-121.67218, 36.15797], [-121.67197, 36.15804], [-121.67187, 36.15804], [-121.67169, 36.15818], [-121.67149, 36.15827], [-121.67144, 36.15835], [-121.67145, 36.15851], [-121.67148, 36.15858], [-121.67157, 36.15865], [-121.67166, 36.15873], [-121.6717, 36.15889], [-121.67177, 36.15897], [-121.67202, 36.15909], [-121.67235, 36.15912], [-121.67244, 36.15919], [-121.67249, 36.15928], [-121.6726, 36.15934], [-121.67321, 36.15935], [-121.6733, 36.1593], [-121.67339, 36.15921], [-121.67343, 36.15914], [-121.67342, 36.15899], [-121.67353, 36.15897], [-121.67364, 36.15902], [-121.67368, 36.1591], [-121.67369, 36.15926], [-121.67376, 36.15941], [-121.67377, 36.15949], [-121.67387, 36.15952], [-121.67398, 36.15959], [-121.67393, 36.15967], [-121.67394, 36.15975], [-121.67403, 36.15983], [-121.67412, 36.15982], [-121.67426, 36.15966], [-121.67435, 36.15963], [-121.67457, 36.15967], [-121.67465, 36.15974], [-121.6747, 36.15989], [-121.67467, 36.16017], [-121.6746, 36.16025], [-121.67441, 36.16034], [-121.67432, 36.16041], [-121.67431, 36.16056], [-121.67452, 36.16068], [-121.67468, 36.16082], [-121.67473, 36.1609], [-121.67474, 36.16105], [-121.67483, 36.16112], [-121.67487, 36.1612], [-121.67487, 36.16129], [-121.67502, 36.16143], [-121.6751, 36.16166], [-121.67512, 36.16183], [-121.6752, 36.16191], [-121.67539, 36.16199], [-121.67551, 36.162], [-121.67554, 36.16192], [-121.67563, 36.16192], [-121.67567, 36.162], [-121.67571, 36.16216], [-121.67576, 36.16223], [-121.67577, 36.1624], [-121.67591, 36.1625], [-121.676, 36.16255], [-121.67606, 36.16263], [-121.67615, 36.1627], [-121.67625, 36.16275], [-121.67655, 36.16286], [-121.67666, 36.16293], [-121.6769, 36.16301], [-121.67702, 36.16317], [-121.67742, 36.1633], [-121.67753, 36.16339], [-121.67766, 36.16339], [-121.67766, 36.16408], [-121.67757, 36.16415], [-121.67756, 36.16516], [-121.6776, 36.1661], [-121.6776, 36.16731], [-121.67764, 36.16784], [-121.67764, 36.16891], [-121.67766, 36.16892], [-121.67792, 36.16883], [-121.67829, 36.16924], [-121.67862, 36.16932], [-121.67893, 36.16936], [-121.67947, 36.16945], [-121.6795, 36.1702], [-121.68002, 36.17003], [-121.68051, 36.17003], [-121.68087, 36.16995], [-121.68194, 36.16993], [-121.68213, 36.17005], [-121.68217, 36.17082], [-121.68248, 36.17079], [-121.68286, 36.17065], [-121.68314, 36.17052], [-121.68327, 36.17032], [-121.6835, 36.16975], [-121.6836, 36.16926], [-121.6837, 36.16893], [-121.68371, 36.16857], [-121.68392, 36.16795], [-121.68402, 36.16777], [-121.68403, 36.16781], [-121.68425, 36.16793], [-121.68456, 36.16781], [-121.68495, 36.16753], [-121.68498, 36.16753], [-121.68589, 36.16791], [-121.68589, 36.16792], [-121.68627, 36.16797], [-121.68655, 36.16822], [-121.68686, 36.16832], [-121.68696, 36.16832], [-121.68723, 36.16853], [-121.68745, 36.16859], [-121.68756, 36.16866], [-121.68764, 36.16875], [-121.68766, 36.1689], [-121.68775, 36.16906], [-121.68786, 36.16916], [-121.68798, 36.1694], [-121.68807, 36.16949], [-121.68818, 36.16956], [-121.68841, 36.16965], [-121.68851, 36.16967], [-121.68861, 36.16967], [-121.68885, 36.16972], [-121.68896, 36.16979], [-121.6891, 36.16995], [-121.68919, 36.17003], [-121.68928, 36.17008], [-121.6893, 36.17017], [-121.6894, 36.17031], [-121.68951, 36.17041], [-121.68954, 36.17051], [-121.68958, 36.17058], [-121.6897, 36.17064], [-121.68993, 36.17071], [-121.69044, 36.1707], [-121.69067, 36.17074], [-121.69088, 36.17087], [-121.69095, 36.17094], [-121.69115, 36.17107], [-121.69149, 36.17121], [-121.69153, 36.17129], [-121.69153, 36.17168], [-121.69157, 36.17175], [-121.69167, 36.17184], [-121.69189, 36.17192], [-121.69208, 36.17193], [-121.69214, 36.17185], [-121.69223, 36.17179], [-121.69255, 36.17172], [-121.69261, 36.17164], [-121.69264, 36.17149], [-121.69269, 36.17141], [-121.69278, 36.17138], [-121.69289, 36.17136], [-121.69307, 36.17136], [-121.69317, 36.17139], [-121.69324, 36.17147], [-121.69333, 36.17152], [-121.69343, 36.17159], [-121.69344, 36.17182], [-121.69361, 36.17206], [-121.69364, 36.17229], [-121.69378, 36.17246], [-121.69372, 36.17255], [-121.69372, 36.17263], [-121.6938, 36.17272], [-121.69399, 36.17278], [-121.69409, 36.17283], [-121.69412, 36.17292], [-121.69396, 36.17308], [-121.69386, 36.17314], [-121.69375, 36.17317], [-121.69374, 36.17324], [-121.69375, 36.17349], [-121.69386, 36.17358], [-121.69405, 36.17358], [-121.69423, 36.17347], [-121.69433, 36.17348], [-121.69433, 36.17356], [-121.69429, 36.17364], [-121.69433, 36.17371], [-121.69443, 36.17374], [-121.69471, 36.17375], [-121.69478, 36.17368], [-121.69487, 36.17364], [-121.69496, 36.17365], [-121.695, 36.17372], [-121.69495, 36.1738], [-121.69486, 36.17383], [-121.69477, 36.17388], [-121.69479, 36.17395], [-121.69485, 36.17402], [-121.69496, 36.1741], [-121.69499, 36.17417], [-121.69506, 36.17425], [-121.69508, 36.1745], [-121.69506, 36.17459], [-121.69501, 36.17467], [-121.69505, 36.17474], [-121.69536, 36.17464], [-121.69545, 36.17459], [-121.69564, 36.17456], [-121.69583, 36.17486], [-121.69587, 36.17508], [-121.696, 36.17527], [-121.69611, 36.17528], [-121.69621, 36.17528], [-121.6963, 36.17522], [-121.69637, 36.17514], [-121.69638, 36.17506], [-121.69637, 36.17497], [-121.69633, 36.17483], [-121.69612, 36.17451], [-121.69606, 36.17429], [-121.69605, 36.17412], [-121.69607, 36.17405], [-121.69617, 36.174], [-121.69646, 36.17394], [-121.69657, 36.17379], [-121.69667, 36.17373], [-121.69679, 36.17372], [-121.69688, 36.17379], [-121.69687, 36.17387], [-121.69698, 36.17393], [-121.69728, 36.17391], [-121.69737, 36.17398], [-121.69743, 36.17405], [-121.69758, 36.1742], [-121.6976, 36.17437], [-121.69756, 36.17446], [-121.69749, 36.17454], [-121.6975, 36.17469], [-121.69739, 36.17484], [-121.69735, 36.17492], [-121.69726, 36.175], [-121.69722, 36.17508], [-121.69721, 36.17516], [-121.69726, 36.17524], [-121.69735, 36.17529], [-121.69745, 36.17532], [-121.69765, 36.17531], [-121.69774, 36.17529], [-121.69783, 36.17524], [-121.69792, 36.17522], [-121.69802, 36.17522], [-121.69812, 36.17517], [-121.69822, 36.17511], [-121.69836, 36.17495], [-121.69857, 36.1749], [-121.69868, 36.1749], [-121.69877, 36.17496], [-121.6988, 36.17511]]]} | Open Access 1 | 17089 | Julia Pfeiffer Burns State Park | 1585 | 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=578 | Monterey 14 | 2278.738 | Julia Pfeiffer Burns SP | 1962 | State Park 15 | 4 |
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]);