View In:   ArcGIS Online Map Viewer

Name: ServiceableLocations

Display Field: type

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5df70be902fc45bba82075eb96fc5e3a

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 20000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 2016881.0806022005
YMin: 234063.50947264011
XMax: 2156156.4954775767
YMax: 318985.66076394543
Spatial Reference: 26852  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• serviceable ( nullable: false, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Currently Serviceable? , Coded Values: [1: Yes] , [2: No] )
• type ( nullable: false, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Location Type , Coded Values: [1: Residential] , [2: Business] , [3: Enterprise] , ...1 more... )
• status ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Location Status , Coded Values: [1: Active Customer] , [3: Disconnected] , [4: Never Connected] , ...1 more... )
• location ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, isViewOverride: false, alias: Location , Coded Values: [Building: Building] , [Mile Post: Mile Post] , [Parcel: Parcel] , ...4 more... )
• addrnum ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Full Address Number, type: esriFieldTypeString )
• unittype ( nullable: true, editable: true, defaultValue: null, length: 10, type: esriFieldTypeString, isViewOverride: false, alias: Unit Type , Coded Values: [APT: Apartment] , [BSMT: Basement] , [BLDG: Building] , ...23 more... )
• unitid ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Unit ID, type: esriFieldTypeString )
• fullname ( nullable: true, editable: true, defaultValue: null, length: 300, alias: Full Name, type: esriFieldTypeString )
• fulladdr ( nullable: true, editable: true, defaultValue: null, length: 500, alias: Full Address, type: esriFieldTypeString )
• placename ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Place Name, type: esriFieldTypeString )
• county ( nullable: true, editable: true, defaultValue: null, length: 40, alias: County, type: esriFieldTypeString )
• municipality ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Municipality, type: esriFieldTypeString )
• stateabbreviation ( nullable: true, editable: true, defaultValue: null, length: 2, type: esriFieldTypeString, isViewOverride: false, alias: State , Coded Values: [AL: Alabama] , [AK: Alaska] , [AS: American Samoa] , ...56 more... )
• zipcode ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Zip Code, type: esriFieldTypeString )
• countryabbreviation ( nullable: true, editable: true, defaultValue: null, length: 2, alias: Country, type: esriFieldTypeString )
• businessname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Business Name, type: esriFieldTypeString )
• salesvolume ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sales Volume, type: esriFieldTypeString )
• naicscode ( nullable: true, editable: true, defaultValue: null, alias: NAICS Code, type: esriFieldTypeSmallInteger )
• siccode ( nullable: true, editable: true, defaultValue: null, alias: SIC Code, type: esriFieldTypeSmallInteger )
• employeecount ( nullable: true, editable: true, defaultValue: null, alias: Employee Count, type: esriFieldTypeInteger )
• contactname ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contact Name, type: esriFieldTypeString )
• contacttel ( nullable: true, editable: true, defaultValue: null, length: 12, alias: Contact Phone Number, type: esriFieldTypeString )
• contactemail ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Contact Email, type: esriFieldTypeString )
• servicearea ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Service Area, type: esriFieldTypeString )
• siteaddid ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Site Address ID, type: esriFieldTypeString )
• billingsystemid ( nullable: true, editable: true, defaultValue: null, alias: Billing System ID, type: esriFieldTypeInteger )
• hubid ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Hub ID, type: esriFieldTypeString )
• locationid ( nullable: true, editable: true, defaultValue: null, alias: Location ID, type: esriFieldTypeInteger )
• carrierid ( nullable: true, editable: true, defaultValue: null, alias: Carrier ID, type: esriFieldTypeInteger )
• isinternetcust ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Broadband Customer? , Coded Values: [1: Yes] , [2: No] )
• customerspeed ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Customer Speed, type: esriFieldTypeString )
• istvcust ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: TV Customer? , Coded Values: [1: Yes] , [2: No] )
• isphonecust ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: VoIP Customer? , Coded Values: [1: Yes] , [2: No] )
• issecuritycust ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, isViewOverride: false, alias: Security Customer? , Coded Values: [1: Yes] , [2: No] )
• cenddate ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Contract End Date, type: esriFieldTypeDate )
• dateofdeployment ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date of Deployement, type: esriFieldTypeDate )
• floorlevel ( nullable: true, editable: true, defaultValue: null, alias: Floor Level, type: esriFieldTypeSmallInteger )
• fibercount ( nullable: true, editable: true, defaultValue: null, alias: Fiber Count, type: esriFieldTypeSmallInteger )
• notes ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Notes, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Creation date, type: esriFieldTypeDate )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Creator, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: Last update, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: Updated by, type: esriFieldTypeString )

Templates:

• Name: Residential
  Description:
  Prototype:
  serviceable: 1
  type: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Business
  Description:
  Prototype:
  serviceable: 1
  type: 2
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Nonprofit
  Description:
  Prototype:
  serviceable: 1
  type: 4
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Enterprise - Not Serviceable
  Description:
  Prototype:
  serviceable: 2
  type: 3
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Enterprise
  Description:
  Prototype:
  serviceable: 1
  type: 3
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Nonprofit - Not Serviceable
  Description:
  Prototype:
  serviceable: 2
  type: 4
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Residential - Not Serviceable
  Description:
  Prototype:
  serviceable: 2
  type: 1
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Business - Not Serviceable
  Description:
  Prototype:
  serviceable: 2
  type: 2
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata