View In:   ArcGIS Online Map Viewer

Name: SDE.Municipal_Skills_auditCombine

Display Field: MUNIC_CODE

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8a576869d45b4e00b38481dd72df0cd1

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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

Supports Datum Transformation: true

Extent:

XMin: 29.316131
YMin: -30.777445
XMax: 32.563817
YMax: -27.243472999999998
Spatial Reference: 4148  (4148)

Drawing Info:

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

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• MUNIC_CODE ( type: esriFieldTypeString, alias: Munic_Code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MUNIC_CODE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• DISTRICT ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DISTRICT )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MUNICIPALITY )
• G_FEMALE ( type: esriFieldTypeDouble, alias: G_Female, editable: true, nullable: true, defaultValue: null, modelName: G_FEMALE )
• G_MALE ( type: esriFieldTypeDouble, alias: G_Male, editable: true, nullable: true, defaultValue: null, modelName: G_MALE )
• R_AFRICAN ( type: esriFieldTypeDouble, alias: R_African, editable: true, nullable: true, defaultValue: null, modelName: R_AFRICAN )
• R_COLOURED ( type: esriFieldTypeDouble, alias: R_Coloured, editable: true, nullable: true, defaultValue: null, modelName: R_COLOURED )
• R_WHITE ( type: esriFieldTypeDouble, alias: R_White, editable: true, nullable: true, defaultValue: null, modelName: R_WHITE )
• R_INDIANS ( type: esriFieldTypeDouble, alias: R_Indians, editable: true, nullable: true, defaultValue: null, modelName: R_INDIANS )
• AGE_LESS20 ( type: esriFieldTypeDouble, alias: Age_less20, editable: true, nullable: true, defaultValue: null, modelName: AGE_LESS20 )
• AGE_21_30 ( type: esriFieldTypeDouble, alias: Age_21_30, editable: true, nullable: true, defaultValue: null, modelName: AGE_21_30 )
• AGE_31_40 ( type: esriFieldTypeDouble, alias: Age_31_40, editable: true, nullable: true, defaultValue: null, modelName: AGE_31_40 )
• AGE_41_50 ( type: esriFieldTypeDouble, alias: Age_41_50, editable: true, nullable: true, defaultValue: null, modelName: AGE_41_50 )
• AGE_ABOVE_51 ( type: esriFieldTypeDouble, alias: Age_above_51, editable: true, nullable: true, defaultValue: null, modelName: AGE_ABOVE_51 )
• NO_DISABILITIES ( type: esriFieldTypeDouble, alias: No_Disabilities, editable: true, nullable: true, defaultValue: null, modelName: NO_DISABILITIES )
• EXPR_BELOW_1YR ( type: esriFieldTypeDouble, alias: Expr_Below_1yr, editable: true, nullable: true, defaultValue: null, modelName: EXPR_BELOW_1YR )
• EXPR_2_TO_3YR ( type: esriFieldTypeDouble, alias: Expr_2_to_3yr, editable: true, nullable: true, defaultValue: null, modelName: EXPR_2_TO_3YR )
• EXPR_4_TO_5YR ( type: esriFieldTypeDouble, alias: Expr_4_to_5yr, editable: true, nullable: true, defaultValue: null, modelName: EXPR_4_TO_5YR )
• EXPR_6_TO_10YR ( type: esriFieldTypeDouble, alias: Expr_6_to_10yr, editable: true, nullable: true, defaultValue: null, modelName: EXPR_6_TO_10YR )
• EXP_ABOVE_10YR ( type: esriFieldTypeDouble, alias: Exp_Above_10yr, editable: true, nullable: true, defaultValue: null, modelName: EXP_ABOVE_10YR )
• GEN_EDUCATION_GRADE_1_9 ( type: esriFieldTypeDouble, alias: Gen_Education_Grade_1_9, editable: true, nullable: true, defaultValue: null, modelName: GEN_EDUCATION_GRADE_1_9 )
• FURTHER_EDUCATION_GRADE_10_11 ( type: esriFieldTypeDouble, alias: Further_Education_Grade_10_11, editable: true, nullable: true, defaultValue: null, modelName: FURTHER_EDUCATION_GRADE_10_11 )
• MATRIC_GRADE_12 ( type: esriFieldTypeDouble, alias: Matric_Grade_12, editable: true, nullable: true, defaultValue: null, modelName: MATRIC_GRADE_12 )
• NATIONAL_CERTIFICATE ( type: esriFieldTypeDouble, alias: National_Certificate, editable: true, nullable: true, defaultValue: null, modelName: NATIONAL_CERTIFICATE )
• NATIONAL_DIPLOMA ( type: esriFieldTypeDouble, alias: National_Diploma, editable: true, nullable: true, defaultValue: null, modelName: NATIONAL_DIPLOMA )
• DEGREE ( type: esriFieldTypeDouble, alias: Degree, editable: true, nullable: true, defaultValue: null, modelName: DEGREE )
• HONOURS ( type: esriFieldTypeDouble, alias: Honours, editable: true, nullable: true, defaultValue: null, modelName: HONOURS )
• MASTERS ( type: esriFieldTypeDouble, alias: Masters, editable: true, nullable: true, defaultValue: null, modelName: MASTERS )
• PHD ( type: esriFieldTypeDouble, alias: PHD, editable: true, nullable: true, defaultValue: null, modelName: PHD )
• TOTAL_QUALIFICATION ( type: esriFieldTypeDouble, alias: Total_Qualification, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_QUALIFICATION )
• MANAGERIAL_ABOVE_LEVEL ( type: esriFieldTypeDouble, alias: Managerial_Above_Level, editable: true, nullable: true, defaultValue: null, modelName: MANAGERIAL_ABOVE_LEVEL )
• MANAGERIAL_MET_LEVEL ( type: esriFieldTypeDouble, alias: Managerial_Met_Level, editable: true, nullable: true, defaultValue: null, modelName: MANAGERIAL_MET_LEVEL )
• MANAGERIAL_BELOW_LEVEL ( type: esriFieldTypeDouble, alias: Managerial_Below_Level, editable: true, nullable: true, defaultValue: null, modelName: MANAGERIAL_BELOW_LEVEL )
• FUNCTIONAL_ABOVE_LEVEL ( type: esriFieldTypeDouble, alias: Functional_Above_Level, editable: true, nullable: true, defaultValue: null, modelName: FUNCTIONAL_ABOVE_LEVEL )
• FUNCTIONAL_MET_LEVEL ( type: esriFieldTypeDouble, alias: Functional_Met_Level, editable: true, nullable: true, defaultValue: null, modelName: FUNCTIONAL_MET_LEVEL )
• FUNCTIONAL_BELOW_LEVEL ( type: esriFieldTypeDouble, alias: Functional_Below_Level, editable: true, nullable: true, defaultValue: null, modelName: FUNCTIONAL_BELOW_LEVEL )
• GENERIC_ABOVE_LEVEL ( type: esriFieldTypeDouble, alias: Generic_Above_Level, editable: true, nullable: true, defaultValue: null, modelName: GENERIC_ABOVE_LEVEL )
• GENERIC_MET_LEVEL ( type: esriFieldTypeDouble, alias: Generic_Met_Level, editable: true, nullable: true, defaultValue: null, modelName: GENERIC_MET_LEVEL )
• GENERIC_BELOW_LEVEL ( type: esriFieldTypeDouble, alias: Generic_Below_Level, editable: true, nullable: true, defaultValue: null, modelName: GENERIC_BELOW_LEVEL )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GIS_STAFF_TOTAL ( type: esriFieldTypeInteger, alias: GIS_STAFF_TOTAL, editable: true, nullable: true, defaultValue: null, modelName: GIS_STAFF_TOTAL )
• GIS_STAFF_TOTAL_D ( type: esriFieldTypeDouble, alias: GIS STAFF TOTAL, editable: true, nullable: true, defaultValue: null, modelName: GIS_STAFF_TOTAL_D )
• G_MALES_ ( type: esriFieldTypeInteger, alias: G_MALES_, editable: true, nullable: true, defaultValue: null, modelName: G_MALES_ )
• G_MALES_D ( type: esriFieldTypeDouble, alias: MALES:, editable: true, nullable: true, defaultValue: null, modelName: G_MALES_D )
• G_FEMALES ( type: esriFieldTypeInteger, alias: G_FEMALES, editable: true, nullable: true, defaultValue: null, modelName: G_FEMALES )
• G_FEMALES_D ( type: esriFieldTypeDouble, alias: FEMALES:, editable: true, nullable: true, defaultValue: null, modelName: G_FEMALES_D )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: SDE.Municipal_Skills_auditCombine
  Description:
  Prototype:
  G_FEMALES: null
  MUNIC_CODE: null
  LONGITUDE: null
  LATITUDE: null
  DISTRICT: null
  MUNICIPALITY: null
  G_FEMALE: null
  G_MALE: null
  R_AFRICAN: null
  R_COLOURED: null
  R_WHITE: null
  R_INDIANS: null
  AGE_LESS20: null
  AGE_21_30: null
  AGE_31_40: null
  AGE_41_50: null
  AGE_ABOVE_51: null
  NO_DISABILITIES: null
  EXPR_BELOW_1YR: null
  EXPR_2_TO_3YR: null
  EXPR_4_TO_5YR: null
  EXPR_6_TO_10YR: null
  EXP_ABOVE_10YR: null
  GEN_EDUCATION_GRADE_1_9: null
  FURTHER_EDUCATION_GRADE_10_11: null
  MATRIC_GRADE_12: null
  NATIONAL_CERTIFICATE: null
  NATIONAL_DIPLOMA: null
  DEGREE: null
  HONOURS: null
  MASTERS: null
  PHD: null
  TOTAL_QUALIFICATION: null
  MANAGERIAL_ABOVE_LEVEL: null
  MANAGERIAL_MET_LEVEL: null
  MANAGERIAL_BELOW_LEVEL: null
  FUNCTIONAL_ABOVE_LEVEL: null
  FUNCTIONAL_MET_LEVEL: null
  FUNCTIONAL_BELOW_LEVEL: null
  GENERIC_ABOVE_LEVEL: null
  GENERIC_MET_LEVEL: null
  GENERIC_BELOW_LEVEL: null
  G_MALES_D: null
  G_FEMALES_D: null
  GIS_STAFF_TOTAL: null
  GIS_STAFF_TOTAL_D: null
  G_MALES_: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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:   Field Groups   Contingent Values

Supported Operations:   Query   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata