units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
76 rows where ACCESS_TYP = 1, MNG_AGENCY = 122 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP, DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
305 | 305 | 304 | {"type": "Polygon", "coordinates": [[[-118.01213, 33.73489], [-118.01191, 33.73503], [-118.01177, 33.73516], [-118.0117, 33.73525], [-118.01163, 33.7355], [-118.01163, 33.73585], [-118.01122, 33.73585], [-118.01119, 33.73402], [-118.01212, 33.73402], [-118.01213, 33.73489]]]} | Open Access 1 | 1042 | Glen View Park | 19325 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.31 | Glen View Park | 0 | Local Park 2 | 4 | |
386 | 386 | 385 | {"type": "Polygon", "coordinates": [[[-118.05417, 33.72241], [-118.05416, 33.72158], [-118.05339, 33.72158], [-118.05338, 33.72109], [-118.05364, 33.72108], [-118.05364, 33.72069], [-118.05357, 33.72068], [-118.05357, 33.72042], [-118.05361, 33.72031], [-118.05367, 33.72022], [-118.05376, 33.72014], [-118.054, 33.72003], [-118.05407, 33.72006], [-118.05425, 33.7205], [-118.05433, 33.72078], [-118.05441, 33.72126], [-118.05443, 33.72234], [-118.0544, 33.72239], [-118.05436, 33.72241], [-118.05417, 33.72241]]]} | Open Access 1 | 1408 | Harbour View Park | 19671 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.406 | Harbour View Park | 0 | Local Park 2 | 4 | |
463 | 463 | 462 | {"type": "Polygon", "coordinates": [[[-117.95893, 33.6679], [-117.95781, 33.6679], [-117.9578, 33.66708], [-117.95781, 33.66704], [-117.95787, 33.66701], [-117.95834, 33.66699], [-117.95844, 33.66703], [-117.95854, 33.66704], [-117.95857, 33.66703], [-117.95862, 33.66697], [-117.95864, 33.66689], [-117.95891, 33.66689], [-117.95893, 33.6679]]]} | Open Access 1 | 1536 | Hawes Park | 19742 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/hawes-park.cfm | Orange 3 | 2.599 | Hawes Park | 0 | Local Park 2 | 4 |
469 | 469 | 468 | {"type": "Polygon", "coordinates": [[[-118.04595, 33.72971], [-118.04398, 33.72972], [-118.04391, 33.72969], [-118.0439, 33.72907], [-118.04415, 33.72896], [-118.04415, 33.72858], [-118.04461, 33.72858], [-118.04462, 33.72874], [-118.04481, 33.72873], [-118.04482, 33.72859], [-118.0449, 33.72859], [-118.04491, 33.72892], [-118.04501, 33.72893], [-118.04502, 33.72962], [-118.04595, 33.72962], [-118.04595, 33.72971]]]} | Open Access 1 | 1517 | Haven View Park | 19741 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/haven-view-park.cfm | Orange 3 | 2.961 | Haven View Park | 0 | Local Park 2 | 4 |
489 | 489 | 488 | {"type": "Polygon", "coordinates": [[[-117.98565, 33.69303], [-117.98466, 33.69303], [-117.98465, 33.69223], [-117.98564, 33.69223], [-117.98565, 33.69303]]]} | Open Access 1 | 1686 | Helme Park | 19809 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/helme-park.cfm | Orange 3 | 2.001 | Helme Park | 0 | Local Park 2 | 4 |
577 | 577 | 576 | {"type": "Polygon", "coordinates": [[[-117.99805, 33.66886], [-117.99804, 33.66848], [-117.99808, 33.66842], [-117.99819, 33.66832], [-117.99832, 33.66824], [-117.99846, 33.66819], [-117.99862, 33.66816], [-117.99885, 33.66818], [-117.99927, 33.66828], [-117.99968, 33.66832], [-118.00008, 33.66831], [-118.00047, 33.66825], [-118.00052, 33.66829], [-118.00068, 33.66868], [-118.00066, 33.66872], [-118.00061, 33.66874], [-118.00042, 33.66871], [-118.00025, 33.6687], [-118.0, 33.66874], [-117.99983, 33.66879], [-117.99953, 33.66895], [-117.99934, 33.66902], [-117.99913, 33.66907], [-117.99893, 33.66909], [-117.99872, 33.66908], [-117.99851, 33.66905], [-117.99832, 33.66899], [-117.99805, 33.66886]]]} | Open Access 1 | 3456 | Lake Park | 20959 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lake-park.cfm | Orange 3 | 4.224 | Lake Park | 0 | Local Park 2 | 4 |
580 | 580 | 579 | {"type": "Polygon", "coordinates": [[[-118.01718, 33.70818], [-118.01661, 33.70819], [-118.01657, 33.70552], [-118.01715, 33.70552], [-118.01718, 33.70818]]]} | Open Access 1 | 1928 | Hope View Park | 20087 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 3.924 | Hope View Park | 0 | Local Park 2 | 4 | |
599 | 599 | 598 | {"type": "MultiPolygon", "coordinates": [[[[-118.00637, 33.70704], [-118.00631, 33.70705], [-118.00632, 33.70813], [-118.00629, 33.70817], [-118.00622, 33.7082], [-118.00432, 33.70821], [-118.00429, 33.70711], [-118.00008, 33.70717], [-118.00006, 33.7058], [-118.0, 33.70579], [-117.99998, 33.70472], [-118.00005, 33.70471], [-118.00004, 33.70396], [-118.0008, 33.70395], [-118.00129, 33.70372], [-118.00219, 33.70362], [-118.00217, 33.70308], [-118.00194, 33.7031], [-118.00167, 33.70337], [-118.00136, 33.70337], [-118.00136, 33.70257], [-118.00183, 33.70257], [-118.00181, 33.70184], [-118.00233, 33.70183], [-118.00232, 33.70108], [-118.0, 33.70109], [-118.0, 33.70102], [-117.99993, 33.70101], [-117.99991, 33.69928], [-118.00249, 33.69926], [-118.00246, 33.69746], [-118.00199, 33.69746], [-118.00194, 33.69392], [-118.00332, 33.6939], [-118.00333, 33.69393], [-118.00343, 33.69393], [-118.00343, 33.6939], [-118.00618, 33.69387], [-118.0062, 33.69471], [-118.00613, 33.69472], [-118.00615, 33.6956], [-118.00621, 33.69561], [-118.00625, 33.69833], [-118.00618, 33.69834], [-118.00622, 33.70105], [-118.00629, 33.70581], [-118.00635, 33.70582], [-118.00637, 33.70704]], [[-118.00621, 33.70812], [-118.00622, 33.70811], [-118.00621, 33.70738], [-118.00561, 33.70738], [-118.0054, 33.70756], [-118.0054, 33.70812], [-118.00621, 33.70812]]], [[[-118.01501, 33.69733], [-118.01496, 33.69734], [-118.01498, 33.69916], [-118.01287, 33.69918], [-118.01286, 33.69895], [-118.01285, 33.69894], [-118.01201, 33.69947], [-118.01143, 33.69976], [-118.01071, 33.70021], [-118.01077, 33.70465], [-118.0066, 33.70468], [-118.00647, 33.69562], [-118.00641, 33.69561], [-118.00639, 33.6947], [-118.00646, 33.69469], [-118.00645, 33.69399], [-118.00648, 33.69392], [-118.00655, 33.6939], [-118.00844, 33.69388], [-118.00845, 33.69382], [-118.01044, 33.6938], [-118.01045, 33.69441], [-118.01052, 33.69442], [-118.01052, 33.6938], [-118.01269, 33.69378], [-118.0127, 33.6944], [-118.01172, 33.69441], [-118.01172, 33.69451], [-118.0127, 33.69451], [-118.01271, 33.69512], [-118.01173, 33.69513], [-118.01173, 33.69523], [-118.01271, 33.69523], [-118.01272, 33.69585], [-118.01174, 33.69586], [-118.01174, 33.69596], [-118.01272, 33.69596], [-118.01273, 33.69657], [-118.01174, 33.69659], [-118.01175, 33.69669], [-118.01273, 33.69668], [-118.01274, 33.6973], [-118.01176, 33.69731], [-118.01175, 33.69735], [-118.01283, 33.69735], [-118.01284, 33.69734], [-118.01279, 33.69378], [-118.01387, 33.69377], [-118.01389, 33.6938], [-118.01496, 33.69379], [-118.01501, 33.69733]], [[-118.01054, 33.69556], [-118.01054, 33.69526], [-118.01039, 33.69526], [-118.01038, 33.69556], [-118.01054, 33.69556]], [[-118.01046, 33.69513], [-118.01054, 33.69514], [-118.01052, 33.69453], [-118.01045, 33.69454], [-118.01046, 33.69513]]]]} | Open Access 1 | 2039 | Huntington Beach Central Park | 29219 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/huntington_central_park/ | Orange 3 | 345.196 | Huntington Beach Central Park | 0 | Local Park 2 | 4 |
661 | 661 | 660 | {"type": "Polygon", "coordinates": [[[-117.97795, 33.6865], [-117.97735, 33.6865], [-117.97731, 33.68648], [-117.97729, 33.68645], [-117.97724, 33.68366], [-117.97155, 33.68368], [-117.97154, 33.68313], [-117.97593, 33.68312], [-117.97593, 33.6831], [-117.97577, 33.68279], [-117.9757, 33.68275], [-117.97574, 33.68269], [-117.97575, 33.68258], [-117.9758, 33.68254], [-117.97637, 33.68253], [-117.97645, 33.68251], [-117.97653, 33.68245], [-117.97691, 33.68242], [-117.9778, 33.68241], [-117.9778, 33.68269], [-117.97786, 33.68274], [-117.97784, 33.68279], [-117.97784, 33.68285], [-117.9779, 33.68311], [-117.97795, 33.6865]]]} | Open Access 1 | 3264 | Lagenbeck Park | 20838 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lagenbeck-park.cfm | Orange 3 | 17.016 | Lagenbeck Park | 0 | Local Park 2 | 4 |
685 | 685 | 684 | {"type": "Polygon", "coordinates": [[[-117.98326, 33.71135], [-117.98321, 33.71147], [-117.98321, 33.71163], [-117.98315, 33.71163], [-117.98314, 33.71136], [-117.98153, 33.71137], [-117.98152, 33.71034], [-117.98171, 33.71018], [-117.98172, 33.71], [-117.9822, 33.70999], [-117.98218, 33.71108], [-117.98231, 33.7112], [-117.98314, 33.71121], [-117.98326, 33.71135]]]} | Open Access 1 | 3494 | Lake View Park | 20967 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lake-view-park.cfm | Orange 3 | 2.634 | Lake View Park | 0 | Local Park 2 | 4 |
787 | 787 | 786 | {"type": "Polygon", "coordinates": [[[-118.03115, 33.70861], [-118.03105, 33.70865], [-118.03101, 33.70868], [-118.03099, 33.70875], [-118.031, 33.7088], [-118.03105, 33.70887], [-118.03106, 33.70892], [-118.03108, 33.71], [-118.03053, 33.71023], [-118.03055, 33.71007], [-118.03063, 33.71005], [-118.03064, 33.70998], [-118.03061, 33.70997], [-118.03061, 33.70937], [-118.02998, 33.70937], [-118.03022, 33.70912], [-118.03041, 33.70888], [-118.03046, 33.70877], [-118.03048, 33.70864], [-118.03046, 33.70855], [-118.0304, 33.70847], [-118.03033, 33.70841], [-118.03032, 33.70837], [-118.03115, 33.70837], [-118.03115, 33.70861]]]} | Open Access 1 | 5126 | Marine View Park | 21850 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.794 | Marine View Park | 0 | Local Park 2 | 4 | |
866 | 866 | 865 | {"type": "Polygon", "coordinates": [[[-118.02397, 33.72238], [-118.0239, 33.72238], [-118.02391, 33.72252], [-118.02388, 33.72257], [-118.02382, 33.72259], [-118.02365, 33.7226], [-118.02365, 33.72265], [-118.0219, 33.72266], [-118.02187, 33.72052], [-118.02394, 33.72051], [-118.02397, 33.72238]]]} | Open Access 1 | 5602 | Carr Park | 16906 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/carr-park.cfm | Orange 3 | 11.205 | Carr Park | 0 | Local Park 2 | 4 |
912 | 912 | 911 | {"type": "Polygon", "coordinates": [[[-118.03256, 33.73135], [-118.03247, 33.73136], [-118.03249, 33.73247], [-118.03076, 33.73248], [-118.03071, 33.73028], [-118.03254, 33.73027], [-118.03256, 33.73135]]]} | Open Access 1 | 5831 | Marina Park | 21834 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/marina-park.cfm | Orange 3 | 9.968 | Marina Park | 0 | Local Park 2 | 4 |
1029 | 1029 | 1028 | {"type": "Polygon", "coordinates": [[[-118.02866, 33.75342], [-118.02769, 33.75342], [-118.02749, 33.75337], [-118.02741, 33.75339], [-118.02734, 33.75347], [-118.02707, 33.7534], [-118.02705, 33.75282], [-118.02729, 33.75282], [-118.02737, 33.75286], [-118.02739, 33.75291], [-118.02741, 33.75315], [-118.02825, 33.75314], [-118.02841, 33.75306], [-118.02866, 33.75306], [-118.02866, 33.75342]]]} | Open Access 1 | 5645 | Franklin Park | 19062 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 1.45 | Franklin Park | 0 | Local Park 2 | 4 | |
1067 | 1067 | 1066 | {"type": "Polygon", "coordinates": [[[-117.9777, 33.67712], [-117.97736, 33.67712], [-117.9772, 33.67696], [-117.9771, 33.67669], [-117.97696, 33.67661], [-117.97683, 33.67658], [-117.9756, 33.67659], [-117.97544, 33.67656], [-117.97563, 33.6763], [-117.97762, 33.6763], [-117.97766, 33.67633], [-117.97769, 33.67638], [-117.9777, 33.67712]]]} | Open Access 1 | 5659 | Newland Park | 22728 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/newland-park.cfm | Orange 3 | 2.247 | Newland Park | 0 | Local Park 2 | 4 |
1263 | 1263 | 1262 | {"type": "Polygon", "coordinates": [[[-117.98242, 33.69516], [-117.98239, 33.69516], [-117.9823, 33.69527], [-117.98222, 33.69532], [-117.98201, 33.69537], [-117.98202, 33.69595], [-117.98197, 33.69607], [-117.98188, 33.69619], [-117.98163, 33.69641], [-117.98125, 33.69685], [-117.98087, 33.69679], [-117.98052, 33.69764], [-117.98041, 33.69764], [-117.9804, 33.69668], [-117.98063, 33.69667], [-117.98063, 33.69652], [-117.98094, 33.69609], [-117.98103, 33.696], [-117.98122, 33.69573], [-117.98128, 33.6957], [-117.98163, 33.69572], [-117.98172, 33.69535], [-117.98182, 33.69533], [-117.98205, 33.69534], [-117.98221, 33.6953], [-117.98233, 33.6952], [-117.98238, 33.69512], [-117.9824, 33.69503], [-117.98242, 33.69504], [-117.98242, 33.69516]]]} | Open Access 1 | 5683 | Lambert Park | 20993 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/lambert-park.cfm | Orange 3 | 3.54 | Lambert Park | 0 | Local Park 2 | 4 |
1315 | 1315 | 1314 | {"type": "Polygon", "coordinates": [[[-118.03039, 33.70438], [-118.03038, 33.70442], [-118.03025, 33.70461], [-118.02969, 33.7044], [-118.02812, 33.70442], [-118.02812, 33.70402], [-118.02845, 33.70383], [-118.02854, 33.7039], [-118.02861, 33.70391], [-118.02886, 33.70387], [-118.02912, 33.70387], [-118.02928, 33.70388], [-118.0297, 33.70398], [-118.02989, 33.70406], [-118.03025, 33.70426], [-118.03039, 33.70438]]]} | Open Access 1 | 7379 | Bolsa View Park | 16249 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/bolsa-view-park.cfm | Orange 3 | 2.674 | Bolsa View Park | 0 | Local Park 2 | 4 |
1367 | 1367 | 1366 | {"type": "Polygon", "coordinates": [[[-118.0208, 33.74187], [-118.01992, 33.74188], [-118.01991, 33.7408], [-118.02002, 33.74079], [-118.02027, 33.74075], [-118.02078, 33.74074], [-118.0208, 33.74187]]]} | Open Access 1 | 11881 | Schroeder Park | 25194 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.483 | Schroeder Park | 0 | Local Park 2 | 4 | |
1396 | 1396 | 1395 | {"type": "Polygon", "coordinates": [[[-117.97577, 33.72084], [-117.97411, 33.72085], [-117.9741, 33.72107], [-117.97401, 33.72112], [-117.97398, 33.72121], [-117.97382, 33.72105], [-117.97371, 33.72092], [-117.97358, 33.72067], [-117.97355, 33.72054], [-117.97409, 33.72051], [-117.97576, 33.72048], [-117.97577, 33.72084]]]} | Open Access 1 | 8637 | Pleasant View Park | 23803 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 2.117 | Pleasant View Park | 0 | Local Park 2 | 4 | |
1683 | 1683 | 1682 | {"type": "Polygon", "coordinates": [[[-117.94628, 33.67622], [-117.94628, 33.6763], [-117.94625, 33.67634], [-117.94616, 33.67636], [-117.94592, 33.67638], [-117.94564, 33.67662], [-117.94522, 33.67792], [-117.94463, 33.67779], [-117.94518, 33.67613], [-117.94576, 33.67624], [-117.94576, 33.67627], [-117.94615, 33.67622], [-117.9462, 33.67616], [-117.94628, 33.67622]]]} | Open Access 1 | 14568 | Arevalos Park | 15580 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/arevalos-park.cfm | Orange 3 | 2.89 | Arevalos 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]);