Layers:

Layer: view_tbl_institutes (0)

Name: view_tbl_institutes

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:
XMin: 23.977542
YMin: 23.3911568174906
XMax: 56.3699618381269
YMax: 54.811538
Spatial Reference: 4326  (4326)



Drawing Info:
Renderer:
Unique Value Renderer:
Field 1: status_id
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Default Label: Other
UniqueValueInfos:
• Value: 0
  Label: Expired
  Description:
  Symbol:
  
• Value: 1
  Label: Active
  Description:
  Symbol:
  
• Value: 2
  Label: AboutExpire
  Description:
  Symbol:
  
• Value: 3
  Label: Inactive
  Description:
  Symbol:
  
• Value: 4
  Label: Closed
  Description:
  Symbol:
  
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• id ( type: esriFieldTypeInteger, alias: id )
• name ( type: esriFieldTypeString, alias: name, length: 2147483647 )
• type ( type: esriFieldTypeInteger, alias: type )
• longitude ( type: esriFieldTypeDouble, alias: longitude )
• latitude ( type: esriFieldTypeDouble, alias: latitude )
• Description ( type: esriFieldTypeString, alias: Description, length: 1073741823 )
• Address ( type: esriFieldTypeString, alias: Address, length: 2147483647 )
• CityID ( type: esriFieldTypeInteger, alias: CityID )
• latlong ( type: esriFieldTypeString, alias: latlong, length: 2147483647 )
• telephone ( type: esriFieldTypeString, alias: telephone, length: 2147483647 )
• pobox ( type: esriFieldTypeString, alias: pobox, length: 2147483647 )
• regionID ( type: esriFieldTypeInteger, alias: regionID )
• notpublic ( type: esriFieldTypeInteger, alias: notpublic )
• fax ( type: esriFieldTypeString, alias: fax, length: 2147483647 )
• InstituteSex ( type: esriFieldTypeInteger, alias: InstituteSex )
• Street ( type: esriFieldTypeString, alias: Street, length: 2147483647 )
• website ( type: esriFieldTypeString, alias: website, length: 2147483647 )
• name_ar ( type: esriFieldTypeString, alias: name_ar, length: 2147483647 )
• Description_ar ( type: esriFieldTypeString, alias: Description_ar, length: 1073741823 )
• address_ar ( type: esriFieldTypeString, alias: address_ar, length: 2147483647 )
• street_ar ( type: esriFieldTypeString, alias: street_ar, length: 2147483647 )
• email ( type: esriFieldTypeString, alias: email, length: 2147483647 )
• type_ar ( type: esriFieldTypeInteger, alias: type_ar )
• gps_lat ( type: esriFieldTypeString, alias: gps_lat, length: 2147483647 )
• gps_long ( type: esriFieldTypeString, alias: gps_long, length: 2147483647 )
• building ( type: esriFieldTypeString, alias: building, length: 2147483647 )
• building_ar ( type: esriFieldTypeString, alias: building_ar, length: 2147483647 )
• floor ( type: esriFieldTypeString, alias: floor, length: 2147483647 )
• floor_ar ( type: esriFieldTypeString, alias: floor_ar, length: 2147483647 )
• status_id ( type: esriFieldTypeInteger, alias: status_id )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 2147483647 )
• Landlord ( type: esriFieldTypeString, alias: Landlord, length: 2147483647 )
• Flat_No ( type: esriFieldTypeString, alias: Flat_No, length: 2147483647 )
• AcademicDirector ( type: esriFieldTypeString, alias: AcademicDirector, length: 2147483647 )
• ExpiryDate ( type: esriFieldTypeDate, alias: ExpiryDate, length: 8 )
• issue_date ( type: esriFieldTypeDate, alias: issue_date, length: 8 )
• creation_date ( type: esriFieldTypeDate, alias: creation_date, length: 8 )
• activities ( type: esriFieldTypeString, alias: activities, length: 200 )
• image_url ( type: esriFieldTypeString, alias: image_url, length: 200 )
• act_level ( type: esriFieldTypeString, alias: act_level, length: 100 )
• user_name ( type: esriFieldTypeString, alias: user_name, length: 200 )
• typeen ( type: esriFieldTypeString, alias: typeen, length: 250 )
• typear ( type: esriFieldTypeString, alias: typear, length: 250 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• cityname ( type: esriFieldTypeString, alias: cityname, length: 2147483647 )
• cityname_ar ( type: esriFieldTypeString, alias: cityname_ar, length: 2147483647 )
• citylong ( type: esriFieldTypeString, alias: citylong, length: 2147483647 )
• citylatit ( type: esriFieldTypeString, alias: citylatit, length: 2147483647 )
• regionname ( type: esriFieldTypeString, alias: regionname, length: 2147483647 )
• regionname_ar ( type: esriFieldTypeString, alias: regionname_ar, length: 2147483647 )
• regionlong ( type: esriFieldTypeString, alias: regionlong, length: 2147483647 )
• regionllatit ( type: esriFieldTypeString, alias: regionllatit, length: 2147483647 )
• rating ( type: esriFieldTypeDouble, alias: rating )
• rating_image ( type: esriFieldTypeString, alias: rating_image, length: 200 )
• mobile ( type: esriFieldTypeString, alias: mobile, length: 50 )
• actvet_rating ( type: esriFieldTypeDouble, alias: actvet_rating )
• actvet_license_no ( type: esriFieldTypeString, alias: actvet_license_no, length: 50 )
• trade_license_no ( type: esriFieldTypeString, alias: trade_license_no, length: 50 )
• establishment_date ( type: esriFieldTypeDate, alias: establishment_date, length: 8 )
• tempActivity ( type: esriFieldTypeString, alias: tempActivity, length: 100 )
• isThereFees ( type: esriFieldTypeSmallInteger, alias: isThereFees )
• last_actvet_rating ( type: esriFieldTypeDouble, alias: last_actvet_rating )
• rating_date ( type: esriFieldTypeDate, alias: rating_date, length: 8 )
• is_semi_gov ( type: esriFieldTypeSmallInteger, alias: is_semi_gov )
• is_rtp ( type: esriFieldTypeSmallInteger, alias: is_rtp )
• rtp_qualifications ( type: esriFieldTypeString, alias: rtp_qualifications, length: 2147483647 )
• rtp_number ( type: esriFieldTypeString, alias: rtp_number, length: 20 )
• rating_average ( type: esriFieldTypeDouble, alias: rating_average )
• raters_count ( type: esriFieldTypeInteger, alias: raters_count )
• rating_value_name ( type: esriFieldTypeString, alias: rating_value_name, length: 100 )
• actvet_ratings_name ( type: esriFieldTypeString, alias: actvet_ratings_name, length: 100 )
• rating_vc ( type: esriFieldTypeString, alias: rating_vc, length: 10 )
• emirati_count ( type: esriFieldTypeInteger, alias: emirati_count )
• emirati_perc ( type: esriFieldTypeDouble, alias: emirati_perc )
• total_rates_with_nationality ( type: esriFieldTypeInteger, alias: total_rates_with_nationality )
• non_emirati_count ( type: esriFieldTypeInteger, alias: non_emirati_count )
• non_emirati_perc ( type: esriFieldTypeDouble, alias: non_emirati_perc )
• emirati_perc_one ( type: esriFieldTypeDouble, alias: emirati_perc_one )
• non_emirati_perc_one ( type: esriFieldTypeDouble, alias: non_emirati_perc_one )
• behavior ( type: esriFieldTypeInteger, alias: behavior )
• category ( type: esriFieldTypeInteger, alias: category )
• violations ( type: esriFieldTypeInteger, alias: violations )
• category_name ( type: esriFieldTypeString, alias: category_name, length: 200 )
• behavior_name ( type: esriFieldTypeString, alias: behavior_name, length: 200 )
• CN_Name_CRM ( type: esriFieldTypeString, alias: CN_Name_CRM, length: 255 )
• guid_CRM ( type: esriFieldTypeString, alias: guid_CRM, length: 255 )
• category_type ( type: esriFieldTypeInteger, alias: category_type )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Tables:

Table: view_tbl_institutes (1)

Name: view_tbl_institutes

Display Field: name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• id ( type: esriFieldTypeInteger, alias: id )
• name ( type: esriFieldTypeString, alias: name, length: 1073741822 )
• type ( type: esriFieldTypeInteger, alias: type )
• longitude ( type: esriFieldTypeDouble, alias: longitude )
• latitude ( type: esriFieldTypeDouble, alias: latitude )
• Description ( type: esriFieldTypeString, alias: Description, length: 1073741823 )
• Address ( type: esriFieldTypeString, alias: Address, length: 1073741822 )
• cityid ( type: esriFieldTypeInteger, alias: cityid )
• latlong ( type: esriFieldTypeString, alias: latlong, length: 1073741822 )
• telephone ( type: esriFieldTypeString, alias: telephone, length: 1073741822 )
• pobox ( type: esriFieldTypeString, alias: pobox, length: 1073741822 )
• regionID ( type: esriFieldTypeInteger, alias: regionID )
• notpublic ( type: esriFieldTypeInteger, alias: notpublic )
• fax ( type: esriFieldTypeString, alias: fax, length: 1073741822 )
• InstituteSex ( type: esriFieldTypeInteger, alias: InstituteSex )
• Street ( type: esriFieldTypeString, alias: Street, length: 1073741822 )
• website ( type: esriFieldTypeString, alias: website, length: 1073741822 )
• name_ar ( type: esriFieldTypeString, alias: name_ar, length: 1073741822 )
• Description_ar ( type: esriFieldTypeString, alias: Description_ar, length: 1073741823 )
• address_ar ( type: esriFieldTypeString, alias: address_ar, length: 1073741822 )
• street_ar ( type: esriFieldTypeString, alias: street_ar, length: 1073741822 )
• email ( type: esriFieldTypeString, alias: email, length: 1073741822 )
• type_ar ( type: esriFieldTypeInteger, alias: type_ar )
• gps_lat ( type: esriFieldTypeString, alias: gps_lat, length: 1073741822 )
• gps_long ( type: esriFieldTypeString, alias: gps_long, length: 1073741822 )
• building ( type: esriFieldTypeString, alias: building, length: 1073741822 )
• building_ar ( type: esriFieldTypeString, alias: building_ar, length: 1073741822 )
• floor ( type: esriFieldTypeString, alias: floor, length: 1073741822 )
• floor_ar ( type: esriFieldTypeString, alias: floor_ar, length: 1073741822 )
• status_id ( type: esriFieldTypeInteger, alias: status_id )
• Owner ( type: esriFieldTypeString, alias: Owner, length: 1073741822 )
• Landlord ( type: esriFieldTypeString, alias: Landlord, length: 1073741822 )
• Flat_No ( type: esriFieldTypeString, alias: Flat_No, length: 1073741822 )
• AcademicDirector ( type: esriFieldTypeString, alias: AcademicDirector, length: 1073741822 )
• ExpiryDate ( type: esriFieldTypeDate, alias: ExpiryDate, length: 8 )
• issue_date ( type: esriFieldTypeDate, alias: issue_date, length: 8 )
• creation_date ( type: esriFieldTypeDate, alias: creation_date, length: 8 )
• activities ( type: esriFieldTypeString, alias: activities, length: 200 )
• image_url ( type: esriFieldTypeString, alias: image_url, length: 200 )
• act_level ( type: esriFieldTypeString, alias: act_level, length: 100 )
• user_name ( type: esriFieldTypeString, alias: user_name, length: 200 )
• typeen ( type: esriFieldTypeString, alias: typeen, length: 250 )
• typear ( type: esriFieldTypeString, alias: typear, length: 250 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• cityname ( type: esriFieldTypeString, alias: cityname, length: 1073741822 )
• cityname_ar ( type: esriFieldTypeString, alias: cityname_ar, length: 1073741822 )
• citylong ( type: esriFieldTypeString, alias: citylong, length: 1073741822 )
• citylatit ( type: esriFieldTypeString, alias: citylatit, length: 1073741822 )
• regionname ( type: esriFieldTypeString, alias: regionname, length: 1073741822 )
• regionname_ar ( type: esriFieldTypeString, alias: regionname_ar, length: 1073741822 )
• regionlong ( type: esriFieldTypeString, alias: regionlong, length: 1073741822 )
• regionllatit ( type: esriFieldTypeString, alias: regionllatit, length: 1073741822 )
• rating ( type: esriFieldTypeDouble, alias: rating )
• rating_image ( type: esriFieldTypeString, alias: rating_image, length: 200 )
• mobile ( type: esriFieldTypeString, alias: mobile, length: 50 )
• actvet_rating ( type: esriFieldTypeDouble, alias: actvet_rating )
• actvet_license_no ( type: esriFieldTypeString, alias: actvet_license_no, length: 50 )
• trade_license_no ( type: esriFieldTypeString, alias: trade_license_no, length: 50 )
• establishment_date ( type: esriFieldTypeDate, alias: establishment_date, length: 8 )
• tempActivity ( type: esriFieldTypeString, alias: tempActivity, length: 100 )
• isThereFees ( type: esriFieldTypeSmallInteger, alias: isThereFees )
• last_actvet_rating ( type: esriFieldTypeDouble, alias: last_actvet_rating )
• rating_date ( type: esriFieldTypeDate, alias: rating_date, length: 8 )
• is_semi_gov ( type: esriFieldTypeSmallInteger, alias: is_semi_gov )
• is_rtp ( type: esriFieldTypeSmallInteger, alias: is_rtp )
• rtp_qualifications ( type: esriFieldTypeString, alias: rtp_qualifications, length: 2147483647 )
• rtp_number ( type: esriFieldTypeString, alias: rtp_number, length: 20 )
• rating_average ( type: esriFieldTypeDouble, alias: rating_average )
• raters_count ( type: esriFieldTypeInteger, alias: raters_count )
• rating_value_name ( type: esriFieldTypeString, alias: rating_value_name, length: 100 )
• actvet_ratings_name ( type: esriFieldTypeString, alias: actvet_ratings_name, length: 100 )
• rating_vc ( type: esriFieldTypeString, alias: rating_vc, length: 10 )
• emirati_count ( type: esriFieldTypeInteger, alias: emirati_count )
• emirati_perc ( type: esriFieldTypeDouble, alias: emirati_perc )
• total_rates_with_nationality ( type: esriFieldTypeInteger, alias: total_rates_with_nationality )
• non_emirati_count ( type: esriFieldTypeInteger, alias: non_emirati_count )
• non_emirati_perc ( type: esriFieldTypeDouble, alias: non_emirati_perc )
• emirati_perc_one ( type: esriFieldTypeDouble, alias: emirati_perc_one )
• non_emirati_perc_one ( type: esriFieldTypeDouble, alias: non_emirati_perc_one )
• behavior ( type: esriFieldTypeInteger, alias: behavior )
• category ( type: esriFieldTypeInteger, alias: category )
• violations ( type: esriFieldTypeInteger, alias: violations )
• category_name ( type: esriFieldTypeString, alias: category_name, length: 200 )
• behavior_name ( type: esriFieldTypeString, alias: behavior_name, length: 200 )
• ESRI_OID ( type: esriFieldTypeOID, alias: ESRI_OID )

Table: tbl_status (2)

Name: tbl_status

Display Field: status

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• statusid ( type: esriFieldTypeOID, alias: statusid )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• status_code ( type: esriFieldTypeString, alias: status_code, length: 50 )

Table: tbl_activities (3)

Name: tbl_activities

Display Field: activity_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• activity_id ( type: esriFieldTypeOID, alias: activity_id )
• activity_name ( type: esriFieldTypeString, alias: activity_name, length: 50 )
• activity_name_ar_1 ( type: esriFieldTypeString, alias: activity_name_ar_1, length: 50 )
• activity_name_ar ( type: esriFieldTypeString, alias: activity_name_ar, length: 100 )

Table: tbl_city (4)

Name: tbl_city

Display Field: cityname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• cityID ( type: esriFieldTypeOID, alias: cityID )
• cityname ( type: esriFieldTypeString, alias: cityname, length: 1073741822 )
• cityname_ar ( type: esriFieldTypeString, alias: cityname_ar, length: 1073741822 )
• citylong ( type: esriFieldTypeString, alias: citylong, length: 1073741822 )
• citylatit ( type: esriFieldTypeString, alias: citylatit, length: 1073741822 )

Table: tbl_region (5)

Name: tbl_region

Display Field: regionname

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
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: false
Supports Returning Geometry Centroid: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:
• regionID ( type: esriFieldTypeOID, alias: regionID )
• cityID ( type: esriFieldTypeInteger, alias: cityID )
• regionname ( type: esriFieldTypeString, alias: regionname, length: 1073741822 )
• regionname_ar ( type: esriFieldTypeString, alias: regionname_ar, length: 1073741822 )
• regionlong ( type: esriFieldTypeString, alias: regionlong, length: 1073741822 )
• regionllatit ( type: esriFieldTypeString, alias: regionllatit, length: 1073741822 )