Name: DBO.Address

Display Field: StreetName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2436884.37496039
YMin: 7020536.91988689
XMax: 2478743.86013889
YMax: 7070723.76012981
Spatial Reference: 102738 (2276)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"AddrSubType","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[255,255,255,255],"width":0.75}},"defaultLabel":"","uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[190,252,187,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"0","label":"Primary"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,182,249,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"1","label":"Secondary"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[189,232,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"2","label":"Block"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,198,179,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"3","label":"Intersection"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[184,189,252,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"4","label":"Other"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[252,244,182,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"5","label":"Meter"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[210,252,230,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"6","label":"Dummy"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,182,255],"toColor":[252,194,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[183,252,179,255],"toColor":[183,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[184,189,252,255],"toColor":[184,189,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,250,252,255],"toColor":[179,250,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,231,255],"toColor":[252,184,231,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,247,202,255],"toColor":[252,247,202,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,218,252,255],"toColor":[182,218,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[207,252,213,255],"toColor":[207,252,213,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[233,252,179,255],"toColor":[233,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,212,252,255],"toColor":[230,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,215,222,255],"toColor":[252,215,222,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,184,252,255],"toColor":[225,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,220,192,255],"toColor":[252,220,192,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field: AddrSubType

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ParcelID (type: esriFieldTypeString, alias: ParcelID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Address (type: esriFieldTypeInteger, alias: Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Direction (type: esriFieldTypeString, alias: Direction, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 1 more ...)
• StreetName (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StreetType (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [RUN: Run], [TRACE: Trace], [WAY: Way], ... 17 more ...)
• AptNo (type: esriFieldTypeString, alias: Apt No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• AddressID (type: esriFieldTypeInteger, alias: AddressID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddrSubType (type: esriFieldTypeSmallInteger, alias: AddrSubType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CADID (type: esriFieldTypeString, alias: CADID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PreQualifier (type: esriFieldTypeString, alias: PreQualifier, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AddressStatus (type: esriFieldTypeString, alias: Address Status, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [City: In Carrollton], [Out: Outside Carrollton])
• LabelAngle (type: esriFieldTypeSmallInteger, alias: Label Angle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OnParkSheet (type: esriFieldTypeString, alias: On Park Sheet, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
• FullAddress (type: esriFieldTypeString, alias: FullAddress, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [SG: SANDRA GRAHAM], [AK: ANNETTE KRUEBBE], [CN: CHARLES NEELY], ... 19 more ...)
• Edit_Date (type: esriFieldTypeDate, alias: Edit_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor_Department (type: esriFieldTypeString, alias: Editor_Department, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Engr: Engineering], [PW: Public Works], [ES: Environmental Services], ... 5 more ...)
• DispatchAddress (type: esriFieldTypeString, alias: DispatchAddress, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• StN_PreTyp (type: esriFieldTypeString, alias: StN_PreTyp, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Floor (type: esriFieldTypeString, alias: Floor, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Room (type: esriFieldTypeString, alias: Room, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Inc_Muni (type: esriFieldTypeString, alias: Inc_Muni, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ESN (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Post_Code (type: esriFieldTypeString, alias: Post_Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Elev (type: esriFieldTypeInteger, alias: Elev, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LeftRight (type: esriFieldTypeString, alias: LeftRight, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [L: Left], [R: Right])
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NTECC_Addr (type: esriFieldTypeString, alias: NTECC_Addr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TEMP (type: esriFieldTypeString, alias: TEMP, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• EXCEPTION (type: esriFieldTypeString, alias: EXCEPTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PGUID (type: esriFieldTypeGUID, alias: ParcelGlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Suites (type: esriFieldTypeString, alias: Suites, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ZoningType (type: esriFieldTypeString, alias: ZoningType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Types:

ID: 0
Name: Primary
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
• Field Name: LeftRight
  Inherited
  
Templates:

Name: Primary
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 0
• AddressStatus: Active
• OnParkSheet: Y

---

ID: 1
Name: Secondary
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
Templates:

Name: Secondary
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 1
• AddressStatus: Active
• OnParkSheet: Y

---

ID: 2
Name: Block
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
Templates:

Name: Block
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 2
• AddressStatus: Active
• OnParkSheet: Y

---

ID: 3
Name: Intersection
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
Templates:

Name: Intersection
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 3
• AddressStatus: Active
• OnParkSheet: Y

---

ID: 4
Name: Other
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
Templates:

Name: Other
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 4
• AddressStatus: Active
• OnParkSheet: Y

---

ID: 5
Name: Meter
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
Templates:

Name: Meter
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 5

---

ID: 6
Name: Dummy
Domains:

• Field Name: Direction
  Inherited
  
• Field Name: StreetType
  Inherited
  
• Field Name: AddressStatus
  Inherited
  
• Field Name: OnParkSheet
  Inherited
  
• Field Name: Editor
  Inherited
  
• Field Name: Editor_Department
  Inherited
  
Templates:

Name: Dummy
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AddrSubType: 6

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/26/2024 4:19:21 PM

Schema Last Edit Date: 6/26/2024 4:19:21 PM

Data Last Edit Date: 6/26/2024 4:19:21 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat