superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
64 rows where MNG_AGENCY = 26 and MNG_AG_TYP = 2 sorted by MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5120 | 5120 | 5119 | {"type": "MultiPolygon", "coordinates": [[[[-119.75025, 34.42221], [-119.75027, 34.4225], [-119.75032, 34.42268], [-119.75041, 34.42282], [-119.75062, 34.42303], [-119.75066, 34.42315], [-119.75069, 34.42406], [-119.75073, 34.42421], [-119.75088, 34.42452], [-119.75092, 34.42468], [-119.7509, 34.42564], [-119.75085, 34.42585], [-119.75076, 34.42605], [-119.75063, 34.42623], [-119.75045, 34.42643], [-119.75037, 34.42656], [-119.75025, 34.42691], [-119.74963, 34.42691], [-119.74999, 34.42633], [-119.75011, 34.42602], [-119.75014, 34.42574], [-119.74994, 34.42554], [-119.74988, 34.4254], [-119.75025, 34.4249], [-119.75025, 34.42476], [-119.74978, 34.42439], [-119.74961, 34.4242], [-119.74951, 34.42403], [-119.74953, 34.42385], [-119.74967, 34.4237], [-119.74975, 34.4235], [-119.74983, 34.42345], [-119.74972, 34.42319], [-119.74956, 34.4231], [-119.74952, 34.42316], [-119.74937, 34.42303], [-119.74915, 34.42294], [-119.74872, 34.42269], [-119.74873, 34.42249], [-119.74887, 34.42206], [-119.74877, 34.4219], [-119.7485, 34.42179], [-119.7481, 34.42156], [-119.74832, 34.42139], [-119.74919, 34.42152], [-119.74931, 34.42163], [-119.7494, 34.42186], [-119.74927, 34.42192], [-119.74925, 34.42209], [-119.7493, 34.42223], [-119.74937, 34.42226], [-119.75025, 34.42221]]], [[[-119.75135, 34.42914], [-119.75061, 34.42944], [-119.75042, 34.43027], [-119.75038, 34.4311], [-119.74987, 34.43189], [-119.74995, 34.43212], [-119.75014, 34.43251], [-119.74972, 34.43262], [-119.74914, 34.43315], [-119.74924, 34.43345], [-119.74892, 34.43323], [-119.74894, 34.43305], [-119.74912, 34.43286], [-119.74925, 34.43281], [-119.7494, 34.43262], [-119.74942, 34.43254], [-119.74969, 34.43239], [-119.74984, 34.43239], [-119.74993, 34.43231], [-119.74988, 34.4322], [-119.74991, 34.43212], [-119.74982, 34.43203], [-119.74969, 34.43174], [-119.74978, 34.43157], [-119.74969, 34.4315], [-119.74979, 34.43142], [-119.74981, 34.43128], [-119.74984, 34.43122], [-119.74991, 34.43114], [-119.75012, 34.43099], [-119.75018, 34.4309], [-119.75011, 34.4308], [-119.75019, 34.43059], [-119.7502, 34.43043], [-119.75003, 34.4301], [-119.75005, 34.42985], [-119.75051, 34.42936], [-119.751, 34.42907], [-119.75104, 34.42877], [-119.75091, 34.42841], [-119.75064, 34.42814], [-119.75025, 34.42817], [-119.75007, 34.42806], [-119.74999, 34.42785], [-119.74997, 34.42758], [-119.75001, 34.42733], [-119.75012, 34.4271], [-119.75043, 34.42765], [-119.75061, 34.42793], [-119.75133, 34.42859], [-119.75135, 34.42914]]]]} | Open Access 1 | Hidden Valley Park | 19919 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 17.716 | Hidden Valley Park | ||
5147 | 5147 | 5146 | {"type": "Polygon", "coordinates": [[[-119.72525, 34.4118], [-119.72524, 34.41189], [-119.72517, 34.41196], [-119.725, 34.41202], [-119.72497, 34.41202], [-119.72474, 34.41246], [-119.72467, 34.4125], [-119.72461, 34.41249], [-119.72448, 34.41204], [-119.72439, 34.41189], [-119.72486, 34.41146], [-119.72523, 34.41174], [-119.72525, 34.4118]]]} | Open Access 1 | Hilda Ray Park | 19957 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.124 | Hilda Ray Park | ||
5235 | 5235 | 5234 | {"type": "Polygon", "coordinates": [[[-119.71793, 34.40835], [-119.71759, 34.40933], [-119.7174, 34.40926], [-119.71644, 34.40915], [-119.71625, 34.40916], [-119.71528, 34.40937], [-119.71521, 34.40916], [-119.71496, 34.40912], [-119.71278, 34.40837], [-119.71396, 34.40727], [-119.71483, 34.40644], [-119.71793, 34.40835]]]} | Open Access 1 | Honda Valley Park | 20065 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 20.686 | Honda Valley Park | ||
5804 | 5804 | 5803 | {"type": "Polygon", "coordinates": [[[-119.71792, 34.40505], [-119.71754, 34.40566], [-119.71711, 34.40547], [-119.71658, 34.40556], [-119.71598, 34.40633], [-119.71585, 34.40616], [-119.71579, 34.4061], [-119.71571, 34.40607], [-119.7156, 34.40605], [-119.71379, 34.40496], [-119.71548, 34.40414], [-119.71691, 34.40345], [-119.71722, 34.40332], [-119.71755, 34.40488], [-119.71792, 34.40505]]]} | Open Access 1 | La Coronilla Park | 20750 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 14.796 | La Coronilla Park | ||
5824 | 5824 | 5823 | {"type": "Polygon", "coordinates": [[[-119.72462, 34.39825], [-119.72456, 34.39841], [-119.72452, 34.39858], [-119.72232, 34.39894], [-119.72233, 34.3985], [-119.72231, 34.39835], [-119.72226, 34.39817], [-119.72215, 34.3979], [-119.72205, 34.39774], [-119.72187, 34.39752], [-119.72174, 34.39738], [-119.72176, 34.39724], [-119.72165, 34.39716], [-119.71991, 34.39689], [-119.71978, 34.39623], [-119.7212, 34.39605], [-119.72169, 34.39596], [-119.72233, 34.39574], [-119.72282, 34.39565], [-119.72329, 34.39562], [-119.72326, 34.39578], [-119.72331, 34.39588], [-119.72348, 34.39599], [-119.72326, 34.39624], [-119.72326, 34.3964], [-119.72314, 34.39669], [-119.72343, 34.39699], [-119.7235, 34.39716], [-119.72371, 34.39743], [-119.72394, 34.39757], [-119.72399, 34.39772], [-119.72424, 34.39786], [-119.72448, 34.39785], [-119.72448, 34.39806], [-119.72462, 34.39825]]]} | Open Access 1 | La Mesa Park | 20773 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 18.703 | La Mesa Park | ||
6069 | 6069 | 6068 | {"type": "Polygon", "coordinates": [[[-119.70263, 34.39947], [-119.70218, 34.40017], [-119.70065, 34.40169], [-119.69974, 34.40255], [-119.69913, 34.40289], [-119.69882, 34.40299], [-119.69812, 34.4031], [-119.69762, 34.4031], [-119.69708, 34.40307], [-119.69699, 34.40296], [-119.69685, 34.40286], [-119.69669, 34.4028], [-119.69653, 34.40279], [-119.69499, 34.40303], [-119.69444, 34.40258], [-119.69516, 34.4027], [-119.69996, 34.40125], [-119.70201, 34.4001], [-119.70247, 34.39937], [-119.70263, 34.39947]]]} | Open Access 1 | Leadbetter Beach | 21125 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 15.844 | Leadbetter Beach | ||
6425 | 6425 | 6424 | {"type": "Polygon", "coordinates": [[[-119.75676, 34.44653], [-119.75671, 34.44688], [-119.75658, 34.447], [-119.75605, 34.44728], [-119.75605, 34.447], [-119.75603, 34.44678], [-119.75606, 34.44662], [-119.75612, 34.4465], [-119.75644, 34.44655], [-119.75676, 34.44653]]]} | Open Access 1 | Los Robles Park | 21534 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.976 | Los Robles Park | ||
6499 | 6499 | 6498 | {"type": "Polygon", "coordinates": [[[-119.73402, 34.43961], [-119.73313, 34.43967], [-119.73279, 34.43975], [-119.73263, 34.43981], [-119.73234, 34.43995], [-119.73188, 34.44027], [-119.73082, 34.44026], [-119.7306, 34.44024], [-119.73006, 34.44013], [-119.73269, 34.43879], [-119.73244, 34.43842], [-119.73358, 34.43784], [-119.73362, 34.43784], [-119.73362, 34.43833], [-119.73392, 34.43888], [-119.73402, 34.43913], [-119.73402, 34.43961]]]} | Open Access 1 | Mackenzie Park | 21636 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 9.596 | Mackenzie Park | ||
7048 | 7048 | 7047 | {"type": "MultiPolygon", "coordinates": [[[[-119.71235, 34.43717], [-119.71239, 34.43727], [-119.71242, 34.43741], [-119.71236, 34.43784], [-119.71238, 34.43805], [-119.71242, 34.43818], [-119.71249, 34.4383], [-119.71277, 34.43863], [-119.71287, 34.43882], [-119.7129, 34.43896], [-119.71292, 34.4391], [-119.71289, 34.43922], [-119.71284, 34.43934], [-119.71275, 34.43944], [-119.71264, 34.43952], [-119.71251, 34.43957], [-119.71237, 34.43958], [-119.7122, 34.43955], [-119.71208, 34.43948], [-119.7116, 34.43929], [-119.71145, 34.43926], [-119.71108, 34.43926], [-119.71107, 34.43818], [-119.71119, 34.43793], [-119.71137, 34.4376], [-119.71141, 34.43755], [-119.71152, 34.4375], [-119.71158, 34.43745], [-119.71161, 34.43737], [-119.71161, 34.43726], [-119.71163, 34.4372], [-119.71188, 34.43689], [-119.71194, 34.43689], [-119.71235, 34.43717]]], [[[-119.71303, 34.43937], [-119.71304, 34.43947], [-119.71301, 34.43961], [-119.71273, 34.44012], [-119.71272, 34.44021], [-119.71228, 34.44022], [-119.71217, 34.44026], [-119.71191, 34.44045], [-119.71188, 34.44029], [-119.71184, 34.4402], [-119.71172, 34.44003], [-119.71127, 34.43969], [-119.71117, 34.43965], [-119.71108, 34.43965], [-119.71108, 34.4394], [-119.7114, 34.43941], [-119.71158, 34.43945], [-119.7122, 34.43971], [-119.71233, 34.43973], [-119.71252, 34.43973], [-119.7127, 34.43967], [-119.71281, 34.4396], [-119.71296, 34.43948], [-119.71303, 34.43937]]]]} | Open Access 1 | Mission Park | 22305 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 10.436 | Mission Park | ||
7141 | 7141 | 7140 | {"type": "Polygon", "coordinates": [[[-119.66557, 34.42181], [-119.6652, 34.42296], [-119.66446, 34.42284], [-119.66145, 34.42302], [-119.66143, 34.42284], [-119.66412, 34.42212], [-119.66557, 34.42181]]]} | Unknown Access 4 | Montecity Country Club | 22411 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 6.027 | Montecity Country Club | ||
7584 | 7584 | 7583 | {"type": "MultiPolygon", "coordinates": [[[[-119.72877, 34.4307], [-119.72837, 34.43096], [-119.72829, 34.43092], [-119.72818, 34.43091], [-119.72808, 34.43094], [-119.72799, 34.431], [-119.72781, 34.43118], [-119.72776, 34.43126], [-119.72774, 34.43137], [-119.72774, 34.43162], [-119.7277, 34.43173], [-119.72764, 34.4318], [-119.72727, 34.43209], [-119.72714, 34.43214], [-119.72701, 34.43216], [-119.72653, 34.43211], [-119.72666, 34.43129], [-119.7267, 34.43114], [-119.72674, 34.43099], [-119.72713, 34.42993], [-119.72715, 34.42981], [-119.72715, 34.42968], [-119.72712, 34.42956], [-119.72708, 34.42944], [-119.72697, 34.42928], [-119.72687, 34.42918], [-119.72623, 34.42871], [-119.72773, 34.42732], [-119.72773, 34.42735], [-119.7279, 34.42748], [-119.7282, 34.42791], [-119.72826, 34.42846], [-119.72814, 34.42903], [-119.72803, 34.42974], [-119.72832, 34.43009], [-119.72859, 34.43049], [-119.72877, 34.4307]]], [[[-119.72833, 34.43216], [-119.72769, 34.43231], [-119.72715, 34.43226], [-119.7273, 34.43224], [-119.72744, 34.43218], [-119.72784, 34.43187], [-119.72789, 34.4318], [-119.72792, 34.43172], [-119.72792, 34.43143], [-119.72795, 34.43132], [-119.72815, 34.43109], [-119.72822, 34.43105], [-119.72828, 34.43104], [-119.72825, 34.43108], [-119.72813, 34.43138], [-119.72824, 34.43162], [-119.72833, 34.43216]]]]} | Open Access 1 | Oak Park | 23002 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 16.202 | Oak Park | ||
7772 | 7772 | 7771 | {"type": "MultiPolygon", "coordinates": [[[[-119.70584, 34.4382], [-119.70455, 34.43838], [-119.70355, 34.43837], [-119.70346, 34.43833], [-119.70343, 34.43825], [-119.70343, 34.43822], [-119.7035, 34.43807], [-119.70359, 34.43794], [-119.70368, 34.43787], [-119.70382, 34.43784], [-119.70584, 34.4382]]], [[[-119.70624, 34.43759], [-119.70606, 34.43805], [-119.70399, 34.43771], [-119.70396, 34.43769], [-119.70395, 34.43765], [-119.70396, 34.4376], [-119.7044, 34.43724], [-119.70495, 34.43742], [-119.70575, 34.43752], [-119.70576, 34.43759], [-119.70624, 34.43759]]]]} | Open Access 1 | Orpet Park | 23223 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 4.385 | Orpet Park | ||
7774 | 7774 | 7773 | {"type": "Polygon", "coordinates": [[[-119.69114, 34.42502], [-119.69001, 34.42608], [-119.68889, 34.42526], [-119.69003, 34.42419], [-119.69114, 34.42502]]]} | Open Access 1 | Ortega Park | 23226 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 5.349 | Ortega Park | ||
7905 | 7905 | 7904 | {"type": "Polygon", "coordinates": [[[-119.69501, 34.41928], [-119.69462, 34.41964], [-119.69441, 34.41949], [-119.69436, 34.41944], [-119.69435, 34.41942], [-119.69424, 34.41934], [-119.69421, 34.41934], [-119.6935, 34.41882], [-119.69388, 34.41847], [-119.69501, 34.41928]]]} | Open Access 1 | Palza Vera Cruz | 23376 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.807 | Palza Vera Cruz | ||
7981 | 7981 | 7980 | {"type": "MultiPolygon", "coordinates": [[[[-119.68316, 34.44755], [-119.68294, 34.44767], [-119.68289, 34.44795], [-119.68272, 34.44841], [-119.68279, 34.44862], [-119.68251, 34.44952], [-119.68206, 34.44972], [-119.68188, 34.45031], [-119.67963, 34.45031], [-119.67959, 34.45386], [-119.67523, 34.45384], [-119.67524, 34.45029], [-119.67212, 34.45027], [-119.67211, 34.44665], [-119.67538, 34.44662], [-119.67537, 34.44518], [-119.67597, 34.44552], [-119.67605, 34.44574], [-119.67658, 34.44602], [-119.67736, 34.44629], [-119.67744, 34.44637], [-119.67749, 34.44654], [-119.67768, 34.44674], [-119.67789, 34.44674], [-119.67807, 34.44678], [-119.67818, 34.44682], [-119.67853, 34.447], [-119.67909, 34.44681], [-119.68033, 34.44679], [-119.68033, 34.44683], [-119.68083, 34.44701], [-119.68108, 34.44696], [-119.68152, 34.4466], [-119.6823, 34.44683], [-119.68238, 34.44693], [-119.68273, 34.44712], [-119.68298, 34.44711], [-119.68316, 34.44755]]], [[[-119.67907, 34.44669], [-119.67855, 34.44688], [-119.67824, 34.44672], [-119.67811, 34.44668], [-119.67907, 34.44669]]], [[[-119.68124, 34.44667], [-119.68101, 34.44686], [-119.68084, 34.44689], [-119.68047, 34.44675], [-119.68048, 34.44668], [-119.68124, 34.44667]]], [[[-119.6884, 34.4466], [-119.68813, 34.44677], [-119.68813, 34.44748], [-119.68822, 34.44894], [-119.68775, 34.44906], [-119.68778, 34.44945], [-119.68807, 34.44986], [-119.68802, 34.45033], [-119.68201, 34.45031], [-119.68219, 34.4498], [-119.68266, 34.44959], [-119.68293, 34.4486], [-119.68287, 34.44841], [-119.68294, 34.44822], [-119.68308, 34.44774], [-119.68333, 34.4476], [-119.6831, 34.44703], [-119.683, 34.44667], [-119.68595, 34.44665], [-119.68813, 34.44666], [-119.68833, 34.44654], [-119.6884, 34.4466]]], [[[-119.68294, 34.44699], [-119.68287, 34.44699], [-119.68257, 34.44685], [-119.68243, 34.44667], [-119.68286, 34.44667], [-119.68294, 34.44699]]]]} | Open Access 1 | Parma Park | 23468 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 187.098 | Parma Park | ||
8102 | 8102 | 8101 | {"type": "Polygon", "coordinates": [[[-119.69755, 34.409], [-119.6969, 34.40961], [-119.69661, 34.4094], [-119.69628, 34.40971], [-119.69508, 34.40884], [-119.69608, 34.40791], [-119.69755, 34.409]]]} | Open Access 1 | Pershing Park | 23618 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 5.765 | Pershing Park | ||
8232 | 8232 | 8231 | {"type": "Polygon", "coordinates": [[[-119.69855, 34.4095], [-119.69842, 34.40964], [-119.69608, 34.40792], [-119.69508, 34.40884], [-119.69458, 34.40847], [-119.69487, 34.4083], [-119.69505, 34.40813], [-119.69525, 34.40775], [-119.69509, 34.40772], [-119.69496, 34.40802], [-119.69475, 34.40822], [-119.69446, 34.40838], [-119.69407, 34.4081], [-119.69422, 34.40793], [-119.69435, 34.40773], [-119.69444, 34.4075], [-119.69448, 34.40738], [-119.69474, 34.40743], [-119.69492, 34.40763], [-119.6955, 34.40754], [-119.6957, 34.40752], [-119.69614, 34.40772], [-119.69676, 34.40788], [-119.69747, 34.40846], [-119.69826, 34.40917], [-119.6982, 34.40925], [-119.69855, 34.4095]]]} | Open Access 1 | Plaza del Mar Park | 23779 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 6.296 | Plaza del Mar Park | ||
8882 | 8882 | 8881 | {"type": "MultiPolygon", "coordinates": [[[[-119.70909, 34.44366], [-119.70909, 34.44415], [-119.70862, 34.44493], [-119.70858, 34.44547], [-119.70828, 34.44567], [-119.70822, 34.44593], [-119.70847, 34.44627], [-119.70848, 34.44648], [-119.70851, 34.44659], [-119.70826, 34.44655], [-119.70805, 34.44586], [-119.70711, 34.44467], [-119.70752, 34.44456], [-119.70909, 34.44366]]], [[[-119.71066, 34.44319], [-119.71065, 34.4436], [-119.71, 34.4436], [-119.70999, 34.44352], [-119.71046, 34.44304], [-119.71066, 34.44319]]]]} | Open Access 1 | Rocky Nook Park | 24543 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 6.003 | Rocky Nook Park | ||
9257 | 9257 | 9256 | {"type": "Polygon", "coordinates": [[[-119.73737, 34.44363], [-119.73737, 34.44367], [-119.73696, 34.44389], [-119.73671, 34.44407], [-119.73664, 34.44407], [-119.7366, 34.44401], [-119.73662, 34.44371], [-119.73659, 34.4434], [-119.73661, 34.44336], [-119.73666, 34.44335], [-119.73708, 34.44353], [-119.73734, 34.4436], [-119.73737, 34.44363]]]} | Open Access 1 | San Roque Park | 24991 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 0.767 | San Roque Park | ||
9286 | 9286 | 9285 | {"type": "Polygon", "coordinates": [[[-119.69167, 34.45419], [-119.69138, 34.45435], [-119.691, 34.45433], [-119.69056, 34.45403], [-119.69059, 34.45371], [-119.69063, 34.45361], [-119.69071, 34.45352], [-119.69083, 34.45346], [-119.6913, 34.45343], [-119.69167, 34.45419]]]} | Unknown Access 4 | Santa Barbara holding 1 | 25042 | 1317 | Santa Barbara, City of 26 | City 2 | City Agency 2 | http://www.santabarbaraca.gov/gov/depts/parksrec/default.asp | City 2 | 1.835 | Santa Barbara holding 1 |
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]);