Name: Addresses

Display Field: fullname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Site Structure/Address Points for communities that are part of the Denco Area 9-1-1 District. The layer also have some points that are not part of the District but fall within Denton County (i.e. Carrollton, Celina, Dallas, Fort Worth, Frisco, New Fairview, Plano. Prosper, Southlake & Valley View). If Field GC_ Exception has 999 this data is outside our District.

Copyright Text: City/Town of: Argyle, Aubrey, Bartonville, Copper Canyon, Corral City, Corinth, Cross Roads, Denton, Dish, Double Oak,, Flower Mound, Hackberry, Hebron, Hickory Creek, Highland Village, Justin, Krugerville, Krum, Lake Dallas, Lakewood Village, Lewisville, Little Elm, Northlake, Oak Point, Pilot Point, Ponder, Providence Village, Roanoke, Sanger, Shady Shores, The Colony, Trophy Club & Unincorporated Denton County.

Min. Scale: 3073

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2432056.1520053
YMin: 7155381.08833911
XMax: 2473605.60696396
YMax: 7204617.98873191
Spatial Reference: 102738 (2276)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,76,115,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.addrnum","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","allowOverlapOfFeatureInterior":"avoid","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,77,168,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":2,"font":{"family":"Arial","size":10,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: true

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:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• siteaddid (type: esriFieldTypeString, alias: Site Address ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• addressptid (type: esriFieldTypeString, alias: Address Point ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• rclnguid (type: esriFieldTypeString, alias: NENA Global ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• discrpagid (type: esriFieldTypeString, alias: Discrepancy Agency ID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• preaddrnum (type: esriFieldTypeString, alias: Address Number Prefix, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• addrnumsuf (type: esriFieldTypeString, alias: Address Number Suffix, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• addrnum (type: esriFieldTypeString, alias: Full Address Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• addrrange (type: esriFieldTypeString, alias: Address Range, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• unittype (type: esriFieldTypeString, alias: Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 23 more ...)
• unitid (type: esriFieldTypeString, alias: Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• altunittype (type: esriFieldTypeString, alias: Alternate Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 23 more ...)
• altunitid (type: esriFieldTypeString, alias: Alternate Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• secondaltunittype (type: esriFieldTypeString, alias: 2nd Alternate Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 23 more ...)
• secondaltunitid (type: esriFieldTypeString, alias: 2nd Alternate Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• thirdaltunittype (type: esriFieldTypeString, alias: 3rd Alternate Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 23 more ...)
• thirdaltunitid (type: esriFieldTypeString, alias: 3rd Alternate Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• fourthaltunittype (type: esriFieldTypeString, alias: 4th Alternate Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 23 more ...)
• fourthaltunitid (type: esriFieldTypeString, alias: 4th Alternate Address Unit Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• fullname (type: esriFieldTypeString, alias: Full Road Name, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• fulladdr (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• placename (type: esriFieldTypeString, alias: Place Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• country (type: esriFieldTypeString, alias: Country Abbreviation, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• stateabbreviation (type: esriFieldTypeString, alias: State Abbreviation, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [AL: Alabama], [AK: Alaska], [AS: American Samoa], ... 56 more ...)
• county (type: esriFieldTypeString, alias: County Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• esn (type: esriFieldTypeString, alias: Emergency Service Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• msag (type: esriFieldTypeString, alias: MSAG Community, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• usngcoord (type: esriFieldTypeString, alias: USNG Coordinate, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• addrclass (type: esriFieldTypeInteger, alias: Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [701: Agriculture, Food, and Livestock], [710: Industry], [720: Commercial and Retail], ... 13 more ...)
• pointtype (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Building: Building], [Mile Post: Mile Post], [Parcel: Parcel], ... 4 more ...)
• capturemeth (type: esriFieldTypeString, alias: Capture Method, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Community Contribution: Community Contribution], [Other: Other], [Plan or Drawing: Plan or Drawing], ... 1 more ...)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Current: Current], [Pending: Pending], [Retired: Retired], ... 2 more ...)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No calculation required, no validation required, no error], [1: No calculation required, no validation required, has error(s)], [2: No calculation required, validation required, no error], ... 5 more ...)
• DelRec (type: esriFieldTypeString, alias: DelRec, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• GPSX (type: esriFieldTypeDouble, alias: GPSX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPSY (type: esriFieldTypeDouble, alias: GPSY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PictureID (type: esriFieldTypeString, alias: PictureID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ParcelNum (type: esriFieldTypeString, alias: ParcelNum, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• OLD_ADDRESS (type: esriFieldTypeString, alias: OLD_ADDRESS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PD_L (type: esriFieldTypeString, alias: PD_L, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SN_L (type: esriFieldTypeString, alias: SN_L, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
• ST_L (type: esriFieldTypeString, alias: ST_L, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SD_L (type: esriFieldTypeString, alias: SD_L, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PSAP (type: esriFieldTypeString, alias: PSAP, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• AddrCLASS_L (type: esriFieldTypeString, alias: AddrCLASS_L, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [R1: Single Family], [R2: Multi Family], [R3: Mobile Home], ... 72 more ...)
• DATE_ASS (type: esriFieldTypeString, alias: DATE_ASS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [SANG: Sanger], [PILO: Pilot Point], [ARGY: Argyle], ... 51 more ...)
• Site_UID (type: esriFieldTypeString, alias: Site_UID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Apt (type: esriFieldTypeString, alias: Apt, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• GC_EXCEPTION (type: esriFieldTypeString, alias: GC_EXCEPTION, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• INT_EXCEPTION (type: esriFieldTypeString, alias: INT_EXCEPTION, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• RPID (type: esriFieldTypeString, alias: RPID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• AddNum_Pre (type: esriFieldTypeString, alias: Address Number Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Add_Number (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddNum_Suf (type: esriFieldTypeString, alias: Address Number Suffix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• St_PreMod (type: esriFieldTypeString, alias: Street Name Pre Modifier, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• St_PreDir (type: esriFieldTypeString, alias: Street Name Pre Directional, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: North], [S: South], [E: East], ... 9 more ...)
• St_PreTyp (type: esriFieldTypeString, alias: Street Name Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• St_PreSep (type: esriFieldTypeString, alias: Street Name Pre Type Separator, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• St_Name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• St_PosTyp (type: esriFieldTypeString, alias: Street Name Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• St_PosDir (type: esriFieldTypeString, alias: Street Name Post Directional, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [N: North], [S: South], [E: East], ... 5 more ...)
• St_PosMod (type: esriFieldTypeString, alias: Street Name Post Modifier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• country: US
• discrpagid: denco.org
• stateabbreviation: TX
• VALIDATIONSTATUS: 6

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/22/2024 12:42:02 AM

Schema Last Edit Date: 10/22/2024 12:42:02 AM

Data Last Edit Date: 10/22/2024 12:37:21 AM

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