Ontario Canada GIS Resources

Province of Ontario open data portal

Ministry of Natural Resources – http://www.mnr.gov.on.ca/en/STEL02_168321.html
GLIN (Great Lakes Information Network) http://gis.glin.net/
LIO (Land Information Ontario) http://www.mnr.gov.on.ca/en/Business/LIO/
Ontario Basic Mapping (OBM) site by the Geography Network http://www.geographynetwork.ca/website/obm/viewer.htm
CLAIMaps – An interactive mapping tool that provides information on mining claims in Ontario, provides the ability to download map images as well as data in SHP format http://www.mndm.gov.on.ca/en/mines-and-minerals/applications/claimaps
Brampton, Ontario – http://open.brampton.ca/
Cambridge, Ontario – Grand River Conservation Authority https://data.grandriver.ca/downloads.html
Durham Region, Ontario –  http://opendata.durham.ca/
Grey County, Ontario – http://opendata.grey.ca
Haldimand County, Ontario – http://opendata.haldimandcounty.on.ca
Halton, Ontario – http://openhalton.ca
Huron County, Ontario – https://data-huron.opendata.arcgis.com/
Mississauga, Ontario – http://data.mississauga.ca/Canadian Open Data / Canadian GIS Data - Falls Viewer
North Frontenac, Ontario – http://data.nftwp.opendata.arcgis.com
Peel Region, Ontario – http://opendata.peelregion.ca
St.Catharines, Ontario – included with the Niagara Open Data website (https://niagaraopendata.ca)
Waterloo, Ontario (City of Waterloo) – http://opendata.waterloo.ca
The University of Toronto Open Data Catalogue contains various data sets http://maps.library.utoronto.ca/cgi-bin/open.pl?display=all

SharePoint 2013 - How to: SharePoint 2013 permissions controlled by AD Security Group will not update

How to: SharePoint 2013 permissions controlled by AD Security Group will not update


You have a site, list, or library with permissions assigned to an Active Directory security group instead of a SharePoint group or individual. When you add a user to or remove a user from the security group within Active Directory, their permissions on the SharePoint site are not updated right away.

Step 1: Windows Token Lifetime within SharePoint
SharePoint creates an authentication token for each user that logs in to the site. This token includes, among other things, the user's membership in various AD security groups. By default, SharePoint caches this token for 10 hours, meaning that the user's permissions within SharePoint will not update for at least 10 hours.

Step 2: Checking the Windows Token Lifetime on the SharePoint 2013 server
To check how often the user's Windows Token is refreshed in SharePoint 2013, log in to the SharePoint 2013 server and run SharePoint Management Shell (run as an administrator). The default PowerShell instance will not recognize SharePoint commands, so it's best to run SharePoint Management Shell instead.

Enter the following PowerShell command in SharePoint Management Shell:

Get-SPSecurityTokenServiceConfig

This will give you a lot of information. You need to look through the information for the "WindowsTokenLifetime" setting. The default setting is 10:00:00.

Step 3: Changing the Windows Token Lifetime on the SharePoint 2013 Server
If you need to change the WindowsTokenLifetime settings, run the SharePoint Management Shell (as an administrator) on the SharePoint 2013 server.

Run the following commands to change the update interval from 10 hours to 1 hour (You can, of course, adjust the interval as needed):

$mysts=Get-SPSecurityTokenServiceConfig

$mysts.WindowsTokenLifetime=(New-TimeSpan -Minutes 60)

$mysts.Update()

Issues

SPSecurityTokenServiceConfig is not recognized

Resolution

Have you added the SharePoint Snapin for PowerShell?

Add-PSSnapin Microsoft.SharePoint.Powershell

While trying control the site security using Active directory security groups I found this issue where users inside those groups were having an Access Denied Error. I realize that the next day they were able to get into the site but newly added users wont.

I assume this was some kind of synchronization problem, but it turns out is a default behavior, SharePoint will cache this group membership info for about 24 hours.

The time out can be configure to a lower value:

$sptokensvc= Get-SPSecurityTokenServiceConfig
$sptokensvc.FormsTokenLifetime = (New-TimeSpan -minutes 2)
$sptokensvc.WindowsTokenLifetime = (New-TimeSpan -minutes 2)
$sptokensvc.LogonTokenCacheExpirationWindow = (New-TimeSpan -minutes 1)
$sptokensvc.Update()
iisreset

This script will tell the token service that the claims will be valid for 1 minute and after that it will get the latest membership information from the Active Directory.

IMPORTANT: DO NOT SET THE LIFETIME VALUES LOWER THAN THE CHACHE EXPIRATION. If you do that the users will experience a ‘The context has expired and can no longer be used’ Error.

911 Analysis - Microsoft Power BI

Server Certificate: Export CRT and Key FROM PFX

1) Download and Install Open SSL : https://code.google.com/p/openssl-for... 2) Open CMD 3) Navigate to Open SSL-Win32\Bin Directory ------------------Retrieving the Private KEY------------------ 4) openssl pkcs12 -in thePFXfile.pfx -nocerts -out privatekey.pem -nodes ------------------Retrieving the Certificate------------------ 5) openssl pkcs12 -in thePFXfile.pfx -nokeys -out certificate.crt 6)Both the Certificate and the Privatekey Can be found in the Bin Directory of OpenSSL

QGIS - Lat Long Tool (Plugin)


I found out a pretty nice plugin which perfectly suited my needs about dealing back and forth between a local SCR and Lat/Long data with various web tools, so I thought I may share..
It's called Lat Lon Tools and it's an open source project developped by the NSA.
This tool is able to zoom easily to Lat/Long coordinates copy pasted from your clipboard or open directly a point from QGIS to a map in your web browser.
Lat Long tools menu screenshot

SharePoint Updates


Find and manage updates for SharePoint Server 2019, SharePoint Server 2016, SharePoint 2013, and SharePoint 2010 in one place. Use the links on this page to get more information about updates, and then download the updates.


Reference

SharePoint Updates Click Here

SharePoint 2013 - Enable Email Notification or Disable Alerts

Get All Alerts


#Variables
$WebURL = "https://SHAREPOINT/"
$ListName="EmergencyPreparedness"
#Function to Get All Active Alerts on a Given List
Function Get-ListAlerts($WebURL, $ListName)
{
#Get the Web and List objects
$Web = Get-SPWeb $WebURL
$List = $web.Lists.TryGetList($ListName)
#Get All Alerts created in the list - Which are Active
$ListAlerts = $Web.Alerts | Where-Object {($_.List.Title -eq $List.Title) -and ($_.Status -eq "ON")}
foreach($Alert in $ListAlerts)
{

write-host "Alert' - $($Alert.Title)' Created for User - '$($Alert.User.Name)'"
}

#Dispose web object
$Web.Dispose()
}
#Call the function Appropriately to Disable or Enable Alerts
Get-ListAlerts $WebURL $ListName

Enable email notifications for Tasks list in SharePoint 2013

In SharePoint 2013 you will find that the option to enable email notification for Tasks list is no longer there. It used to be under List Settings > Advanced Settings > Send e-mail when ownership is assigned? (Yes/No). It is still there for Issues list in SharePoint 2013 however.
The good news is you can still enable it for Tasks list in SharePoint 2013, and it still works. The only thing is you’ll need to use PowerShell.

Add-PSSnapin Microsoft.SharePoint.Powershell
$web = Get-SPWeb "http://myServer/myWeb"
$list = $web.Lists.TryGetList("Tasks")
$list.EnableAssignToEmail = $true
$list.Update()


OR

$site=Get-SPSite "https://sharepoint"
$web=$site.OpenWeb()
$list=$web.Lists.TryGetList("Tasks")
if($list -ne $null)
{
   $list.EnableAssignToEmail =$true
   $list.Update()
}


Reference