units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where COUNTY = 4, DES_TP = 14 and MNG_AGENCY = 42
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 21
MNG_AGENCY 1
- Encinitas, City of · 21 ✖
DES_TP 1
- Local Other or Unknown · 21 ✖
ACCESS_TYP 1
- Open Access 21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | 35531 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.21 | 0 | Local Other or Unknown 14 | 4 | ||
13416 | 13416 | 13415 | {"type": "Polygon", "coordinates": [[[-117.28517, 33.08411], [-117.28517, 33.08713], [-117.28478, 33.08714], [-117.28429, 33.08718], [-117.28299, 33.08738], [-117.28297, 33.08412], [-117.28517, 33.08411]]]} | Open Access 1 | 35528 | Encinitas holding 29 | 18656 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 17.436 | Encinitas holding 29 | 0 | Local Other or Unknown 14 | 4 | |
13417 | 13417 | 13416 | {"type": "Polygon", "coordinates": [[[-117.28529, 33.07544], [-117.2852, 33.07638], [-117.2851, 33.07638], [-117.28509, 33.07542], [-117.28506, 33.07538], [-117.28525, 33.0754], [-117.28529, 33.07544]]]} | Open Access 1 | 35529 | Encinitas holding 31 | 18657 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.384 | Encinitas holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13419 | 13419 | 13418 | {"type": "Polygon", "coordinates": [[[-117.24702, 33.0564], [-117.24692, 33.05685], [-117.24691, 33.05685], [-117.24689, 33.05683], [-117.2469, 33.05662], [-117.24702, 33.0564]]]} | Open Access 1 | 35537 | Encinitas holding 36 | 18658 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.044 | Encinitas holding 36 | 0 | Local Other or Unknown 14 | 4 | |
13420 | 13420 | 13419 | {"type": "Polygon", "coordinates": [[[-117.25554, 33.03255], [-117.25419, 33.03259], [-117.25425, 33.03238], [-117.25435, 33.0322], [-117.25409, 33.03203], [-117.25412, 33.03199], [-117.25439, 33.03213], [-117.25449, 33.03195], [-117.25455, 33.03175], [-117.25454, 33.03156], [-117.2545, 33.03127], [-117.25453, 33.03099], [-117.25448, 33.03085], [-117.2544, 33.03057], [-117.25438, 33.03034], [-117.25454, 33.03041], [-117.25463, 33.03047], [-117.25474, 33.03058], [-117.25485, 33.03073], [-117.25491, 33.03087], [-117.25502, 33.03152], [-117.25508, 33.03166], [-117.25522, 33.0318], [-117.2553, 33.03184], [-117.25546, 33.03189], [-117.25554, 33.03189], [-117.25554, 33.03255]]]} | Open Access 1 | 35538 | Encinitas holding 12 | 18647 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.895 | Encinitas holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13421 | 13421 | 13420 | {"type": "Polygon", "coordinates": [[[-117.25119, 33.02892], [-117.25116, 33.02906], [-117.24968, 33.02909], [-117.24971, 33.02907], [-117.24974, 33.02897], [-117.24991, 33.02881], [-117.24992, 33.02878], [-117.24992, 33.02865], [-117.24995, 33.02859], [-117.25001, 33.02853], [-117.25075, 33.02804], [-117.25081, 33.02804], [-117.25084, 33.02805], [-117.25088, 33.0281], [-117.25089, 33.02815], [-117.25081, 33.02827], [-117.25054, 33.02853], [-117.2505, 33.02861], [-117.25049, 33.02867], [-117.25051, 33.02876], [-117.25055, 33.0288], [-117.25063, 33.02884], [-117.2508, 33.02884], [-117.25102, 33.02881], [-117.25113, 33.02882], [-117.25118, 33.02885], [-117.25119, 33.02892]]]} | Open Access 1 | 35539 | Encinitas holding 47 | 18663 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.83 | Encinitas holding 47 | 0 | Local Other or Unknown 14 | 4 | |
13423 | 13423 | 13422 | {"type": "Polygon", "coordinates": [[[-117.25097, 33.02595], [-117.25082, 33.02602], [-117.25066, 33.02604], [-117.25034, 33.02612], [-117.24989, 33.02611], [-117.24982, 33.02614], [-117.24939, 33.02641], [-117.24938, 33.02662], [-117.24941, 33.02672], [-117.24949, 33.02681], [-117.24953, 33.02685], [-117.24963, 33.02688], [-117.24997, 33.02692], [-117.24915, 33.02722], [-117.24916, 33.0291], [-117.24825, 33.02912], [-117.24825, 33.02901], [-117.24853, 33.02901], [-117.24852, 33.02874], [-117.24826, 33.02831], [-117.24789, 33.0283], [-117.24788, 33.02811], [-117.24859, 33.02811], [-117.24858, 33.02777], [-117.24844, 33.02778], [-117.24805, 33.0273], [-117.2485, 33.02721], [-117.24848, 33.02711], [-117.2487, 33.02709], [-117.2487, 33.02682], [-117.24777, 33.02649], [-117.24794, 33.02643], [-117.24793, 33.02623], [-117.24817, 33.02577], [-117.24817, 33.02571], [-117.24807, 33.02552], [-117.24913, 33.02551], [-117.24913, 33.02413], [-117.24932, 33.02414], [-117.24939, 33.02417], [-117.24926, 33.02429], [-117.24928, 33.02435], [-117.24945, 33.02447], [-117.24962, 33.02456], [-117.24966, 33.02456], [-117.24973, 33.02449], [-117.24978, 33.02449], [-117.24999, 33.02457], [-117.25006, 33.02469], [-117.25007, 33.02474], [-117.2501, 33.02514], [-117.25033, 33.02515], [-117.25038, 33.02475], [-117.25075, 33.02474], [-117.25077, 33.02476], [-117.25076, 33.02488], [-117.25073, 33.02495], [-117.25067, 33.02503], [-117.25052, 33.02515], [-117.2505, 33.0252], [-117.25053, 33.02524], [-117.25088, 33.02547], [-117.25094, 33.02554], [-117.25097, 33.02574], [-117.25097, 33.02595]]]} | Open Access 1 | 35540 | Encinitas holding 41 | 18661 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 15.302 | Encinitas holding 41 | 0 | Local Other or Unknown 14 | 4 | |
13424 | 13424 | 13423 | {"type": "Polygon", "coordinates": [[[-117.25303, 33.03045], [-117.25301, 33.031], [-117.25251, 33.03099], [-117.25221, 33.03096], [-117.25225, 33.0308], [-117.25224, 33.03072], [-117.25259, 33.0307], [-117.25258, 33.03044], [-117.25299, 33.03041], [-117.25303, 33.03045]]]} | Open Access 1 | 35543 | Encinitas holding 40 | 18660 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.88 | Encinitas holding 40 | 0 | Local Other or Unknown 14 | 4 | |
13427 | 13427 | 13426 | {"type": "Polygon", "coordinates": [[[-117.25343, 33.02661], [-117.25336, 33.02656], [-117.2531, 33.02647], [-117.25296, 33.02647], [-117.25283, 33.0265], [-117.25274, 33.02655], [-117.25272, 33.0266], [-117.25209, 33.0266], [-117.25196, 33.02644], [-117.25185, 33.02624], [-117.25185, 33.02612], [-117.25194, 33.02595], [-117.25198, 33.02582], [-117.25197, 33.02575], [-117.25188, 33.02556], [-117.25181, 33.02549], [-117.2517, 33.02546], [-117.25128, 33.02546], [-117.25121, 33.02543], [-117.25113, 33.02537], [-117.25112, 33.02528], [-117.25114, 33.02519], [-117.25114, 33.02506], [-117.2511, 33.02499], [-117.25105, 33.02485], [-117.25097, 33.02475], [-117.25096, 33.02471], [-117.25104, 33.02463], [-117.25107, 33.02457], [-117.25116, 33.02445], [-117.25121, 33.02433], [-117.25121, 33.02425], [-117.25113, 33.02409], [-117.25124, 33.02378], [-117.25119, 33.02362], [-117.25121, 33.02353], [-117.25123, 33.02351], [-117.25127, 33.0235], [-117.25127, 33.02542], [-117.25342, 33.02542], [-117.25343, 33.02661]]]} | Open Access 1 | 35544 | Encinitas holding 37 | 18659 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 5.06 | Encinitas holding 37 | 0 | Local Other or Unknown 14 | 4 | |
13428 | 13428 | 13427 | {"type": "Polygon", "coordinates": [[[-117.25127, 33.02194], [-117.25127, 33.02345], [-117.25103, 33.02344], [-117.2509, 33.02335], [-117.2507, 33.0233], [-117.25061, 33.02326], [-117.25046, 33.02314], [-117.25039, 33.02299], [-117.25041, 33.02262], [-117.25034, 33.02248], [-117.25025, 33.02238], [-117.2504, 33.02227], [-117.25071, 33.0221], [-117.25109, 33.02196], [-117.25123, 33.02192], [-117.25126, 33.02192], [-117.25127, 33.02194]]]} | Open Access 1 | 35546 | Encinitas holding 42 | 18662 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 2.872 | Encinitas holding 42 | 0 | Local Other or Unknown 14 | 4 | |
13429 | 13429 | 13428 | {"type": "Polygon", "coordinates": [[[-117.26321, 33.06745], [-117.26292, 33.06743], [-117.26291, 33.06741], [-117.26254, 33.06741], [-117.26246, 33.06737], [-117.26249, 33.06552], [-117.26252, 33.0653], [-117.26255, 33.06527], [-117.26304, 33.06525], [-117.26303, 33.06536], [-117.26294, 33.06558], [-117.26288, 33.06689], [-117.26294, 33.0671], [-117.26302, 33.06728], [-117.26306, 33.06732], [-117.26317, 33.06736], [-117.26321, 33.06745]]]} | Open Access 1 | 35548 | Encinitas holding 1 | 18645 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 2.584 | Encinitas holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13504 | 13504 | 13503 | {"type": "Polygon", "coordinates": [[[-117.2641, 33.06086], [-117.26391, 33.06092], [-117.26379, 33.06074], [-117.26377, 33.06074], [-117.26372, 33.06078], [-117.26368, 33.06086], [-117.26368, 33.06107], [-117.26343, 33.06107], [-117.26332, 33.06135], [-117.26335, 33.06149], [-117.2635, 33.06179], [-117.26317, 33.06286], [-117.2632, 33.0629], [-117.2632, 33.06304], [-117.26311, 33.0635], [-117.26312, 33.06388], [-117.2631, 33.064], [-117.2631, 33.0642], [-117.26314, 33.06445], [-117.26328, 33.06493], [-117.26308, 33.06497], [-117.26266, 33.06499], [-117.2626, 33.06493], [-117.26263, 33.06455], [-117.2629, 33.0626], [-117.26296, 33.06202], [-117.26296, 33.05866], [-117.26298, 33.05863], [-117.26301, 33.05861], [-117.26329, 33.05861], [-117.26358, 33.05865], [-117.26386, 33.05873], [-117.26404, 33.05881], [-117.26382, 33.05976], [-117.2641, 33.06086]]]} | Open Access 1 | 35817 | Encinitas holding 20 | 18651 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 10.231 | Encinitas holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13506 | 13506 | 13505 | {"type": "Polygon", "coordinates": [[[-117.2513, 33.02732], [-117.25128, 33.02869], [-117.25071, 33.02869], [-117.25069, 33.02867], [-117.25069, 33.02864], [-117.25071, 33.02859], [-117.25095, 33.02831], [-117.25101, 33.0282], [-117.25103, 33.02811], [-117.251, 33.02801], [-117.25087, 33.02786], [-117.25082, 33.02777], [-117.25085, 33.02767], [-117.25083, 33.02746], [-117.25096, 33.0274], [-117.2513, 33.02732]]]} | Open Access 1 | 35789 | Encinitas holding 11 | 18646 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.401 | Encinitas holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13517 | 13517 | 13516 | {"type": "Polygon", "coordinates": [[[-117.2873, 33.08409], [-117.28675, 33.08409], [-117.28637, 33.08148], [-117.28631, 33.08126], [-117.28621, 33.08103], [-117.28589, 33.08046], [-117.28723, 33.08045], [-117.2873, 33.08409]]]} | Open Access 1 | 35810 | Encinitas holding 25 | 18652 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 7.638 | Encinitas holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13519 | 13519 | 13518 | {"type": "Polygon", "coordinates": [[[-117.25555, 33.03156], [-117.25554, 33.03171], [-117.25551, 33.03172], [-117.25538, 33.03169], [-117.25524, 33.03157], [-117.25521, 33.03149], [-117.25511, 33.03088], [-117.25506, 33.03072], [-117.25492, 33.03051], [-117.25482, 33.0304], [-117.25463, 33.03026], [-117.25451, 33.03021], [-117.2546, 33.03006], [-117.25456, 33.02982], [-117.25446, 33.02964], [-117.25431, 33.0296], [-117.2542, 33.02922], [-117.25408, 33.02918], [-117.25351, 33.02933], [-117.25342, 33.02945], [-117.25328, 33.02972], [-117.25344, 33.02987], [-117.25345, 33.0299], [-117.25259, 33.02999], [-117.25136, 33.03006], [-117.25134, 33.03033], [-117.25132, 33.03033], [-117.25131, 33.03042], [-117.25128, 33.02906], [-117.25534, 33.02898], [-117.25534, 33.02966], [-117.25539, 33.03042], [-117.25547, 33.03115], [-117.25555, 33.03156]]]} | Open Access 1 | 35814 | Encinitas holding 26 | 18653 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 10.133 | Encinitas holding 26 | 0 | Local Other or Unknown 14 | 4 | |
13520 | 13520 | 13519 | {"type": "Polygon", "coordinates": [[[-117.25124, 33.02661], [-117.2512, 33.02671], [-117.25099, 33.02698], [-117.25086, 33.02705], [-117.25075, 33.02708], [-117.25046, 33.02687], [-117.25028, 33.0268], [-117.25038, 33.0265], [-117.25079, 33.02648], [-117.2509, 33.02644], [-117.25108, 33.02634], [-117.25123, 33.02631], [-117.25125, 33.02646], [-117.25124, 33.02661]]]} | Open Access 1 | 35815 | Encinitas holding 27 | 18654 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.158 | Encinitas holding 27 | 0 | Local Other or Unknown 14 | 4 | |
13521 | 13521 | 13520 | {"type": "Polygon", "coordinates": [[[-117.25009, 33.02695], [-117.24992, 33.02756], [-117.24973, 33.02758], [-117.24966, 33.0277], [-117.2497, 33.02792], [-117.24915, 33.02826], [-117.24915, 33.02722], [-117.24995, 33.02692], [-117.25009, 33.02695]]]} | Open Access 1 | 35818 | Encinitas holding 28 | 18655 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 1.842 | Encinitas holding 28 | 0 | Local Other or Unknown 14 | 4 | |
13539 | 13539 | 13538 | {"type": "Polygon", "coordinates": [[[-117.25535, 33.02689], [-117.25534, 33.02898], [-117.25128, 33.02906], [-117.2513, 33.02725], [-117.25342, 33.02724], [-117.25342, 33.0256], [-117.254, 33.02648], [-117.25474, 33.0268], [-117.25483, 33.02681], [-117.25471, 33.02689], [-117.2546, 33.02701], [-117.25456, 33.02725], [-117.25397, 33.02765], [-117.25373, 33.02775], [-117.25324, 33.02793], [-117.25311, 33.02796], [-117.25294, 33.02798], [-117.25266, 33.02794], [-117.25253, 33.02801], [-117.25239, 33.02798], [-117.25232, 33.028], [-117.25207, 33.02796], [-117.25171, 33.02806], [-117.25159, 33.0282], [-117.25156, 33.02832], [-117.25161, 33.02851], [-117.25164, 33.02857], [-117.25179, 33.02864], [-117.25193, 33.02864], [-117.25228, 33.02858], [-117.25241, 33.02857], [-117.25275, 33.02876], [-117.25302, 33.02883], [-117.25333, 33.02882], [-117.25358, 33.02876], [-117.25375, 33.0287], [-117.25448, 33.02862], [-117.25459, 33.0287], [-117.25478, 33.0287], [-117.25495, 33.02852], [-117.25504, 33.02837], [-117.25503, 33.02795], [-117.25505, 33.02785], [-117.25508, 33.02733], [-117.25508, 33.02708], [-117.25506, 33.02703], [-117.25506, 33.02696], [-117.25512, 33.02692], [-117.25517, 33.02685], [-117.25531, 33.02685], [-117.25533, 33.02685], [-117.25535, 33.02689]]]} | Open Access 1 | 35847 | Encinitas holding 5 | 18664 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 13.377 | Encinitas holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13551 | 13551 | 13550 | {"type": "Polygon", "coordinates": [[[-117.25536, 33.02438], [-117.25535, 33.02541], [-117.25342, 33.02542], [-117.25342, 33.02439], [-117.25362, 33.02439], [-117.25363, 33.02473], [-117.25402, 33.02473], [-117.2542, 33.02486], [-117.25429, 33.02485], [-117.25449, 33.02468], [-117.25468, 33.02484], [-117.25469, 33.02535], [-117.25502, 33.02536], [-117.25504, 33.02527], [-117.2549, 33.0252], [-117.25481, 33.02506], [-117.25478, 33.02493], [-117.25484, 33.02488], [-117.255, 33.02488], [-117.25511, 33.02493], [-117.25512, 33.02466], [-117.25501, 33.02445], [-117.25501, 33.02442], [-117.25504, 33.02438], [-117.25536, 33.02438]]]} | Open Access 1 | 35867 | Encinitas holding 19 | 18650 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 3.335 | Encinitas holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13552 | 13552 | 13551 | {"type": "Polygon", "coordinates": [[[-117.28549, 33.07638], [-117.28536, 33.07638], [-117.28543, 33.07582], [-117.28549, 33.07638], [-117.28549, 33.07638]]]} | Open Access 1 | 35868 | Encinitas holding 17 | 18648 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.092 | Encinitas holding 17 | 0 | Local Other or Unknown 14 | 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]);