units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1, LAYER = 4, MNG_AGENCY = 631 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Midpeninsula Regional Open Space District · 2 ✖
DES_TP 1
ACCESS_TYP 1
- Open Access · 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15876 | 15876 | 15875 | {"type": "Polygon", "coordinates": [[[-122.19788, 37.31259], [-122.19734, 37.31318], [-122.19634, 37.31243], [-122.19512, 37.31263], [-122.19479, 37.31321], [-122.19457, 37.31393], [-122.19651, 37.31469], [-122.19637, 37.31486], [-122.19649, 37.31511], [-122.19677, 37.31531], [-122.19678, 37.31573], [-122.19699, 37.31607], [-122.19696, 37.31612], [-122.19657, 37.31632], [-122.19604, 37.31634], [-122.19587, 37.31666], [-122.19566, 37.31687], [-122.19547, 37.31683], [-122.19504, 37.31651], [-122.19456, 37.31658], [-122.19444, 37.31652], [-122.1943, 37.31618], [-122.19402, 37.31611], [-122.19386, 37.31614], [-122.19376, 37.31639], [-122.19367, 37.31649], [-122.19352, 37.31645], [-122.19297, 37.31617], [-122.19267, 37.31617], [-122.1924, 37.31599], [-122.19242, 37.31584], [-122.1924, 37.31566], [-122.19229, 37.31555], [-122.19188, 37.31533], [-122.19124, 37.31537], [-122.19108, 37.31511], [-122.19086, 37.31497], [-122.19074, 37.31469], [-122.19023, 37.31457], [-122.18987, 37.31438], [-122.18816, 37.31498], [-122.18749, 37.315], [-122.18738, 37.31497], [-122.18716, 37.31473], [-122.18694, 37.31453], [-122.18666, 37.31432], [-122.18635, 37.31414], [-122.18605, 37.314], [-122.18567, 37.31385], [-122.18536, 37.31377], [-122.18499, 37.31369], [-122.18473, 37.31366], [-122.18435, 37.31364], [-122.18402, 37.31365], [-122.1837, 37.31368], [-122.18339, 37.31373], [-122.18304, 37.31382], [-122.18235, 37.31408], [-122.18218, 37.31413], [-122.18202, 37.31415], [-122.18185, 37.31415], [-122.18169, 37.31413], [-122.18152, 37.31408], [-122.18138, 37.31402], [-122.18124, 37.31394], [-122.18112, 37.31383], [-122.18102, 37.3137], [-122.18095, 37.31354], [-122.18089, 37.31323], [-122.18082, 37.31301], [-122.18075, 37.31285], [-122.18063, 37.3127], [-122.18051, 37.31258], [-122.18031, 37.31246], [-122.18015, 37.31239], [-122.17991, 37.31233], [-122.17962, 37.31231], [-122.17935, 37.31234], [-122.17781, 37.31279], [-122.17738, 37.31287], [-122.17706, 37.31289], [-122.17675, 37.31288], [-122.17648, 37.31285], [-122.17618, 37.31278], [-122.17593, 37.3127], [-122.17573, 37.31262], [-122.1689, 37.30948], [-122.16861, 37.30882], [-122.16854, 37.30873], [-122.16853, 37.30874], [-122.16885, 37.30946], [-122.16864, 37.30934], [-122.16845, 37.3092], [-122.1683, 37.30904], [-122.16818, 37.30885], [-122.1681, 37.30866], [-122.1679, 37.30805], [-122.16775, 37.30774], [-122.16757, 37.30745], [-122.16734, 37.30717], [-122.16709, 37.30691], [-122.1668, 37.30667], [-122.16649, 37.30645], [-122.16615, 37.30626], [-122.1658, 37.30609], [-122.1647, 37.30564], [-122.16457, 37.30564], [-122.1638, 37.30531], [-122.16355, 37.30517], [-122.16335, 37.30503], [-122.16319, 37.3049], [-122.16299, 37.3047], [-122.16275, 37.3044], [-122.16257, 37.30408], [-122.16232, 37.30354], [-122.16236, 37.30345], [-122.16177, 37.30214], [-122.1617, 37.30195], [-122.16167, 37.30177], [-122.16168, 37.30157], [-122.16173, 37.30137], [-122.16182, 37.30118], [-122.16195, 37.30101], [-122.16211, 37.30085], [-122.1627, 37.30046], [-122.16285, 37.30032], [-122.16298, 37.30017], [-122.16307, 37.29999], [-122.16307, 37.29997], [-122.16314, 37.29972], [-122.16316, 37.29942], [-122.16321, 37.29928], [-122.16328, 37.29915], [-122.16337, 37.29902], [-122.16348, 37.29892], [-122.16388, 37.29868], [-122.16411, 37.29849], [-122.1643, 37.29824], [-122.16443, 37.298], [-122.16449, 37.29777], [-122.16451, 37.2975], [-122.16447, 37.29723], [-122.16437, 37.29703], [-122.16432, 37.29682], [-122.1643, 37.29655], [-122.16434, 37.29634], [-122.1644, 37.29617], [-122.1646, 37.29576], [-122.16464, 37.29576], [-122.16465, 37.29574], [-122.16513, 37.29555], [-122.16485, 37.29499], [-122.16477, 37.29476], [-122.16466, 37.29454], [-122.16451, 37.29434], [-122.16619, 37.29509], [-122.16883, 37.29411], [-122.1707, 37.29412], [-122.17077, 37.29059], [-122.17083, 37.28873], [-122.17105, 37.28877], [-122.17118, 37.28884], [-122.17169, 37.28899], [-122.1719, 37.28903], [-122.17229, 37.28917], [-122.17248, 37.28923], [-122.17283, 37.28939], [-122.17312, 37.28948], [-122.17327, 37.28955], [-122.17366, 37.28969], [-122.1738, 37.28975], [-122.17391, 37.28983], [-122.17401, 37.28985], [-122.17445, 37.28985], [-122.1746, 37.28979], [-122.17505, 37.28971], [-122.17562, 37.28952], [-122.17575, 37.28939], [-122.17585, 37.28935], [-122.17598, 37.28933], [-122.17636, 37.28934], [-122.17675, 37.2893], [-122.1772, 37.28932], [-122.1773, 37.28934], [-122.17737, 37.2894], [-122.17744, 37.28942], [-122.1776, 37.28944], [-122.17776, 37.28944], [-122.1779, 37.28948], [-122.17824, 37.28975], [-122.17849, 37.2899], [-122.17871, 37.29014], [-122.17886, 37.29027], [-122.17904, 37.29034], [-122.17943, 37.29039], [-122.17929, 37.29238], [-122.18765, 37.29745], [-122.18733, 37.30127], [-122.18704, 37.30506], [-122.19623, 37.30499], [-122.19621, 37.3058], [-122.19332, 37.3058], [-122.19331, 37.30581], [-122.19403, 37.30612], [-122.19456, 37.30706], [-122.19516, 37.30775], [-122.1957, 37.3087], [-122.19737, 37.30869], [-122.19748, 37.30942], [-122.1975, 37.31059], [-122.1978, 37.31136], [-122.19783, 37.31155], [-122.19777, 37.31174], [-122.19766, 37.31193], [-122.19761, 37.31214], [-122.19781, 37.31241], [-122.19788, 37.31259]], [[-122.17642, 37.29416], [-122.1707, 37.29412], [-122.1696, 37.30123], [-122.17866, 37.30117], [-122.17916, 37.29419], [-122.17642, 37.29416]]]} | Open Access 1 | 581 | Skyline Ridge Open Space Preserve | 29302 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_skyline_ridge.asp | San Mateo 15 | 1148.046 | Skyline Ridge OSP | 2000 | Local Conservation Area 4 | 2 |
15898 | 15898 | 15897 | {"type": "Polygon", "coordinates": [[[-122.34004, 37.40028], [-122.34001, 37.40309], [-122.33477, 37.40313], [-122.33473, 37.40325], [-122.33446, 37.40377], [-122.33442, 37.40431], [-122.33426, 37.40449], [-122.33396, 37.40474], [-122.33387, 37.40485], [-122.33378, 37.40499], [-122.33373, 37.4051], [-122.33366, 37.40538], [-122.33358, 37.40558], [-122.33319, 37.40631], [-122.33316, 37.40646], [-122.33316, 37.40682], [-122.33314, 37.4069], [-122.33309, 37.40698], [-122.33304, 37.40702], [-122.33295, 37.40703], [-122.33287, 37.40712], [-122.33275, 37.40729], [-122.33267, 37.40745], [-122.33261, 37.4077], [-122.33261, 37.40794], [-122.33269, 37.40818], [-122.33282, 37.40836], [-122.33295, 37.40861], [-122.33325, 37.40907], [-122.33389, 37.40887], [-122.33436, 37.41099], [-122.33371, 37.41089], [-122.33346, 37.41069], [-122.33324, 37.41102], [-122.33325, 37.41135], [-122.33296, 37.41151], [-122.33281, 37.41168], [-122.33267, 37.41169], [-122.33254, 37.41198], [-122.33251, 37.41222], [-122.33255, 37.41236], [-122.33271, 37.41253], [-122.33275, 37.41264], [-122.33274, 37.41294], [-122.33269, 37.41319], [-122.3326, 37.41343], [-122.33245, 37.41369], [-122.33235, 37.41379], [-122.332, 37.41407], [-122.33196, 37.41414], [-122.33193, 37.41424], [-122.33194, 37.41434], [-122.33198, 37.41444], [-122.3323, 37.41488], [-122.33251, 37.41509], [-122.33254, 37.41517], [-122.33254, 37.41526], [-122.33251, 37.41532], [-122.33221, 37.41578], [-122.33207, 37.41606], [-122.33198, 37.41615], [-122.33174, 37.4163], [-122.33165, 37.41642], [-122.3316, 37.41653], [-122.32938, 37.41499], [-122.32929, 37.41505], [-122.32912, 37.41537], [-122.32885, 37.41554], [-122.32786, 37.41572], [-122.3253, 37.41489], [-122.32516, 37.41521], [-122.32456, 37.41599], [-122.32421, 37.41631], [-122.3238, 37.41705], [-122.32268, 37.4167], [-122.32207, 37.41658], [-122.3218, 37.41707], [-122.3206, 37.41702], [-122.32027, 37.41792], [-122.31934, 37.41829], [-122.31928, 37.41807], [-122.31913, 37.41782], [-122.31894, 37.41762], [-122.31869, 37.41745], [-122.31848, 37.41734], [-122.31818, 37.41724], [-122.31793, 37.41718], [-122.3175, 37.41713], [-122.31728, 37.41707], [-122.31713, 37.41701], [-122.31511, 37.41591], [-122.31529, 37.4157], [-122.31529, 37.41569], [-122.31501, 37.41554], [-122.31482, 37.41576], [-122.31078, 37.41359], [-122.31049, 37.41346], [-122.31028, 37.41341], [-122.31001, 37.41336], [-122.3096, 37.41335], [-122.30905, 37.41342], [-122.30869, 37.4134], [-122.30842, 37.41334], [-122.30821, 37.41326], [-122.30792, 37.41309], [-122.30777, 37.41297], [-122.30687, 37.41204], [-122.30684, 37.41188], [-122.30672, 37.41166], [-122.30671, 37.41131], [-122.30682, 37.41113], [-122.30703, 37.4109], [-122.30696, 37.41083], [-122.30736, 37.41062], [-122.3076, 37.41035], [-122.30761, 37.41028], [-122.30733, 37.4099], [-122.3075, 37.40969], [-122.3076, 37.40952], [-122.30768, 37.40934], [-122.30775, 37.40912], [-122.30779, 37.40856], [-122.3077, 37.4081], [-122.30764, 37.40791], [-122.30747, 37.40759], [-122.30716, 37.40718], [-122.30694, 37.40698], [-122.30642, 37.40663], [-122.30639, 37.40663], [-122.30597, 37.40645], [-122.30346, 37.40563], [-122.30319, 37.40552], [-122.30293, 37.4054], [-122.30259, 37.40519], [-122.30037, 37.40364], [-122.30138, 37.4027], [-122.29988, 37.40126], [-122.29987, 37.40127], [-122.29989, 37.4021], [-122.29924, 37.40284], [-122.29882, 37.40255], [-122.29853, 37.40228], [-122.29835, 37.40208], [-122.29816, 37.40182], [-122.2979, 37.40133], [-122.29777, 37.40115], [-122.29754, 37.40092], [-122.29713, 37.40062], [-122.29682, 37.40043], [-122.29656, 37.40029], [-122.29621, 37.40015], [-122.29585, 37.40002], [-122.29547, 37.39993], [-122.29517, 37.39987], [-122.29478, 37.39982], [-122.29441, 37.3998], [-122.29407, 37.3997], [-122.29382, 37.39956], [-122.29313, 37.39898], [-122.29304, 37.39886], [-122.29297, 37.39871], [-122.29296, 37.39856], [-122.29298, 37.39843], [-122.29305, 37.39829], [-122.29311, 37.3982], [-122.29321, 37.39812], [-122.29372, 37.39781], [-122.29383, 37.39772], [-122.29394, 37.39759], [-122.29401, 37.39742], [-122.29402, 37.39722], [-122.29387, 37.39653], [-122.29382, 37.39639], [-122.29372, 37.39623], [-122.29587, 37.39619], [-122.29585, 37.39109], [-122.29595, 37.39118], [-122.29663, 37.39099], [-122.29716, 37.39094], [-122.29746, 37.39074], [-122.29819, 37.39055], [-122.29833, 37.39046], [-122.29847, 37.39028], [-122.29854, 37.39011], [-122.29852, 37.3897], [-122.29834, 37.38945], [-122.29816, 37.38933], [-122.29773, 37.38926], [-122.29769, 37.38896], [-122.29766, 37.38896], [-122.29782, 37.38883], [-122.29795, 37.38853], [-122.29783, 37.3878], [-122.29806, 37.38708], [-122.29802, 37.38696], [-122.2979, 37.3868], [-122.29758, 37.38666], [-122.29744, 37.38665], [-122.29731, 37.3867], [-122.29716, 37.38669], [-122.29709, 37.38663], [-122.29695, 37.38657], [-122.29672, 37.38661], [-122.2963, 37.38639], [-122.29615, 37.38628], [-122.29608, 37.38605], [-122.29578, 37.38587], [-122.29576, 37.38524], [-122.29576, 37.38315], [-122.29578, 37.38159], [-122.30464, 37.38151], [-122.30466, 37.38209], [-122.30893, 37.38205], [-122.30893, 37.38077], [-122.3125, 37.38216], [-122.31453, 37.38243], [-122.31631, 37.38247], [-122.31637, 37.38129], [-122.31705, 37.38149], [-122.31705, 37.38175], [-122.31659, 37.38217], [-122.31649, 37.38251], [-122.31651, 37.38252], [-122.31736, 37.38213], [-122.31767, 37.38195], [-122.31806, 37.38203], [-122.31919, 37.38209], [-122.31952, 37.38213], [-122.32055, 37.3824], [-122.32127, 37.38218], [-122.32174, 37.38172], [-122.32207, 37.38169], [-122.32238, 37.38154], [-122.32295, 37.38151], [-122.32334, 37.38131], [-122.32776, 37.38132], [-122.32805, 37.381], [-122.33171, 37.38537], [-122.33066, 37.38539], [-122.3313, 37.38642], [-122.33201, 37.38693], [-122.332, 37.38766], [-122.33199, 37.38769], [-122.33196, 37.38771], [-122.33184, 37.38773], [-122.33172, 37.38779], [-122.33157, 37.38793], [-122.33129, 37.3879], [-122.33105, 37.38795], [-122.33089, 37.38804], [-122.33076, 37.38819], [-122.33072, 37.38829], [-122.3307, 37.38839], [-122.33071, 37.38847], [-122.33076, 37.38864], [-122.33074, 37.38889], [-122.33076, 37.38922], [-122.33073, 37.3893], [-122.33067, 37.38936], [-122.33062, 37.38938], [-122.33039, 37.38943], [-122.33003, 37.38943], [-122.32986, 37.3894], [-122.32971, 37.38932], [-122.32959, 37.38929], [-122.32944, 37.38929], [-122.32925, 37.38932], [-122.32921, 37.3893], [-122.32915, 37.38922], [-122.32903, 37.38915], [-122.3289, 37.3891], [-122.32878, 37.3891], [-122.32867, 37.38911], [-122.32856, 37.38915], [-122.32803, 37.38948], [-122.32792, 37.39016], [-122.32794, 37.39028], [-122.32802, 37.3904], [-122.32812, 37.39046], [-122.32827, 37.39051], [-122.32838, 37.39052], [-122.32897, 37.39048], [-122.3293, 37.3905], [-122.32941, 37.39054], [-122.32951, 37.3906], [-122.3296, 37.39068], [-122.32967, 37.39079], [-122.32971, 37.3909], [-122.3297, 37.39104], [-122.32972, 37.39112], [-122.32977, 37.39123], [-122.32985, 37.39131], [-122.33069, 37.39197], [-122.33129, 37.39206], [-122.33137, 37.3921], [-122.33139, 37.39217], [-122.33134, 37.39228], [-122.33132, 37.39241], [-122.33137, 37.3928], [-122.33145, 37.39292], [-122.33162, 37.39302], [-122.33165, 37.39307], [-122.33163, 37.39314], [-122.33144, 37.39331], [-122.3314, 37.39359], [-122.33077, 37.39395], [-122.33058, 37.3942], [-122.33048, 37.39422], [-122.33035, 37.39426], [-122.33027, 37.39431], [-122.33019, 37.39439], [-122.33014, 37.39451], [-122.33014, 37.39465], [-122.33018, 37.39474], [-122.33034, 37.39495], [-122.33021, 37.39513], [-122.32982, 37.39546], [-122.33002, 37.39579], [-122.33003, 37.39586], [-122.33, 37.39589], [-122.32995, 37.39591], [-122.32941, 37.396], [-122.32931, 37.39605], [-122.32922, 37.39613], [-122.32916, 37.39622], [-122.32913, 37.39631], [-122.32912, 37.39663], [-122.32916, 37.39676], [-122.32924, 37.39685], [-122.32937, 37.39692], [-122.32954, 37.39698], [-122.32968, 37.397], [-122.3299, 37.39697], [-122.33012, 37.39687], [-122.33082, 37.39685], [-122.33101, 37.39682], [-122.33121, 37.39674], [-122.33138, 37.39662], [-122.33147, 37.39651], [-122.33169, 37.39611], [-122.33205, 37.39624], [-122.3323, 37.39599], [-122.33232, 37.39596], [-122.33237, 37.39595], [-122.33253, 37.39634], [-122.33286, 37.39648], [-122.33286, 37.39663], [-122.33323, 37.39711], [-122.33308, 37.39738], [-122.33306, 37.39769], [-122.33308, 37.39777], [-122.33314, 37.39784], [-122.3332, 37.39788], [-122.33328, 37.3979], [-122.33344, 37.3979], [-122.33356, 37.39784], [-122.33364, 37.39774], [-122.3337, 37.3977], [-122.33385, 37.39766], [-122.33398, 37.39767], [-122.33414, 37.39777], [-122.33429, 37.39781], [-122.33446, 37.3978], [-122.33461, 37.39773], [-122.33463, 37.39773], [-122.33466, 37.39776], [-122.33473, 37.3979], [-122.33474, 37.39805], [-122.33472, 37.39818], [-122.33456, 37.39851], [-122.33455, 37.39862], [-122.33458, 37.39873], [-122.33466, 37.39886], [-122.33478, 37.39895], [-122.33485, 37.39898], [-122.33515, 37.39906], [-122.33518, 37.39908], [-122.33526, 37.39938], [-122.33544, 37.39966], [-122.33541, 37.4], [-122.3353, 37.40018], [-122.33527, 37.40025], [-122.33527, 37.40034], [-122.33529, 37.40042], [-122.33534, 37.40049], [-122.33546, 37.40061], [-122.33551, 37.4008], [-122.33561, 37.40095], [-122.33576, 37.40105], [-122.33605, 37.40115], [-122.33614, 37.40122], [-122.33618, 37.40133], [-122.33619, 37.40158], [-122.33623, 37.40164], [-122.3363, 37.40168], [-122.33641, 37.40168], [-122.33657, 37.40162], [-122.33667, 37.40161], [-122.33722, 37.40172], [-122.33774, 37.40155], [-122.33798, 37.40155], [-122.3381, 37.40152], [-122.33822, 37.40144], [-122.33827, 37.40138], [-122.33829, 37.4013], [-122.3383, 37.40097], [-122.3382, 37.40067], [-122.33822, 37.40063], [-122.33845, 37.40054], [-122.33866, 37.40039], [-122.33884, 37.40039], [-122.33894, 37.40037], [-122.33903, 37.40033], [-122.33917, 37.40022], [-122.33928, 37.40018], [-122.33943, 37.40018], [-122.34004, 37.40028]], [[-122.33264, 37.40918], [-122.33246, 37.40888], [-122.33201, 37.40856], [-122.33196, 37.40874], [-122.33225, 37.40896], [-122.3321, 37.40929], [-122.33224, 37.40955], [-122.33195, 37.40968], [-122.33206, 37.41004], [-122.33146, 37.41045], [-122.33146, 37.41046], [-122.33338, 37.41024], [-122.33342, 37.41002], [-122.33342, 37.40994], [-122.33264, 37.40918]]]} | Open Access 1 | 8871 | El Corte de Madera Creek Open Space Preserve | 28199 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_ecdm.asp | San Mateo 15 | 2687.638 | El Corte de Madera Creek OSP | 2000 | Local Conservation Area 4 | 2 |
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]);