Name: Addresses

Display Field: St_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This dataset contains addresses maintained by a variety of authorities. Addresses within the corporate limits of the Town of Prosper are maintained by the Town of Prosper. Addresses outside of that area are maintained by the various neighboring municipalities or the counties of Collin and Denton.

Copyright Text: Town of Prosper, data@prospertx.gov

Min. Scale: 24000

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10793339.0721
YMin: 3917594.2583
XMax: -10761544.0248
YMax: 3936928.553
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,170,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[78,78,78,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

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)
• Source (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• UpdateID (type: esriFieldTypeString, alias: Editor ID, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• DateUpdate (type: esriFieldTypeDate, alias: Date Edited, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GC_Exception (type: esriFieldTypeString, alias: QC Exception Code, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• AddNum_Pre (type: esriFieldTypeString, alias: Add Num Prefix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Add_Number (type: esriFieldTypeInteger, alias: Add Num, SQL Type: sqlTypeOther, nullable: false, editable: true)
• AddNum_Suf (type: esriFieldTypeString, alias: Add Num Suffix, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• St_PreMod (type: esriFieldTypeString, alias: St Pre Mod, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• St_PreDir (type: esriFieldTypeString, alias: St Pre Dir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [E: E], [N: N], [NE: NE], ... 5 more ...)
• St_PreTyp (type: esriFieldTypeString, alias: St Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• St_PreSep (type: esriFieldTypeString, alias: St Pre Type Sep, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• St_Name (type: esriFieldTypeString, alias: St Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• St_PosTyp (type: esriFieldTypeString, alias: St Post Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [DR: DR], [RD: RD], [ST: ST], ... 198 more ...)
• St_PosDir (type: esriFieldTypeString, alias: St Post Dir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [E: E], [N: N], [NE: NE], ... 5 more ...)
• St_PosMod (type: esriFieldTypeString, alias: St Post Mod, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Mile_Post (type: esriFieldTypeString, alias: Milepost, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Wing (type: esriFieldTypeString, alias: Wing, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Floor (type: esriFieldTypeString, alias: Floor, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Room (type: esriFieldTypeString, alias: Room, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• NCT_Type (type: esriFieldTypeString, alias: NCT Type, SQL Type: sqlTypeOther, length: 35, nullable: false, editable: true, Coded Values: [Single Family Residential: Single Family Residential], [Apartment: Apartment], [Air Quality Monitoring Facility: Air Quality Monitoring Facility], ... 102 more ...)
• Place_Type (type: esriFieldTypeString, alias: Place Type, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true, Coded Values: [Residential: Residential], [Health: Health], [Commercial: Commercial], ... 8 more ...)
• Stru_Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Primary: Primary], [Secondary: Secondary], [Tertiary: Tertiary], ... 1 more ...)
• Addtl_Loc1 (type: esriFieldTypeString, alias: Addtl Info 1, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• Addtl_Loc2 (type: esriFieldTypeString, alias: Addtl Info 2, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• AddDataURI (type: esriFieldTypeString, alias: Addtl Data URI, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• LandmkName (type: esriFieldTypeString, alias: Landmark Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Placement (type: esriFieldTypeString, alias: Placement Method, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Structure: Structure], [Site: Site], [Property Access: Property Access], ... 2 more ...)
• Nbrhd_Comm (type: esriFieldTypeString, alias: Neighborhood Community, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MSAGComm (type: esriFieldTypeString, alias: MSAG Comm Name, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• Inc_Muni (type: esriFieldTypeString, alias: Incorporated Municipality, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Uninc_Comm (type: esriFieldTypeString, alias: Unincorporated Community, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ESN (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true)
• Exchange (type: esriFieldTypeString, alias: Exchange, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Tandem (type: esriFieldTypeString, alias: Tandem, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• Post_Comm (type: esriFieldTypeString, alias: Postal Comm Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Post_Code (type: esriFieldTypeString, alias: Postal Code, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Post_Code4 (type: esriFieldTypeString, alias: ZIP Plus 4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LSt_PreDir (type: esriFieldTypeString, alias: L-St Pre Dir, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: E], [N: N], [NE: NE], ... 5 more ...)
• LSt_PreTyp (type: esriFieldTypeString, alias: L-St Pre Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LSt_Name (type: esriFieldTypeString, alias: L-St Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LSt_Type (type: esriFieldTypeString, alias: L-St Type, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LSt_PosDir (type: esriFieldTypeString, alias: L-St Post Dir, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: E], [N: N], [NE: NE], ... 5 more ...)
• Parcel_ID (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Asset_ID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Long (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Elev (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Effective (type: esriFieldTypeDate, alias: Date Effective, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Expire (type: esriFieldTypeDate, alias: Date Expiration, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CreateID (type: esriFieldTypeString, alias: Creator ID, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• DateCreate (type: esriFieldTypeDate, alias: Date Create, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DiscrpAgID (type: esriFieldTypeString, alias: Discrepancy Agency ID, SQL Type: sqlTypeOther, length: 75, nullable: false, editable: true)
• Site_NGUID (type: esriFieldTypeString, alias: NENA Global ID, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• St_FullName (type: esriFieldTypeString, alias: St Full Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• 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)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/6/2022 7:27:15 PM

Schema Last Edit Date: 9/6/2022 7:27:15 PM

Data Last Edit Date: 9/6/2022 7:27:15 PM

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