units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
44 rows where MNG_AGENCY = 408 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME
DES_TP 3
- Local Park 42
- None 1
- None 1
MNG_AG_TYP 1
MNG_AGENCY 1
- El Dorado, County of · 44 ✖
ACCESS_TYP 1
- Open Access 44
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16293 | 16293 | 16292 | {"type": "MultiPolygon", "coordinates": [[[[-121.06093, 38.67132], [-121.06085, 38.67139], [-121.06073, 38.67131], [-121.06076, 38.67126], [-121.06083, 38.67125], [-121.06093, 38.67132]]], [[[-121.06114, 38.67115], [-121.06106, 38.67123], [-121.06097, 38.67114], [-121.06099, 38.6711], [-121.06103, 38.67107], [-121.06114, 38.67115]]]]} | Open Access 1 | 35747 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.07 | RP | 0 | Local Park 2 | 4 | |
15955 | 15955 | 15954 | {"type": "Polygon", "coordinates": [[[-121.07146, 38.66759], [-121.07144, 38.66762], [-121.07138, 38.66763], [-121.0708, 38.66758], [-121.07072, 38.66757], [-121.07068, 38.66754], [-121.07067, 38.66751], [-121.07146, 38.66759]]]} | Open Access 1 | 36172 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.089 | RP | 0 | Local Park 2 | 4 | |
16386 | 16386 | 16385 | {"type": "Polygon", "coordinates": [[[-121.05687, 38.66352], [-121.05668, 38.66357], [-121.05641, 38.6636], [-121.05543, 38.66361], [-121.05519, 38.66358], [-121.05513, 38.66355], [-121.05687, 38.66352]]]} | Open Access 1 | 35695 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.233 | RP | 0 | Local Park 2 | 4 | |
16407 | 16407 | 16406 | {"type": "Polygon", "coordinates": [[[-121.05152, 38.6801], [-121.05133, 38.68088], [-121.05127, 38.681], [-121.05122, 38.68104], [-121.05119, 38.68079], [-121.05135, 38.68007], [-121.05152, 38.6801]]]} | Open Access 1 | 35689 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.341 | RP | 0 | Local Park 2 | 4 | |
13452 | 13452 | 13451 | {"type": "Polygon", "coordinates": [[[-121.05734, 38.6586], [-121.05697, 38.65922], [-121.05661, 38.65869], [-121.05709, 38.65863], [-121.05734, 38.6586]]]} | Open Access 1 | 35646 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.505 | RP | 0 | Local Park 2 | 4 | |
3882 | 3882 | 3881 | {"type": "Polygon", "coordinates": [[[-121.05744, 38.6923], [-121.05686, 38.69256], [-121.05671, 38.69203], [-121.05697, 38.69203], [-121.05725, 38.69199], [-121.05729, 38.69201], [-121.05744, 38.6923]]]} | Open Access 1 | 35716 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.621 | RP | 0 | Local Park 2 | 4 | |
16387 | 16387 | 16386 | {"type": "MultiPolygon", "coordinates": [[[[-121.05229, 38.68426], [-121.0523, 38.68435], [-121.05233, 38.68444], [-121.05229, 38.68449], [-121.05222, 38.6845], [-121.05206, 38.68449], [-121.05189, 38.68444], [-121.0517, 38.68441], [-121.05154, 38.68441], [-121.05137, 38.68444], [-121.0512, 38.68449], [-121.051, 38.6846], [-121.05089, 38.68468], [-121.05072, 38.68487], [-121.05049, 38.68437], [-121.05057, 38.68434], [-121.05073, 38.68461], [-121.05078, 38.68459], [-121.05105, 38.6844], [-121.05134, 38.68431], [-121.05177, 38.68431], [-121.05201, 38.68437], [-121.05202, 38.68442], [-121.05227, 38.68445], [-121.05226, 38.68422], [-121.05229, 38.68426]]], [[[-121.0531, 38.68377], [-121.05313, 38.68416], [-121.05309, 38.68419], [-121.05298, 38.68422], [-121.05297, 38.68418], [-121.05301, 38.68417], [-121.05304, 38.68413], [-121.05296, 38.68392], [-121.05295, 38.68383], [-121.05296, 38.68375], [-121.0531, 38.68377]]], [[[-121.05327, 38.68461], [-121.05317, 38.68466], [-121.05315, 38.68457], [-121.05303, 38.68433], [-121.05311, 38.68432], [-121.05317, 38.68435], [-121.05327, 38.68461]]]]} | Open Access 1 | 35603 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.803 | RP | 0 | Local Park 2 | 4 | |
16408 | 16408 | 16407 | {"type": "Polygon", "coordinates": [[[-121.06425, 38.675], [-121.06441, 38.67501], [-121.06455, 38.67506], [-121.06463, 38.67514], [-121.06469, 38.67525], [-121.06468, 38.67535], [-121.06464, 38.67544], [-121.06442, 38.67569], [-121.0644, 38.6757], [-121.06433, 38.67569], [-121.06378, 38.67539], [-121.0638, 38.67534], [-121.06405, 38.67507], [-121.06415, 38.67502], [-121.06425, 38.675]]]} | Open Access 1 | 35693 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 0.99 | RP | 0 | Local Park 2 | 4 | |
16303 | 16303 | 16302 | {"type": "Polygon", "coordinates": [[[-121.05729, 38.65827], [-121.05645, 38.65846], [-121.05615, 38.65803], [-121.05704, 38.65778], [-121.05729, 38.65827]]]} | Open Access 1 | 35748 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.092 | RP | 0 | Local Park 2 | 4 | |
3428 | 3428 | 3427 | {"type": "Polygon", "coordinates": [[[-120.92638, 38.66545], [-120.92512, 38.66575], [-120.92479, 38.66594], [-120.92458, 38.66569], [-120.92491, 38.6655], [-120.92627, 38.66518], [-120.92638, 38.66545]]]} | Open Access 1 | 25182 | Bradford Park | 16323 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.212 | Bradford Park | 0 | Local Park 2 | 4 | |
13742 | 13742 | 13741 | {"type": "Polygon", "coordinates": [[[-121.05662, 38.69141], [-121.05642, 38.69185], [-121.05575, 38.69165], [-121.05573, 38.69161], [-121.05582, 38.69135], [-121.05583, 38.69114], [-121.05578, 38.69094], [-121.05569, 38.69078], [-121.05569, 38.69074], [-121.05633, 38.69113], [-121.05662, 38.69141]]]} | Open Access 1 | 36231 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.288 | RP | 0 | Local Park 2 | 4 | |
16402 | 16402 | 16401 | {"type": "MultiPolygon", "coordinates": [[[[-121.06643, 38.67439], [-121.06643, 38.67443], [-121.06641, 38.67444], [-121.0663, 38.67449], [-121.06621, 38.67456], [-121.06612, 38.67459], [-121.06605, 38.67458], [-121.06601, 38.67449], [-121.06643, 38.67439]]], [[[-121.06746, 38.67743], [-121.06739, 38.67745], [-121.06743, 38.67755], [-121.06724, 38.67756], [-121.0671, 38.67755], [-121.06699, 38.67752], [-121.0671, 38.67751], [-121.06739, 38.67744], [-121.06712, 38.67654], [-121.06696, 38.67596], [-121.06653, 38.67476], [-121.06614, 38.67482], [-121.06611, 38.67474], [-121.06615, 38.67469], [-121.06651, 38.67469], [-121.06655, 38.67472], [-121.06695, 38.67577], [-121.06725, 38.67679], [-121.06746, 38.67737], [-121.06746, 38.67743]]], [[[-121.06781, 38.67862], [-121.06709, 38.67864], [-121.06754, 38.67856], [-121.06755, 38.67855], [-121.06737, 38.67783], [-121.06691, 38.67767], [-121.06695, 38.67765], [-121.06698, 38.67764], [-121.06719, 38.67768], [-121.06732, 38.67768], [-121.06751, 38.67765], [-121.06756, 38.67767], [-121.0677, 38.6781], [-121.06781, 38.67862]]]]} | Open Access 1 | 35601 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.32 | RP | 0 | Local Park 2 | 4 | |
12696 | 12696 | 12695 | {"type": "Polygon", "coordinates": [[[-121.0719, 38.67814], [-121.07125, 38.67814], [-121.07105, 38.67682], [-121.06976, 38.67683], [-121.06915, 38.6752], [-121.06924, 38.67517], [-121.06929, 38.67514], [-121.06934, 38.67507], [-121.06935, 38.675], [-121.0693, 38.67491], [-121.06916, 38.67483], [-121.06914, 38.67481], [-121.06889, 38.67414], [-121.06892, 38.67408], [-121.06921, 38.67401], [-121.06925, 38.67401], [-121.06929, 38.67404], [-121.06892, 38.67413], [-121.069, 38.67433], [-121.06921, 38.67479], [-121.06933, 38.67486], [-121.0694, 38.67497], [-121.0694, 38.67506], [-121.06937, 38.67514], [-121.06926, 38.67522], [-121.06961, 38.67617], [-121.06969, 38.67644], [-121.06978, 38.67665], [-121.06983, 38.67669], [-121.06991, 38.67675], [-121.07001, 38.67677], [-121.07014, 38.67678], [-121.07018, 38.67648], [-121.07022, 38.67649], [-121.07022, 38.67677], [-121.07119, 38.67676], [-121.07122, 38.67688], [-121.0713, 38.67766], [-121.07134, 38.67786], [-121.0714, 38.67806], [-121.07178, 38.678], [-121.0718, 38.67806], [-121.0719, 38.67814]]]} | Open Access 1 | 35750 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.364 | RP | 0 | Local Park 2 | 4 | |
4941 | 4941 | 4940 | {"type": "Polygon", "coordinates": [[[-121.07045, 38.671], [-121.07044, 38.67105], [-121.07017, 38.67151], [-121.07012, 38.67153], [-121.06933, 38.67126], [-121.06923, 38.67118], [-121.0692, 38.67109], [-121.06921, 38.67095], [-121.06927, 38.67084], [-121.06939, 38.67073], [-121.06953, 38.67069], [-121.06965, 38.67071], [-121.07037, 38.67096], [-121.07045, 38.671]]]} | Open Access 1 | 36177 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 1.592 | RP | 0 | Local Park 2 | 4 | |
16394 | 16394 | 16393 | {"type": "MultiPolygon", "coordinates": [[[[-121.04972, 38.68166], [-121.04971, 38.68168], [-121.04966, 38.68175], [-121.0496, 38.68179], [-121.04942, 38.68165], [-121.04944, 38.68105], [-121.0495, 38.6813], [-121.04954, 38.68141], [-121.04972, 38.68166]]], [[[-121.05217, 38.67999], [-121.05194, 38.68108], [-121.05185, 38.68127], [-121.05167, 38.68145], [-121.05147, 38.68158], [-121.05114, 38.68171], [-121.05084, 38.68181], [-121.0505, 38.68189], [-121.05031, 38.68192], [-121.05011, 38.68193], [-121.04994, 38.6819], [-121.04976, 38.68186], [-121.04985, 38.68173], [-121.05, 38.68162], [-121.05013, 38.68188], [-121.05122, 38.68155], [-121.05138, 38.68148], [-121.05152, 38.68139], [-121.05168, 38.68122], [-121.05179, 38.68102], [-121.05208, 38.67993], [-121.05216, 38.67996], [-121.05217, 38.67999]]], [[[-121.05022, 38.68138], [-121.0502, 38.68142], [-121.05018, 38.68144], [-121.05002, 38.68149], [-121.04988, 38.68156], [-121.04982, 38.68157], [-121.04979, 38.68155], [-121.05008, 38.68143], [-121.04994, 38.6812], [-121.04991, 38.68096], [-121.0499, 38.6807], [-121.04993, 38.68061], [-121.04981, 38.68037], [-121.04996, 38.68033], [-121.04995, 38.68037], [-121.04995, 38.68043], [-121.05007, 38.68059], [-121.05008, 38.68066], [-121.05005, 38.68084], [-121.05006, 38.68097], [-121.0501, 38.6811], [-121.05022, 38.68138]]], [[[-121.05081, 38.68121], [-121.05079, 38.68125], [-121.05077, 38.68127], [-121.0504, 38.68136], [-121.05067, 38.68126], [-121.05056, 38.68102], [-121.05055, 38.68077], [-121.05062, 38.68044], [-121.05058, 38.6802], [-121.05072, 38.68015], [-121.05079, 38.68023], [-121.05081, 38.6803], [-121.05072, 38.68074], [-121.05071, 38.68089], [-121.05074, 38.68105], [-121.05081, 38.68121]]], [[[-121.05121, 38.68104], [-121.05114, 38.68112], [-121.05101, 38.68119], [-121.05095, 38.68119], [-121.05089, 38.68109], [-121.05121, 38.68104]]]]} | Open Access 1 | 35574 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 2.271 | RP | 0 | Local Park 2 | 4 | |
16410 | 16410 | 16409 | {"type": "Polygon", "coordinates": [[[-121.06053, 38.6662], [-121.0606, 38.66632], [-121.06062, 38.66644], [-121.06057, 38.66658], [-121.06045, 38.66669], [-121.06031, 38.66674], [-121.05907, 38.66704], [-121.05904, 38.66704], [-121.05901, 38.667], [-121.05878, 38.66643], [-121.0588, 38.66639], [-121.05883, 38.66638], [-121.06005, 38.66608], [-121.06017, 38.66607], [-121.06028, 38.66608], [-121.06046, 38.66615], [-121.06053, 38.6662]]]} | Open Access 1 | 35707 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 2.773 | RP | 0 | Local Park 2 | 4 | |
16399 | 16399 | 16398 | {"type": "Polygon", "coordinates": [[[-121.05814, 38.64186], [-121.05811, 38.64293], [-121.05665, 38.64295], [-121.05666, 38.64188], [-121.05814, 38.64186]]]} | Open Access 1 | 35599 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 3.767 | RP | 0 | Local Park 2 | 4 | |
5001 | 5001 | 5000 | {"type": "Polygon", "coordinates": [[[-121.04869, 38.68669], [-121.04729, 38.68674], [-121.0448, 38.68651], [-121.04586, 38.68586], [-121.04702, 38.68637], [-121.04817, 38.68632], [-121.0483, 38.68644], [-121.04865, 38.68664], [-121.04869, 38.68669]]]} | Open Access 1 | 35595 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 3.777 | RP | 0 | Local Park 2 | 4 | |
16398 | 16398 | 16397 | {"type": "MultiPolygon", "coordinates": [[[[-121.04437, 38.68043], [-121.04429, 38.68054], [-121.04421, 38.68061], [-121.04411, 38.68065], [-121.044, 38.68067], [-121.04397, 38.68066], [-121.04398, 38.68056], [-121.04411, 38.68037], [-121.0439, 38.68028], [-121.0431, 38.6801], [-121.04265, 38.68004], [-121.04244, 38.68003], [-121.04235, 38.6804], [-121.04231, 38.6804], [-121.04228, 38.6804], [-121.04225, 38.68036], [-121.04223, 38.68024], [-121.04218, 38.68018], [-121.04219, 38.68014], [-121.04224, 38.68008], [-121.04227, 38.67994], [-121.0429, 38.67997], [-121.04334, 38.68004], [-121.0437, 38.68014], [-121.04411, 38.68029], [-121.04434, 38.68039], [-121.04437, 38.68043]]], [[[-121.04519, 38.68163], [-121.04506, 38.68142], [-121.04468, 38.68141], [-121.0445, 38.68141], [-121.04446, 38.6814], [-121.04427, 38.68125], [-121.04427, 38.68091], [-121.04382, 38.6809], [-121.04384, 38.68081], [-121.04386, 38.68078], [-121.0439, 38.68077], [-121.0441, 38.68077], [-121.04426, 38.68071], [-121.04437, 38.68064], [-121.04449, 38.68049], [-121.04452, 38.68047], [-121.04518, 38.68071], [-121.04519, 38.68163]]], [[[-121.04205, 38.68015], [-121.04206, 38.68019], [-121.04203, 38.68028], [-121.04203, 38.68037], [-121.042, 38.68041], [-121.04197, 38.68042], [-121.04194, 38.68042], [-121.04178, 38.68007], [-121.04144, 38.68014], [-121.04109, 38.68022], [-121.04057, 38.68042], [-121.04028, 38.68058], [-121.03996, 38.68079], [-121.03903, 38.68161], [-121.03893, 38.68174], [-121.0389, 38.68184], [-121.03889, 38.68201], [-121.03882, 38.6821], [-121.03869, 38.68215], [-121.03851, 38.68214], [-121.0384, 38.68215], [-121.03817, 38.68229], [-121.03808, 38.68229], [-121.03803, 38.68231], [-121.03798, 38.68235], [-121.03796, 38.68239], [-121.03789, 38.68239], [-121.03749, 38.68251], [-121.03742, 38.6824], [-121.03771, 38.6823], [-121.03797, 38.68219], [-121.03822, 38.68206], [-121.03844, 38.68192], [-121.03874, 38.68169], [-121.0397, 38.68081], [-121.04003, 38.68057], [-121.0404, 38.68037], [-121.04086, 38.68017], [-121.04122, 38.68007], [-121.04137, 38.68005], [-121.04147, 38.68], [-121.04193, 38.67995], [-121.04198, 38.68008], [-121.04205, 38.68015]]]]} | Open Access 1 | 35594 | Regional Park | 3446 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 4.76 | RP | 0 | Local Park 2 | 4 | |
3874 | 3874 | 3873 | {"type": "Polygon", "coordinates": [[[-121.01029, 38.67025], [-121.00859, 38.67106], [-121.00596, 38.67107], [-121.00591, 38.67096], [-121.00832, 38.67042], [-121.0086, 38.67009], [-121.00799, 38.66978], [-121.00808, 38.66966], [-121.00871, 38.66997], [-121.00918, 38.6694], [-121.01029, 38.67025]]]} | Open Access 1 | 35657 | Cameron Park-Shingle Springs 1 | 16762 | 351 | El Dorado, County of 414 | County 3 | County Agency 3 | http://www.edcgov.us/Parks/ | County 3 | 351 | El Dorado, County of 408 | County 3 | County Agency 3 | El Dorado 34 | 6.395 | Cameron Park-Shingle Springs 1 | None 331 |
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]);