units_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

47 rows where AGNCY_LEV = 2, MNG_AGENCY = 178 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: GAP_STS

MNG_AG_TYP 1

  • City Agency · 47 ✖

MNG_AGENCY 1

  • Mission Viejo, City of · 47 ✖

ACCESS_TYP 1

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
486 486 485 {"type": "Polygon", "coordinates": [[[-117.6813, 33.61079], [-117.681, 33.61102], [-117.68099, 33.61113], [-117.68092, 33.61115], [-117.68084, 33.61123], [-117.68084, 33.61127], [-117.68089, 33.61133], [-117.68067, 33.61153], [-117.6799, 33.61034], [-117.67975, 33.60987], [-117.67944, 33.60924], [-117.67845, 33.60767], [-117.67894, 33.60821], [-117.67928, 33.60801], [-117.67933, 33.60807], [-117.6795, 33.60811], [-117.67961, 33.60776], [-117.67961, 33.60741], [-117.67972, 33.6074], [-117.68084, 33.60876], [-117.68058, 33.60894], [-117.68053, 33.60895], [-117.6805, 33.60894], [-117.68035, 33.60879], [-117.68028, 33.60876], [-117.68018, 33.60875], [-117.68012, 33.60877], [-117.68003, 33.60883], [-117.68002, 33.6089], [-117.6801, 33.60897], [-117.6802, 33.60896], [-117.67984, 33.6092], [-117.6813, 33.61079]]]} Open Access 1 1948 Bart Spendlove Park 15840 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 8.707 Bart Spendlove Park 0 Local Park 2 4
757 757 756 {"type": "Polygon", "coordinates": [[[-117.66963, 33.58289], [-117.66954, 33.58291], [-117.66938, 33.58291], [-117.66935, 33.58294], [-117.66925, 33.58295], [-117.66913, 33.58293], [-117.66909, 33.58295], [-117.66892, 33.58289], [-117.6688, 33.58289], [-117.66822, 33.58268], [-117.66793, 33.58253], [-117.66789, 33.58254], [-117.66739, 33.58312], [-117.66739, 33.58316], [-117.66721, 33.58291], [-117.6673, 33.58287], [-117.66744, 33.58276], [-117.66788, 33.5823], [-117.66815, 33.58244], [-117.66826, 33.58235], [-117.6693, 33.58181], [-117.66963, 33.58289]]]} Open Access 1 4949 Madrid Fore Park 21662 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 3.179 Madrid Fore Park 0 Local Park 2 4
817 817 816 {"type": "Polygon", "coordinates": [[[-117.62784, 33.64741], [-117.62779, 33.64747], [-117.62698, 33.64704], [-117.62608, 33.64633], [-117.62569, 33.64592], [-117.62537, 33.64553], [-117.62539, 33.64545], [-117.62739, 33.64502], [-117.62746, 33.64504], [-117.62764, 33.6456], [-117.62768, 33.64568], [-117.62739, 33.64578], [-117.62743, 33.64595], [-117.62747, 33.64597], [-117.62754, 33.64611], [-117.62758, 33.64613], [-117.62767, 33.64627], [-117.62772, 33.64629], [-117.628, 33.64657], [-117.62804, 33.64667], [-117.62806, 33.64681], [-117.62804, 33.64697], [-117.62795, 33.64715], [-117.62778, 33.64733], [-117.62779, 33.64739], [-117.62784, 33.64741]]]} Open Access 1 5264 Melinda Park 22109 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 8.6 Melinda Park 0 Local Park 2 4
1028 1028 1027 {"type": "Polygon", "coordinates": [[[-117.66962, 33.60827], [-117.66943, 33.60877], [-117.66909, 33.60876], [-117.66897, 33.60895], [-117.66894, 33.60921], [-117.66885, 33.60956], [-117.66878, 33.60971], [-117.66865, 33.61009], [-117.66865, 33.61025], [-117.66791, 33.61023], [-117.66834, 33.60814], [-117.66845, 33.60811], [-117.66883, 33.60811], [-117.66922, 33.60817], [-117.66962, 33.60827]]]} Open Access 1 5641 El Dorado Park 18506 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 4.933 El Dorado Park 0 Local Park 2 4
1280 1280 1279 {"type": "Polygon", "coordinates": [[[-117.6886, 33.60417], [-117.68825, 33.60431], [-117.6882, 33.60422], [-117.68803, 33.60404], [-117.68833, 33.60382], [-117.68851, 33.60403], [-117.6886, 33.60417]]]} Open Access 1 9876 Aegean Hills Park 15279 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 0.371 Aegean Hills Park 0 Local Park 2 4
1442 1442 1441 {"type": "Polygon", "coordinates": [[[-117.67129, 33.60231], [-117.67127, 33.60295], [-117.67121, 33.6035], [-117.66979, 33.60287], [-117.6702, 33.60214], [-117.67114, 33.6022], [-117.67129, 33.60231]]]} Open Access 1 12483 Marguerite M. O'Neill Park 21807 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 3.49 Marguerite M. O'Neill Park 0 Local Park 2 4
1593 1593 1592 {"type": "Polygon", "coordinates": [[[-117.65477, 33.62495], [-117.6546, 33.62521], [-117.65448, 33.62533], [-117.65419, 33.62559], [-117.6539, 33.6258], [-117.6536, 33.62596], [-117.65327, 33.62607], [-117.65272, 33.62618], [-117.65242, 33.62621], [-117.65189, 33.62622], [-117.6518, 33.62615], [-117.65174, 33.62557], [-117.65155, 33.62477], [-117.65202, 33.62476], [-117.65223, 33.62483], [-117.65251, 33.62462], [-117.65276, 33.62466], [-117.6529, 33.62473], [-117.65323, 33.62468], [-117.65346, 33.62477], [-117.6537, 33.62481], [-117.65389, 33.62486], [-117.65409, 33.62485], [-117.65426, 33.62481], [-117.65449, 33.62485], [-117.65477, 33.62495]]]} Open Access 1 12156 Aurora Park 15709 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 8.961 Aurora Park 0 Local Park 2 4
1640 1640 1639 {"type": "Polygon", "coordinates": [[[-117.65166, 33.64041], [-117.6516, 33.64043], [-117.65136, 33.64074], [-117.65134, 33.64074], [-117.65137, 33.64044], [-117.65136, 33.6404], [-117.65133, 33.64039], [-117.65114, 33.64037], [-117.65106, 33.64039], [-117.65096, 33.64041], [-117.65085, 33.64049], [-117.65019, 33.64026], [-117.65016, 33.64027], [-117.6501, 33.64051], [-117.65006, 33.6405], [-117.65007, 33.64024], [-117.65001, 33.64023], [-117.64985, 33.64028], [-117.64982, 33.64013], [-117.64986, 33.63997], [-117.64989, 33.63992], [-117.65003, 33.63977], [-117.6502, 33.6395], [-117.65028, 33.63915], [-117.65029, 33.63879], [-117.65025, 33.63869], [-117.65003, 33.63841], [-117.64991, 33.63833], [-117.64961, 33.63823], [-117.64965, 33.63817], [-117.64994, 33.63824], [-117.65022, 33.63806], [-117.65071, 33.63857], [-117.65113, 33.63893], [-117.65127, 33.63908], [-117.6514, 33.63933], [-117.65151, 33.63979], [-117.65153, 33.64005], [-117.65166, 33.64041]]]} Open Access 1 12490 Minaya Park 22258 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 6.423 Minaya Park 0 Local Park 2 4
1670 1670 1669 {"type": "Polygon", "coordinates": [[[-117.66405, 33.63016], [-117.66372, 33.63081], [-117.66359, 33.63122], [-117.66331, 33.63185], [-117.6632, 33.63188], [-117.66309, 33.63183], [-117.66243, 33.63166], [-117.66214, 33.63164], [-117.66159, 33.63169], [-117.66121, 33.63181], [-117.66094, 33.63193], [-117.66074, 33.63204], [-117.66067, 33.63205], [-117.66061, 33.63198], [-117.6605, 33.63171], [-117.66046, 33.63133], [-117.66077, 33.63135], [-117.66105, 33.6311], [-117.66117, 33.63109], [-117.66135, 33.63119], [-117.66156, 33.63117], [-117.66176, 33.63135], [-117.66205, 33.63132], [-117.66212, 33.6312], [-117.66224, 33.63121], [-117.66229, 33.63119], [-117.66239, 33.63104], [-117.66253, 33.63094], [-117.66276, 33.63114], [-117.66287, 33.63116], [-117.663, 33.63107], [-117.66312, 33.63078], [-117.66308, 33.63051], [-117.66285, 33.63037], [-117.66198, 33.63006], [-117.66115, 33.62995], [-117.66065, 33.62983], [-117.66049, 33.62976], [-117.66045, 33.62978], [-117.66033, 33.62972], [-117.66028, 33.62975], [-117.66014, 33.62969], [-117.66008, 33.6297], [-117.65998, 33.62963], [-117.65992, 33.62964], [-117.65982, 33.62954], [-117.65976, 33.62954], [-117.65956, 33.62936], [-117.65985, 33.62882], [-117.66022, 33.6284], [-117.66054, 33.62858], [-117.6605, 33.62871], [-117.66071, 33.62893], [-117.66117, 33.62888], [-117.6612, 33.62886], [-117.66132, 33.6289], [-117.6614, 33.6289], [-117.66151, 33.62889], [-117.66168, 33.62885], [-117.66183, 33.62913], [-117.66202, 33.62907], [-117.66208, 33.62899], [-117.66259, 33.62922], [-117.66265, 33.62919], [-117.66267, 33.62922], [-117.66274, 33.62923], [-117.66282, 33.62922], [-117.66322, 33.62939], [-117.66332, 33.62955], [-117.66356, 33.62972], [-117.66365, 33.62992], [-117.66372, 33.63], [-117.66405, 33.63016]]]} Open Access 1 12606 San Gabriel and Santa Lucia Open Space 24893 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 16.445 San Gabriel and Santa Lucia OS 0 Local Recreation Area 3 4
1906 1906 1905 {"type": "Polygon", "coordinates": [[[-117.65907, 33.61619], [-117.65915, 33.61636], [-117.65919, 33.61654], [-117.65922, 33.6169], [-117.65906, 33.61738], [-117.65898, 33.61767], [-117.65879, 33.61764], [-117.65826, 33.61763], [-117.65761, 33.6178], [-117.65752, 33.61781], [-117.65749, 33.61743], [-117.65729, 33.61648], [-117.65764, 33.61643], [-117.65907, 33.61619]]]} Open Access 1 14724 Castille Park 16950 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 5.923 Castille Park 0 Local Park 2 4
2449 2449 2448 {"type": "Polygon", "coordinates": [[[-117.66415, 33.61724], [-117.66405, 33.61732], [-117.66355, 33.61759], [-117.6638, 33.61778], [-117.66376, 33.61793], [-117.66308, 33.61752], [-117.66316, 33.61729], [-117.66285, 33.6172], [-117.66284, 33.61715], [-117.66279, 33.61708], [-117.66284, 33.61702], [-117.66267, 33.61644], [-117.66327, 33.6163], [-117.66335, 33.61658], [-117.66415, 33.61724]]]} Open Access 1 12180 Christopher Park 17232 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 2.824 Christopher Park 0 Local Park 2 4
3341 3341 3340 {"type": "Polygon", "coordinates": [[[-117.65528, 33.59652], [-117.65529, 33.5968], [-117.65509, 33.59779], [-117.65469, 33.59824], [-117.65465, 33.59825], [-117.65436, 33.59858], [-117.65394, 33.59884], [-117.65373, 33.59894], [-117.65348, 33.5984], [-117.65365, 33.59687], [-117.65392, 33.59678], [-117.65478, 33.59657], [-117.65528, 33.59652]]]} Open Access 1 30296 World Cup Soccer Fields 27756 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 7.416 World Cup Soccer Fields 0 Local Recreation Area 3 4
3812 3812 3811 {"type": "Polygon", "coordinates": [[[-117.63394, 33.60507], [-117.63391, 33.60568], [-117.63388, 33.60587], [-117.63372, 33.60642], [-117.63352, 33.60685], [-117.63333, 33.60715], [-117.63272, 33.60796], [-117.63249, 33.60773], [-117.63246, 33.60773], [-117.63237, 33.60775], [-117.63215, 33.60762], [-117.63207, 33.60754], [-117.63203, 33.60747], [-117.63202, 33.60735], [-117.63223, 33.60679], [-117.63227, 33.60664], [-117.63245, 33.60642], [-117.6325, 33.60626], [-117.63258, 33.60609], [-117.63294, 33.60565], [-117.6329, 33.60553], [-117.63296, 33.60541], [-117.63289, 33.60525], [-117.63286, 33.60503], [-117.63287, 33.60498], [-117.63281, 33.60487], [-117.63291, 33.60487], [-117.6331, 33.60488], [-117.63332, 33.60494], [-117.63357, 33.60503], [-117.63369, 33.605], [-117.63394, 33.60507]]]} Open Access 1 10146 Robert A Curtis Park 24481 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 8.168 Robert A Curtis Park 0 Local Park 2 4
5199 5199 5198 {"type": "Polygon", "coordinates": [[[-117.65837, 33.63225], [-117.65835, 33.63227], [-117.65821, 33.63231], [-117.65795, 33.63233], [-117.65783, 33.63242], [-117.65752, 33.63232], [-117.65735, 33.63233], [-117.65733, 33.63239], [-117.65718, 33.63239], [-117.65721, 33.63178], [-117.65731, 33.63152], [-117.6573, 33.63142], [-117.65727, 33.63131], [-117.65719, 33.63111], [-117.65714, 33.63103], [-117.65827, 33.63102], [-117.65825, 33.63123], [-117.65826, 33.63171], [-117.65832, 33.63204], [-117.65838, 33.6322], [-117.65837, 33.63225]]]} Open Access 1 24600 Barcelona Park 15811 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 3.579 Barcelona Park 0 Local Park 2 4
5247 5247 5246 {"type": "Polygon", "coordinates": [[[-117.65338, 33.57827], [-117.65327, 33.57829], [-117.65319, 33.57833], [-117.65311, 33.57841], [-117.65252, 33.57938], [-117.6515, 33.57897], [-117.65142, 33.57895], [-117.65131, 33.57897], [-117.65136, 33.57891], [-117.65146, 33.57884], [-117.65149, 33.57885], [-117.65167, 33.57868], [-117.65227, 33.57803], [-117.65338, 33.57827]]]} Open Access 1 1343 Barbadanes Park 15804 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 3.369 Barbadanes Park 0 Local Park 2 4
5320 5320 5319 {"type": "Polygon", "coordinates": [[[-117.64915, 33.57941], [-117.64761, 33.58031], [-117.64747, 33.5801], [-117.64726, 33.57969], [-117.64714, 33.57936], [-117.64711, 33.57919], [-117.64712, 33.57916], [-117.64716, 33.57916], [-117.64753, 33.57917], [-117.64795, 33.57916], [-117.64821, 33.57912], [-117.64872, 33.579], [-117.64876, 33.57903], [-117.64892, 33.57921], [-117.64915, 33.57941]]]} Open Access 1 5594 Napoli Park 22634 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 3.701 Napoli Park 0 Local Park 2 4
5334 5334 5333 {"type": "Polygon", "coordinates": [[[-117.64889, 33.64769], [-117.64859, 33.64778], [-117.64842, 33.64786], [-117.64826, 33.64796], [-117.64798, 33.64819], [-117.64775, 33.64808], [-117.64751, 33.64791], [-117.64738, 33.64774], [-117.64723, 33.64738], [-117.64716, 33.64719], [-117.64712, 33.64686], [-117.64713, 33.64652], [-117.64727, 33.64615], [-117.64741, 33.6462], [-117.64804, 33.64651], [-117.64803, 33.64661], [-117.6481, 33.64669], [-117.64837, 33.64685], [-117.6486, 33.64703], [-117.6487, 33.64715], [-117.64876, 33.64727], [-117.64889, 33.64765], [-117.64889, 33.64769]]]} Open Access 1 24601 Crucero Park 17838 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 5.477 Crucero Park 0 Local Park 2 4
5335 5335 5334 {"type": "Polygon", "coordinates": [[[-117.63849, 33.59792], [-117.63849, 33.59798], [-117.63814, 33.59871], [-117.6378, 33.59939], [-117.63765, 33.59961], [-117.63741, 33.59992], [-117.6371, 33.60025], [-117.63629, 33.60087], [-117.63581, 33.6012], [-117.63527, 33.60069], [-117.63503, 33.60059], [-117.63493, 33.60058], [-117.63489, 33.60055], [-117.63485, 33.60045], [-117.63485, 33.60032], [-117.63495, 33.60022], [-117.63499, 33.60011], [-117.6351, 33.59996], [-117.63537, 33.59984], [-117.63541, 33.59981], [-117.63534, 33.59972], [-117.63486, 33.59924], [-117.63488, 33.59917], [-117.63494, 33.59913], [-117.63502, 33.59913], [-117.63542, 33.59918], [-117.63594, 33.59903], [-117.63608, 33.59904], [-117.6362, 33.59885], [-117.63623, 33.59849], [-117.63624, 33.59847], [-117.63633, 33.5985], [-117.63656, 33.59865], [-117.63658, 33.59864], [-117.63662, 33.59851], [-117.63662, 33.59835], [-117.63676, 33.59803], [-117.63678, 33.59774], [-117.63735, 33.59739], [-117.63742, 33.59737], [-117.63756, 33.59736], [-117.63766, 33.59737], [-117.63783, 33.59745], [-117.63792, 33.59757], [-117.63829, 33.59778], [-117.63849, 33.59792]]]} Open Access 1 24602 Gilleran Park 19294 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 17.037 Gilleran Park 0 Local Park 2 4
5337 5337 5336 {"type": "Polygon", "coordinates": [[[-117.64483, 33.59557], [-117.64455, 33.59568], [-117.64443, 33.59575], [-117.64287, 33.5969], [-117.64321, 33.59717], [-117.6434, 33.59738], [-117.6434, 33.59751], [-117.64351, 33.59762], [-117.64361, 33.59775], [-117.64373, 33.59774], [-117.64376, 33.59779], [-117.64381, 33.59783], [-117.64374, 33.59793], [-117.64389, 33.59823], [-117.64382, 33.59825], [-117.64376, 33.59838], [-117.64384, 33.59866], [-117.64394, 33.59869], [-117.64394, 33.59875], [-117.64396, 33.5988], [-117.64385, 33.59889], [-117.64389, 33.59918], [-117.64393, 33.5993], [-117.64402, 33.59932], [-117.64381, 33.59954], [-117.64373, 33.59932], [-117.64369, 33.59911], [-117.64366, 33.5986], [-117.64364, 33.59833], [-117.64361, 33.59817], [-117.64354, 33.59797], [-117.64345, 33.59778], [-117.64334, 33.5976], [-117.64321, 33.59744], [-117.64308, 33.59731], [-117.64289, 33.59715], [-117.64252, 33.59693], [-117.64232, 33.59684], [-117.64213, 33.59678], [-117.6417, 33.5967], [-117.64128, 33.59667], [-117.6419, 33.59661], [-117.64225, 33.5965], [-117.64251, 33.59637], [-117.6428, 33.59616], [-117.64296, 33.59601], [-117.64311, 33.59584], [-117.64343, 33.59538], [-117.64367, 33.59509], [-117.64381, 33.59495], [-117.64404, 33.59481], [-117.64424, 33.59472], [-117.64447, 33.59465], [-117.64465, 33.59461], [-117.64472, 33.59462], [-117.64483, 33.59557]]]} Open Access 1 24604 Pacific Hills Park 23301 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 7.922 Pacific Hills Park 0 Local Park 2 4
5338 5338 5337 {"type": "Polygon", "coordinates": [[[-117.66274, 33.61347], [-117.66203, 33.61356], [-117.66193, 33.61345], [-117.66163, 33.61332], [-117.66218, 33.61239], [-117.66223, 33.61233], [-117.66254, 33.61252], [-117.66263, 33.61302], [-117.66274, 33.61347]]]} Open Access 1 24605 Valyermo Park 26817 1207 Mission Viejo, City of 182 City 2 City Agency 2 http://cityofmissionviejo.org/ City 2 1207 Mission Viejo, City of 178 City 2 City Agency 2   Orange 3 2.064 Valyermo Park 0 Local Park 2 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);