{ "currentVersion": 10.91, "id": 45, "name": "MDU_ADDRESS", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CREATIONUSER", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Creation User", "length": 50, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 50, "domain": null }, { "name": "IPID", "type": "esriFieldTypeString", "alias": "IPID", "length": 90, "domain": null }, { "name": "ADDRESSID", "type": "esriFieldTypeString", "alias": "Address ID", "length": 255, "domain": null }, { "name": "UNITNUMBER", "type": "esriFieldTypeString", "alias": "Unit Number", "length": 250, "domain": null }, { "name": "SIGNALIPID", "type": "esriFieldTypeString", "alias": "Signal IPID", "length": 90, "domain": null }, { "name": "IS_CONNECTED", "type": "esriFieldTypeString", "alias": "Is Connected", "length": 5, "domain": { "type": "codedValue", "name": "YesNoText", "description": "Yes\\No Text Values", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONNECTEDFIBERIPID", "type": "esriFieldTypeString", "alias": "Connected Fiber IPID", "length": 90, "domain": null }, { "name": "CONNECTEDEQUIPMENTIPID", "type": "esriFieldTypeString", "alias": "Connected Equipment IPID", "length": 90, "domain": null }, { "name": "CONNECTEDPORTNUMBER", "type": "esriFieldTypeString", "alias": "Connected Port Number", "length": 10, "domain": null }, { "name": "CONNECTEDPORTTYPE", "type": "esriFieldTypeString", "alias": "Connected Port Type", "length": 10, "domain": { "type": "codedValue", "name": "PortType", "description": "Port Type", "codedValues": [ { "name": "Input", "code": "1" }, { "name": "Output", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "length": 150, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "length": 50, "domain": { "type": "codedValue", "name": "USAStates", "description": "USA States", "codedValues": [ { "name": "Alabama", "code": "AL" }, { "name": "Alaska", "code": "AK" }, { "name": "Arizona", "code": "AZ" }, { "name": "Arkansas", "code": "AR" }, { "name": "California", "code": "CA" }, { "name": "Colorado", "code": "CO" }, { "name": "Connecticut", "code": "CT" }, { "name": "Delaware", "code": "DE" }, { "name": "District of Columbia", "code": "DC" }, { "name": "Florida", "code": "FL" }, { "name": "Georgia", "code": "GA" }, { "name": "Hawaii", "code": "HI" }, { "name": "Idaho", "code": "ID" }, { "name": "Illinois", "code": "IL" }, { "name": "Indiana", "code": "IN" }, { "name": "Iowa", "code": "IA" }, { "name": "Kansas", "code": "KS" }, { "name": "Kentucky", "code": "KY" }, { "name": "Loisiana", "code": "LA" }, { "name": "Maine", "code": "ME" }, { "name": "Maryland", "code": "MD" }, { "name": "Massachusettes", "code": "MA" }, { "name": "Michigan", "code": "MI" }, { "name": "Minnesota", "code": "MN" }, { "name": "Mississippi", "code": "MS" }, { "name": "Missouri", "code": "MO" }, { "name": "Montana", "code": "MT" }, { "name": "Nebraska", "code": "NE" }, { "name": "Nevada", "code": "NV" }, { "name": "New Hampshire", "code": "NH" }, { "name": "New Jersey", "code": "NJ" }, { "name": "New Mexico", "code": "NM" }, { "name": "New York", "code": "NY" }, { "name": "North Carolina", "code": "NC" }, { "name": "North Dakota", "code": "ND" }, { "name": "Ohio", "code": "OH" }, { "name": "Oklahoma", "code": "OK" }, { "name": "Oregon", "code": "OR" }, { "name": "Pennsylvania", "code": "PA" }, { "name": "Rhode Island", "code": "RI" }, { "name": "South Carolina", "code": "SC" }, { "name": "South Dakota", "code": "SD" }, { "name": "Tennessee", "code": "TN" }, { "name": "Texas", "code": "TX" }, { "name": "Utah", "code": "UT" }, { "name": "Vermont", "code": "VT" }, { "name": "Virginia", "code": "VA" }, { "name": "Washington", "code": "WA" }, { "name": "West Virginia", "code": "WV" }, { "name": "Wisconsin", "code": "WI" }, { "name": "Wyoming", "code": "WY" }, { "name": "Mississippi", "code": "Mississippi" }, { "name": "Oklahoma", "code": "Oklahoma" }, { "name": "Delaware", "code": "Delaware" }, { "name": "Minnesota", "code": "Minnesota" }, { "name": "Illinois", "code": "Illinois" }, { "name": "Arkansas", "code": "Arkansas" }, { "name": "New Mexico", "code": "New Mexico" }, { "name": "Indiana", "code": "Indiana" }, { "name": "Maryland", "code": "Maryland" }, { "name": "Idaho", "code": "Idaho" }, { "name": "Wyoming", "code": "Wyoming" }, { "name": "Tennessee", "code": "Tennessee" }, { "name": "Arizona", "code": "Arizona" }, { "name": "Iowa", "code": "Iowa" }, { "name": "Michigan", "code": "Michigan" }, { "name": "Kansas", "code": "Kansas" }, { "name": "Utah", "code": "Utah" }, { "name": "Virginia", "code": "Virginia" }, { "name": "Oregon", "code": "Oregon" }, { "name": "Connecticut", "code": "Connecticut" }, { "name": "Montana", "code": "Montana" }, { "name": "California", "code": "California" }, { "name": "Texas", "code": "Texas" }, { "name": "West Virginia", "code": "West Virginia" }, { "name": "South Carolina", "code": "South Carolina" }, { "name": "New Hampshire", "code": "New Hampshire" }, { "name": "Wisconsin", "code": "Wisconsin" }, { "name": "Vermont", "code": "Vermont" }, { "name": "Georgia", "code": "Georgia" }, { "name": "North Dakota", "code": "North Dakota" }, { "name": "Loisiana", "code": "Loisiana" }, { "name": "Pennsylvania", "code": "Pennsylvania" }, { "name": "Florida", "code": "Florida" }, { "name": "Alaska", "code": "Alaska" }, { "name": "Kentucky", "code": "Kentucky" }, { "name": "Hawaii", "code": "Hawaii" }, { "name": "Nebraska", "code": "Nebraska" }, { "name": "Missouri", "code": "Missouri" }, { "name": "Ohio", "code": "Ohio" }, { "name": "Alabama", "code": "Alabama" }, { "name": "New York", "code": "New York" }, { "name": "South Dakota", "code": "South Dakota" }, { "name": "Colorado", "code": "Colorado" }, { "name": "New Jersey", "code": "New Jersey" }, { "name": "Washington", "code": "Washington" }, { "name": "North Carolina", "code": "North Carolina" }, { "name": "District of Columbia", "code": "District of Columbia" }, { "name": "Massachusettes", "code": "Massachusettes" }, { "name": "Nevada", "code": "Nevada" }, { "name": "Maine", "code": "Maine" }, { "name": "Rhode Island", "code": "Rhode Island" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ZIPCODE", "type": "esriFieldTypeString", "alias": "Zip Code", "length": 20, "domain": null }, { "name": "LANDLORD_ID", "type": "esriFieldTypeString", "alias": "Landlord ID", "length": 255, "domain": null }, { "name": "THREEGISID", "type": "esriFieldTypeGUID", "alias": "3-GIS ID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "EDITTRACKINGUSER", "type": "esriFieldTypeString", "alias": "EDITTRACKINGUSER", "length": 255, "domain": null }, { "name": "EDITTRACKINGDATE", "type": "esriFieldTypeDate", "alias": "EDITTRACKINGDATE", "length": 8, "domain": null }, { "name": "CLLI", "type": "esriFieldTypeString", "alias": "CLLI", "length": 100, "domain": null }, { "name": "tenantname", "type": "esriFieldTypeString", "alias": "tenantname", "length": 100, "domain": null }, { "name": "planningid", "type": "esriFieldTypeGUID", "alias": "Planning Id", "length": 38, "domain": null }, { "name": "isdelete", "type": "esriFieldTypeSmallInteger", "alias": "Is Delete", "domain": null }, { "name": "timestamp", "type": "esriFieldTypeDate", "alias": "Timestamp", "length": 8, "domain": null }, { "name": "clonetype", "type": "esriFieldTypeString", "alias": "Clone Type", "length": 50, "domain": null }, { "name": "isplanning", "type": "esriFieldTypeSmallInteger", "alias": "Is Planning", "domain": null } ], "indexes": [ { "name": "R29_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_29", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G119LANDLORD_ID", "fields": "LANDLORD_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "TGS_MDU_ADDRESS", "fields": "THREEGISID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 67, "name": "ADDRESS", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "LANDLORD_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }