superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 204
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1122 | 1122 | 1121 | {"type": "Polygon", "coordinates": [[[-122.06423, 38.24698], [-122.06271, 38.24698], [-122.06272, 38.24918], [-122.05835, 38.24917], [-122.0583, 38.24668], [-122.05833, 38.24524], [-122.06423, 38.2453], [-122.06423, 38.24698]]]} | Open Access 1 | Alan Witt Park | 15325 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 47.478 | Alan Witt Park | ||
1475 | 1475 | 1474 | {"type": "Polygon", "coordinates": [[[-122.1469, 38.19688], [-122.14679, 38.19694], [-122.14671, 38.19692], [-122.14621, 38.19672], [-122.14624, 38.1965], [-122.1459, 38.19623], [-122.14581, 38.19597], [-122.14579, 38.19566], [-122.14573, 38.19545], [-122.14544, 38.19539], [-122.14553, 38.19513], [-122.14552, 38.19504], [-122.14545, 38.19499], [-122.14532, 38.19496], [-122.14574, 38.19453], [-122.1455, 38.19433], [-122.14546, 38.19427], [-122.14541, 38.19423], [-122.14534, 38.1942], [-122.14531, 38.19416], [-122.1453, 38.19409], [-122.14489, 38.19382], [-122.14492, 38.19377], [-122.14492, 38.1937], [-122.14487, 38.19364], [-122.14479, 38.19361], [-122.14468, 38.19361], [-122.14444, 38.19344], [-122.14405, 38.19339], [-122.14384, 38.19325], [-122.14385, 38.19318], [-122.14372, 38.19311], [-122.1436, 38.19309], [-122.14314, 38.19344], [-122.14294, 38.19334], [-122.14252, 38.19319], [-122.14221, 38.19312], [-122.14152, 38.19309], [-122.14144, 38.19283], [-122.14127, 38.19279], [-122.14114, 38.1928], [-122.14081, 38.19294], [-122.14064, 38.19275], [-122.14051, 38.19264], [-122.14031, 38.19254], [-122.14016, 38.19252], [-122.14001, 38.19253], [-122.13988, 38.19248], [-122.13976, 38.19257], [-122.13948, 38.19244], [-122.13938, 38.19244], [-122.13927, 38.19234], [-122.13914, 38.19232], [-122.13848, 38.19213], [-122.13845, 38.19112], [-122.13856, 38.19112], [-122.1388, 38.19118], [-122.13893, 38.19125], [-122.13912, 38.19151], [-122.13921, 38.19149], [-122.13953, 38.19165], [-122.13969, 38.19189], [-122.13979, 38.19188], [-122.14007, 38.19193], [-122.14057, 38.19205], [-122.14059, 38.19207], [-122.1405, 38.19235], [-122.14049, 38.19242], [-122.14051, 38.19245], [-122.14081, 38.19249], [-122.14125, 38.19249], [-122.14155, 38.19253], [-122.14171, 38.19259], [-122.14197, 38.19271], [-122.14234, 38.19284], [-122.14243, 38.19282], [-122.14247, 38.19269], [-122.14294, 38.19268], [-122.14345, 38.19263], [-122.14356, 38.19253], [-122.14415, 38.19254], [-122.14424, 38.19266], [-122.1446, 38.1929], [-122.14492, 38.19301], [-122.14502, 38.19299], [-122.14505, 38.19304], [-122.14514, 38.19306], [-122.14522, 38.19305], [-122.14527, 38.19301], [-122.14551, 38.19328], [-122.14586, 38.19305], [-122.14623, 38.19418], [-122.14675, 38.1959], [-122.14689, 38.19633], [-122.14695, 38.19642], [-122.14698, 38.19666], [-122.1469, 38.19688]]]} | Open Access 1 | American Canyon Creek Park | 15447 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 17.953 | American Canyon Creek Park | ||
3259 | 3259 | 3258 | {"type": "Polygon", "coordinates": [[[-122.01497, 38.28933], [-122.01455, 38.28938], [-122.01421, 38.28953], [-122.01412, 38.28954], [-122.01398, 38.2895], [-122.01353, 38.28967], [-122.01353, 38.28977], [-122.0136, 38.28997], [-122.01351, 38.29013], [-122.01313, 38.28976], [-122.01302, 38.28933], [-122.01314, 38.2891], [-122.01337, 38.28884], [-122.01336, 38.28882], [-122.0137, 38.28834], [-122.01375, 38.28785], [-122.01373, 38.28782], [-122.01375, 38.28782], [-122.01406, 38.28783], [-122.01457, 38.28804], [-122.01493, 38.28826], [-122.01503, 38.28868], [-122.01495, 38.28906], [-122.01497, 38.28933]]]} | Open Access 1 | Fairfield holding 1 | 18795 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.147 | Fairfield holding 1 | ||
3692 | 3692 | 3691 | {"type": "Polygon", "coordinates": [[[-122.02401, 38.26071], [-122.02263, 38.26068], [-122.02261, 38.25964], [-122.02245, 38.25963], [-122.0225, 38.25902], [-122.02244, 38.25828], [-122.02395, 38.2583], [-122.02399, 38.25833], [-122.02401, 38.25835], [-122.02402, 38.2587], [-122.02401, 38.26071]]]} | Open Access 1 | Dover Park | 18252 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 8.537 | Dover Park | ||
4132 | 4132 | 4131 | {"type": "Polygon", "coordinates": [[[-122.02388, 38.29513], [-122.02362, 38.2953], [-122.02362, 38.29555], [-122.02331, 38.29552], [-122.02335, 38.29515], [-122.02326, 38.29484], [-122.0231, 38.29483], [-122.02304, 38.29462], [-122.02293, 38.29444], [-122.02249, 38.29358], [-122.02246, 38.29312], [-122.02247, 38.29306], [-122.02227, 38.29279], [-122.02192, 38.29225], [-122.02154, 38.29179], [-122.02121, 38.29157], [-122.021, 38.29134], [-122.0205, 38.29028], [-122.02049, 38.29011], [-122.02061, 38.29003], [-122.02054, 38.28981], [-122.02002, 38.28946], [-122.01995, 38.28943], [-122.01992, 38.28933], [-122.01984, 38.28924], [-122.01982, 38.28897], [-122.01997, 38.28868], [-122.02001, 38.28866], [-122.02033, 38.28825], [-122.02039, 38.28787], [-122.02034, 38.28758], [-122.01987, 38.28677], [-122.01974, 38.28601], [-122.01954, 38.2845], [-122.01947, 38.28367], [-122.01928, 38.28287], [-122.01919, 38.28224], [-122.01918, 38.28205], [-122.01916, 38.28194], [-122.01919, 38.28192], [-122.01917, 38.2816], [-122.01821, 38.27987], [-122.01798, 38.27986], [-122.01797, 38.27925], [-122.018, 38.27921], [-122.01804, 38.27689], [-122.01785, 38.27667], [-122.01756, 38.27643], [-122.01707, 38.27596], [-122.01666, 38.2755], [-122.01639, 38.27508], [-122.01619, 38.27458], [-122.01605, 38.27455], [-122.01582, 38.27387], [-122.01634, 38.27367], [-122.01643, 38.27391], [-122.01659, 38.27444], [-122.0168, 38.27489], [-122.01706, 38.27531], [-122.01743, 38.27575], [-122.01811, 38.27634], [-122.01828, 38.27653], [-122.01868, 38.2766], [-122.0187, 38.2779], [-122.01849, 38.27792], [-122.01845, 38.27975], [-122.01871, 38.27977], [-122.01934, 38.28085], [-122.01987, 38.28185], [-122.01988, 38.28205], [-122.01995, 38.28273], [-122.02019, 38.28378], [-122.02021, 38.28407], [-122.02027, 38.28441], [-122.02053, 38.28444], [-122.02034, 38.28482], [-122.02028, 38.28502], [-122.0205, 38.28657], [-122.02081, 38.28713], [-122.02089, 38.28721], [-122.02092, 38.28731], [-122.02097, 38.28734], [-122.0212, 38.28777], [-122.02126, 38.28816], [-122.02097, 38.28829], [-122.02087, 38.28896], [-122.02095, 38.28968], [-122.02109, 38.28993], [-122.02116, 38.28993], [-122.02169, 38.29075], [-122.02183, 38.29107], [-122.02204, 38.29138], [-122.02194, 38.29152], [-122.02227, 38.2917], [-122.02243, 38.29183], [-122.02257, 38.29203], [-122.0226, 38.29209], [-122.02268, 38.29216], [-122.02285, 38.29235], [-122.02306, 38.29317], [-122.02309, 38.29345], [-122.0232, 38.29373], [-122.02349, 38.29428], [-122.02371, 38.2945], [-122.02389, 38.29502], [-122.02388, 38.29513]]]} | Open Access 1 | Fairfield Linear CreekPark | 18796 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 35.552 | Fairfield Linear CreekPark | ||
4133 | 4133 | 4132 | {"type": "Polygon", "coordinates": [[[-122.09278, 38.24037], [-122.09046, 38.24124], [-122.08872, 38.24205], [-122.08805, 38.2428], [-122.08698, 38.2436], [-122.08478, 38.2439], [-122.0838, 38.24422], [-122.08075, 38.2456], [-122.07742, 38.24696], [-122.07497, 38.24809], [-122.07332, 38.24867], [-122.07148, 38.24944], [-122.07106, 38.24972], [-122.07129, 38.25019], [-122.06756, 38.25175], [-122.06023, 38.25488], [-122.05484, 38.25709], [-122.05473, 38.25736], [-122.05404, 38.25741], [-122.054, 38.25793], [-122.05236, 38.25796], [-122.04975, 38.25925], [-122.04975, 38.25926], [-122.04981, 38.25928], [-122.04553, 38.26116], [-122.04037, 38.26341], [-122.04036, 38.26325], [-122.03385, 38.26602], [-122.01603, 38.27379], [-122.01575, 38.27296], [-122.01683, 38.2726], [-122.0181, 38.27259], [-122.02505, 38.26952], [-122.03921, 38.26337], [-122.04036, 38.26286], [-122.04037, 38.26281], [-122.04059, 38.26279], [-122.04235, 38.26205], [-122.04513, 38.26077], [-122.04832, 38.25941], [-122.04836, 38.25935], [-122.04974, 38.25879], [-122.04971, 38.25837], [-122.05143, 38.258], [-122.05152, 38.25767], [-122.05277, 38.25744], [-122.0536, 38.25711], [-122.0536, 38.25709], [-122.05354, 38.25701], [-122.0549, 38.25656], [-122.05864, 38.2549], [-122.06656, 38.25147], [-122.06856, 38.25067], [-122.07124, 38.24939], [-122.07182, 38.24906], [-122.07202, 38.24883], [-122.07586, 38.24745], [-122.08486, 38.24356], [-122.08627, 38.24342], [-122.08749, 38.24312], [-122.08817, 38.24249], [-122.0884, 38.24204], [-122.09237, 38.24032], [-122.09278, 38.24037]]]} | Open Access 1 | Fairfield Linear Park | 18797 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 79.803 | Fairfield Linear Park | ||
4149 | 4149 | 4148 | {"type": "Polygon", "coordinates": [[[-122.04197, 38.27757], [-122.0416, 38.27758], [-122.04147, 38.27761], [-122.04132, 38.27769], [-122.04097, 38.27776], [-122.04013, 38.27786], [-122.04013, 38.27648], [-122.04191, 38.27649], [-122.04197, 38.27654], [-122.04197, 38.27757]]]} | Open Access 1 | Hillview Park | 19993 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 5.465 | Hillview Park | ||
4508 | 4508 | 4507 | {"type": "Polygon", "coordinates": [[[-121.97912, 38.29715], [-121.97792, 38.29773], [-121.97767, 38.29735], [-121.97673, 38.2962], [-121.97642, 38.29586], [-121.97764, 38.29528], [-121.97775, 38.2953], [-121.97912, 38.29715]]]} | Open Access 1 | Gary Falati Park | 19229 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 7.566 | Gary Falati Park | ||
4594 | 4594 | 4593 | {"type": "Polygon", "coordinates": [[[-122.06016, 38.25216], [-122.05982, 38.25215], [-122.05981, 38.25188], [-122.06016, 38.25187], [-122.06016, 38.25216]]]} | Open Access 1 | Kentucky Street Tot Lot | 20622 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.235 | Kentucky Street Tot Lot | ||
4978 | 4978 | 4977 | {"type": "Polygon", "coordinates": [[[-122.05474, 38.25477], [-122.05436, 38.25478], [-122.05436, 38.25458], [-122.05473, 38.25458], [-122.05474, 38.25477]]]} | Open Access 1 | Hayes & Utah Street Tot Lot | 19754 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.174 | Hayes & Utah Street Tot Lot | ||
5560 | 5560 | 5559 | {"type": "Polygon", "coordinates": [[[-122.06362, 38.26685], [-122.06308, 38.26853], [-122.06218, 38.26864], [-122.06218, 38.26842], [-122.06216, 38.26832], [-122.06217, 38.26688], [-122.06212, 38.26682], [-122.06224, 38.26646], [-122.06362, 38.26685]]]} | Open Access 1 | Mankas Park | 21750 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 5.599 | Mankas Park | ||
6038 | 6038 | 6037 | {"type": "Polygon", "coordinates": [[[-122.01918, 38.28203], [-122.01814, 38.2823], [-122.01809, 38.28228], [-122.0181, 38.28202], [-122.01804, 38.28129], [-122.01747, 38.28112], [-122.01683, 38.28113], [-122.01684, 38.28165], [-122.01589, 38.28169], [-122.01584, 38.28172], [-122.01554, 38.28169], [-122.01539, 38.2817], [-122.01538, 38.28182], [-122.01519, 38.2819], [-122.01519, 38.28266], [-122.01483, 38.2827], [-122.01429, 38.28294], [-122.01361, 38.28337], [-122.01342, 38.28346], [-122.01337, 38.28345], [-122.01198, 38.282], [-122.0119, 38.28179], [-122.01189, 38.28002], [-122.01188, 38.28], [-122.0119, 38.27995], [-122.012, 38.27992], [-122.01329, 38.27994], [-122.01449, 38.27992], [-122.01753, 38.27994], [-122.01823, 38.27993], [-122.01827, 38.28012], [-122.01863, 38.28069], [-122.01914, 38.28161], [-122.01916, 38.2818], [-122.01915, 38.28196], [-122.01918, 38.28203]]]} | Open Access 1 | Laurel Creek Park | 21091 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 37.599 | Laurel Creek Park | ||
6075 | 6075 | 6074 | {"type": "Polygon", "coordinates": [[[-122.04031, 38.25555], [-122.04029, 38.25817], [-122.03928, 38.25818], [-122.03926, 38.25723], [-122.03922, 38.25721], [-122.03924, 38.25552], [-122.04018, 38.25553], [-122.04031, 38.25555]]]} | Open Access 1 | Lee Bell Park | 21131 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.668 | Lee Bell Park | ||
6231 | 6231 | 6230 | {"type": "MultiPolygon", "coordinates": [[[[-122.05671, 38.25641], [-122.05649, 38.25652], [-122.05634, 38.25651], [-122.0563, 38.25649], [-122.05666, 38.25634], [-122.05671, 38.25641]]], [[[-122.06112, 38.25383], [-122.06072, 38.254], [-122.06069, 38.25395], [-122.06087, 38.25392], [-122.06096, 38.25387], [-122.06108, 38.25378], [-122.06112, 38.25383]]]]} | Open Access 1 | Linear Park Playground | 21306 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 0.116 | Linear Park Playground | ||
6861 | 6861 | 6860 | {"type": "MultiPolygon", "coordinates": [[[[-122.00251, 38.2696], [-122.00233, 38.26963], [-122.0022, 38.26968], [-122.00115, 38.27042], [-122.001, 38.27046], [-122.00064, 38.27045], [-122.00079, 38.26977], [-122.00083, 38.26941], [-122.00093, 38.269], [-122.00111, 38.26902], [-122.0015, 38.26897], [-122.0016, 38.26894], [-122.00174, 38.26885], [-122.00196, 38.26874], [-122.0021, 38.26877], [-122.00234, 38.26902], [-122.00237, 38.26924], [-122.00236, 38.26929], [-122.0023, 38.26936], [-122.00231, 38.26939], [-122.0023, 38.26945], [-122.00243, 38.2695], [-122.00249, 38.2695], [-122.00251, 38.2696]]], [[[-122.05196, 38.28157], [-122.05189, 38.28173], [-122.05184, 38.28197], [-122.0518, 38.28203], [-122.05173, 38.28215], [-122.05151, 38.28236], [-122.05144, 38.28239], [-122.05123, 38.2821], [-122.05113, 38.28209], [-122.05107, 38.28211], [-122.05101, 38.2821], [-122.05098, 38.28206], [-122.05103, 38.28189], [-122.05102, 38.28184], [-122.05096, 38.28181], [-122.05092, 38.28172], [-122.05091, 38.28165], [-122.05092, 38.2816], [-122.05102, 38.28151], [-122.05113, 38.28151], [-122.05133, 38.28146], [-122.05135, 38.28137], [-122.05135, 38.28127], [-122.0514, 38.28116], [-122.05148, 38.28112], [-122.05159, 38.28113], [-122.05169, 38.28118], [-122.05178, 38.28128], [-122.05196, 38.28157]]]]} | Open Access 1 | Meadow Glen Park | 22071 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.376 | Meadow Glen Park | ||
7411 | 7411 | 7410 | {"type": "Polygon", "coordinates": [[[-121.96736, 38.30157], [-121.96735, 38.30183], [-121.96663, 38.30199], [-121.96611, 38.30257], [-121.96381, 38.307], [-121.96352, 38.30735], [-121.96535, 38.3109], [-121.96492, 38.31134], [-121.96492, 38.31136], [-121.96449, 38.31183], [-121.96353, 38.31397], [-121.96367, 38.31471], [-121.96344, 38.31549], [-121.96158, 38.31549], [-121.95215, 38.31541], [-121.95186, 38.31079], [-121.95186, 38.31055], [-121.95137, 38.30158], [-121.96736, 38.30157]]]} | No Public Access 3 | Noonan Reservoir | 22785 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 428.79 | Noonan Reservoir | ||
7631 | 7631 | 7630 | {"type": "Polygon", "coordinates": [[[-122.0663, 38.26167], [-122.0661, 38.26176], [-122.06535, 38.26216], [-122.06512, 38.26224], [-122.06493, 38.26224], [-122.06482, 38.2623], [-122.06477, 38.26238], [-122.06479, 38.26246], [-122.06486, 38.26256], [-122.06488, 38.26269], [-122.06496, 38.26292], [-122.06498, 38.26322], [-122.06495, 38.26326], [-122.06495, 38.26335], [-122.06428, 38.26336], [-122.06425, 38.26328], [-122.0641, 38.26327], [-122.06043, 38.26325], [-122.05979, 38.26322], [-122.05974, 38.26317], [-122.06176, 38.26072], [-122.06219, 38.26031], [-122.06226, 38.26028], [-122.06434, 38.25997], [-122.06438, 38.26003], [-122.06567, 38.25984], [-122.06576, 38.25986], [-122.06583, 38.25995], [-122.0663, 38.26167]]]} | Open Access 1 | Octo-Inn | 23068 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 35.909 | Octo-Inn | ||
8680 | 8680 | 8679 | {"type": "Polygon", "coordinates": [[[-122.01429, 38.26531], [-122.01427, 38.26661], [-122.01228, 38.26662], [-122.01227, 38.2653], [-122.01232, 38.26529], [-122.01429, 38.26531]]]} | Open Access 1 | Tabor Park | 26162 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 6.354 | Tabor Park | ||
8700 | 8700 | 8699 | {"type": "Polygon", "coordinates": [[[-122.14304, 38.19095], [-122.14273, 38.19111], [-122.14244, 38.19273], [-122.1424, 38.19282], [-122.14233, 38.19284], [-122.14197, 38.1927], [-122.14176, 38.19259], [-122.14156, 38.19252], [-122.14126, 38.19248], [-122.1408, 38.19248], [-122.14062, 38.19246], [-122.14051, 38.19243], [-122.14051, 38.19235], [-122.14104, 38.19081], [-122.14151, 38.19087], [-122.14213, 38.19078], [-122.14284, 38.19063], [-122.14304, 38.19095]]]} | Open Access 1 | Ridgeview Park | 24359 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 8.278 | Ridgeview Park | ||
8894 | 8894 | 8893 | {"type": "Polygon", "coordinates": [[[-121.99862, 38.26741], [-121.99801, 38.26763], [-121.9976, 38.26714], [-121.99761, 38.26711], [-121.99757, 38.26706], [-121.99724, 38.26669], [-121.99708, 38.26654], [-121.99709, 38.26593], [-121.99855, 38.26597], [-121.99855, 38.26636], [-121.99851, 38.26651], [-121.99844, 38.26664], [-121.99843, 38.26685], [-121.99855, 38.26715], [-121.99862, 38.26741]]]} | Open Access 1 | Tolenas Park | 26391 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 4.428 | Tolenas Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);