Name: MDU_ADDRESS

Display Field: creationuser

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID )
• creationuser ( type: esriFieldTypeString, alias: Creation User, length: 50 )
• datecreated ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• datemodified ( type: esriFieldTypeDate, alias: Date Modified, length: 8 )
• lastuser ( type: esriFieldTypeString, alias: Last User, length: 50 )
• ipid ( type: esriFieldTypeString, alias: IPID, length: 90 )
• addressid ( type: esriFieldTypeString, alias: Address ID, length: 255 )
• unitnumber ( type: esriFieldTypeString, alias: Unit Number, length: 250 )
• signalipid ( type: esriFieldTypeString, alias: Signal IPID, length: 90 )
• is_connected ( type: esriFieldTypeString, alias: Is Connected, length: 5 , Coded Values: [Y: Yes] , [N: No] )
• connectedfiberipid ( type: esriFieldTypeString, alias: Connected Fiber IPID, length: 90 )
• connectedequipmentipid ( type: esriFieldTypeString, alias: Connected Equipment IPID, length: 90 )
• connectedportnumber ( type: esriFieldTypeString, alias: Connected Port Number, length: 10 )
• connectedporttype ( type: esriFieldTypeString, alias: Connected Port Type, length: 10 , Coded Values: [1: Input] , [2: Output] )
• city ( type: esriFieldTypeString, alias: City, length: 150 )
• state ( type: esriFieldTypeString, alias: State, length: 50 , Coded Values: [AL: Alabama] , [AK: Alaska] , [AZ: Arizona] , ...48 more... )
• zipcode ( type: esriFieldTypeString, alias: Zip Code, length: 20 )
• landlord_id ( type: esriFieldTypeString, alias: Landlord ID, length: 255 )
• threegisid ( type: esriFieldTypeGUID, alias: 3-GIS ID, length: 38 )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• edittrackinguser ( type: esriFieldTypeString, alias: EDITTRACKINGUSER, length: 255 )
• edittrackingdate ( type: esriFieldTypeDate, alias: EDITTRACKINGDATE, length: 8 )
• tenantname ( type: esriFieldTypeString, alias: tenantname, length: 100 )
• planningid ( type: esriFieldTypeGUID, alias: Planning Id, length: 38 )
• isdelete ( type: esriFieldTypeSmallInteger, alias: Is Delete )
• timestamp ( type: esriFieldTypeDate, alias: Timestamp, length: 8 )
• clonetype ( type: esriFieldTypeString, alias: Clone Type, length: 50 )
• isplanning ( type: esriFieldTypeSmallInteger, alias: Is Planning )

Relationships:

• ADDRESS (60) -- Related To: Address (11)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata