territorial data management systems - gcnwa experience · connections and updates between filemaker...
TRANSCRIPT
![Page 1: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/1.jpg)
Territorial Data Management
Systems - GCNWA
ExperienceHugo Mailhot Couture
Ndakinna Office – Grand Conseil de la Nation Waban-Aki
![Page 2: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/2.jpg)
Round table: your expectations /
needs?2
![Page 3: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/3.jpg)
Table of content
1. Management of consultations and computerized Solutions - What do we stand to gain?
2. Data management: from a necessary evil to a structuring element
3. Developing a database
4. GCNWA’s app
5. Development / collaborations
3
![Page 4: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/4.jpg)
1. Management of consultations and
computerized Solutions - What do we
stand to gain?4
![Page 5: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/5.jpg)
What do we stand to gain?
1. Environmental communication and analysis for consultations
2. Monitoring of the consultations and commitments of developers
3. Credibility during negotiations/consultations
5
![Page 6: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/6.jpg)
Environmental communication and
analysis for consultations
Integration and analysis of data on:
Land use and occupation
Aboriginal ecological knowledge
External sources (western science)
The components/impacts of a project
Facilitated and credible presentations and communication:
Environmental and cultural sensitivities
Stakes of the Nation
Implications for rights and interests
6
![Page 7: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/7.jpg)
Example 1: Energy East consultation
(First Nations issues are not limited to
fishing sites)7
![Page 8: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/8.jpg)
Example 2: Data analysis for a
developer – Asking the right questions
Has the fish habitat
changed?
8
![Page 9: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/9.jpg)
Monitoring of the consultations and
commitments of proponents
Centralize the information on:
Important steps and dates of each consultation
Environmental commitments to the Nation
Expected dates for accountability
E.g.: Developer’s report following a development project (5 years after construction)
Making information available for the team:
Flexible access according to tasks
Institutional memory in the event of staff changes
9
![Page 10: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/10.jpg)
Credibility during negotiations/
consultations
Communication history (have we been adequately consulted?)
Crown
Proponent
Etc.
Easier to evaluate/prove compliance (or lack of compliance) with
commitments
10
![Page 11: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/11.jpg)
2. Data management: from a
necessary evil to a structuring elementBackground information on our process
11
![Page 12: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/12.jpg)
Sample data – Biography mapping
Course of the interview
Directed interview lasting
approximately two hours
Marking (by interviewer) coded
on paper map
Digitization and georeferencing
12
![Page 13: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/13.jpg)
Database VS spreadsheet
Database Pros
Nearly infinite connections between data
Management of large amounts of data facilitated
Easy to use (if properly set up)
Helps to standardize the data
Cons
Complex to set up
Requires expertise for maintenance
Can be costly (acquisition)
Spreadsheet
Pros
Easy to set up
Simple to use
Allows for certain analyses (dynamic
crossing-referencing table)
Affordable (Excel)
Cons
Limited connections between data
Tedious analysis (amount of
important data)
13
![Page 14: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/14.jpg)
Database – structuring element
Confidentiality and security
Institutional memory
Work efficiency:
Linking of information
Automation of operations
14
![Page 15: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/15.jpg)
3. Developing a database - How
does it work?Best practices and pitfalls to avoid
15
![Page 16: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/16.jpg)
Know your organization
What data do you have? (Land use, Membership List, etc.)
Do you want to add new data types?
How are they currently managed?
Who is responsible for managing them?
Who uses them?
Who generates it?
16
![Page 17: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/17.jpg)
Understand your needs
Why did you collect these data?
Speciofic objectives?
Projects / tasks that need it?
Are these data used for these reasons?
Yes How?
No Why?
Are these data used for other purposes?
17
![Page 18: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/18.jpg)
Talk with users / "producers" /
managers
Get to know:
Their interactions with the data (When, what, how, why)
What are their tasks, how do they realize them?
Target potential improvements by knowing:
Limits in their work (lack of time for X, too much Y, etc.)
What would they like to do with the data?
18
![Page 19: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/19.jpg)
Some basics
Table - Excel sheet equivalent
Field - Equivalent of a "column" in excel
Unique field - Reference when creating relationships
Relationships - Link data from multiple tables
Forms - User interface, allows data entry
19
![Page 20: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/20.jpg)
Planning the structure - Tables and
relationships
Schematize tables and relationships before you start!
What are the "logical" links between "tables" that you already have?
Example: Interview participants VS Interview results
Anticipate possible links with your future data
Provide unique identifiers (yes, numbers!)
20
![Page 21: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/21.jpg)
How does it work?
Table: Participant
Participant number (u)
Last name/First name
Address
Etc.
Table: Interview
Interview number (U)
Participant number (ref)
Place
Date
Time
Subject
Etc.
Table: Use of the land
Point number
Interview number (ref)
Resource used
Season
Etc.
Table: Region (importation)
Table: Province (importation)
Table: Cities (importation)
Table: Type of resource
Table: Participation in a consultation
Table: GCNWA employee
21
![Page 22: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/22.jpg)
Plan for uses - Forms
Data Entry Forms (normally one table only)
Forms and report see data (links between tables)
Data analysis
Use of data
22
![Page 23: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/23.jpg)
Data entry form23
![Page 24: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/24.jpg)
Analysis form / report24
![Page 25: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/25.jpg)
Advice
Assess capacity before starting (undergo training if necessary)
Long-term planning (plan functions / tables)
Segment the job (phase / functions / tables)
Plan backups for data
25
![Page 26: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/26.jpg)
Developing?
Pros
Flexibility/adaptability
Limiting recurring costs
Sustainability
Adoption by the team
Will exactly meet your need.
Cons Higher initial cost
Internal expertise required (creation and maintenance)
Minimized by FileMaker
Required IT infrastructure
Depends on the chosen scalability
Development dependent on your "free time“
Requires the ideal conditions (expertise + initial funding)
26
![Page 27: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/27.jpg)
Purchasing?
Advantages
Development independent of:
Internal expertise
Available time
Initial cost minimized (depending
on the provider)
Advanced features available
Concerns Sustainability vs. Intellectual
property?
Dependence on an outside provider
Recurring costs (vs. "variable" financing)
Confidentiality and control
Physical location of DB vs. legal context
Features/development adapted to other clienteles
27
![Page 28: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/28.jpg)
4. GCNWA’s appFilemaker interface, server and database
28
![Page 29: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/29.jpg)
Features
Current use
Research data
Interview data
Information on the members
Telephone interview forms
Access/security management
Consultations: interactions with
the members (development)
Needs/To come
Consultations: interactions with
developers/governments
Environmental and commitment
monitoring
Archiving of documents
(limitation)
Complex statistics and analyses
(limitation)
Map interface (limitation)
29
![Page 30: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/30.jpg)
User interface
Simple
navigation
30
![Page 31: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/31.jpg)
Respondent’s formImportation of
data (survey
results)
31
![Page 32: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/32.jpg)
Return from the field – data entry
Standardization of the
data
Institutional memory
32
![Page 33: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/33.jpg)
List of respondentsRegion / province /
country automatic33
![Page 34: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/34.jpg)
Why is this of interest?
Too much useless data?
A resident from Wôlinak is obviously in the Centre-du-Québec region!
Each field is "searchable" and can be sorted
34
![Page 35: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/35.jpg)
Example: Sorting by region35
![Page 36: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/36.jpg)
Example: Search by hunting area or
hunted species
36
![Page 37: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/37.jpg)
Viewing data and links (personalized
forms)E.g.: All participants who
spoke about a resource
• Planning of interviews
• Understanding of the
activities and dynamics
• Response to the
consultations
37
![Page 38: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/38.jpg)
Telephone interviews for a
consultation?
Rendering automatic (decreasing
entry errors):
• Creation of the forms
• Member identifiers (#)
• Identification of the interviewer
• Links
38
![Page 39: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/39.jpg)
Telephone interview form (cont’d)
Who participated in a
consultation?
What consultations did a person
participate in their life?
Who from our team spoke to which
member of the Nation for a given
consultation?
39
![Page 40: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/40.jpg)
5. Development / collaborationsFuture features / Needs
40
![Page 41: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/41.jpg)
Current main limitation: GeomaticsConnections and updates between
FileMaker and GIS are done manually
(limitation = internal expertise)
41
![Page 42: Territorial Data Management Systems - GCNWA Experience · Connections and updates between FileMaker and GIS are done manually (limitation = internal expertise) 41. Needs / development](https://reader035.vdocuments.us/reader035/viewer/2022081615/5fdac41b57cc7966c25f3f8c/html5/thumbnails/42.jpg)
Needs / development
Consultations: monitoring and interactions with proponents /
governments
Archiving documents
Geomatics interface / environmental data
"Standard" resources and procedures (not computerized)
42