1.0 DCPLUS 20200412 17561100 20200412 17561100 https://www.arcgis.com/sharing/rest/content/items/5ff7061f5a4f47f4ae40f405f4391b3c/info/thumbnail/ago_downloaded.png https://www.arcgis.com/home/item.html?id=5ff7061f5a4f47f4ae40f405f4391b3c 5ff7061f5a4f47f4ae40f405f4391b3c Feature Service https://services7.arcgis.com/AHJOWTX3sFcnmA9U/arcgis/rest/services/finalproject/FeatureServer raymond_chelsea_finalproject 2020-04-12T17:56:11 2020-04-12T18:43:25 Mohawk College Campus Tables Employee Department Location Foreign Key Primary Key ArcGIS Pro Microsoft Sequel Server Management Studio Relational Database Management Systems course This map shows the locations and names of Mohawk College campuses in southern Ontario. In addition, there are related attribute tables that show employee and department information for each location. This is a map that displays the location and names of the campuses of Mohawk College in southern Ontario. The location information was created using two separate data files, the first being a table 'tblLocation' with the LocationID, campus name, street, city and province was created using Microsoft SQL Server Management Studio and imported to ArcGIS Pro and the second a .txt file with the x-coordinates, y-coordinates and LocationID's of each campus. These files were imported into ArcGIS Pro and using the geoprocessing tool 'Join Field' and the common LocationID field the table 'tblLocation' was joined to create a layer that showed the spatial distribution of each campus location and its information (i.e. name and address). In addition, a table 'tblEmployee' was created to relate each employee to the campus they worked at using the foreign key LocationID, as well as other attribute information like EmployeeId, First Name, Last Name, DepartmentID, Positon and Salary. The DepartmentID created a foreign key relationship to the table 'tblDepartment' to store the department names. <div><br /></div><div>These maps and tables were created as part of an assignment submission for the Mohawk College Relational Database Management Systems course.</div> Mohawk College Student, Chelsea Raymond (April 2020). Esri. ArcGIS Pro. Microsoft SQL Server Management Studio. Mohawk College. Disclaimer: The information contained in the tables 'tblEmployee' and 'tblDepartment' is a work of fiction. Names, businesses, salaries and incidents are products of the author's imagination. Any resemblance to actual persons, living or dead, or actual events is purely coincidental. -80.22442683041555 -79.71196077520771 43.262304195661386 43.14747328564723 1 /9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwDpaQjIwafJG0TAMRyAeCD/ACple/oz5t3QzbikPUA1IRmm7MnJ6UxiMARgAfX0qF12tjPapz19utVycsT60gEqSNdxFR1YiHFAE8MJkdY1AG44BJ4zVmHZaXskcqB4/uOCf6/WrVrNb3cUVm5KIDgKBkljnnP4n8hUUtraWyqJJVZ87XRD0wev8uPrWDnd8rOhU7JSTHwNFZSCWNWmiLNHj3zx+launEXNx5swILLuCseDwSKz4YbeWbyUERti/wArN95W2E/lkVdP29bOSRpLYJChKx9dy49PxrmqpPbc66LcdXsihbCxutUbzZHEC8IpGc13VqYVtIhDgRhBs+leY2909rMJVPI69s/lXR6b4kkuLyK3uggic7VK8bfSniKEntsicPiILfdnZCkY02NQAMZpX6VwHeytcO6o20bj6V53qEjSX0rsoVieg/KvQLk7o2B4A5+p9K8+1Bj9oO5ywUcZ7d8fma78J8TOHG/AinKcAUkLAOpIOM5NRsxZs4pQfSu8846yW8judPYGIKJ5EVGzjYccn9K5+4MnnyCVt0isQxznnNN85ngjiLZRCSB6Zxn+Qpmayp0uS5pVq89go79aKUAsQAMk8AVsZIT2orYkt7PSxEZiZr1fmaI42KewPrRWLqSesFoa+yitJyszNubaW1mMcqlWH61DXaO0TyL5kCsRwpK5xmsptFilndmkZAW4CqMCuenjoNe/ob1MFK/uamCAWYAAkk8AUMrKxVgQwOCD2rffQkiiR/PZJgoJI5Ab/wDXWLdQzQzstwD5nUknOffNdFOvCo7RZhUoTpq8kQlQwxUDRMtdNoun2zRGefZLu4Uddv196uzQ6W+/dGGY914P51jUxkIS5Tang5zhzXOLC1e09F+2wCRlVN4LFjgAVpvo8TAvHIVxjIY547/jUqaNbmHDTNvJ+9jgUPF0nHRiWFqKWxfu7a1vpJIU8uOVGXMi43Zx0/LFY1xpi2cG6Ykkyqu4DouOf1/lWimnnTC8okeWE4DYJDLz1469akubgXFtNm2eSMDkFec4446/jWEJuLXK7o6akFJXkrSKV2bW2WdooYpFeNFUgZCEhuf5H8RUz6bAjSqLcyeWEVRuI3Du38/bj2otrJn06WzXJ3L5jblwQ3YfpQLi6tNPlaVgfLl8ofJ94A4z/Oqbe0XrcUbbzWlv8zDvrR7aZlA+XOR3wD2+tV4mKkEdVORXUMU1CzG+BWmVQxUHqCAa5lo2jkZXBB9CK6aNTnXK90ctekoNSjsz0zTb5L23Vw+XAAcAfdbvVh2OMYrA8IxlbediAA20gZ9jz+NbF3MIkZhyR2zXmSjabR6sJc0EzB12SR7iKNHZSMkgemOo9e9chcSNPIztkknPrW5qeq2s0plgjfz8bQ24gKeeRWC2etehhoOKbZ52LqKTSTI9tAxSOfm60ojbP/166jkJQcjilxV/TdPSYBpGOzPX/P8AnmtG5tbd4vLVRGg5DheST/kVyzxlOE+Rm8cLOUeY5+r2lJ/pLTYDeQhkCnncR0GP89KbcadNBKijDpIwVHHAJP8AKpLayujsltSwblSc45yeAe4x3rSdSDhdPciEJRnqtilJI8sjO5yzHJ+tFbkWiSKizkhJ4yCqg/K2Md+xoqPrUNos0WGm9ZL8DQPMo2MCD1qVSBgKRubpxXPPqbyRtFEpVmOFwOf/AK1Pnv7jS4I0fLTsONx4Vfb8eteYsLU2e/Y9D6zT3Wxv3Ept7d5NgcoC2M9a52XUjdWbRPChmwAXPXA7898/zrOvNRnupiWchAflQE4FMVgw4r0MPhVBe9ucVfFObtHY39PmhMY8m0KMEwZCTgt+fPeg7nQkRrweM9T/APWqtZaiiRJbuhCjhSOSSev9ajvNQ8mZmjwB/DgcH86461CpOq0kdFOtBU02y8s6xBgVYE9hzj2p32jcQduAeCVxWZDqaTDZIrKccEfNnjp/npT5hL5akY5XsD36Y/CuedKdJ2kjeFSM17uppW0rxO3mTMwf5uf6f57VpRTq8ZZiMAZ3D0Fc80m+MBmPGMfN1qeO4aMKMgJ6A0KSl6kRly6G39oEKu0hwgGS2aw9Uuo7myDxXJOHwY8dQOh/r/8AqpNSla5tFEQyqn58fp+FY+5gMAnGc4r0MLSTXOnqc2Jrv4LaHRaVJZqs0MTtkfOzOMN0xxjrjJ/OsXUJHNwUdlby+Ny/xe9bt7Et3ZGSMKZVwyOvyk9P6Vgajay2zqJOSyhs+vHP61dCUZTcr6k11KMFG2h1XhCffBMhI+UD+tZPiLU2a9eGJx5a5HA5z0P+FYllfz2MrNA5XcNre4pk8zXNw8r5JdiTmtI0Eqrk9iZYi9JQW4+JwHVnXIB5HrWlf/2Ylmi2pLTsQcjPAx3/AMKyC2OBSgYG4/lW0oXad9jnjPlTVtxGUlulT28LyuEUEk+lOSNmiMmCVX9Ks2M6wJLwS56ADt3NRVqOMG4asqnFSklLRF+eT7NEIlPzoNqjHU0ZLRqkmMgZbB4qndMTLG7HMu4cCphGzbZNxCkAjA/SvGlG0FN7u53qpeTSHxmUD9++9FYMqnt6H8ql+1Oduz5UHAA6AUhhKISobA7/AFpotJMbjgAjIGcVhOq5PUuMWtiyl6zBtzHANFQ28QDtvRjluc9v880VPMapsx7KUR3kTkDg856D3/DrVW9vTd3JYY2rwoPQ+p+vv7VXklyCqkkHq3+FQ4Pavo3BOfP1PHU2ochOGQtlmA/3qVXRTkv07LzUBJU4PbjNGT0q7klw3jLkRqFH949ag3ljknJ9ajB4pQTRYLkynHSr8MvmIFzyDxzWaCanh5kUHucGscRSVSDRpSqOErm7YhbmeO2l2hCTggYJwCRz37Vdk0QruaKUtjkKRyarx2RQQTW6t5gbcXXlQpzjj/PSt62lMi7irKc4wa+alNp3ie1GlGS945hvNtSNwKnuM5qKVUnHmJGNxYbsHmuo1LTnu4lkQgMox8wzXPxWF1uOyNpFDMu4DpjrXXQrP44Oz7HJVpWfK9iUTLEm0sAgGAD6dqgnkju0VHw2BhXA5FLcKYI/3/ylv4SpGB9azzOkEokBVschSOBW+HhOpLmWjM6s1FWZSkTacgU0OMVYmmjYmRUABPCjtVTqc9K9pbHnkhJHNOVg52k4A/WmkfLUeSGBB57UAdPZx2ciC2EiiNosyyMOA3UDJ9P1xS6ZpjJvnnkCRMrIvy/6xSDyM9u/Ss3SS8d7E1zaiSFjglhwAe9bl9qS/a1jSSENnGGJP/oOT/n2rxsVUqU5OFN35j0KMIzSlNWsOh0mBrjzGmLGNh8vAAx7D/PFTPbLK+GQ7sZGQRzVaC4jbfHcn95GzbQmVyR0Gc/WpbjVV0+GNZsSuzYG1+QvXJx3HT9a8+SrVZqD1Z1JU4xcuhcWyXy03bi3cdQe/pTordVX5kQA8gKOlVrPWba8Dq0scbFvlTJHH1IHNT2l015ez26RgLDxuLcn3A9P8RWbo1U2mtjWEqbs09x9rAsMKq/LE5b2NFSx7287fG0eyQoCf4sdx7UVEoST1N4wTWh5cDk09gBxnmmjK8jrSHk5PWvrz5ok2E59etNK7aTPbFP2hiMHikAzNKDSlSOKTGODTQDgxqSOQq6sOxzUYFOFD1A7KymSWKPyy0iMgOd+CuByCeDx/Wr9o7eYAHVl2AYXnH+eK4/Sr97K54cKrcZYZA9OP89TXV2tyJZWbaAwJyCORjqD7j/PWvncXhXRemx7mGxEasUnuaMtyybY0ALseAazL+5M2IY4YjnJDFOmevP5/X86o6zrAt71I4xuKDJOfX6dKzkv3uoJo3ZIjtyDjqeuM+/NKjgKkoqdtGY1cVBScSrqd5m5ZItgVcD5DkE+tZjEk5JpZf8AWnPXNMLZNfQU4KnBRj0PKlJyd2KrHpmpUXpk0yMc05nxV3ESOy7e/tUO3cd2cc+tIW3gD0rS0nS5NTuRDGcYG5mPQClKSirvYcYuTstzodPu2bSYvstpO7p8oIxjdgDJPpz3rPfQL/8AezyiM/KWZiSfxzjGa6yy0/7OkUTOX2rtAIACgfSrQlCJt28E44BxXgRxPs5ydNbnuPCKcEpvVHnv9oSJJGGYuAOWKgN69Rz196uwahauY0ukDOpwpG0YB55Pbk11qaNYSXaTtaIHXngfKfYjpnnP4Corjw/pTI8sdmpbBOA7KD7cHiuiVfDz3TXoc0cNWhs0zOi01ZLcX0MMWXHAPGf/AK/9ajtbeeDWFuIo12CPadvBbjg47c447CtjTbyKeBPLXbj5dhXGMdf1yPwqhqL/AGTVMNCNkozEY1PzEdd3uD3HbGa5Ie055Jdmtex2OMFGLflsXDdR+RuZlj7AEcZxRWf9rtHtAjzW00xA2/OCS2Me2OgoqPYtfEmbc8XszgNwxwMUuMj3+lSGNWY7QfxpNpU/pX01j5kAV28D8xSZVeeaRxjt1pOR78UgHByD7U3rTxhh70mKaAQA04e9IBTsUwHDFXLK+ks5/NX5sepqkKcDmpnCM4uMtmOMnF3RrySWN7ciVpCkhA+Qrw361Uljnt5WcHYhPGecj6d6p7c9qsCb90sMgMipkqoOME/0rCNGULcruuzNHUUrtqzI5pIpQ5MeDxgqcDvzzmq7RbUDLyO/FdfaW1klu6SooRVAYEgsx5P4Hk/pVG5soLqNmtrd4UQfNk55JOP8+9YQx1Lm5XdGksPO1zn48CmN1yfyq3c2b2789PUVXxng/wA67otSV0czunZiJtJrsvBj7be7PGNyY5Ge/wD9b9a47YAauafqD2E+V5jJwwBxkVjiacqlFxjubYeoqdRSZ6f5kQO8K271pqMHKkqOhySOxrmIvE9msOWlbcB90Ifyqe38S2k+QpdWJ+VWGCf6V8+6FdK7hseysVSelzoJEjYh0nJC5G0NkZ/xoMqBCBzg88Vlf2opGAVyBnmpra+jnxjGB6f4Vi3LexoqsXoZweTTdXchR9lmy5yB8pxz+YH51evfEunWce3eZnHRIuc8dz0AqLyBOrpMqOHJBJyc/p9a5TxBNbLdrbWcaIkQw7IPvMf8Mfnmu/CxjiJpSW2/9fgc9epKjTco9SneXf2u9luPLWMO2Qi9FHYUVWxn7tFe8kkrI8Rtt3ZIFVWwoPPfnH601guck4p7qwb5mLcfxdqZg7/m3AdPX9KFe2oELc8CmgZ7VaCjPOBUcqhep69s0MCMqVGaUNRksuDSqo9aACjrT9uBwaQUxCCndBSimk0DFDY5q1p7J9ui37cAk/MO+Dj9cVUyMU3nPFTKPNFruOLs0zowDsA54Hc5oUc/Wm2N1HfPtDstxtGEIAVz3Ix0/wDr1qJHGXUbCq5wB1Ib0NfO1YSpO0j04x5/eT0IYbBLxMSIGUe/P4f57VSv/DXk2z3EE4KopYq3XGM8EV0UFusKEKSckk56muf8RXMqW0VsrbUckuBwTjpn2/wq8JWquqoQegVqUI03KS1OZLnOM8VIqg8n8aiI5qZPu19AeWMIG6p7O48m4R8BgDUD4ximxDLgUNJqzBO2p2zWiTQpJC3JUNz3zSxWax3HlySbd64DKQGB9v1rQtrTZbQCOQPGqgA5zkAYo8ryi2QrD+LPGRXyrnaTSPbVPZtGN4i1CW3g+zwMyiYtvY8HHAwP6/8A665RVy3zGuh1horma3somBmR9hY9BnHU1l6parY3KW+7c6oC5HTPtXuYHlhTjG1m7v8A4J52J5pzcr6IqAFTRTuwHJwOfaiu45TofFFokDQ3KLtaQ4ce+DzWCSRj3HOaveINR+33+IziGPoM557/AMqz0O9QO/SubBRmqEVPc2xLi6rcNhuG3KDz6VFM26U9eOKu/ZybUzqOEO05I/T16GqG0hju69TXRdPYxsAOKcCCeabg5xRyKoCXp0OaUEVED71IGGKAHikIFCnNBODzQAhFIemBTuvSm0CNDRiI74y84jjY5BxyeP6110Fu8UIyQxJJJB7mua0CCN3aRy2fMQBQOuDnP6CuuupoLWxMjSIjRqSqswG7GTj9K8DMZOVbkR6+FSVC7MnVdUks4cIFDt2POPeuUubiW7l3yMWbGM4qTVNQa+u2kIwOy+lUw5Bzk16eEwqowV17xwV6zqS0eg0qd3NSKMdKOpp2PlrsMCNhnvSg7AF75yaVjt+tRUAd74fvVk0+KMNloxh/Uckj9MVa1G7W2haZtpABO0nBOB/jiuIsNSexLkZO4etLe6lcXxTzcBB0Vc/1rx6mXSnXcvsvU9OONiqCj9pDUu9mqC42DiXeVH1ziob24a5vpZyoUuc4Hao42JlLYpWGDuPX0r1eSKlzddjzeZ2sNUt1Jopu7caKYiSdt8zPgDcScDoPaiD5pVGcZOKKKHpHQa1ZoXIMIMAY7DtLAcbj1GfzqhNtTGFzuooqaX8NPuOp8bRCO59KQ0UVoSApwoooESDrSmiigY3OKcAMdKKKANvQ2KsdvGFP8xVfWLiR7mQsSdmVGTnvRRXn0Eni5v8ArodtV/7NBeZiA5OTSniiivQOIeDUg5FFFACBctk88d6aRgbveiigQ080FyzYNFFJDLCptHBpjjFFFMCIDmiiigR//9k= 5ff7061f5a4f47f4ae40f405f4391b3c https://services7.arcgis.com/AHJOWTX3sFcnmA9U/arcgis/rest/services/finalproject/FeatureServer Feature Service EPSG