units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
41 rows where DES_TP = 2, MNG_AGENCY = 326 and MNG_AG_TYP = 2 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency · 41 ✖
MNG_AGENCY 1
- Murrieta, City of · 41 ✖
DES_TP 1
- Local Park · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10733 | 10733 | 10732 | {"type": "Polygon", "coordinates": [[[-117.22514, 33.57752], [-117.22473, 33.57762], [-117.22503, 33.57866], [-117.22368, 33.57761], [-117.22385, 33.57746], [-117.22408, 33.5773], [-117.22431, 33.57718], [-117.22457, 33.57707], [-117.22472, 33.57757], [-117.22513, 33.57748], [-117.22514, 33.57752]]]} | Open Access 1 | 19952 | Antigua Park | 15519 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 2.274 | Antigua Park | 0 | Local Park 2 | 4 | |
10734 | 10734 | 10733 | {"type": "Polygon", "coordinates": [[[-117.22023, 33.56942], [-117.21987, 33.56969], [-117.21948, 33.56933], [-117.21996, 33.56895], [-117.2202, 33.56917], [-117.22017, 33.56923], [-117.22017, 33.56931], [-117.22018, 33.56936], [-117.22023, 33.56942]]]} | Open Access 1 | 19953 | Montafino Park | 22380 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 0.765 | Montafino Park | 0 | Local Park 2 | 4 | |
16914 | 16914 | 16913 | {"type": "Polygon", "coordinates": [[[-117.22054, 33.57636], [-117.22038, 33.57652], [-117.2202, 33.57676], [-117.21927, 33.57767], [-117.21907, 33.57793], [-117.21895, 33.57815], [-117.21873, 33.5787], [-117.21862, 33.57891], [-117.21892, 33.57907], [-117.21878, 33.57924], [-117.21862, 33.5794], [-117.21847, 33.57951], [-117.21831, 33.5796], [-117.21797, 33.57919], [-117.21772, 33.57901], [-117.21742, 33.57893], [-117.21756, 33.57831], [-117.21773, 33.57794], [-117.21814, 33.57745], [-117.21919, 33.57682], [-117.21996, 33.5759], [-117.22054, 33.57636]]]} | Open Access 1 | 19954 | Mountain Pride Park | 22545 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 9.651 | Mtn. Pride Park | 0 | Local Park 2 | 4 | |
10735 | 10735 | 10734 | {"type": "Polygon", "coordinates": [[[-117.21827, 33.58487], [-117.21607, 33.58653], [-117.21597, 33.58652], [-117.21589, 33.58644], [-117.21614, 33.58623], [-117.21518, 33.58535], [-117.21506, 33.58522], [-117.21497, 33.58509], [-117.21487, 33.58492], [-117.2148, 33.58475], [-117.21476, 33.58459], [-117.21475, 33.5843], [-117.21477, 33.58411], [-117.21481, 33.58398], [-117.21491, 33.58374], [-117.21526, 33.58316], [-117.21534, 33.58295], [-117.21536, 33.58281], [-117.21537, 33.58265], [-117.21534, 33.5825], [-117.21531, 33.58237], [-117.21551, 33.58233], [-117.21749, 33.58417], [-117.21822, 33.58477], [-117.21827, 33.58487]]]} | Open Access 1 | 19955 | Glen Arbor Park | 19315 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 18.923 | Glen Arbor Park | 0 | Local Park 2 | 4 | |
10736 | 10736 | 10735 | {"type": "Polygon", "coordinates": [[[-117.21754, 33.58942], [-117.21704, 33.5898], [-117.2169, 33.58988], [-117.21649, 33.58952], [-117.21708, 33.58907], [-117.21716, 33.58907], [-117.21754, 33.58942]]]} | Open Access 1 | 19956 | Crystal Aire Park | 17842 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 1.112 | Crystal Aire Park | 0 | Local Park 2 | 4 | |
10737 | 10737 | 10736 | {"type": "Polygon", "coordinates": [[[-117.19207, 33.58147], [-117.19147, 33.58193], [-117.19075, 33.58111], [-117.19094, 33.58095], [-117.18947, 33.57961], [-117.1898, 33.57937], [-117.19207, 33.58147]]]} | Open Access 1 | 19958 | Century Park | 17080 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 3.907 | Century Park | 0 | Local Park 2 | 4 | |
10738 | 10738 | 10737 | {"type": "Polygon", "coordinates": [[[-117.18792, 33.5783], [-117.18504, 33.58045], [-117.18504, 33.58047], [-117.18513, 33.5805], [-117.18483, 33.58072], [-117.1847, 33.58073], [-117.18378, 33.58069], [-117.18414, 33.57977], [-117.18444, 33.57977], [-117.18487, 33.57973], [-117.18519, 33.57966], [-117.18554, 33.57953], [-117.18583, 33.57937], [-117.18612, 33.57916], [-117.18634, 33.57894], [-117.18654, 33.57867], [-117.18668, 33.57841], [-117.18678, 33.5781], [-117.18682, 33.57781], [-117.1868, 33.57746], [-117.18675, 33.57725], [-117.18672, 33.57722], [-117.18635, 33.57727], [-117.18626, 33.57677], [-117.18792, 33.5783]]]} | Open Access 1 | 19959 | Barratt Park | 33142 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 8.273 | Barratt Park | 0 | Local Park 2 | 4 | |
10741 | 10741 | 10740 | {"type": "Polygon", "coordinates": [[[-117.17013, 33.55521], [-117.1701, 33.55528], [-117.16948, 33.55572], [-117.1693, 33.55567], [-117.16926, 33.55564], [-117.16918, 33.55565], [-117.16918, 33.55571], [-117.16913, 33.55574], [-117.16891, 33.55575], [-117.16846, 33.55557], [-117.16835, 33.55543], [-117.16784, 33.55546], [-117.16785, 33.55528], [-117.16788, 33.55504], [-117.16798, 33.55506], [-117.16798, 33.55509], [-117.16815, 33.55511], [-117.16819, 33.55492], [-117.16803, 33.55489], [-117.16799, 33.55501], [-117.1679, 33.55499], [-117.168, 33.55465], [-117.16809, 33.5546], [-117.16844, 33.55469], [-117.17013, 33.55521]]]} | Open Access 1 | 19961 | Firefighters Park | 18911 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 3.853 | Firefighters Park | 0 | Local Park 2 | 4 | |
11348 | 11348 | 11347 | {"type": "Polygon", "coordinates": [[[-117.16712, 33.56775], [-117.16704, 33.56803], [-117.16702, 33.56819], [-117.16702, 33.5685], [-117.16629, 33.56851], [-117.16591, 33.56846], [-117.16561, 33.56833], [-117.1654, 33.56817], [-117.16523, 33.56799], [-117.16515, 33.56771], [-117.16525, 33.56771], [-117.16538, 33.56755], [-117.16542, 33.56767], [-117.16557, 33.56791], [-117.16588, 33.56801], [-117.16615, 33.56807], [-117.1663, 33.56806], [-117.16651, 33.56799], [-117.1666, 33.5679], [-117.1666, 33.56782], [-117.16673, 33.56788], [-117.16684, 33.56797], [-117.16689, 33.56795], [-117.16694, 33.56779], [-117.16694, 33.56771], [-117.16712, 33.56775]]]} | Open Access 1 | 22130 | Whitewood Park | 27471 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 2.357 | Whitewood Park | 0 | Local Park 2 | 4 | |
11349 | 11349 | 11348 | {"type": "Polygon", "coordinates": [[[-117.17818, 33.56625], [-117.17525, 33.56844], [-117.17515, 33.56916], [-117.17494, 33.56917], [-117.17472, 33.56924], [-117.17457, 33.56932], [-117.17427, 33.56955], [-117.17405, 33.56934], [-117.17398, 33.56939], [-117.1738, 33.56923], [-117.17286, 33.56875], [-117.17306, 33.56842], [-117.17306, 33.56819], [-117.17352, 33.5682], [-117.17405, 33.56806], [-117.17461, 33.56781], [-117.17554, 33.5671], [-117.17588, 33.56688], [-117.17729, 33.56634], [-117.17785, 33.56593], [-117.17818, 33.56625]]]} | Open Access 1 | 22131 | Rancho Acacias Park | 33141 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 13.017 | Rancho Acacias Park | 0 | Local Park 2 | 4 | |
11350 | 11350 | 11349 | {"type": "Polygon", "coordinates": [[[-117.18475, 33.56446], [-117.18474, 33.56447], [-117.18458, 33.56438], [-117.18435, 33.56431], [-117.18259, 33.56431], [-117.1826, 33.56367], [-117.18264, 33.56346], [-117.18269, 33.56326], [-117.18276, 33.56309], [-117.18294, 33.56278], [-117.18475, 33.56446]]]} | Open Access 1 | 22132 | Meadowridge Park | 22094 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 4.287 | Meadowridge Park | 0 | Local Park 2 | 4 | |
11353 | 11353 | 11352 | {"type": "Polygon", "coordinates": [[[-117.16604, 33.55441], [-117.16605, 33.55479], [-117.16604, 33.55495], [-117.16597, 33.55518], [-117.16588, 33.55536], [-117.16571, 33.55556], [-117.16533, 33.55609], [-117.16504, 33.55642], [-117.16406, 33.55733], [-117.1638, 33.55765], [-117.16349, 33.55798], [-117.16259, 33.5591], [-117.16238, 33.55941], [-117.16225, 33.55965], [-117.16212, 33.55999], [-117.16204, 33.56026], [-117.162, 33.56059], [-117.16199, 33.5609], [-117.16211, 33.56185], [-117.16201, 33.56266], [-117.16202, 33.56292], [-117.16209, 33.56323], [-117.1622, 33.56347], [-117.16235, 33.5637], [-117.16253, 33.5639], [-117.16143, 33.5639], [-117.16142, 33.56455], [-117.16169, 33.56665], [-117.16337, 33.56729], [-117.16367, 33.56785], [-117.16347, 33.56856], [-117.16282, 33.56928], [-117.16277, 33.5697], [-117.16226, 33.56931], [-117.16277, 33.56883], [-117.16301, 33.56875], [-117.16316, 33.56856], [-117.16319, 33.56833], [-117.16336, 33.5682], [-117.1632, 33.56803], [-117.16302, 33.56815], [-117.16274, 33.56795], [-117.16256, 33.56786], [-117.16223, 33.56773], [-117.16198, 33.56755], [-117.16198, 33.56754], [-117.16188, 33.56746], [-117.16186, 33.56746], [-117.16149, 33.56719], [-117.16138, 33.56709], [-117.1614, 33.56707], [-117.1613, 33.56698], [-117.16127, 33.56699], [-117.16106, 33.56677], [-117.16081, 33.56642], [-117.16025, 33.56558], [-117.16019, 33.56545], [-117.16014, 33.56532], [-117.15994, 33.5641], [-117.15997, 33.56395], [-117.16004, 33.56389], [-117.15993, 33.56355], [-117.16046, 33.56283], [-117.16052, 33.56269], [-117.16056, 33.56247], [-117.16054, 33.56228], [-117.16047, 33.5621], [-117.16037, 33.56193], [-117.16014, 33.56169], [-117.16014, 33.56164], [-117.16038, 33.56139], [-117.16049, 33.56122], [-117.16056, 33.56108], [-117.16061, 33.56091], [-117.16064, 33.56075], [-117.16063, 33.56037], [-117.16083, 33.56036], [-117.16106, 33.55994], [-117.16109, 33.55967], [-117.16106, 33.55893], [-117.16149, 33.55847], [-117.16151, 33.55834], [-117.16217, 33.55789], [-117.16209, 33.55733], [-117.16253, 33.55653], [-117.16358, 33.55595], [-117.16409, 33.55593], [-117.16523, 33.55503], [-117.16538, 33.5547], [-117.16534, 33.55452], [-117.16604, 33.55441]]]} | Open Access 1 | 22134 | Pond Park | 23883 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 52.9 | Pond Park | 0 | Local Park 2 | 4 | |
11358 | 11358 | 11357 | {"type": "Polygon", "coordinates": [[[-117.20489, 33.58643], [-117.20434, 33.58688], [-117.20406, 33.58724], [-117.20281, 33.58703], [-117.20154, 33.58694], [-117.20128, 33.58697], [-117.20118, 33.58654], [-117.20334, 33.58617], [-117.20373, 33.58607], [-117.20417, 33.58607], [-117.2046, 33.58619], [-117.20489, 33.58643]]]} | Open Access 1 | 22143 | Valley Vista Park | 26812 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 6.793 | Valley Vista Park | 0 | Local Park 2 | 4 | |
11992 | 11992 | 11991 | {"type": "Polygon", "coordinates": [[[-117.21501, 33.59236], [-117.21477, 33.5923], [-117.21456, 33.59232], [-117.21445, 33.59236], [-117.21437, 33.59241], [-117.21425, 33.59255], [-117.21422, 33.59265], [-117.21421, 33.59274], [-117.21423, 33.59284], [-117.21427, 33.59293], [-117.21434, 33.59301], [-117.21476, 33.59338], [-117.2143, 33.59375], [-117.21415, 33.59432], [-117.21381, 33.59458], [-117.21363, 33.5947], [-117.21353, 33.59459], [-117.21337, 33.59411], [-117.21338, 33.59388], [-117.21304, 33.59323], [-117.21289, 33.59312], [-117.21307, 33.59294], [-117.21312, 33.59286], [-117.21314, 33.59278], [-117.21314, 33.59268], [-117.21312, 33.5926], [-117.21307, 33.59251], [-117.213, 33.59243], [-117.21288, 33.59235], [-117.21276, 33.59231], [-117.21258, 33.5923], [-117.21243, 33.59234], [-117.21232, 33.5924], [-117.21224, 33.59247], [-117.21177, 33.59307], [-117.21164, 33.593], [-117.21226, 33.59228], [-117.21263, 33.59195], [-117.21263, 33.59193], [-117.2124, 33.59195], [-117.21225, 33.59199], [-117.21211, 33.59207], [-117.21198, 33.59219], [-117.21173, 33.59249], [-117.21168, 33.59269], [-117.21153, 33.59293], [-117.21122, 33.59263], [-117.21105, 33.59242], [-117.21096, 33.59227], [-117.21127, 33.59214], [-117.21104, 33.59175], [-117.21118, 33.59169], [-117.21166, 33.59155], [-117.21187, 33.59139], [-117.21195, 33.59115], [-117.2119, 33.59097], [-117.21176, 33.59082], [-117.21148, 33.59073], [-117.21122, 33.59077], [-117.21055, 33.59105], [-117.21086, 33.59078], [-117.21124, 33.59055], [-117.21165, 33.59027], [-117.21299, 33.58924], [-117.2137, 33.58989], [-117.21336, 33.59015], [-117.21352, 33.5903], [-117.21363, 33.59033], [-117.21358, 33.59042], [-117.21359, 33.5905], [-117.21364, 33.59058], [-117.21374, 33.59065], [-117.21352, 33.5909], [-117.21364, 33.59101], [-117.2136, 33.59106], [-117.21501, 33.59236]]]} | Open Access 1 | 24647 | Echo Canyon Park | 18419 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 23.408 | Echo Canyon Park | 0 | Local Park 2 | 4 | |
11993 | 11993 | 11992 | {"type": "Polygon", "coordinates": [[[-117.14668, 33.57411], [-117.14655, 33.57447], [-117.14648, 33.57484], [-117.14648, 33.57603], [-117.1453, 33.57604], [-117.14529, 33.57375], [-117.14558, 33.57377], [-117.14583, 33.57382], [-117.14668, 33.57411]]]} | Open Access 1 | 24648 | Mira Mosa Park | 22275 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 6.764 | Mira Mosa Park | 0 | Local Park 2 | 4 | |
3057 | 3057 | 3056 | {"type": "Polygon", "coordinates": [[[-117.24916, 33.57327], [-117.24874, 33.57336], [-117.24866, 33.57308], [-117.24907, 33.57298], [-117.24916, 33.57327]]]} | Open Access 1 | 24649 | Oak Tree Park | 23012 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 0.328 | Oak Tree Park | 0 | Local Park 2 | 4 | |
5359 | 5359 | 5358 | {"type": "Polygon", "coordinates": [[[-117.1403, 33.57415], [-117.13924, 33.57416], [-117.13919, 33.57413], [-117.13916, 33.57248], [-117.14027, 33.57246], [-117.1403, 33.57415]]]} | Open Access 1 | 24650 | Shady Maple Park | 25349 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 4.79 | Shady Maple Park | 0 | Local Park 2 | 4 | |
5360 | 5360 | 5359 | {"type": "Polygon", "coordinates": [[[-117.232, 33.58521], [-117.23159, 33.58549], [-117.23057, 33.58454], [-117.23045, 33.58446], [-117.23025, 33.58435], [-117.23005, 33.58418], [-117.2305, 33.58383], [-117.23135, 33.58462], [-117.23141, 33.58463], [-117.23189, 33.585], [-117.232, 33.58521]]]} | Open Access 1 | 24651 | Sycamore Park | 26139 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 2.664 | Sycamore Park | 0 | Local Park 2 | 4 | |
14087 | 14087 | 14086 | {"type": "Polygon", "coordinates": [[[-117.1709, 33.55086], [-117.17086, 33.55094], [-117.17084, 33.55101], [-117.17078, 33.55104], [-117.17074, 33.55109], [-117.17073, 33.55115], [-117.17074, 33.5512], [-117.16988, 33.5518], [-117.16938, 33.55133], [-117.16996, 33.55106], [-117.17052, 33.55061], [-117.17066, 33.55075], [-117.1709, 33.55086]]]} | Open Access 1 | 39163 | Creekside Village Green Park | 33139 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 2.012 | Creekside Village Green Park | 0 | Local Park 2 | 4 | |
14091 | 14091 | 14090 | {"type": "Polygon", "coordinates": [[[-117.21183, 33.5585], [-117.2118, 33.55858], [-117.21182, 33.55867], [-117.21125, 33.5591], [-117.21106, 33.55919], [-117.21091, 33.55922], [-117.21077, 33.55923], [-117.21062, 33.5592], [-117.2105, 33.55916], [-117.21037, 33.5591], [-117.21028, 33.55903], [-117.21019, 33.55892], [-117.21013, 33.5588], [-117.21011, 33.55869], [-117.21011, 33.55857], [-117.21013, 33.55847], [-117.21023, 33.55829], [-117.21031, 33.55821], [-117.21087, 33.55779], [-117.21097, 33.55782], [-117.21106, 33.5578], [-117.21183, 33.5585]]]} | Open Access 1 | 39164 | Town Square Park | 26494 | 1391 | Murrieta, City of 329 | City 2 | City Agency 2 | http://www.murrieta.org/services/cs/default.asp#.VJnvnF4AHA | City 2 | 1391 | Murrieta, City of 326 | City 2 | City Agency 2 | Riverside 10 | 4.206 | Town Square 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]);