units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
130 rows where MNG_AGENCY = 533 sorted by AGNCY_LEV
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 53
- Local Other or Unknown 43
- Local Recreation Area 8
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 110
MNG_AGENCY 1
- Roseville, City of · 110 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3664 | 3664 | 3663 | {"type": "Polygon", "coordinates": [[[-121.3465, 38.79539], [-121.3411, 38.79543], [-121.3411, 38.79542], [-121.34159, 38.79537], [-121.34265, 38.79521], [-121.34315, 38.7951], [-121.34381, 38.79492], [-121.34428, 38.79475], [-121.34485, 38.79451], [-121.34613, 38.79383], [-121.34649, 38.79424], [-121.3465, 38.79539]]]} | Open Access 1 | 29635 | Veterans Memorial Park | 27032 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 7.926 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
4094 | 4094 | 4093 | {"type": "Polygon", "coordinates": [[[-121.36163, 38.78195], [-121.36202, 38.78195], [-121.36207, 38.78197], [-121.3621, 38.78202], [-121.3621, 38.78293], [-121.36208, 38.78302], [-121.36204, 38.78311], [-121.36196, 38.78318], [-121.36186, 38.78322], [-121.36173, 38.78325], [-121.36153, 38.78324], [-121.36138, 38.78317], [-121.36128, 38.78306], [-121.36125, 38.78293], [-121.36125, 38.782], [-121.36127, 38.78196], [-121.36133, 38.78195], [-121.36163, 38.78195]]]} | Open Access 1 | 44548 | C. Doulton Burner Park | 16626 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.505 | C. Doulton Burner Park | 0 | Local Park 2 | 4 | |
4095 | 4095 | 4094 | {"type": "Polygon", "coordinates": [[[-121.37638, 38.77648], [-121.37582, 38.7765], [-121.3749, 38.77687], [-121.37462, 38.7772], [-121.37463, 38.77749], [-121.37493, 38.77792], [-121.37493, 38.7783], [-121.37526, 38.77842], [-121.37505, 38.77852], [-121.37501, 38.7786], [-121.37492, 38.77859], [-121.37481, 38.77862], [-121.3737, 38.77862], [-121.37369, 38.77609], [-121.37453, 38.77609], [-121.37638, 38.77648]]]} | Open Access 1 | 44549 | Bud Nichols Park | 16479 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 7.988 | Bud Nichols Park | 0 | Local Park 2 | 4 | |
4096 | 4096 | 4095 | {"type": "Polygon", "coordinates": [[[-121.36411, 38.77865], [-121.36211, 38.77865], [-121.36211, 38.77832], [-121.36206, 38.77773], [-121.36206, 38.77704], [-121.36204, 38.77703], [-121.36206, 38.77698], [-121.36209, 38.77695], [-121.36214, 38.77694], [-121.36326, 38.77694], [-121.36351, 38.77693], [-121.36375, 38.77689], [-121.36411, 38.77678], [-121.36411, 38.77865]]]} | Open Access 1 | 44551 | Fred Festersen Park | 19074 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 8.398 | Fred Festersen Park | 0 | Local Park 2 | 4 | |
4276 | 4276 | 4275 | {"type": "Polygon", "coordinates": [[[-121.36832, 38.78194], [-121.36963, 38.78194], [-121.36975, 38.78195], [-121.36987, 38.78199], [-121.37, 38.78209], [-121.37005, 38.78218], [-121.37006, 38.78232], [-121.37003, 38.78241], [-121.36996, 38.7825], [-121.36982, 38.78258], [-121.3697, 38.78261], [-121.3683, 38.78261], [-121.36826, 38.78259], [-121.36824, 38.78254], [-121.36824, 38.78201], [-121.36826, 38.78197], [-121.36832, 38.78194]]]} | Open Access 1 | 45270 | Alberto and Carmen Heredia Park | 15340 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.744 | Alberto and Carmen Heredia Park | 0 | Local Park 2 | 4 | |
4814 | 4814 | 4813 | {"type": "Polygon", "coordinates": [[[-121.22585, 38.76387], [-121.22532, 38.76402], [-121.22495, 38.76411], [-121.22456, 38.76418], [-121.22408, 38.76423], [-121.22418, 38.76363], [-121.22563, 38.76349], [-121.22577, 38.76368], [-121.22585, 38.76387]]]} | Open Access 1 | 48764 | Unknown Park - Roseville, City of | 33491 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.092 | 0 | Local Other or Unknown 14 | 4 | ||
5033 | 5033 | 5032 | {"type": "Polygon", "coordinates": [[[-121.28497, 38.79373], [-121.28355, 38.79373], [-121.28355, 38.7922], [-121.28497, 38.7922], [-121.28497, 38.79373]]]} | Open Access 1 | 20877 | Aldo Pineschi Sr. Park | 15350 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 5.163 | Aldo Pineschi Sr. Park | 0 | Local Park 2 | 4 | |
5034 | 5034 | 5033 | {"type": "Polygon", "coordinates": [[[-121.2388, 38.76523], [-121.23847, 38.76535], [-121.23837, 38.76531], [-121.23826, 38.76531], [-121.23819, 38.76535], [-121.23815, 38.76541], [-121.23814, 38.76548], [-121.23818, 38.76554], [-121.23789, 38.7657], [-121.2375, 38.76574], [-121.23744, 38.76562], [-121.23735, 38.76551], [-121.23723, 38.76541], [-121.23707, 38.76532], [-121.23704, 38.76527], [-121.23718, 38.76505], [-121.23735, 38.76483], [-121.23754, 38.76463], [-121.23784, 38.76438], [-121.23858, 38.76499], [-121.23871, 38.76512], [-121.2388, 38.76523]]]} | Open Access 1 | 20837 | Cambria Park | 16749 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 3.001 | Cambria Park | 0 | Local Park 2 | 4 | |
5036 | 5036 | 5035 | {"type": "Polygon", "coordinates": [[[-121.34655, 38.7663], [-121.34587, 38.76643], [-121.34525, 38.76661], [-121.34472, 38.76681], [-121.34337, 38.76736], [-121.34293, 38.76751], [-121.34259, 38.76761], [-121.34201, 38.76774], [-121.34154, 38.76782], [-121.34095, 38.76788], [-121.34047, 38.7679], [-121.34009, 38.7679], [-121.34009, 38.76633], [-121.33548, 38.76634], [-121.33547, 38.76823], [-121.33303, 38.76848], [-121.33213, 38.76853], [-121.33153, 38.76852], [-121.33111, 38.76849], [-121.33038, 38.76849], [-121.33031, 38.76847], [-121.33025, 38.76843], [-121.33021, 38.76839], [-121.33019, 38.76833], [-121.33019, 38.76766], [-121.33014, 38.76716], [-121.33015, 38.76655], [-121.3302, 38.76608], [-121.33028, 38.76552], [-121.33041, 38.76496], [-121.33057, 38.7644], [-121.33077, 38.76386], [-121.33485, 38.76387], [-121.33486, 38.76544], [-121.34009, 38.76526], [-121.34011, 38.76633], [-121.34655, 38.7663]]]} | Open Access 1 | 20857 | Mahany Park | 21686 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 79.555 | Mahany Park | 0 | Local Park 2 | 4 | |
5354 | 5354 | 5353 | {"type": "MultiPolygon", "coordinates": [[[[-121.27808, 38.76655], [-121.27727, 38.76671], [-121.27706, 38.76678], [-121.27681, 38.76692], [-121.27676, 38.76693], [-121.27669, 38.7669], [-121.27662, 38.76679], [-121.27658, 38.76669], [-121.27657, 38.76656], [-121.27808, 38.76655]]], [[[-121.27819, 38.76686], [-121.27801, 38.76687], [-121.27729, 38.76695], [-121.27733, 38.76685], [-121.27735, 38.76684], [-121.27815, 38.76669], [-121.27819, 38.7667], [-121.27822, 38.76673], [-121.27822, 38.76677], [-121.27819, 38.76686]]]]} | Open Access 1 | 36420 | Roseville holding 29 | 24648 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.864 | Roseville holding 29 | 0 | Local Other or Unknown 14 | 4 | |
5385 | 5385 | 5384 | {"type": "Polygon", "coordinates": [[[-121.28307, 38.78], [-121.28264, 38.78022], [-121.28219, 38.78039], [-121.28199, 38.78005], [-121.28182, 38.77989], [-121.28146, 38.77964], [-121.28221, 38.77939], [-121.28307, 38.78]]]} | Open Access 1 | 36418 | Roseville holding 31 | 24651 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.841 | Roseville holding 31 | 0 | Local Other or Unknown 14 | 4 | |
5386 | 5386 | 5385 | {"type": "Polygon", "coordinates": [[[-121.31243, 38.80095], [-121.3121, 38.80123], [-121.31177, 38.801], [-121.31176, 38.80095], [-121.31148, 38.80074], [-121.31191, 38.80058], [-121.31243, 38.80095]]]} | Open Access 1 | 36419 | Roseville holding 30 | 24650 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.7 | Roseville holding 30 | 0 | Local Other or Unknown 14 | 4 | |
7658 | 7658 | 7657 | {"type": "MultiPolygon", "coordinates": [[[[-121.33318, 38.77738], [-121.33108, 38.77841], [-121.33128, 38.77895], [-121.32992, 38.7806], [-121.32992, 38.78173], [-121.32873, 38.78173], [-121.32872, 38.78055], [-121.32156, 38.78053], [-121.32156, 38.78087], [-121.31946, 38.7809], [-121.31879, 38.78159], [-121.31752, 38.78178], [-121.31706, 38.78176], [-121.3164, 38.78152], [-121.31639, 38.78104], [-121.3168, 38.78104], [-121.3168, 38.7806], [-121.31722, 38.7806], [-121.31721, 38.78027], [-121.31757, 38.78019], [-121.31786, 38.78005], [-121.31832, 38.77973], [-121.31895, 38.77946], [-121.31997, 38.77946], [-121.32051, 38.77928], [-121.32092, 38.77882], [-121.32092, 38.77742], [-121.32062, 38.77657], [-121.32031, 38.77607], [-121.32023, 38.77564], [-121.32045, 38.77546], [-121.32045, 38.77538], [-121.32093, 38.77498], [-121.32143, 38.77515], [-121.32183, 38.77515], [-121.3221, 38.77615], [-121.32251, 38.77655], [-121.32444, 38.77695], [-121.32498, 38.77669], [-121.3249, 38.77644], [-121.32469, 38.77602], [-121.32503, 38.7745], [-121.32453, 38.77439], [-121.32468, 38.77396], [-121.32476, 38.7738], [-121.32488, 38.77368], [-121.32526, 38.77338], [-121.32555, 38.77359], [-121.32614, 38.77315], [-121.32665, 38.77183], [-121.32719, 38.77085], [-121.3268, 38.77069], [-121.32705, 38.77029], [-121.32804, 38.77073], [-121.32803, 38.77237], [-121.3275, 38.77302], [-121.32701, 38.77395], [-121.32698, 38.77427], [-121.32751, 38.77437], [-121.32754, 38.77479], [-121.32806, 38.77504], [-121.32944, 38.775], [-121.32978, 38.77527], [-121.3301, 38.77531], [-121.33058, 38.77524], [-121.33095, 38.77505], [-121.33119, 38.77532], [-121.33147, 38.7756], [-121.33217, 38.77619], [-121.33252, 38.77653], [-121.33288, 38.77695], [-121.33318, 38.77738]]], [[[-121.32686, 38.77028], [-121.32641, 38.77099], [-121.32599, 38.77096], [-121.32596, 38.77099], [-121.3258, 38.77099], [-121.32524, 38.7708], [-121.32443, 38.77075], [-121.32303, 38.77032], [-121.32255, 38.77025], [-121.32223, 38.7704], [-121.3222, 38.77056], [-121.32222, 38.77062], [-121.32204, 38.77086], [-121.32161, 38.77117], [-121.32166, 38.77172], [-121.32211, 38.77178], [-121.3224, 38.77186], [-121.32331, 38.77204], [-121.32351, 38.77226], [-121.32406, 38.77263], [-121.32457, 38.77327], [-121.32485, 38.77349], [-121.3247, 38.77361], [-121.32459, 38.77376], [-121.32404, 38.77348], [-121.32353, 38.77337], [-121.32313, 38.77319], [-121.32279, 38.77313], [-121.32193, 38.77286], [-121.32157, 38.77278], [-121.32101, 38.77276], [-121.32085, 38.77268], [-121.32073, 38.77252], [-121.3205, 38.77187], [-121.32023, 38.77153], [-121.31978, 38.77114], [-121.3196, 38.77066], [-121.31904, 38.77035], [-121.31941, 38.76996], [-121.31985, 38.76957], [-121.32034, 38.76922], [-121.32088, 38.76892], [-121.32141, 38.76868], [-121.32202, 38.76846], [-121.32265, 38.7683], [-121.32326, 38.76819], [-121.32342, 38.76966], [-121.32506, 38.76974], [-121.32589, 38.76986], [-121.32631, 38.77008], [-121.32686, 38.77028]]]]} | Restricted Access 2 | 20863 | Woodcreek Oaks Golf Course | 33075 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 208.072 | Woodcreek Oaks GC | 0 | Local Recreation Area 3 | 4 | |
10889 | 10889 | 10888 | {"type": "Polygon", "coordinates": [[[-121.22636, 38.76641], [-121.22597, 38.76681], [-121.22581, 38.76691], [-121.22564, 38.76699], [-121.22522, 38.76711], [-121.22482, 38.76726], [-121.22478, 38.76716], [-121.22476, 38.76704], [-121.22476, 38.7666], [-121.22479, 38.76644], [-121.22488, 38.76626], [-121.22507, 38.76605], [-121.22515, 38.76594], [-121.22521, 38.76584], [-121.22525, 38.76571], [-121.22601, 38.76549], [-121.22606, 38.76579], [-121.22614, 38.76606], [-121.22613, 38.76612], [-121.22604, 38.76622], [-121.22603, 38.76627], [-121.22604, 38.76632], [-121.2261, 38.76638], [-121.22617, 38.76641], [-121.22626, 38.76641], [-121.22634, 38.76638], [-121.22636, 38.76641]]]} | Open Access 1 | 20836 | David Uribe Park | 17945 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 3.999 | David Uribe Park | 0 | Local Park 2 | 4 | |
10897 | 10897 | 10896 | {"type": "Polygon", "coordinates": [[[-121.33607, 38.80579], [-121.33607, 38.80666], [-121.33435, 38.80665], [-121.33415, 38.80581], [-121.33417, 38.80577], [-121.33422, 38.80574], [-121.33466, 38.80568], [-121.33501, 38.80567], [-121.33549, 38.80569], [-121.33607, 38.80579]]]} | Open Access 1 | 20851 | Leonard Davis Park | 21173 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 4.123 | Leonard Davis Park | 0 | Local Park 2 | 4 | |
10898 | 10898 | 10897 | {"type": "MultiPolygon", "coordinates": [[[[-121.22561, 38.72393], [-121.22559, 38.72431], [-121.22119, 38.72428], [-121.22118, 38.7243], [-121.22195, 38.7251], [-121.22065, 38.72586], [-121.21916, 38.72429], [-121.22028, 38.7229], [-121.22046, 38.72272], [-121.22065, 38.72256], [-121.22102, 38.72233], [-121.22139, 38.72217], [-121.22183, 38.72204], [-121.2223, 38.72198], [-121.22232, 38.72214], [-121.22233, 38.7239], [-121.22561, 38.72393]]], [[[-121.25541, 38.72966], [-121.25391, 38.72967], [-121.2539, 38.72955], [-121.25075, 38.72948], [-121.25075, 38.72943], [-121.25157, 38.72942], [-121.25186, 38.72935], [-121.25236, 38.72912], [-121.25267, 38.72885], [-121.25274, 38.7289], [-121.25282, 38.72891], [-121.2529, 38.72889], [-121.25296, 38.72883], [-121.25312, 38.7288], [-121.25327, 38.72887], [-121.25345, 38.72864], [-121.25424, 38.72903], [-121.25523, 38.72961], [-121.25541, 38.72966]]], [[[-121.3323, 38.75879], [-121.3323, 38.75929], [-121.33079, 38.75928], [-121.3305, 38.7593], [-121.33002, 38.75945], [-121.32985, 38.75945], [-121.32985, 38.75845], [-121.33025, 38.75845], [-121.33028, 38.75843], [-121.3304, 38.75845], [-121.33047, 38.75843], [-121.33053, 38.75837], [-121.33088, 38.75847], [-121.33087, 38.75854], [-121.331, 38.75873], [-121.3311, 38.75881], [-121.33132, 38.75858], [-121.33143, 38.7586], [-121.33154, 38.75855], [-121.33194, 38.75878], [-121.3323, 38.75879]]], [[[-121.33422, 38.75841], [-121.33424, 38.75849], [-121.33421, 38.75857], [-121.33372, 38.75912], [-121.3334, 38.75955], [-121.33237, 38.7607], [-121.33232, 38.76072], [-121.33226, 38.76072], [-121.33225, 38.76071], [-121.33233, 38.76067], [-121.33284, 38.7601], [-121.33285, 38.75943], [-121.33248, 38.75942], [-121.33248, 38.75898], [-121.33284, 38.75898], [-121.33285, 38.7588], [-121.33312, 38.75879], [-121.33312, 38.7585], [-121.33319, 38.75849], [-121.33324, 38.75846], [-121.33327, 38.75842], [-121.33328, 38.75836], [-121.33336, 38.75835], [-121.33354, 38.75805], [-121.33322, 38.75785], [-121.33287, 38.75768], [-121.33225, 38.75745], [-121.3318, 38.75733], [-121.33138, 38.75723], [-121.33062, 38.75708], [-121.33052, 38.7571], [-121.33055, 38.75706], [-121.33061, 38.75705], [-121.33131, 38.75718], [-121.3319, 38.75731], [-121.33246, 38.75749], [-121.33289, 38.75765], [-121.33325, 38.75782], [-121.33358, 38.75803], [-121.33415, 38.75834], [-121.33422, 38.75841]]], [[[-121.34395, 38.76631], [-121.3401, 38.76633], [-121.34008, 38.76526], [-121.33485, 38.76544], [-121.33485, 38.76428], [-121.33615, 38.76423], [-121.33616, 38.7606], [-121.33339, 38.76004], [-121.3339, 38.75948], [-121.33417, 38.75923], [-121.33459, 38.75877], [-121.3347, 38.75872], [-121.33481, 38.75872], [-121.33558, 38.75912], [-121.33662, 38.7595], [-121.33744, 38.75973], [-121.33833, 38.7599], [-121.33836, 38.75993], [-121.33837, 38.75996], [-121.33831, 38.76039], [-121.33832, 38.76053], [-121.33836, 38.76066], [-121.33844, 38.76081], [-121.33857, 38.76095], [-121.33869, 38.76106], [-121.33887, 38.76116], [-121.33906, 38.76123], [-121.33923, 38.76127], [-121.33998, 38.76133], [-121.34019, 38.76137], [-121.34035, 38.76142], [-121.34153, 38.76191], [-121.34176, 38.76198], [-121.342, 38.76202], [-121.342, 38.76224], [-121.34208, 38.76286], [-121.34215, 38.7629], [-121.34244, 38.76291], [-121.34242, 38.76304], [-121.34239, 38.76313], [-121.34242, 38.76322], [-121.34216, 38.76352], [-121.34216, 38.76354], [-121.34395, 38.76354], [-121.34395, 38.76631]]], [[[-121.27652, 38.76697], [-121.27618, 38.76698], [-121.27629, 38.76722], [-121.27618, 38.76725], [-121.27606, 38.76698], [-121.27273, 38.767], [-121.27272, 38.76658], [-121.27639, 38.76656], [-121.27641, 38.76677], [-121.27646, 38.76689], [-121.27652, 38.76697]]], [[[-121.30982, 38.7664], [-121.3098, 38.76652], [-121.30975, 38.76662], [-121.30502, 38.76678], [-121.30297, 38.76742], [-121.30298, 38.7674], [-121.30435, 38.76697], [-121.30433, 38.76641], [-121.30982, 38.7664]]], [[[-121.25912, 38.75786], [-121.25908, 38.75784], [-121.25854, 38.75841], [-121.25833, 38.75842], [-121.25828, 38.75856], [-121.25802, 38.75868], [-121.25776, 38.75867], [-121.25742, 38.75888], [-121.257, 38.75904], [-121.25676, 38.75919], [-121.25667, 38.75934], [-121.25671, 38.75947], [-121.25709, 38.75987], [-121.25708, 38.75993], [-121.25665, 38.76037], [-121.25621, 38.76072], [-121.25571, 38.761], [-121.25433, 38.76191], [-121.25434, 38.76192], [-121.25468, 38.7619], [-121.25416, 38.76208], [-121.25369, 38.76265], [-121.2536, 38.763], [-121.25364, 38.76327], [-121.25375, 38.76346], [-121.25383, 38.7638], [-121.25403, 38.76437], [-121.25426, 38.76455], [-121.25432, 38.76476], [-121.25441, 38.76477], [-121.2544, 38.76485], [-121.25445, 38.76547], [-121.25441, 38.76562], [-121.25432, 38.76575], [-121.25376, 38.7663], [-121.24921, 38.76915], [-121.24737, 38.76923], [-121.24358, 38.76923], [-121.24383, 38.76898], [-121.2444, 38.76866], [-121.24454, 38.76851], [-121.24454, 38.76837], [-121.24445, 38.76825], [-121.24345, 38.76746], [-121.24315, 38.76732], [-121.24276, 38.76723], [-121.24156, 38.76722], [-121.24131, 38.76715], [-121.24132, 38.7668], [-121.2395, 38.7668], [-121.23943, 38.7667], [-121.23758, 38.76758], [-121.23763, 38.76735], [-121.23763, 38.76687], [-121.23817, 38.76687], [-121.23856, 38.76684], [-121.23897, 38.76677], [-121.23929, 38.76669], [-121.24377, 38.76669], [-121.24377, 38.76698], [-121.24555, 38.76802], [-121.24623, 38.76802], [-121.24624, 38.76788], [-121.24737, 38.76773], [-121.24743, 38.76773], [-121.24757, 38.76779], [-121.24767, 38.76785], [-121.24785, 38.76777], [-121.24796, 38.76779], [-121.248, 38.76772], [-121.24816, 38.76774], [-121.24832, 38.76773], [-121.24847, 38.7678], [-121.24867, 38.76771], [-121.2489, 38.76788], [-121.24926, 38.76778], [-121.24939, 38.76762], [-121.24954, 38.76754], [-121.24968, 38.76725], [-121.24985, 38.76724], [-121.24996, 38.76708], [-121.25015, 38.76708], [-121.25033, 38.76703], [-121.25045, 38.76691], [-121.25059, 38.76682], [-121.25074, 38.76681], [-121.25088, 38.76674], [-121.25108, 38.76643], [-121.25116, 38.76616], [-121.25106, 38.76601], [-121.25114, 38.76594], [-121.25126, 38.76603], [-121.25138, 38.76592], [-121.2513, 38.76584], [-121.25131, 38.76564], [-121.25144, 38.7655], [-121.25147, 38.76538], [-121.2516, 38.76527], [-121.25164, 38.76514], [-121.25181, 38.76493], [-121.25195, 38.76482], [-121.25186, 38.76467], [-121.25192, 38.76452], [-121.25187, 38.76441], [-121.25187, 38.76432], [-121.25175, 38.76425], [-121.25174, 38.76415], [-121.2518, 38.76401], [-121.2516, 38.76398], [-121.2514, 38.76387], [-121.25136, 38.76371], [-121.25134, 38.76369], [-121.25129, 38.76356], [-121.25124, 38.76352], [-121.25132, 38.76317], [-121.25137, 38.76283], [-121.25181, 38.76282], [-121.2522, 38.76276], [-121.25258, 38.76259], [-121.25261, 38.76246], [-121.25265, 38.76238], [-121.25258, 38.76173], [-121.25288, 38.76129], [-121.25278, 38.7611], [-121.2523, 38.76124], [-121.25211, 38.76115], [-121.25195, 38.76131], [-121.25195, 38.76133], [-121.2516, 38.76136], [-121.2512, 38.76133], [-121.25122, 38.76125], [-121.2516, 38.76126], [-121.25162, 38.76103], [-121.2517, 38.76062], [-121.25179, 38.76032], [-121.25193, 38.75995], [-121.25242, 38.75967], [-121.2524, 38.7595], [-121.25273, 38.75944], [-121.25307, 38.75931], [-121.25327, 38.75912], [-121.25345, 38.75912], [-121.2536, 38.75916], [-121.25413, 38.75896], [-121.25414, 38.75894], [-121.25401, 38.75876], [-121.25415, 38.75866], [-121.25427, 38.75875], [-121.25454, 38.75873], [-121.25488, 38.75863], [-121.25524, 38.75871], [-121.25534, 38.75855], [-121.25555, 38.75849], [-121.25549, 38.75857], [-121.25561, 38.75877], [-121.25613, 38.75891], [-121.2564, 38.75873], [-121.25677, 38.75841], [-121.25705, 38.75803], [-121.25768, 38.75766], [-121.25759, 38.75753], [-121.25739, 38.75744], [-121.25706, 38.75722], [-121.25715, 38.75704], [-121.25731, 38.75713], [-121.25782, 38.75729], [-121.258, 38.757], [-121.25898, 38.75739], [-121.25911, 38.75748], [-121.25926, 38.75754], [-121.25931, 38.7576], [-121.25931, 38.75764], [-121.25929, 38.75767], [-121.25912, 38.75786]]], [[[-121.25913, 38.76859], [-121.25871, 38.76979], [-121.25866, 38.76979], [-121.25831, 38.76959], [-121.25802, 38.76949], [-121.25776, 38.76944], [-121.25746, 38.76944], [-121.25745, 38.76894], [-121.25831, 38.76751], [-121.25913, 38.76859]]], [[[-121.29013, 38.77161], [-121.28995, 38.77182], [-121.28972, 38.77208], [-121.29013, 38.77161]]], [[[-121.27864, 38.77393], [-121.27854, 38.77395], [-121.27779, 38.77344], [-121.27714, 38.77357], [-121.27527, 38.77387], [-121.27472, 38.77347], [-121.27635, 38.77329], [-121.27702, 38.77333], [-121.27696, 38.77309], [-121.27694, 38.77291], [-121.27692, 38.77161], [-121.27678, 38.77148], [-121.27644, 38.77148], [-121.27582, 38.77155], [-121.27581, 38.77202], [-121.27526, 38.77222], [-121.27468, 38.77211], [-121.27445, 38.77175], [-121.27346, 38.77183], [-121.27298, 38.77224], [-121.27136, 38.77107], [-121.27067, 38.77061], [-121.27043, 38.77042], [-121.27207, 38.76989], [-121.27504, 38.76874], [-121.27516, 38.76873], [-121.27525, 38.76857], [-121.27534, 38.76858], [-121.27525, 38.76876], [-121.27656, 38.76946], [-121.27689, 38.76946], [-121.27689, 38.76954], [-121.27698, 38.76959], [-121.27704, 38.76966], [-121.27707, 38.76975], [-121.27711, 38.7728], [-121.2772, 38.77297], [-121.27743, 38.77311], [-121.27782, 38.77291], [-121.27842, 38.77338], [-121.27844, 38.77345], [-121.27851, 38.77351], [-121.27864, 38.77393]]], [[[-121.28835, 38.77325], [-121.2882, 38.77329], [-121.2882, 38.77331], [-121.28701, 38.77335], [-121.28618, 38.77381], [-121.28564, 38.77388], [-121.2852, 38.77401], [-121.2848, 38.77407], [-121.28385, 38.7743], [-121.28127, 38.77466], [-121.28112, 38.77429], [-121.27995, 38.7742], [-121.27887, 38.77401], [-121.27878, 38.77392], [-121.27867, 38.77373], [-121.27865, 38.77361], [-121.27868, 38.77356], [-121.27875, 38.77354], [-121.27945, 38.77356], [-121.27962, 38.77354], [-121.281, 38.77331], [-121.28203, 38.77273], [-121.28244, 38.77221], [-121.2832, 38.77231], [-121.28364, 38.77202], [-121.2841, 38.77202], [-121.28454, 38.77262], [-121.28449, 38.7728], [-121.28471, 38.77317], [-121.28551, 38.77343], [-121.28578, 38.77317], [-121.28718, 38.77267], [-121.28805, 38.773], [-121.28818, 38.77293], [-121.28835, 38.77325]]], [[[-121.2749, 38.77399], [-121.27435, 38.77408], [-121.27354, 38.77407], [-121.27351, 38.77444], [-121.27323, 38.77455], [-121.2726, 38.77439], [-121.27187, 38.7749], [-121.2719, 38.77532], [-121.27163, 38.77538], [-121.27082, 38.77591], [-121.27051, 38.77629], [-121.26983, 38.77681], [-121.26956, 38.77718], [-121.26893, 38.77739], [-121.26767, 38.77754], [-121.26734, 38.77727], [-121.26706, 38.77699], [-121.26682, 38.77668], [-121.26662, 38.77636], [-121.26649, 38.77608], [-121.26639, 38.77579], [-121.26606, 38.77432], [-121.26593, 38.77432], [-121.26597, 38.77387], [-121.26598, 38.77335], [-121.26602, 38.77331], [-121.26607, 38.77329], [-121.26616, 38.77329], [-121.2663, 38.77332], [-121.26637, 38.77337], [-121.2664, 38.77344], [-121.2663, 38.77382], [-121.26628, 38.77401], [-121.26627, 38.7743], [-121.26629, 38.77454], [-121.26651, 38.77555], [-121.26662, 38.77575], [-121.26679, 38.77622], [-121.26688, 38.77639], [-121.26704, 38.77662], [-121.2672, 38.77681], [-121.26738, 38.77695], [-121.26751, 38.77703], [-121.26769, 38.77709], [-121.26787, 38.77712], [-121.26817, 38.77713], [-121.26846, 38.7771], [-121.26869, 38.77704], [-121.26895, 38.77694], [-121.26916, 38.77681], [-121.26937, 38.77663], [-121.26965, 38.77627], [-121.26974, 38.77618], [-121.27044, 38.77566], [-121.27106, 38.77532], [-121.2712, 38.77519], [-121.27132, 38.77502], [-121.27149, 38.77502], [-121.27159, 38.77476], [-121.27192, 38.77449], [-121.27232, 38.7744], [-121.27238, 38.77413], [-121.27298, 38.77421], [-121.27334, 38.77396], [-121.27367, 38.77384], [-121.2746, 38.77376], [-121.2749, 38.77399]]], [[[-121.28707, 38.78013], [-121.287, 38.78052], [-121.28696, 38.78086], [-121.28684, 38.78074], [-121.28635, 38.78062], [-121.28589, 38.78067], [-121.28536, 38.78096], [-121.28495, 38.78141], [-121.28471, 38.78204], [-121.28376, 38.78264], [-121.28229, 38.7831], [-121.28035, 38.78292], [-121.27983, 38.783], [-121.27894, 38.78338], [-121.27864, 38.78323], [-121.27918, 38.78295], [-121.27991, 38.78237], [-121.28082, 38.78245], [-121.28215, 38.78218], [-121.28306, 38.78163], [-121.28387, 38.78074], [-121.28434, 38.78095], [-121.28453, 38.78055], [-121.28588, 38.78023], [-121.28635, 38.78029], [-121.28707, 38.78013]]], [[[-121.35548, 38.78148], [-121.35509, 38.78152], [-121.35433, 38.78261], [-121.35429, 38.78275], [-121.35394, 38.78269], [-121.35389, 38.78271], [-121.35384, 38.78267], [-121.35378, 38.78265], [-121.35362, 38.78252], [-121.35324, 38.78247], [-121.35205, 38.7822], [-121.35199, 38.78217], [-121.3519, 38.78217], [-121.35189, 38.78215], [-121.3515, 38.78206], [-121.3514, 38.78262], [-121.35135, 38.78281], [-121.35113, 38.783], [-121.35078, 38.78311], [-121.35015, 38.78319], [-121.34961, 38.7833], [-121.34904, 38.78344], [-121.34848, 38.78361], [-121.34828, 38.78364], [-121.34806, 38.78362], [-121.34667, 38.78324], [-121.34671, 38.78191], [-121.34679, 38.7816], [-121.34693, 38.78132], [-121.34708, 38.78114], [-121.34878, 38.77973], [-121.34925, 38.77952], [-121.34943, 38.77937], [-121.34917, 38.77917], [-121.34919, 38.77909], [-121.34914, 38.77901], [-121.34931, 38.77861], [-121.34933, 38.77845], [-121.3493, 38.77827], [-121.34923, 38.77811], [-121.34888, 38.77758], [-121.34962, 38.77733], [-121.3503, 38.77716], [-121.35033, 38.77722], [-121.35097, 38.77751], [-121.35159, 38.77815], [-121.35171, 38.77875], [-121.35188, 38.77911], [-121.3521, 38.7793], [-121.35299, 38.77965], [-121.35355, 38.78042], [-121.35469, 38.78081], [-121.35542, 38.78109], [-121.35523, 38.78137], [-121.35548, 38.78148]]]]} | No Public Access 3 | 20853 | Wetlands | 27444 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 394.838 | Wetlands | 0 | Local Conservation Area 4 | 2 | |
10900 | 10900 | 10899 | {"type": "Polygon", "coordinates": [[[-121.33031, 38.75424], [-121.33027, 38.75428], [-121.32987, 38.75429], [-121.32986, 38.75538], [-121.32913, 38.75519], [-121.32896, 38.75513], [-121.32875, 38.75502], [-121.32837, 38.75476], [-121.32797, 38.7546], [-121.32792, 38.75455], [-121.32793, 38.7545], [-121.32819, 38.75407], [-121.32825, 38.75403], [-121.32874, 38.75417], [-121.32889, 38.75419], [-121.3291, 38.75419], [-121.32942, 38.75414], [-121.32993, 38.75394], [-121.32997, 38.75396], [-121.33016, 38.75414], [-121.33031, 38.75424]]]} | Open Access 1 | 20891 | James A. Hall Park | 20341 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 4.361 | James A. Hall Park | 0 | Local Park 2 | 4 | |
10901 | 10901 | 10900 | {"type": "Polygon", "coordinates": [[[-121.31804, 38.75775], [-121.31713, 38.75822], [-121.31682, 38.75837], [-121.31629, 38.75858], [-121.31573, 38.75875], [-121.31504, 38.75891], [-121.31443, 38.759], [-121.31396, 38.75904], [-121.31348, 38.75905], [-121.31343, 38.75904], [-121.31339, 38.759], [-121.31341, 38.75865], [-121.31345, 38.7585], [-121.3135, 38.75837], [-121.31358, 38.75823], [-121.31369, 38.75809], [-121.31397, 38.75784], [-121.31458, 38.75829], [-121.31596, 38.7574], [-121.31702, 38.75682], [-121.31804, 38.75775]]]} | Open Access 1 | 20892 | JAMES W. WANISH PARK | 20354 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 11.213 | JAMES W. WANISH PARK | None 950 | |||
10902 | 10902 | 10901 | {"type": "MultiPolygon", "coordinates": [[[[-121.33139, 38.7838], [-121.33161, 38.78383], [-121.33183, 38.7839], [-121.33292, 38.78439], [-121.33295, 38.78442], [-121.33295, 38.78445], [-121.33282, 38.78464], [-121.33261, 38.78488], [-121.33216, 38.78532], [-121.33161, 38.78575], [-121.33096, 38.78617], [-121.33096, 38.78595], [-121.33088, 38.78577], [-121.33067, 38.78559], [-121.33021, 38.78538], [-121.32944, 38.78538], [-121.32903, 38.78529], [-121.32873, 38.78513], [-121.32873, 38.78294], [-121.32899, 38.78294], [-121.32901, 38.783], [-121.32904, 38.78303], [-121.32916, 38.78306], [-121.32922, 38.78304], [-121.32934, 38.78295], [-121.32953, 38.78294], [-121.32953, 38.78317], [-121.32956, 38.78331], [-121.32964, 38.78348], [-121.32973, 38.78362], [-121.32986, 38.78376], [-121.33003, 38.78388], [-121.33019, 38.78397], [-121.33038, 38.78404], [-121.33058, 38.78409], [-121.33081, 38.78411], [-121.33102, 38.78411], [-121.33153, 38.78405], [-121.33154, 38.78404], [-121.33139, 38.7838]]], [[[-121.33561, 38.78584], [-121.33453, 38.78693], [-121.33485, 38.78711], [-121.33428, 38.78774], [-121.33475, 38.78801], [-121.33413, 38.78864], [-121.33423, 38.78908], [-121.33448, 38.78911], [-121.33453, 38.78917], [-121.33461, 38.7892], [-121.3347, 38.78918], [-121.33476, 38.78913], [-121.33514, 38.78916], [-121.33493, 38.79025], [-121.33467, 38.79003], [-121.33458, 38.78978], [-121.33469, 38.78943], [-121.33462, 38.78933], [-121.33451, 38.78928], [-121.33403, 38.78925], [-121.33382, 38.78927], [-121.33367, 38.78913], [-121.3335, 38.78905], [-121.33321, 38.78898], [-121.33257, 38.78873], [-121.33232, 38.78855], [-121.3323, 38.78845], [-121.33238, 38.78827], [-121.33298, 38.78786], [-121.33313, 38.78767], [-121.33308, 38.78735], [-121.33291, 38.7872], [-121.33275, 38.78714], [-121.33254, 38.78716], [-121.3324, 38.78726], [-121.3323, 38.78749], [-121.33217, 38.78755], [-121.3321, 38.78755], [-121.33202, 38.78752], [-121.332, 38.78744], [-121.33147, 38.78716], [-121.33131, 38.78704], [-121.33132, 38.78699], [-121.33141, 38.78694], [-121.33149, 38.78687], [-121.33151, 38.78676], [-121.33155, 38.78675], [-121.33183, 38.78675], [-121.33192, 38.78672], [-121.3319, 38.7866], [-121.33182, 38.78645], [-121.33198, 38.78622], [-121.33204, 38.78604], [-121.33198, 38.78606], [-121.33186, 38.78618], [-121.33174, 38.78624], [-121.33163, 38.78627], [-121.33158, 38.78635], [-121.33168, 38.78652], [-121.33162, 38.78658], [-121.33106, 38.78671], [-121.33095, 38.78657], [-121.33095, 38.78645], [-121.33176, 38.78593], [-121.33203, 38.78573], [-121.33238, 38.78544], [-121.33277, 38.78506], [-121.33319, 38.78456], [-121.33323, 38.78454], [-121.33329, 38.78454], [-121.33437, 38.78503], [-121.33561, 38.78584]]]]} | Open Access 1 | 20855 | Blue Oaks Park | 16184 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 42.568 | Blue Oaks Park | 0 | Local Park 2 | 4 | |
10904 | 10904 | 10903 | {"type": "MultiPolygon", "coordinates": [[[[-121.29959, 38.76962], [-121.2993, 38.7698], [-121.29923, 38.76987], [-121.29918, 38.76996], [-121.29916, 38.77015], [-121.29909, 38.77023], [-121.29902, 38.77026], [-121.29895, 38.77027], [-121.29852, 38.77021], [-121.29834, 38.77026], [-121.29781, 38.77063], [-121.29753, 38.77099], [-121.29743, 38.77103], [-121.2973, 38.77105], [-121.29728, 38.77091], [-121.29738, 38.77088], [-121.29763, 38.77055], [-121.2982, 38.77014], [-121.29832, 38.77009], [-121.29848, 38.77006], [-121.29861, 38.77006], [-121.29888, 38.7701], [-121.29892, 38.7701], [-121.29896, 38.77006], [-121.29897, 38.76993], [-121.29901, 38.76983], [-121.29912, 38.76971], [-121.29946, 38.76949], [-121.29959, 38.76962]]], [[[-121.30131, 38.76977], [-121.30109, 38.7698], [-121.30087, 38.76974], [-121.30077, 38.77001], [-121.30059, 38.76995], [-121.30061, 38.7699], [-121.30055, 38.76978], [-121.30029, 38.76952], [-121.30004, 38.76946], [-121.29992, 38.76945], [-121.29981, 38.76947], [-121.29971, 38.76953], [-121.29926, 38.76909], [-121.29925, 38.76904], [-121.29938, 38.76892], [-121.2995, 38.76884], [-121.29964, 38.76879], [-121.2998, 38.76875], [-121.29992, 38.76929], [-121.30018, 38.76932], [-121.30025, 38.76925], [-121.30036, 38.76927], [-121.30039, 38.76931], [-121.30056, 38.76939], [-121.30083, 38.76944], [-121.30096, 38.76948], [-121.30126, 38.76949], [-121.30131, 38.76977]]], [[[-121.30185, 38.76993], [-121.3015, 38.76993], [-121.30142, 38.76957], [-121.30177, 38.76954], [-121.30185, 38.76993]]], [[[-121.30413, 38.77028], [-121.30379, 38.77055], [-121.30374, 38.77063], [-121.30374, 38.77072], [-121.30321, 38.77073], [-121.30284, 38.77079], [-121.30276, 38.77077], [-121.30273, 38.77074], [-121.30268, 38.77062], [-121.30253, 38.77014], [-121.3024, 38.76965], [-121.30229, 38.7691], [-121.30254, 38.76925], [-121.30251, 38.76928], [-121.30251, 38.7693], [-121.30256, 38.76932], [-121.3026, 38.76928], [-121.30314, 38.76959], [-121.30365, 38.76993], [-121.30413, 38.77028]]], [[[-121.31662, 38.77171], [-121.31619, 38.77188], [-121.31577, 38.77201], [-121.31578, 38.77177], [-121.31574, 38.77155], [-121.31561, 38.77139], [-121.31544, 38.77098], [-121.31523, 38.77076], [-121.31513, 38.77063], [-121.31501, 38.77051], [-121.31481, 38.77039], [-121.31453, 38.77035], [-121.31411, 38.77017], [-121.31393, 38.77022], [-121.31359, 38.77046], [-121.3134, 38.7704], [-121.31309, 38.76999], [-121.31309, 38.76967], [-121.31335, 38.76963], [-121.31368, 38.76973], [-121.31377, 38.76979], [-121.3139, 38.76983], [-121.3141, 38.76979], [-121.31416, 38.76971], [-121.31426, 38.76966], [-121.31466, 38.76978], [-121.31496, 38.76993], [-121.31529, 38.77021], [-121.31581, 38.77084], [-121.31587, 38.77099], [-121.3163, 38.77142], [-121.31639, 38.77154], [-121.31662, 38.77171]]], [[[-121.33001, 38.76511], [-121.32991, 38.76563], [-121.32982, 38.76636], [-121.32569, 38.76637], [-121.32568, 38.76502], [-121.32375, 38.76509], [-121.32375, 38.76473], [-121.32414, 38.76503], [-121.32558, 38.76498], [-121.32561, 38.76492], [-121.3256, 38.76477], [-121.32609, 38.76474], [-121.3261, 38.7649], [-121.32612, 38.76496], [-121.32932, 38.76485], [-121.32934, 38.76513], [-121.33001, 38.76511]]]]} | Open Access 1 | 20881 | Welands | 27335 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 26.924 | Welands | None 951 |
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]);