{ "currentVersion": 10.71, "id": 15, "name": "GIS_Publication.DBO.STREET_DICT", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ST_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "STREET_ID", "type": "esriFieldTypeInteger", "alias": "STREET_ID", "domain": null }, { "name": "DUP_STREET_ID", "type": "esriFieldTypeInteger", "alias": "DUP_STREET_ID", "domain": null }, { "name": "FEATURE_KEY", "type": "esriFieldTypeInteger", "alias": "FEATURE_KEY", "domain": null }, { "name": "METAPHONE", "type": "esriFieldTypeString", "alias": "METAPHONE", "length": 50, "domain": null }, { "name": "PRE_MOD", "type": "esriFieldTypeString", "alias": "PreModifier", "length": 20, "domain": { "type": "codedValue", "name": "PreMod", "description": "PreMod", "codedValues": [ { "name": "Ramp", "code": "RAMP" }, { "name": "Access", "code": "ACCESS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRE_DIR", "type": "esriFieldTypeString", "alias": "PreDir", "length": 10, "domain": { "type": "codedValue", "name": "PreDir", "description": "PreDir", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PRE_TYPE", "type": "esriFieldTypeString", "alias": "PreType", "length": 20, "domain": { "type": "codedValue", "name": "PreType", "description": "PreType", "codedValues": [ { "name": "County Highway", "code": "COUNTY HWY" }, { "name": "County Road", "code": "COUNTY RD" }, { "name": "Frontage Road", "code": "FRONTAGE RD" }, { "name": "Highway", "code": "HWY" }, { "name": "Interstate", "code": "I" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ST_NAME", "type": "esriFieldTypeString", "alias": "StreetName", "length": 50, "domain": null }, { "name": "ST_TYPE", "type": "esriFieldTypeString", "alias": "StreetType", "length": 20, "domain": { "type": "codedValue", "name": "StreetType", "description": "StreetType", "codedValues": [ { "name": "Avenue", "code": "AVE" }, { "name": "Boulevard", "code": "BLVD" }, { "name": "Circle", "code": "CIR" }, { "name": "Court", "code": "CT" }, { "name": "Drive", "code": "DR" }, { "name": "Highway", "code": "HWY" }, { "name": "Lane", "code": "LN" }, { "name": "Parkway", "code": "PKWY" }, { "name": "Place", "code": "PL" }, { "name": "Road", "code": "RD" }, { "name": "Street", "code": "ST" }, { "name": "Interstate", "code": "I" }, { "name": "Way", "code": "WAY" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POST_DIR", "type": "esriFieldTypeString", "alias": "PostDir", "length": 10, "domain": { "type": "codedValue", "name": "PostDir", "description": "PostDir", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "POST_MOD", "type": "esriFieldTypeString", "alias": "PostModifier", "length": 20, "domain": { "type": "codedValue", "name": "PostMod", "description": "PostMod", "codedValues": [ { "name": "Ramp", "code": "RAMP" }, { "name": "Access", "code": "ACCESS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 50, "domain": { "type": "codedValue", "name": "Community", "description": "Community", "codedValues": [ { "name": "Rochester", "code": "ROCHESTER" }, { "name": "Byron", "code": "BYRON" }, { "name": "Chatfield", "code": "CHATFIELD" }, { "name": "Dexter", "code": "DEXTER" }, { "name": "Dover", "code": "DOVER" }, { "name": "Elgin", "code": "ELGIN" }, { "name": "Eyota", "code": "EYOTA" }, { "name": "Hayfield", "code": "HAYFIELD" }, { "name": "Kasson", "code": "KASSON" }, { "name": "Mantorville", "code": "MANTORVILLE" }, { "name": "Mazeppa", "code": "MAZEPPA" }, { "name": "Oronoco", "code": "ORONOCO" }, { "name": "Pine Island", "code": "PINE ISLAND" }, { "name": "Plainview", "code": "PLAINVIEW" }, { "name": "Saint Charles", "code": "ST CHARLES" }, { "name": "Sargeant", "code": "SARGEANT" }, { "name": "Stewartville", "code": "STEWARTVILLE" }, { "name": "Zumbro Falls", "code": "ZUMBRO FALLS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "length": 25, "domain": { "type": "codedValue", "name": "County", "description": "County", "codedValues": [ { "name": "Olmsted", "code": "OLMSTED" }, { "name": "Dodge", "code": "DODGE" }, { "name": "Goodhue", "code": "GOODHUE" }, { "name": "Wabasha", "code": "WABASHA" }, { "name": "Winona", "code": "WINONA" }, { "name": "Fillmore", "code": "FILLMORE" }, { "name": "Mower", "code": "MOWER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "length": 2, "domain": { "type": "codedValue", "name": "State", "description": "State", "codedValues": [ { "name": "Minnesota", "code": "MN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EFF_STATUS", "type": "esriFieldTypeString", "alias": "EffectiveStatus", "length": 20, "domain": { "type": "codedValue", "name": "EffectiveStatus_StreetName", "description": "Effective Status for Street Name", "codedValues": [ { "name": "Active", "code": "A" }, { "name": "Retired", "code": "R" }, { "name": "Reserved", "code": "RS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ALIAS_ONLY", "type": "esriFieldTypeString", "alias": "AliasOnly", "length": 1, "domain": { "type": "codedValue", "name": "YesNo", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 2000, "domain": null }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "EDIT_USER", "type": "esriFieldTypeString", "alias": "EditUser", "length": 50, "domain": { "type": "codedValue", "name": "EditUser_4", "description": "EditUser", "codedValues": [ { "name": "Janice K. Chezick", "code": "plajchez" }, { "name": "David F. Wittman", "code": "pladwitt" }, { "name": "Jennifer L. Rand-Weaver", "code": "plajrand" }, { "name": "Mary E. Sheehan", "code": "plamshee" }, { "name": "Initial", "code": "INITIAL" }, { "name": "Gregory Baugher", "code": "oc09592" }, { "name": "Steven Wolf", "code": "oc09624" }, { "name": "David McCollister", "code": "oc09745" }, { "name": "Teresa R. Blader", "code": "oc10020" }, { "name": "Hannah Hutchins", "code": "oc09979" }, { "name": "Adam Nowinski", "code": "oc10168" }, { "name": "Randy S. Growdon", "code": "plargrow" }, { "name": "Greg Keith", "code": "oc10367" }, { "name": "Bruce A. Whetstone", "code": "plabwhet" }, { "name": "Skylar L. Schoh", "code": "OC10583" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EDIT_REASN", "type": "esriFieldTypeString", "alias": "ReasonForEdit", "length": 50, "domain": { "type": "codedValue", "name": "ReasonForEdit_StreetName", "description": "ReasonForEdit_StreetName", "codedValues": [ { "name": "New", "code": "NEW" }, { "name": "Initial Data Load", "code": "INITIAL" }, { "name": "Attribute Update", "code": "ATTU" }, { "name": "Retired", "code": "R" }, { "name": "Reserve", "code": "RS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FULL_NAME", "type": "esriFieldTypeString", "alias": "CompleteStreetName", "length": 500, "domain": null }, { "name": "ENFORCE_VALIDATION", "type": "esriFieldTypeString", "alias": "EnforceValidation", "length": 1, "domain": { "type": "codedValue", "name": "YesNo", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "JOIN_ID", "type": "esriFieldTypeInteger", "alias": "JoinID", "domain": null }, { "name": "SOURCE_ID", "type": "esriFieldTypeInteger", "alias": "SOURCE_ID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R708_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_708", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I3274METAPHONE", "fields": "METAPHONE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I3274FEATURE_KEY", "fields": "FEATURE_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I3274STREET_ID", "fields": "STREET_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_708", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }