Name: usps_sites_raw_ExcelToTable_Geocoded

Display Field: Loc_name

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: -17576351.6194379
YMin: 2037007.26905316
XMax: -7355618.69836876
YMax: 9559974.09700104
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"c99bbe6d39f572fcb96ba7d96138e1bb","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB8AAAAfCAYAAAAfrhY5AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADYklEQVRIidVXz08TURCepRtsEzmUE1sSkTYkGrzglpAQ9IDXoiYE6IZ4XRL9B7jR3vgHNKFXgv2BTSTFo94JrVxoIMG2asLWi10STaxi+sy39ml32aUtLTFO0ux2+3a+mXnz5vsq0j808b8Cj8fjPsHVG8I9YzWfcSUhx4Satjg/n+s6+EYqJbvIJRMj1e25IvskyXju8XiMq6aVjevz5IuywChD7DSqKIrWMXgilVZrjEX8/utSIDBM/V7vmTW3Rm8a14quS4VCSS0US2o8uRlVFuYiFwLfSKXknpoQkaSBEJzbgVoNa/qDXkKQ+/mDlUQyHQovzAbbAt+oAwcC/tB48HZTULsg7k5N0m72rZxIprNOAYh2DzsBbrT6+3I8sZlRwnMzTcETqbSKUncK3BiArp+E4Dc8PxtzBEe50Vy8gbpld6YmaSvzao2InMFd5JLR1by5tg8rNLOevxCgr6+X1h6OUOhGP3k8bgr4h8mavWh6g5GKTuWGF7OPx+j+ep60Lz9aBpYHr9LagxHTM/gtFt+rjdmLjZMLA6TxSA2u7lD2yRgdL0/Q0ssjiu1+agqsjg8YGeeOv9LS1pERPAx+4R84fAD9AcfI5JOLG7L1re5Q5N6Q4VAdlyj4bM8x28j0kFEtBIlgreb1eqla/R7i2bc0XiOvP1Dm8DNlHo2Stjxh9AEysysztihzWLH143G7Td9FfgOS4LPazgAWfLpnVACljL75aATFy4zmRLbn9Qb8czJqOXNucIyssQ0r09cMYKmv908g7ZrIb0CLYKdWzjjfBuxxbLfsWGarVXTdwKEz4EKtKQVat6HdGVD9VjXhiPwGQgB8DFpshcHaNWSt6ye5xYW/gsO05xAC4GPQIgyNZHdkWjX0BrdCoUSMMZPSEU2r2WkUQoCLBjQUPt3I+l2xVGY9NefZriiKBgUCIQA+7pbt5w+oRxAiYYvGE60LIX2gQCAEukGrANaOtW0lPGfK2vGcQ3lAgWB4dRIAgPP5gxyxn0t2v4tOLyIAKBAIAfAxaLGdPeYZA9hJyYrnOYH0AQdDCICPndRrIyi6Gs2FPbYrdcvgsDr5xxAE+Bi0CHYCSXAuACgGCM4xjhO62tpcFwK3BgE+rtPi2X8sDQPkUv4uKb/379xyXhp4N+0X4cmv+BaS61cAAAAASUVORK5CYII=","contentType":"image/png","width":23,"height":23,"angle":0,"xoffset":0,"yoffset":0}},"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:

Type ID Field:

Fields:

• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: LongLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: ShortLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: PlaceName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: BuildingName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddressNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: AddressRange, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: BldgType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: LevelType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: LevelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: UnitType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: SubAddress, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: MetroArea, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: RegionAbbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: PostalExt, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CntryName (type: esriFieldTypeString, alias: CountryName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, 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)
• DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Xmin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Xmax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Ymin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Ymax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: ExtraInfo, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_F1st_bundle__1___2nd_bundl (type: esriFieldTypeInteger, alias: 1st bundle (1)/ 2nd bundle (2), SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_West (type: esriFieldTypeString, alias: West, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Priority_Order (type: esriFieldTypeInteger, alias: Priority Order, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Go_Live_Date (type: esriFieldTypeString, alias: Go Live Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_VMF_Finance_Number (type: esriFieldTypeInteger, alias: VMF Finance Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_VMF_Name (type: esriFieldTypeString, alias: VMF Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_RESEARCH (type: esriFieldTypeString, alias: RESEARCH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Zip_Code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_USPS_Manager (type: esriFieldTypeString, alias: USPS Manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_USPS_Manager_Email (type: esriFieldTypeString, alias: USPS Manager Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_USPS_Manager_Phone_Number (type: esriFieldTypeString, alias: USPS Manager Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Concerns (type: esriFieldTypeString, alias: Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_VMF_On_Site_Flag (type: esriFieldTypeString, alias: VMF On Site Flag, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Lease_Status (type: esriFieldTypeString, alias: Lease Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_LEASE_EXPIRATION_DATE (type: esriFieldTypeString, alias: LEASE EXPIRATION DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_LEASE_ANNUAL_RENT_AMT (type: esriFieldTypeString, alias: LEASE ANNUAL RENT AMT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_AREA_INT_VMF_SQFT (type: esriFieldTypeInteger, alias: AREA INT VMF SQFT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Utility (type: esriFieldTypeString, alias: Utility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Utility_Contact_Name (type: esriFieldTypeString, alias: Utility Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Utility_Contact_Informatio (type: esriFieldTypeString, alias: Utility Contact Information (EMAIL), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Utility_Contact_Informat_1 (type: esriFieldTypeString, alias: Utility Contact Information (PHONE), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Incentives_Available__to_p (type: esriFieldTypeString, alias: Incentives Available (to present in the design phase), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Transformer_Size__kVA_ (type: esriFieldTypeString, alias: Transformer Size (kVA), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Voltage_Service (type: esriFieldTypeString, alias: Voltage Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Current_Service (type: esriFieldTypeString, alias: Current Service, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Max_Service_Available (type: esriFieldTypeString, alias: Max Service Available, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Upgrades_Timeline (type: esriFieldTypeString, alias: Upgrades Timeline, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: usps_sites_raw_ExcelToTable_Geocoded
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_Max_Service_Available:
• USER_Upgrades_Timeline:
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_F1st_bundle__1___2nd_bundl: 0
• USER_West:
• USER_Priority_Order: 0
• USER_Go_Live_Date:
• USER_VMF_Finance_Number: 0
• USER_VMF_Name:
• USER_Address:
• USER_City:
• USER_State:
• USER_RESEARCH:
• USER_Zip_Code:
• USER_USPS_Manager:
• USER_USPS_Manager_Email:
• USER_USPS_Manager_Phone_Number:
• USER_Concerns:
• USER_VMF_On_Site_Flag:
• USER_Lease_Status:
• USER_LEASE_EXPIRATION_DATE:
• USER_LEASE_ANNUAL_RENT_AMT:
• USER_AREA_INT_VMF_SQFT: 0
• USER_Utility:
• USER_Utility_Contact_Name:
• USER_Utility_Contact_Informatio:
• USER_Utility_Contact_Informat_1:
• USER_Incentives_Available__to_p:
• USER_Transformer_Size__kVA_:
• USER_Voltage_Service:
• USER_Current_Service:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/31/2023 7:44:16 PM

Schema Last Edit Date: 5/31/2023 7:44:16 PM

Data Last Edit Date: 5/31/2023 7:44:16 PM

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