View In:   ArcGIS Online Map Viewer

Name: Materials - Customer Side

Display Field: created_user

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 0e8ab3d53c5547a4b9b8701841d6faf6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -8699157.64608693
YMin: 4762908.448989041
XMax: -8665040.907036807
YMax: 4808120.037650295
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: N/A
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Contains Lead
  Label: Contains Lead
  Description: Contains Lead
  Symbol:
  
• Value: No Lead
  Label: No Lead
  Description: No Lead
  Symbol:
  
• Value: Unknown Material
  Label: Unknown Material
  Description: Unknown Material
  Symbol:
  
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: FID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: globalid )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: created_date, type: esriFieldTypeDate )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: null, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• lc_district_material ( modelName: lc_district_material, nullable: true, editable: true, defaultValue: null, length: 255, alias: lc_utility_material, type: esriFieldTypeString , Coded Values: [1: Galvanized] , [4: Lead] , [5: Non-Lead] , ...7 more... )
• lc_owner_material ( modelName: lc_owner_material, nullable: true, editable: true, defaultValue: null, length: 255, alias: lc_customer_material, type: esriFieldTypeString , Coded Values: [1: Galvanized] , [4: Lead] , [5: Non-Lead] , ...7 more... )
• comment ( modelName: comment, nullable: true, editable: true, defaultValue: null, length: 500, alias: comment, type: esriFieldTypeString )
• northing ( modelName: northing, nullable: true, editable: true, defaultValue: null, alias: northing, type: esriFieldTypeDouble )
• easting ( modelName: easting, nullable: true, editable: true, defaultValue: null, alias: easting, type: esriFieldTypeDouble )
• account ( modelName: account, nullable: true, editable: true, defaultValue: null, length: 255, alias: account, type: esriFieldTypeString )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: longitude, type: esriFieldTypeDouble )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: latitude, type: esriFieldTypeDouble )
• multi_registers ( modelName: multi_registers, nullable: true, editable: true, defaultValue: null, length: 255, alias: multi_meters, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• master_meter ( modelName: master_meter, nullable: true, editable: true, defaultValue: null, length: 255, alias: master_meter, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• location_description ( modelName: location_description, nullable: true, editable: true, defaultValue: null, length: 255, alias: location, type: esriFieldTypeString )
• meter_type ( modelName: meter_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: meter_type, type: esriFieldTypeString , Coded Values: [2: Compound] , [3: Turbine] , [1: Single Disc] , ...4 more... )
• meter_description ( modelName: meter_description, nullable: true, editable: true, defaultValue: null, length: 255, alias: description, type: esriFieldTypeString , Coded Values: [1: Single] , [2: Compound] , [3: Domestic Combination] )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 255, alias: status, type: esriFieldTypeString , Coded Values: [Vacant: Vacant] , [In Use: In Use] , [Other: Other] , ...3 more... )
• customer_type ( modelName: customer_type, nullable: true, editable: true, defaultValue: null, length: 255, alias: customer_type, type: esriFieldTypeString , Coded Values: [1: Domestic] , [2: Fire] , [Both: Both] )
• dual_register ( modelName: dual_register, nullable: true, editable: true, defaultValue: null, length: 255, alias: dual_register, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• bypass ( modelName: bypass, nullable: true, editable: true, defaultValue: null, length: 255, alias: Is_there_a_bypass, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• multiplier ( modelName: multiplier, nullable: true, editable: true, defaultValue: null, length: 255, alias: multiplier, type: esriFieldTypeString , Coded Values: [1: 100] , [2: 1000] , [3: 10000] )
• unique_id ( modelName: unique_id, nullable: true, editable: true, defaultValue: null, length: 256, alias: Unique ID, type: esriFieldTypeString )
• owner_type ( modelName: owner_type, nullable: true, editable: true, defaultValue: 1, length: 255, alias: owner, type: esriFieldTypeString , Coded Values: [1: BCPSWD] , [2: Private] , [3: City of Martinsburg] , ...4 more... )
• full_address ( modelName: full_address, nullable: true, editable: true, defaultValue: null, length: 256, alias: Full Address, type: esriFieldTypeString )
• lc_verified_method ( modelName: lc_verified_method, nullable: true, editable: true, defaultValue: null, length: 255, alias: lc_verified_method, type: esriFieldTypeString , Coded Values: [workorder: Work Order] , [staff: Staff] , [customer: Customer] , ...2 more... )
• lc_verified_year ( modelName: lc_verified_year, nullable: true, editable: true, defaultValue: null, alias: lc_verified_year, type: esriFieldTypeInteger )
• lc_year_house_built ( modelName: lc_year_house_built, nullable: true, editable: true, defaultValue: null, alias: lc_year_house_built, type: esriFieldTypeInteger )
• lc_verified_date ( modelName: lc_verified_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: lc_verified_date, type: esriFieldTypeDate )
• county ( modelName: county, nullable: true, editable: true, defaultValue: Berkeley, length: 255, alias: county, type: esriFieldTypeString , Coded Values: [Berkeley: Berkeley] , [Jefferson: Jefferson] )
• data_loggable ( modelName: data_loggable, nullable: true, editable: true, defaultValue: null, length: 255, alias: data_loggable, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] )
• installed_year ( modelName: installed_year, nullable: true, editable: true, defaultValue: null, alias: installed_year, type: esriFieldTypeSmallInteger )
• lowflow_size ( modelName: lowflow_size, nullable: true, editable: true, defaultValue: null, length: 255, alias: lowflow_size, type: esriFieldTypeString , Coded Values: [0.625: 5/8"] , [0.75: 3/4"] , [1.5: 1 1/2"] , ...2 more... )
• meter_size ( modelName: meter_size, nullable: true, editable: true, defaultValue: null, length: 255, alias: meter_size, type: esriFieldTypeString , Coded Values: [1: 5/8"] , [2: 3/4"] , [3: 1"] , ...7 more... )
• owner_name ( modelName: owner_name, nullable: true, editable: true, defaultValue: null, length: 255, alias: owner_name, type: esriFieldTypeString )
• last_test_date ( modelName: last_test_date, nullable: true, editable: true, defaultValue: null, length: 29, alias: Last Tested Date, type: esriFieldTypeDate )
• near_fid ( modelName: near_fid, nullable: true, editable: true, defaultValue: null, alias: NEAR_FID, type: esriFieldTypeInteger )
• near_dist ( modelName: near_dist, nullable: true, editable: true, defaultValue: null, alias: NEAR_DIST, type: esriFieldTypeDouble )

Templates:

• Name: Materials - Customer Side
  Description:
  Prototype:
  customer_type: null
  meter_description: null
  lc_district_material: null
  dual_register: null
  latitude: null
  lc_year_house_built: null
  lowflow_size: null
  county: Berkeley
  full_address: null
  northing: null
  lc_verified_method: null
  last_test_date: null
  master_meter: null
  lc_verified_date: null
  longitude: null
  owner_name: null
  easting: null
  unique_id: null
  near_fid: null
  multiplier: null
  meter_size: null
  location_description: null
  meter_type: null
  multi_registers: null
  near_dist: null
  bypass: null
  installed_year: null
  data_loggable: null
  lc_owner_material: null
  comment: null
  lc_verified_year: null
  account: null
  owner_type: 1
  status: null
  
  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

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