{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 16, "name": "STREET_DICT", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "CENTERLINES", "relatedTableId": 2, "cardinality": "esriRelCardinalityManyToMany", "role": "esriRelRoleDestination", "keyField": "STREET_ID", "composite": false, "relationshipTableId": 17, "keyFieldInRelationshipTable": "STREET_ID" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "ST_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "STREET_ID", "type": "esriFieldTypeInteger", "alias": "STREET_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "STREET_ID" }, { "name": "DUP_STREET_ID", "type": "esriFieldTypeInteger", "alias": "DUP_STREET_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DUP_STREET_ID" }, { "name": "FEATURE_KEY", "type": "esriFieldTypeInteger", "alias": "FEATURE_KEY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FEATURE_KEY" }, { "name": "METAPHONE", "type": "esriFieldTypeString", "alias": "METAPHONE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "METAPHONE" }, { "name": "PRE_MOD", "type": "esriFieldTypeString", "alias": "PreModifier", "domain": { "type": "codedValue", "name": "PreMod", "description": "PreMod", "codedValues": [ { "name": "Ramp", "code": "RAMP" }, { "name": "Access", "code": "ACCESS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PRE_MOD" }, { "name": "PRE_DIR", "type": "esriFieldTypeString", "alias": "PreDir", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PRE_DIR" }, { "name": "PRE_TYPE", "type": "esriFieldTypeString", "alias": "PreType", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PRE_TYPE" }, { "name": "ST_NAME", "type": "esriFieldTypeString", "alias": "StreetName", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ST_NAME" }, { "name": "ST_TYPE", "type": "esriFieldTypeString", "alias": "StreetType", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ST_TYPE" }, { "name": "POST_DIR", "type": "esriFieldTypeString", "alias": "PostDir", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "POST_DIR" }, { "name": "POST_MOD", "type": "esriFieldTypeString", "alias": "PostModifier", "domain": { "type": "codedValue", "name": "PostMod", "description": "PostMod", "codedValues": [ { "name": "Ramp", "code": "RAMP" }, { "name": "Access", "code": "ACCESS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "POST_MOD" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CITY" }, { "name": "COUNTY", "type": "esriFieldTypeString", "alias": "County", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "COUNTY" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "domain": { "type": "codedValue", "name": "State", "description": "State", "codedValues": [ { "name": "Minnesota", "code": "MN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": "MN", "modelName": "STATE" }, { "name": "EFF_STATUS", "type": "esriFieldTypeString", "alias": "EffectiveStatus", "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" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EFF_STATUS" }, { "name": "ALIAS_ONLY", "type": "esriFieldTypeString", "alias": "AliasOnly", "domain": { "type": "codedValue", "name": "YesNo", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "ALIAS_ONLY" }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "COMMENT" }, { "name": "EDIT_DATE", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDIT_DATE" }, { "name": "EDIT_USER", "type": "esriFieldTypeString", "alias": "EditUser", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDIT_USER" }, { "name": "EDIT_REASN", "type": "esriFieldTypeString", "alias": "ReasonForEdit", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "EDIT_REASN" }, { "name": "FULL_NAME", "type": "esriFieldTypeString", "alias": "CompleteStreetName", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "FULL_NAME" }, { "name": "ENFORCE_VALIDATION", "type": "esriFieldTypeString", "alias": "EnforceValidation", "domain": { "type": "codedValue", "name": "YesNo", "description": "YesNo", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "Y", "modelName": "ENFORCE_VALIDATION" }, { "name": "JOIN_ID", "type": "esriFieldTypeInteger", "alias": "JoinID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JOIN_ID" }, { "name": "SOURCE_ID", "type": "esriFieldTypeInteger", "alias": "SOURCE_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SOURCE_ID" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R832_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_832", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I15699METAPHONE", "fields": "METAPHONE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I15699FEATURE_KE", "fields": "FEATURE_KEY", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I15699STREET_ID", "fields": "STREET_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_832", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "STREET_DICT", "description": "", "prototype": { "attributes": { "SOURCE_ID": null, "JOIN_ID": null, "STREET_ID": null, "DUP_STREET_ID": null, "FEATURE_KEY": null, "METAPHONE": null, "PRE_MOD": null, "PRE_DIR": null, "PRE_TYPE": null, "ST_NAME": null, "ST_TYPE": null, "POST_DIR": null, "POST_MOD": null, "CITY": null, "COUNTY": null, "STATE": "MN", "EFF_STATUS": null, "ALIAS_ONLY": "N", "COMMENT": null, "EDIT_DATE": null, "EDIT_USER": null, "EDIT_REASN": null, "FULL_NAME": null, "ENFORCE_VALIDATION": "Y" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }