units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
32 rows where ACCESS_TYP = 1, MNG_AGENCY = 165 and MNG_AG_TYP = 3 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
DES_TP 7
MNG_AG_TYP 1
- County Agency · 32 ✖
MNG_AGENCY 1
- Riverside, County of · 32 ✖
ACCESS_TYP 1
- Open Access · 32 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
431 | 431 | 430 | {"type": "Polygon", "coordinates": [[[-117.28428, 33.76243], [-117.28273, 33.76246], [-117.2827, 33.76182], [-117.28324, 33.76181], [-117.28324, 33.76162], [-117.28425, 33.76159], [-117.28428, 33.76243]]]} | Open Access 1 | 48878 | Goodhope Park | 33599 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.022 | Goodhope Park | 0 | Local Park 2 | 4 | |
1099 | 1099 | 1098 | {"type": "Polygon", "coordinates": [[[-116.95489, 33.98303], [-116.95487, 33.98323], [-116.9546, 33.98346], [-116.95406, 33.98442], [-116.95376, 33.98457], [-116.95354, 33.98473], [-116.95305, 33.98462], [-116.9529, 33.9843], [-116.95287, 33.98398], [-116.95261, 33.98389], [-116.95215, 33.98347], [-116.952, 33.98315], [-116.95168, 33.98291], [-116.95142, 33.98279], [-116.95117, 33.98291], [-116.95089, 33.98273], [-116.95074, 33.98224], [-116.9509, 33.98148], [-116.95086, 33.98132], [-116.95083, 33.98091], [-116.95085, 33.9806], [-116.95075, 33.98032], [-116.95062, 33.97963], [-116.95038, 33.97899], [-116.95009, 33.9787], [-116.95005, 33.97853], [-116.94976, 33.97837], [-116.94969, 33.97798], [-116.94962, 33.97766], [-116.94941, 33.97749], [-116.94973, 33.97706], [-116.95035, 33.97679], [-116.95069, 33.97669], [-116.9508, 33.97634], [-116.9513, 33.9761], [-116.9513, 33.97605], [-116.95342, 33.97612], [-116.95481, 33.97613], [-116.95449, 33.97627], [-116.95418, 33.97658], [-116.95416, 33.97729], [-116.95406, 33.97855], [-116.95382, 33.97883], [-116.95364, 33.97944], [-116.95373, 33.98027], [-116.95402, 33.9808], [-116.95406, 33.98136], [-116.95422, 33.98197], [-116.9546, 33.98262], [-116.95489, 33.98303]]]} | Open Access 1 | 6503 | Bogart County Park | 16226 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 70.98 | Bogart County Park | 0 | Local Park 2 | 4 | |
4081 | 4081 | 4080 | {"type": "Polygon", "coordinates": [[[-117.12462, 33.54378], [-117.12448, 33.54508], [-117.12437, 33.54616], [-117.12388, 33.54512], [-117.12356, 33.54429], [-117.12362, 33.54435], [-117.12371, 33.54437], [-117.12389, 33.54459], [-117.12438, 33.54458], [-117.12447, 33.54378], [-117.12462, 33.54378]], [[-117.12427, 33.54564], [-117.12424, 33.54563], [-117.1242, 33.54564], [-117.12424, 33.54573], [-117.12426, 33.54572], [-117.12427, 33.54564]]]} | Open Access 1 | 48876 | Overlook Park | 33597 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 2.188 | Overlook Park | 0 | Local Park 2 | 4 | |
4206 | 4206 | 4205 | {"type": "Polygon", "coordinates": [[[-117.34495, 33.64111], [-117.34461, 33.64156], [-117.34354, 33.6409], [-117.34412, 33.64026], [-117.34444, 33.64045], [-117.34428, 33.64065], [-117.34495, 33.64111]]]} | Open Access 1 | 48872 | Perret Park | 33593 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 2.063 | Perret Park | 0 | Local Park 2 | 4 | |
4815 | 4815 | 4814 | {"type": "Polygon", "coordinates": [[[-116.07451, 33.56924], [-116.07349, 33.56924], [-116.07349, 33.56872], [-116.07451, 33.56872], [-116.07451, 33.56924]]]} | Open Access 1 | 48766 | Unknown Park - Riverside, County of | 33493 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 1.339 | 0 | Local Other or Unknown 14 | 4 | ||
4875 | 4875 | 4874 | {"type": "Polygon", "coordinates": [[[-114.62963, 33.43504], [-114.62963, 33.43504], [-114.62692, 33.43503], [-114.6273, 33.43394], [-114.62962, 33.4339], [-114.62963, 33.43504]]]} | Open Access 1 | 14733 | Thirty Eighth Street County Park | 26304 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 7.153 | Thirty Eighth Street County Park | 0 | Local Park 2 | 4 | |
5175 | 5175 | 5174 | {"type": "MultiPolygon", "coordinates": [[[[-116.22904, 33.56937], [-116.22417, 33.57225], [-116.22417, 33.57225], [-116.22448, 33.56938], [-116.22904, 33.56937]]], [[[-116.47104, 33.54345], [-116.47103, 33.54704], [-116.46673, 33.54703], [-116.46673, 33.54344], [-116.47104, 33.54345]]]]} | Open Access 1 | 4462 | Santa Rosa and San Jacinto Mountains National Monument | 25129 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 55.98 | Santa Rosa and San Jacinto Mtns. NM | 2000 | National Monument or Landmark 80 | 3 | |
5279 | 5279 | 5278 | {"type": "Polygon", "coordinates": [[[-117.25814, 33.7139], [-117.25811, 33.71948], [-117.25803, 33.72838], [-117.24077, 33.72856], [-117.24065, 33.72142], [-117.24062, 33.71414], [-117.25808, 33.71387], [-117.25809, 33.7139], [-117.25814, 33.7139]]]} | Open Access 1 | 2650 | Kabian Park Property | 20539 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 640.487 | Kabian Park Property | 0 | Local Other or Unknown 14 | 4 | |
6006 | 6006 | 6005 | {"type": "Polygon", "coordinates": [[[-117.12554, 33.55661], [-117.12553, 33.5568], [-117.12529, 33.55681], [-117.12524, 33.55678], [-117.12519, 33.55681], [-117.12506, 33.55681], [-117.12505, 33.55686], [-117.125, 33.55686], [-117.125, 33.5569], [-117.12496, 33.55692], [-117.12494, 33.55695], [-117.12496, 33.55699], [-117.125, 33.55701], [-117.125, 33.55709], [-117.12504, 33.55709], [-117.12505, 33.5572], [-117.12522, 33.5572], [-117.12523, 33.55718], [-117.12525, 33.55718], [-117.12526, 33.5572], [-117.12545, 33.5572], [-117.12546, 33.55724], [-117.12553, 33.55724], [-117.12552, 33.55745], [-117.12403, 33.55744], [-117.12404, 33.55702], [-117.12365, 33.55701], [-117.12365, 33.55667], [-117.12363, 33.55663], [-117.12358, 33.55661], [-117.1234, 33.55662], [-117.12335, 33.55664], [-117.12292, 33.55701], [-117.12262, 33.55696], [-117.12249, 33.55684], [-117.12272, 33.55671], [-117.12299, 33.55661], [-117.12313, 33.55657], [-117.12342, 33.55654], [-117.12549, 33.55657], [-117.12554, 33.55661]]]} | Open Access 1 | 48874 | Central Park Community Park Murrieta | 33595 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.887 | Central Park Community Park Murrieta | None 485 | |||
6259 | 6259 | 6258 | {"type": "Polygon", "coordinates": [[[-117.14043, 33.54708], [-117.14033, 33.54714], [-117.14015, 33.54747], [-117.14, 33.54759], [-117.1397, 33.54789], [-117.13919, 33.54827], [-117.13902, 33.54831], [-117.13885, 33.54827], [-117.13872, 33.54818], [-117.13868, 33.54811], [-117.13866, 33.54803], [-117.13865, 33.54803], [-117.13819, 33.54827], [-117.13775, 33.54854], [-117.1376, 33.54869], [-117.13734, 33.54913], [-117.13712, 33.54933], [-117.13684, 33.54927], [-117.13672, 33.54927], [-117.13643, 33.54949], [-117.13623, 33.54973], [-117.13611, 33.54969], [-117.13681, 33.54916], [-117.13676, 33.5491], [-117.13698, 33.54886], [-117.13707, 33.54872], [-117.13719, 33.54846], [-117.13729, 33.54833], [-117.13743, 33.54823], [-117.13791, 33.548], [-117.13812, 33.54786], [-117.13818, 33.54775], [-117.13821, 33.54764], [-117.1382, 33.54752], [-117.13815, 33.54746], [-117.13968, 33.54619], [-117.14015, 33.54657], [-117.13848, 33.54781], [-117.13848, 33.54782], [-117.13852, 33.54785], [-117.1402, 33.54661], [-117.14042, 33.54677], [-117.14043, 33.54708]]]} | Open Access 1 | 48875 | Guenther Willows Park | 33596 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 8.902 | Guenther Willows Park | 0 | Local Park 2 | 4 | |
6276 | 6276 | 6275 | {"type": "Polygon", "coordinates": [[[-117.51151, 33.77707], [-117.51138, 33.77733], [-117.51089, 33.77824], [-117.51044, 33.77898], [-117.50991, 33.77901], [-117.5099, 33.77885], [-117.50991, 33.77865], [-117.50988, 33.77857], [-117.50981, 33.7785], [-117.50971, 33.77848], [-117.50949, 33.77851], [-117.50935, 33.77852], [-117.50932, 33.77819], [-117.50853, 33.77823], [-117.51151, 33.77707]]]} | Open Access 1 | 48880 | Montecito Ranch Park | 33601 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 5.314 | Montecito Ranch Park | 0 | Local Park 2 | 4 | |
6369 | 6369 | 6368 | {"type": "Polygon", "coordinates": [[[-116.68439, 33.67798], [-116.68332, 33.67893], [-116.68325, 33.67922], [-116.68303, 33.67923], [-116.68266, 33.68164], [-116.68233, 33.68175], [-116.68215, 33.68145], [-116.68192, 33.68122], [-116.68198, 33.68044], [-116.68174, 33.68004], [-116.68091, 33.67917], [-116.68038, 33.67794], [-116.67964, 33.67719], [-116.6792, 33.6776], [-116.67885, 33.6784], [-116.67838, 33.67849], [-116.67788, 33.67828], [-116.67766, 33.6776], [-116.67571, 33.67759], [-116.6757, 33.67582], [-116.67894, 33.67586], [-116.6796, 33.67582], [-116.67984, 33.67574], [-116.68008, 33.67574], [-116.68006, 33.67523], [-116.68191, 33.67527], [-116.68211, 33.67525], [-116.68334, 33.67622], [-116.68347, 33.67629], [-116.68439, 33.67742], [-116.68439, 33.67798]]]} | Open Access 1 | 1753 | Herkey Creek Park | 19866 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 62.283 | Herkey Creek Park | 0 | Local Park 2 | 4 | |
6477 | 6477 | 6476 | {"type": "Polygon", "coordinates": [[[-116.7286, 33.74804], [-116.72433, 33.74805], [-116.72439, 33.75331], [-116.72419, 33.75332], [-116.72401, 33.75332], [-116.7238, 33.75328], [-116.72363, 33.75324], [-116.72265, 33.75277], [-116.72224, 33.75263], [-116.72198, 33.75258], [-116.72159, 33.75253], [-116.72116, 33.75253], [-116.72079, 33.75257], [-116.72033, 33.75266], [-116.72006, 33.75267], [-116.72007, 33.75162], [-116.72, 33.74448], [-116.72147, 33.74447], [-116.72155, 33.74437], [-116.72169, 33.74442], [-116.72174, 33.74435], [-116.72185, 33.74399], [-116.72191, 33.74398], [-116.72254, 33.74304], [-116.72217, 33.74269], [-116.72259, 33.74237], [-116.72285, 33.74216], [-116.72316, 33.742], [-116.72341, 33.74181], [-116.7237, 33.74169], [-116.72465, 33.74205], [-116.7254, 33.74138], [-116.72574, 33.74058], [-116.72635, 33.74011], [-116.72689, 33.74058], [-116.72747, 33.74026], [-116.72757, 33.74037], [-116.72842, 33.73989], [-116.72855, 33.73978], [-116.72856, 33.74444], [-116.7286, 33.74804]], [[-116.72097, 33.75236], [-116.72113, 33.75235], [-116.72111, 33.75222], [-116.72095, 33.75223], [-116.72097, 33.75236]]]} | Open Access 1 | 2065 | Idyllwild Park | 20173 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 183.588 | Idyllwild Park | 0 | Local Park 2 | 4 | |
6507 | 6507 | 6506 | {"type": "Polygon", "coordinates": [[[-117.42105, 33.99374], [-117.42104, 33.99393], [-117.42094, 33.99387], [-117.42032, 33.99432], [-117.41971, 33.9945], [-117.41891, 33.99527], [-117.41837, 33.99521], [-117.41467, 33.99321], [-117.41633, 33.99213], [-117.4184, 33.99191], [-117.42105, 33.99374]]]} | Open Access 1 | 2430 | Jensen-Alvarado Ranch Historical Park | 20393 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 30.063 | Jensen-Alvarado Ranch Historical Park | 0 | Local Historic or Cultural Area 19 | 4 | |
6572 | 6572 | 6571 | {"type": "MultiPolygon", "coordinates": [[[[-116.74317, 33.79362], [-116.74314, 33.79385], [-116.7431, 33.79399], [-116.74302, 33.79414], [-116.74292, 33.79427], [-116.74278, 33.7944], [-116.74237, 33.79466], [-116.74219, 33.79482], [-116.74206, 33.79497], [-116.74179, 33.79539], [-116.74168, 33.79551], [-116.74155, 33.79559], [-116.74108, 33.7958], [-116.74093, 33.79592], [-116.74092, 33.79375], [-116.74317, 33.79362]]], [[[-116.74967, 33.79645], [-116.74694, 33.79669], [-116.74655, 33.7964], [-116.74644, 33.79628], [-116.74637, 33.79615], [-116.74631, 33.79597], [-116.74625, 33.79529], [-116.74617, 33.7951], [-116.74607, 33.79493], [-116.74588, 33.79475], [-116.74566, 33.79462], [-116.74541, 33.79454], [-116.74513, 33.7945], [-116.74488, 33.79452], [-116.74463, 33.79457], [-116.74437, 33.79468], [-116.74415, 33.79481], [-116.74394, 33.795], [-116.74367, 33.79537], [-116.74353, 33.7955], [-116.74341, 33.79558], [-116.74291, 33.79584], [-116.74266, 33.79603], [-116.74249, 33.79624], [-116.74222, 33.79673], [-116.74212, 33.79683], [-116.74198, 33.79692], [-116.7418, 33.79698], [-116.74162, 33.79699], [-116.74147, 33.79697], [-116.74133, 33.79692], [-116.74118, 33.79683], [-116.74107, 33.7967], [-116.74101, 33.79656], [-116.741, 33.79642], [-116.74104, 33.79624], [-116.74116, 33.79608], [-116.74128, 33.79599], [-116.74169, 33.7958], [-116.74188, 33.79568], [-116.74203, 33.79552], [-116.74233, 33.79506], [-116.74243, 33.79494], [-116.7426, 33.7948], [-116.74296, 33.79457], [-116.74315, 33.79439], [-116.74328, 33.79422], [-116.74337, 33.79403], [-116.74343, 33.79383], [-116.74345, 33.79361], [-116.74964, 33.79325], [-116.74967, 33.79645]]], [[[-116.74653, 33.79671], [-116.74533, 33.79682], [-116.74224, 33.79708], [-116.74237, 33.79698], [-116.74246, 33.79687], [-116.74273, 33.79638], [-116.74281, 33.79627], [-116.74293, 33.79614], [-116.7431, 33.79602], [-116.74357, 33.79578], [-116.74374, 33.79566], [-116.7439, 33.79551], [-116.74416, 33.79514], [-116.74436, 33.79497], [-116.7445, 33.79488], [-116.74468, 33.79481], [-116.74501, 33.79474], [-116.74525, 33.79474], [-116.74548, 33.7948], [-116.74567, 33.79491], [-116.74584, 33.79506], [-116.74592, 33.7952], [-116.74597, 33.79533], [-116.74603, 33.79601], [-116.74608, 33.79622], [-116.74616, 33.79637], [-116.74624, 33.79647], [-116.74636, 33.79658], [-116.74653, 33.79671]]]]} | Open Access 1 | 3816 | Lawler Lodge Park | 21114 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 65.857 | Lawler Lodge Park | 0 | Local Park 2 | 4 | |
6930 | 6930 | 6929 | {"type": "Polygon", "coordinates": [[[-117.38678, 33.93378], [-117.38579, 33.93434], [-117.38492, 33.93328], [-117.38591, 33.93272], [-117.38678, 33.93378]]]} | Open Access 1 | 5826 | Washington Park | 27271 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 3.904 | Washington Park | 0 | Local Park 2 | 4 | |
7766 | 7766 | 7765 | {"type": "Polygon", "coordinates": [[[-116.73697, 33.76722], [-116.73616, 33.76785], [-116.73441, 33.76766], [-116.73406, 33.7661], [-116.73443, 33.76596], [-116.73465, 33.76583], [-116.73672, 33.76566], [-116.73697, 33.76722]]]} | Open Access 1 | 8479 | Pine Cove County Park | 23674 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 12.829 | Pine Cove County Park | 0 | Local Park 2 | 4 | |
10537 | 10537 | 10536 | {"type": "Polygon", "coordinates": [[[-117.11988, 33.71789], [-117.11539, 33.71793], [-117.11537, 33.72508], [-117.11986, 33.72504], [-117.11979, 33.72862], [-117.1023, 33.72895], [-117.10226, 33.72172], [-117.10216, 33.7145], [-117.10576, 33.71446], [-117.10651, 33.71438], [-117.11099, 33.71433], [-117.11139, 33.71453], [-117.11318, 33.71473], [-117.11586, 33.71436], [-117.11982, 33.71433], [-117.11988, 33.71789]]]} | Open Access 1 | 18750 | Double Butte Park Property | 18237 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 560.311 | Double Butte Park Property | 0 | Local Other or Unknown 14 | 4 | |
11352 | 11352 | 11351 | {"type": "Polygon", "coordinates": [[[-116.90313, 33.94334], [-116.89857, 33.94333], [-116.89827, 33.94266], [-116.89791, 33.94223], [-116.89766, 33.9413], [-116.89702, 33.9398], [-116.89651, 33.93845], [-116.8965, 33.93756], [-116.8943, 33.93447], [-116.8943, 33.93254], [-116.89922, 33.93253], [-116.89923, 33.93542], [-116.89855, 33.93543], [-116.89855, 33.93599], [-116.89923, 33.936], [-116.89923, 33.9367], [-116.90309, 33.93967], [-116.90313, 33.94334]]]} | Open Access 1 | 22147 | Gilman Historic Ranch Park | 19295 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 131.555 | Gilman Historic Ranch Park | 0 | Local Historic or Cultural Area 19 | 4 | |
12519 | 12519 | 12518 | {"type": "Polygon", "coordinates": [[[-114.53743, 33.67682], [-114.53197, 33.67681], [-114.53248, 33.67467], [-114.53295, 33.67313], [-114.53327, 33.67189], [-114.53329, 33.67168], [-114.53329, 33.67139], [-114.53305, 33.66978], [-114.53407, 33.66976], [-114.53408, 33.66975], [-114.53406, 33.66967], [-114.5349, 33.66965], [-114.53487, 33.66951], [-114.53726, 33.66945], [-114.53743, 33.67682]]]} | Open Access 1 | 29002 | Mayflower Park | 21976 | 315 | Riverside, County of 169 | County 3 | County Agency 3 | http://www.rivcoparks.org/ | County 3 | 315 | Riverside, County of 165 | County 3 | County Agency 3 | Riverside 10 | 83.858 | Mayflower Park | 0 | Local Park 2 | 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]);