Layers:

Layer: Lecturer (0)


Name: Lecturer

Display Field: FirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a point layer showing the details of the lecturer, course taught and department where the building is located.

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: -79.9209099999999
YMin: 43.2589100000001
XMax: -79.916487
YMax: 43.2642970000001
Spatial Reference: 4326 (4326)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"158f49b0273858c3ec59ac4338837ac5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAATCAYAAACk9eypAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA7UlEQVQokZWSMVLDMBBFn8CkcO1LqHcb01LnEPS0dgoV2IdITR3OENXudQnXZiYZZilsIZBlPGwnad9/0qwy/lnZYud40XyiAbjH8fro0sDxohH1jLDnbt4ToLaOXf6CKYcAmL7gOtaoOflnKTTX8Q14CsDt45BsDlBBY2vaqpsAkT1q47UyBWbf2q1SaExfzAbcJiQ4TDl4g4MNYOqZr/SQn7iNh78BeQ+AKQcaewbWoLMfYBhcW3U0dgkIA7v85Jfx11haFNZPeQnElig9ZfhtidLTgLck0tcMk0VBnL4OtFWH6YvU0ZohmQ7wBUizT9PKvJazAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":14,"angle":0,"xoffset":0,"yoffset":6}},"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: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• InstructID (type: esriFieldTypeString, alias: InstructID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FirstName (type: esriFieldTypeString, alias: FirstName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Semester (type: esriFieldTypeString, alias: Semester, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Credits (type: esriFieldTypeDouble, alias: Credits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DepartName (type: esriFieldTypeString, alias: DepartName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Lecturer
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2022 2:17:27 AM

Schema Last Edit Date: 8/2/2022 2:17:27 AM

Data Last Edit Date: 8/2/2022 2:17:27 AM

Tables:

View_2$ (3)


Name: View_2$

Display Field: FirstName

Type: Table

Description: This table show the various details of the Lecturer/Instructor, name , course taught and location of departments. This is the main Sql query/ view created from all the 3 tables(Instructor, CourseTaught and Department).

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• InstructID (type: esriFieldTypeString, alias: InstructID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FirstName (type: esriFieldTypeString, alias: FirstName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Semester (type: esriFieldTypeString, alias: Semester, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Credits (type: esriFieldTypeDouble, alias: Credits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DepartName (type: esriFieldTypeString, alias: DepartName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: View_2$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2022 2:15:44 AM

Schema Last Edit Date: 8/2/2022 2:15:44 AM

Data Last Edit Date: 8/2/2022 2:15:44 AM

tblInstructor$ (4)


Name: tblInstructor$

Display Field: FirstName

Type: Table

Description: This table shows the Instructor details.

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• InstructID (type: esriFieldTypeString, alias: InstructID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FirstName (type: esriFieldTypeString, alias: FirstName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LastName (type: esriFieldTypeString, alias: LastName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DepartName (type: esriFieldTypeString, alias: DepartName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PhoneNum (type: esriFieldTypeString, alias: PhoneNum, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: tblInstructor$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2022 2:07:30 AM

Schema Last Edit Date: 8/2/2022 2:07:30 AM

Data Last Edit Date: 8/2/2022 2:07:30 AM

tblCourseTaught$ (5)


Name: tblCourseTaught$

Display Field: CourseID

Type: Table

Description: This table shows the details of the course taught, the title, semester, credits for teaching and so on.

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• CourseID (type: esriFieldTypeString, alias: CourseID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Semester (type: esriFieldTypeString, alias: Semester, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Year (type: esriFieldTypeDouble, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Credits (type: esriFieldTypeDouble, alias: Credits, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstructID (type: esriFieldTypeString, alias: InstructID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: tblCourseTaught$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2022 2:10:30 AM

Schema Last Edit Date: 8/2/2022 2:10:30 AM

Data Last Edit Date: 8/2/2022 2:10:30 AM

tblDepartment$ (6)


Name: tblDepartment$

Display Field: DepartName

Type: Table

Description: This table shows the details of the department, where it is located and the coordinates of the location of the building.

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• DepartID (type: esriFieldTypeString, alias: DepartID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DepartName (type: esriFieldTypeString, alias: DepartName, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Lat (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Long (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: tblDepartment$
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/2/2022 2:12:05 AM

Schema Last Edit Date: 8/2/2022 2:12:05 AM

Data Last Edit Date: 8/2/2022 2:12:05 AM