units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 313 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
DES_TP 4
- Local Park 16
- Local Recreation Area 6
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 24
MNG_AGENCY 1
- Rohnert Park, City of · 24 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15710 | 15710 | 15709 | {"type": "MultiPolygon", "coordinates": [[[[-122.6975, 38.36612], [-122.69734, 38.36619], [-122.69709, 38.36634], [-122.69536, 38.36726], [-122.69449, 38.36934], [-122.69517, 38.37036], [-122.69584, 38.37134], [-122.69411, 38.37136], [-122.69245, 38.37031], [-122.6907, 38.36986], [-122.69038, 38.36872], [-122.69177, 38.36859], [-122.69286, 38.36873], [-122.69358, 38.36666], [-122.69634, 38.36528], [-122.69642, 38.36534], [-122.69653, 38.36539], [-122.69676, 38.36547], [-122.69697, 38.36557], [-122.69712, 38.3657], [-122.6975, 38.36612]]], [[[-122.70898, 38.36012], [-122.70778, 38.36135], [-122.70767, 38.36152], [-122.7071, 38.36209], [-122.70702, 38.36205], [-122.70749, 38.36157], [-122.70685, 38.36117], [-122.70628, 38.36175], [-122.70462, 38.36108], [-122.70419, 38.36097], [-122.70374, 38.36092], [-122.70328, 38.36091], [-122.6964, 38.36125], [-122.69604, 38.36128], [-122.69564, 38.35972], [-122.69545, 38.35657], [-122.69691, 38.35647], [-122.69729, 38.35803], [-122.69748, 38.36003], [-122.69883, 38.3598], [-122.69954, 38.35961], [-122.6992, 38.35623], [-122.70064, 38.35614], [-122.70132, 38.35947], [-122.70166, 38.35957], [-122.70361, 38.35947], [-122.7057, 38.35799], [-122.70517, 38.35712], [-122.70522, 38.35674], [-122.70433, 38.35571], [-122.70408, 38.35529], [-122.70251, 38.35278], [-122.70262, 38.35201], [-122.70138, 38.35104], [-122.70123, 38.3508], [-122.70313, 38.35077], [-122.70898, 38.36012]]], [[[-122.70001, 38.36778], [-122.69854, 38.36776], [-122.69753, 38.36894], [-122.69828, 38.37051], [-122.69833, 38.37064], [-122.69784, 38.37126], [-122.69777, 38.3713], [-122.69774, 38.37131], [-122.69684, 38.37131], [-122.69615, 38.37029], [-122.6968, 38.37005], [-122.69645, 38.36954], [-122.69607, 38.36922], [-122.69604, 38.36805], [-122.69607, 38.36797], [-122.69626, 38.36772], [-122.69639, 38.36758], [-122.6976, 38.36692], [-122.69759, 38.36669], [-122.69761, 38.36658], [-122.69764, 38.36655], [-122.69857, 38.36607], [-122.70001, 38.36778]]], [[[-122.70675, 38.36236], [-122.70468, 38.36506], [-122.70424, 38.36526], [-122.70083, 38.36524], [-122.70082, 38.36531], [-122.69993, 38.36531], [-122.69981, 38.36545], [-122.69971, 38.36554], [-122.69938, 38.36556], [-122.6991, 38.36561], [-122.69892, 38.36568], [-122.69853, 38.36588], [-122.69755, 38.36467], [-122.7001, 38.36388], [-122.70223, 38.36407], [-122.70278, 38.36381], [-122.70414, 38.363], [-122.70537, 38.36235], [-122.70572, 38.36194], [-122.70675, 38.36236]]], [[[-122.705, 38.36688], [-122.70205, 38.36782], [-122.70046, 38.36783], [-122.69937, 38.36659], [-122.70193, 38.36629], [-122.7025, 38.36599], [-122.70448, 38.366], [-122.705, 38.36688]]], [[[-122.70295, 38.35048], [-122.70097, 38.35045], [-122.6998, 38.34855], [-122.70177, 38.34858], [-122.70295, 38.35048]]], [[[-122.71201, 38.36935], [-122.71009, 38.36937], [-122.70842, 38.36762], [-122.70643, 38.36764], [-122.70528, 38.36571], [-122.70759, 38.3627], [-122.70855, 38.36309], [-122.70858, 38.36313], [-122.70859, 38.36317], [-122.70813, 38.36387], [-122.70799, 38.36382], [-122.70739, 38.3645], [-122.70634, 38.36559], [-122.70696, 38.36676], [-122.70714, 38.36692], [-122.70862, 38.36683], [-122.70864, 38.36672], [-122.70856, 38.36671], [-122.70864, 38.36569], [-122.7087, 38.36569], [-122.7087, 38.36543], [-122.70875, 38.36542], [-122.70875, 38.36529], [-122.70871, 38.36529], [-122.70872, 38.36513], [-122.70868, 38.36512], [-122.70873, 38.36441], [-122.70877, 38.36415], [-122.70945, 38.3639], [-122.70951, 38.36446], [-122.70954, 38.36529], [-122.71015, 38.36529], [-122.71024, 38.36524], [-122.71043, 38.3652], [-122.71044, 38.36511], [-122.71048, 38.36504], [-122.71064, 38.36488], [-122.71069, 38.36478], [-122.71067, 38.36468], [-122.71071, 38.36464], [-122.71056, 38.36444], [-122.71052, 38.36438], [-122.7105, 38.3643], [-122.71047, 38.36415], [-122.7105, 38.36412], [-122.71044, 38.36393], [-122.71041, 38.36364], [-122.71078, 38.36365], [-122.71095, 38.36393], [-122.71102, 38.36391], [-122.71146, 38.36462], [-122.71163, 38.36782], [-122.71174, 38.36845], [-122.71201, 38.36935]]]]} | Restricted Access 2 | 28193 | Rohnert Park Municipal Golf Course | 33089 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 282.784 | Rohnert Park Municipal GC | 0 | Local Recreation Area 3 | 4 | |
14283 | 14283 | 14282 | {"type": "Polygon", "coordinates": [[[-122.69604, 38.36128], [-122.69554, 38.36139], [-122.69524, 38.3615], [-122.69474, 38.36174], [-122.69466, 38.36174], [-122.69451, 38.36158], [-122.69443, 38.36147], [-122.69432, 38.36123], [-122.6943, 38.36111], [-122.69427, 38.36053], [-122.69432, 38.36047], [-122.6945, 38.36046], [-122.69447, 38.3606], [-122.69447, 38.36068], [-122.69453, 38.36085], [-122.6946, 38.36095], [-122.69471, 38.36104], [-122.69484, 38.36112], [-122.69497, 38.36116], [-122.69517, 38.36118], [-122.69528, 38.36118], [-122.69547, 38.36113], [-122.69564, 38.36105], [-122.69572, 38.36099], [-122.69583, 38.36084], [-122.69587, 38.36067], [-122.69587, 38.36059], [-122.69604, 38.36128]]]} | Open Access 1 | 44212 | Country Club Mini Park | 17694 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 2.114 | Country Club MP | 0 | Local Park 2 | 4 | |
12479 | 12479 | 12478 | {"type": "Polygon", "coordinates": [[[-122.68917, 38.31984], [-122.68871, 38.32012], [-122.68862, 38.31988], [-122.6885, 38.31969], [-122.68833, 38.31976], [-122.68822, 38.31988], [-122.68821, 38.31994], [-122.68813, 38.31992], [-122.68814, 38.31986], [-122.68808, 38.31967], [-122.68771, 38.31971], [-122.68776, 38.31955], [-122.68787, 38.31946], [-122.68798, 38.31932], [-122.68799, 38.31915], [-122.68789, 38.31873], [-122.68799, 38.31873], [-122.68873, 38.31983], [-122.68917, 38.31984]]]} | Open Access 1 | 28202 | Lydia Court Mini-park | 21602 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 1.298 | Lydia Court Mini-park | None 1088 | |||
12478 | 12478 | 12477 | {"type": "Polygon", "coordinates": [[[-122.70081, 38.32988], [-122.70061, 38.32996], [-122.70041, 38.32967], [-122.7006, 38.32959], [-122.70081, 38.32988]]]} | Open Access 1 | 28199 | Burton Avenue Tot Lot | 16528 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.17 | Burton Avenue Tot Lot | 0 | Local Recreation Area 3 | 4 | |
12477 | 12477 | 12476 | {"type": "Polygon", "coordinates": [[[-122.6955, 38.35083], [-122.6955, 38.35097], [-122.69511, 38.35097], [-122.69472, 38.35084], [-122.6955, 38.35083]]]} | Open Access 1 | 28198 | Hinebaugh Creek Park | 20001 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.195 | Hinebaugh Creek Park | 0 | Local Park 2 | 4 | |
12468 | 12468 | 12467 | {"type": "Polygon", "coordinates": [[[-122.68291, 38.34386], [-122.68267, 38.34386], [-122.68266, 38.34356], [-122.6829, 38.34357], [-122.68291, 38.34386]]]} | Open Access 1 | 28196 | Foot Hills Mini Park / Jasmine Tot Lot | 18974 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.171 | Foot Hills MP / Jasmine Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11556 | 11556 | 11555 | {"type": "Polygon", "coordinates": [[[-122.71072, 38.36465], [-122.71067, 38.36468], [-122.71069, 38.36478], [-122.71065, 38.36488], [-122.71048, 38.36503], [-122.71044, 38.36511], [-122.71043, 38.3652], [-122.71024, 38.36524], [-122.71015, 38.36529], [-122.70954, 38.36529], [-122.70951, 38.36446], [-122.70998, 38.36444], [-122.70998, 38.36434], [-122.7105, 38.3643], [-122.71052, 38.36438], [-122.71056, 38.36444], [-122.71072, 38.36465]]]} | Open Access 1 | 23643 | Roberts Lake Park | 24494 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 2.239 | Roberts Lake Park | 0 | Local Park 2 | 4 | |
11108 | 11108 | 11107 | {"type": "Polygon", "coordinates": [[[-122.6879, 38.32193], [-122.6879, 38.32224], [-122.6877, 38.32225], [-122.6877, 38.32193], [-122.6879, 38.32193]]]} | Open Access 1 | 28203 | Lilac Way Tot Lot | 21233 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.156 | Lilac Way Tot Lot | 0 | Local Recreation Area 3 | 4 | |
7765 | 7765 | 7764 | {"type": "Polygon", "coordinates": [[[-122.6821, 38.33061], [-122.6821, 38.33102], [-122.68208, 38.33113], [-122.68194, 38.33135], [-122.68174, 38.33153], [-122.68168, 38.33162], [-122.68157, 38.33183], [-122.68154, 38.33206], [-122.68144, 38.33214], [-122.677, 38.33216], [-122.67668, 38.33221], [-122.67656, 38.33217], [-122.67654, 38.33211], [-122.67642, 38.3318], [-122.67635, 38.33147], [-122.67634, 38.33107], [-122.67642, 38.331], [-122.67968, 38.33097], [-122.6798, 38.33099], [-122.67989, 38.331], [-122.67996, 38.33096], [-122.67998, 38.33091], [-122.67995, 38.33077], [-122.67994, 38.33029], [-122.6812, 38.33029], [-122.68121, 38.33054], [-122.68152, 38.33054], [-122.68153, 38.33061], [-122.6821, 38.33061]]]} | Open Access 1 | 8478 | Magnolia Park | 21681 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 18.043 | Magnolia Park | 1962 | Local Park 2 | 4 | |
7762 | 7762 | 7761 | {"type": "Polygon", "coordinates": [[[-122.68283, 38.33783], [-122.68273, 38.33791], [-122.68222, 38.33795], [-122.68211, 38.33788], [-122.68206, 38.33754], [-122.68184, 38.33688], [-122.68179, 38.33666], [-122.68178, 38.33633], [-122.68183, 38.33628], [-122.68196, 38.33624], [-122.68244, 38.33624], [-122.68244, 38.33656], [-122.68249, 38.33661], [-122.68244, 38.33667], [-122.68243, 38.33673], [-122.68247, 38.3368], [-122.6826, 38.33689], [-122.6827, 38.33715], [-122.68279, 38.33749], [-122.68283, 38.33783]]]} | Open Access 1 | 8455 | Rainbow Park | 24090 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 2.874 | Rainbow Park | 1962 | Local Park 2 | 4 | |
7511 | 7511 | 7510 | {"type": "Polygon", "coordinates": [[[-122.68194, 38.36972], [-122.68116, 38.36973], [-122.68117, 38.37063], [-122.68002, 38.37064], [-122.67995, 38.37062], [-122.67993, 38.37059], [-122.67994, 38.36792], [-122.67996, 38.36787], [-122.68001, 38.36785], [-122.68031, 38.36782], [-122.68053, 38.36776], [-122.68102, 38.36756], [-122.68128, 38.36748], [-122.68157, 38.36743], [-122.6819, 38.36741], [-122.68193, 38.3693], [-122.68194, 38.36937], [-122.68199, 38.36948], [-122.68198, 38.3695], [-122.68193, 38.36952], [-122.68194, 38.36972]]]} | Open Access 1 | 7045 | Golis Park | 19386 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 12.688 | Golis Park | 1962 | Local Park 2 | 4 | |
5389 | 5389 | 5388 | {"type": "Polygon", "coordinates": [[[-122.69406, 38.32394], [-122.69184, 38.32478], [-122.69137, 38.32401], [-122.69294, 38.32344], [-122.69304, 38.32338], [-122.69314, 38.32329], [-122.6933, 38.32325], [-122.69365, 38.32326], [-122.69406, 38.32394]]]} | Open Access 1 | 8496 | Ladybug Park | 20827 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 5.032 | Ladybug Park | 1962 | Local Park 2 | 4 | |
5388 | 5388 | 5387 | {"type": "Polygon", "coordinates": [[[-122.70016, 38.35527], [-122.69945, 38.35534], [-122.69945, 38.35567], [-122.69925, 38.35569], [-122.69905, 38.35569], [-122.69895, 38.35569], [-122.69871, 38.35562], [-122.69837, 38.35545], [-122.69791, 38.35528], [-122.69806, 38.35499], [-122.69824, 38.35472], [-122.69825, 38.35464], [-122.69832, 38.35452], [-122.69839, 38.35444], [-122.69863, 38.35376], [-122.69871, 38.35378], [-122.69901, 38.35369], [-122.69912, 38.35376], [-122.69927, 38.35378], [-122.69966, 38.35387], [-122.69978, 38.35417], [-122.69996, 38.35448], [-122.69994, 38.35463], [-122.70002, 38.35476], [-122.69995, 38.35482], [-122.69994, 38.3549], [-122.70001, 38.35498], [-122.70009, 38.35502], [-122.70008, 38.35511], [-122.70016, 38.35527]]]} | Open Access 1 | 8383 | Dorotea Park | 18221 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 6.845 | Dorotea Park | 1962 | Local Park 2 | 4 | |
5365 | 5365 | 5364 | {"type": "Polygon", "coordinates": [[[-122.69201, 38.3549], [-122.69201, 38.35508], [-122.69198, 38.35537], [-122.69193, 38.35554], [-122.69184, 38.35575], [-122.69143, 38.35644], [-122.69128, 38.35641], [-122.68961, 38.35644], [-122.68958, 38.35602], [-122.68958, 38.35507], [-122.68968, 38.35482], [-122.68984, 38.35459], [-122.69002, 38.35468], [-122.69015, 38.35472], [-122.69017, 38.35481], [-122.69025, 38.35488], [-122.69031, 38.35489], [-122.69037, 38.35487], [-122.69049, 38.35482], [-122.69193, 38.35482], [-122.69201, 38.3549]]]} | Open Access 1 | 8373 | Eagle Park | 18342 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 8.741 | Eagle Park | 1962 | Local Park 2 | 4 | |
3217 | 3217 | 3216 | {"type": "Polygon", "coordinates": [[[-122.69549, 38.34679], [-122.69543, 38.34722], [-122.69517, 38.34718], [-122.69523, 38.34676], [-122.69549, 38.34679]]]} | Open Access 1 | 28197 | Civic Center Tot Lot | 17370 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.273 | Civic Ctr. Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3216 | 3216 | 3215 | {"type": "Polygon", "coordinates": [[[-122.69706, 38.34239], [-122.69676, 38.3424], [-122.69675, 38.34203], [-122.69679, 38.34203], [-122.69684, 38.34205], [-122.69706, 38.34239]]]} | Open Access 1 | 28195 | Carlita Circle Tot Lot | 16858 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.163 | Carlita Circle Tot Lot | 0 | Local Recreation Area 3 | 4 | |
3215 | 3215 | 3214 | {"type": "Polygon", "coordinates": [[[-122.68779, 38.33818], [-122.68742, 38.3387], [-122.68736, 38.33868], [-122.6872, 38.33842], [-122.68741, 38.33811], [-122.68779, 38.33818]]]} | Open Access 1 | 28194 | Cielo Mini-park | 17254 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.428 | Cielo Mini-park | None 264 | |||
1382 | 1382 | 1381 | {"type": "Polygon", "coordinates": [[[-122.70788, 38.34198], [-122.70682, 38.34199], [-122.70676, 38.34111], [-122.70675, 38.34001], [-122.70784, 38.34001], [-122.70788, 38.34198]]]} | Open Access 1 | 8424 | Alicia Park | 15365 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 5.133 | Alicia Park | 1962 | Local Park 2 | 4 | |
1381 | 1381 | 1380 | {"type": "Polygon", "coordinates": [[[-122.69368, 38.34124], [-122.69329, 38.3419], [-122.69329, 38.3423], [-122.69148, 38.34232], [-122.69146, 38.34161], [-122.69155, 38.34158], [-122.6916, 38.34155], [-122.6924, 38.34064], [-122.69295, 38.34094], [-122.69322, 38.34106], [-122.69368, 38.34124]]]} | Open Access 1 | 8416 | Colegio Vista Park | 17489 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 5.985 | Colegio Vista Park | 1962 | Local Park 2 | 4 | |
1379 | 1379 | 1378 | {"type": "Polygon", "coordinates": [[[-122.69158, 38.34574], [-122.69136, 38.34566], [-122.69118, 38.34562], [-122.69114, 38.34559], [-122.69112, 38.34555], [-122.69118, 38.34527], [-122.69157, 38.34527], [-122.69161, 38.34561], [-122.69161, 38.34569], [-122.69158, 38.34574]]]} | Open Access 1 | 8405 | San Simeon Park | 24993 | 1281 | Rohnert Park, City of 316 | City 2 | City Agency 2 | http://www.ci.rohnert-park.ca.us/index.aspx?page=74 | City 2 | 1281 | Rohnert Park, City of 313 | City 2 | City Agency 2 | Sonoma 16 | 0.422 | San Simeon Park | 1962 | 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]);