{ "currentVersion": 10.61, "cimVersion": "2.2.0", "id": 6, "name": "Mailaddress", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "MAD_MAIL_NAME1", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MAD_MNC", "type": "esriFieldTypeInteger", "alias": "MAD_MNC", "domain": null }, { "name": "MAD_OWN_ID", "type": "esriFieldTypeInteger", "alias": "MAD_OWN_ID", "domain": null }, { "name": "MAD_LINE_NUM", "type": "esriFieldTypeInteger", "alias": "MAD_LINE_NUM", "domain": null }, { "name": "MAD_ADR_TYPE", "type": "esriFieldTypeString", "alias": "MAD_ADR_TYPE", "length": 6, "domain": null }, { "name": "MAD_MAIL_NAME1", "type": "esriFieldTypeString", "alias": "MAD_MAIL_NAME1", "length": 85, "domain": null }, { "name": "MAD_MAIL_NAME2", "type": "esriFieldTypeString", "alias": "MAD_MAIL_NAME2", "length": 85, "domain": null }, { "name": "MAD_CO_LINE", "type": "esriFieldTypeString", "alias": "MAD_CO_LINE", "length": 85, "domain": null }, { "name": "MAD_MAIL_ADDR1", "type": "esriFieldTypeString", "alias": "MAD_MAIL_ADDR1", "length": 50, "domain": null }, { "name": "MAD_MAIL_CITY", "type": "esriFieldTypeString", "alias": "MAD_MAIL_CITY", "length": 30, "domain": null }, { "name": "MAD_MAIL_STATE", "type": "esriFieldTypeString", "alias": "MAD_MAIL_STATE", "length": 20, "domain": null }, { "name": "MAD_MAIL_ZIP", "type": "esriFieldTypeString", "alias": "MAD_MAIL_ZIP", "length": 20, "domain": null }, { "name": "MAD_MAIL_COUNTY", "type": "esriFieldTypeString", "alias": "MAD_MAIL_COUNTY", "length": 30, "domain": null }, { "name": "MAD_MAIL_COUNTRY", "type": "esriFieldTypeString", "alias": "MAD_MAIL_COUNTRY", "length": 30, "domain": null }, { "name": "MAD_MAIL_CARR", "type": "esriFieldTypeString", "alias": "MAD_MAIL_CARR", "length": 10, "domain": null }, { "name": "MAD_CREATE_DATE", "type": "esriFieldTypeDate", "alias": "MAD_CREATE_DATE", "length": 8, "domain": null }, { "name": "MAD_LAST_UPDATE", "type": "esriFieldTypeDate", "alias": "MAD_LAST_UPDATE", "length": 8, "domain": null }, { "name": "MAD_START_MONTH", "type": "esriFieldTypeString", "alias": "MAD_START_MONTH", "length": 2, "domain": null }, { "name": "MAD_START_DAY", "type": "esriFieldTypeString", "alias": "MAD_START_DAY", "length": 2, "domain": null }, { "name": "MAD_END_MONTH", "type": "esriFieldTypeString", "alias": "MAD_END_MONTH", "length": 2, "domain": null }, { "name": "MAD_END_DAY", "type": "esriFieldTypeString", "alias": "MAD_END_DAY", "length": 2, "domain": null }, { "name": "MAD_START_DATE", "type": "esriFieldTypeDate", "alias": "MAD_START_DATE", "length": 8, "domain": null }, { "name": "MAD_END_DATE", "type": "esriFieldTypeDate", "alias": "MAD_END_DATE", "length": 8, "domain": null }, { "name": "MAD_BOX_NUMBER", "type": "esriFieldTypeString", "alias": "MAD_BOX_NUMBER", "length": 9, "domain": null }, { "name": "MAD_BUILDING_ID", "type": "esriFieldTypeInteger", "alias": "MAD_BUILDING_ID", "domain": null }, { "name": "MAD_ADDRESS_INFO", "type": "esriFieldTypeString", "alias": "MAD_ADDRESS_INFO", "length": 250, "domain": null }, { "name": "MAD_POST_DIRECTION", "type": "esriFieldTypeString", "alias": "MAD_POST_DIRECTION", "length": 3, "domain": null }, { "name": "MAD_PRE_DIRECTION", "type": "esriFieldTypeString", "alias": "MAD_PRE_DIRECTION", "length": 3, "domain": null }, { "name": "MAD_STREET_NAME_PREFIX", "type": "esriFieldTypeString", "alias": "MAD_STREET_NAME_PREFIX", "length": 25, "domain": null }, { "name": "MAD_STREET_NAME_SUFFIX", "type": "esriFieldTypeString", "alias": "MAD_STREET_NAME_SUFFIX", "length": 25, "domain": null }, { "name": "MAD_STREET_NUMBER", "type": "esriFieldTypeInteger", "alias": "MAD_STREET_NUMBER", "domain": null }, { "name": "MAD_UNIT_TYPE", "type": "esriFieldTypeString", "alias": "MAD_UNIT_TYPE", "length": 10, "domain": null }, { "name": "MAD_UNIT_NUMBER", "type": "esriFieldTypeString", "alias": "MAD_UNIT_NUMBER", "length": 9, "domain": null }, { "name": "MAD_STREET_NAME", "type": "esriFieldTypeString", "alias": "MAD_STREET_NAME", "length": 50, "domain": null }, { "name": "MAD_STREET_TYPE", "type": "esriFieldTypeString", "alias": "MAD_STREET_TYPE", "length": 10, "domain": null }, { "name": "MAD_ADDRESS_ID", "type": "esriFieldTypeInteger", "alias": "MAD_ADDRESS_ID", "domain": null }, { "name": "MAD_MAIL_ADDR2", "type": "esriFieldTypeString", "alias": "MAD_MAIL_ADDR2", "length": 50, "domain": null }, { "name": "MAD_MAIL_ADDR3", "type": "esriFieldTypeString", "alias": "MAD_MAIL_ADDR3", "length": 50, "domain": null }, { "name": "MAD_ID", "type": "esriFieldTypeInteger", "alias": "MAD_ID", "domain": null } ], "indexes": [ { "name": "PK_POQ_MAILADDRESS_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }