EPA Parcels Project
NC INTEGRATED CADASTRAL DATA EXCHANGE Funded by US EPA Grant 83431001 Prepared for Statewide Mapping Advisory Committee April 16, 2014
2
Parcels…
Master Schema • OWNNAME -The full parcel owner name • MAILADD -The full mailing address (single string)
• SITEADD -The full site address • PARNO - A unique identifier used for the parcel • IMPROVVAL -Value of improvements • LANDVAL - Value of land • PARVAL - Total value of improvements and land • PARUSEDESC- Primary parcel use description • GISACRE - Parcel calculated land area
Crazy Quilt • tables
6
Same (Translated) Field Names Across the State
7
Collaboration in North Carolina
8
Team Work Players
Expertise
• Carbon Project, Inc.
Application development
• Fairview Industries, Inc.
Parcel data / standards
• Atlas Geographic Data, Inc.
Parcel data analysis / management
• CGIA /ITS
Project management / partners
• Dept. of Secretary of State
Parcel data / standards
• Department of Transportation
Parcel integration
• NCEM, DENR, DOR…
Parcel data applications
• Tribal and local partners
Data development and management
9
County, State and Tribal Partners
Why Compile Datasets? More than one county can be involved in: • Disaster response • 911 call answering • Floodplain mapping • Transportation planning • Economic development •…
Why not just download? • Published cadastral data • 100 county websites • Availability county by county? • Consistency in property descriptors? • Field definitions? • Metadata?
Why not just call a county? • Local effort duplicated • Multiple versions acquired
• Integrating with GIS tools is time consuming
13
Seamless Parcels Project Security – NCID authentication approved for production Transformer – User Interface finalized EPA Exchange Network – EN REST registered NC OneMap – web services created
14
Cloud-based Transformer
Fully cloud-based set of tools…
15
Cloud-based Transformer
Parcels ‘Transform Group’… there can be others
16
Add a County
Import the county data for the new county using the right pointing arrow key on the top of the county banner. This will open a standard file selection operation. Use the shift key to select multiple files.
17
Upload a Shapefile
18
19
20
County and Master Schema County Schema (starting point)…
Master Schema (ending point)…
21 Percent of Counties with Values in Selected Fields, 25 Sample NC Counties REVISEDDATE
Values in Attributes? GISACRE
RECRDAREANO
SALEDATETX SOURCEDATX SOURCEDATE SZIP
SSTATE SCITY SITEADD MZIP MSTATE MAILADD OWNNAME Percent
OWNTYPE PARVAL LANDVAL IMPROVVAL PARVALTYPE STRUCTYEAR STRUCTNO MULTISTRUCT STRUCT PARUSEDESC NPARNO PARNO CNTYNAME STNAME 0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
22
Cloud-based Transformer
Saves county schema, data and transforms to turn the local data into the standard
23
Cloud-based Transformer
Multiple transform functions can be performed on county data to produce standard data content
24
Jobs Output and Publishing…
Polygon and Point (automated on cloud) Shapefile output …
25
These are files…
Polygon and Point Shapefile output …
26
Jobs Output and Publishing…
Lets make them services…
Hit ‘Publish’ to send the standard data to WFS and EN REST
27
WFS • Key service interface for
Integrated Cadastral Data Exchange is Web Feature Service (WFS) • Provides interactive
geographic features, each of which is a representation of a “real-world” parcel • Standard, well known
Operations and Filters…
28
EPA Exchange Network http://ncservices.cloudapp.net/wfs/
29
WFS in AutoCAD
30
31
32
NC OneMap – Discovery and Access • http://data.nconemap.com • Parcels • Create feature class in NC OneMap Database (25 counties) • Publish web services • Package downloadable data • Use WFS from the Cloud to update database
33
Reaching More Consumers • Web Services from the Cloud (Carbon Project) • WFS and open geographic data • EPA Exchange Network REST • Open Data formats • JSON • KML • GML • CSV
• Web Services from NC OneMap (ArcGIS Server) • Esri REST • WMS • WFS • JSON
34
Web Services on Desktop • Example of ArcMap and web services • Land development example • Display 4-foot contours and parcel boundaries over orthoimagery • Identify attributes of parcel of interest
35
36
Benefits • Standard data fields – consistent for multi-county areas • One source for web services with statewide parcels • Data consumers • Business uses range from environmental assessment, emergency response, to many other government and commercial functions • Data producers • New customers and eyes on data, ‘opens’ data • Metadata is a product • Data retention (disaster recovery / archiving)
• Application developers • Much easier to create applications that solve problems • Reusable services and cloud
37
Questions and Discussion?
EPA PARCELS PROJECT Contacts: [email protected] [email protected] [email protected]
2
Parcels…
Master Schema • OWNNAME -The full parcel owner name • MAILADD -The full mailing address (single string)
• SITEADD -The full site address • PARNO - A unique identifier used for the parcel • IMPROVVAL -Value of improvements • LANDVAL - Value of land • PARVAL - Total value of improvements and land • PARUSEDESC- Primary parcel use description • GISACRE - Parcel calculated land area
Crazy Quilt • tables
6
Same (Translated) Field Names Across the State
7
Collaboration in North Carolina
8
Team Work Players
Expertise
• Carbon Project, Inc.
Application development
• Fairview Industries, Inc.
Parcel data / standards
• Atlas Geographic Data, Inc.
Parcel data analysis / management
• CGIA /ITS
Project management / partners
• Dept. of Secretary of State
Parcel data / standards
• Department of Transportation
Parcel integration
• NCEM, DENR, DOR…
Parcel data applications
• Tribal and local partners
Data development and management
9
County, State and Tribal Partners
Why Compile Datasets? More than one county can be involved in: • Disaster response • 911 call answering • Floodplain mapping • Transportation planning • Economic development •…
Why not just download? • Published cadastral data • 100 county websites • Availability county by county? • Consistency in property descriptors? • Field definitions? • Metadata?
Why not just call a county? • Local effort duplicated • Multiple versions acquired
• Integrating with GIS tools is time consuming
13
Seamless Parcels Project Security – NCID authentication approved for production Transformer – User Interface finalized EPA Exchange Network – EN REST registered NC OneMap – web services created
14
Cloud-based Transformer
Fully cloud-based set of tools…
15
Cloud-based Transformer
Parcels ‘Transform Group’… there can be others
16
Add a County
Import the county data for the new county using the right pointing arrow key on the top of the county banner. This will open a standard file selection operation. Use the shift key to select multiple files.
17
Upload a Shapefile
18
19
20
County and Master Schema County Schema (starting point)…
Master Schema (ending point)…
21 Percent of Counties with Values in Selected Fields, 25 Sample NC Counties REVISEDDATE
Values in Attributes? GISACRE
RECRDAREANO
SALEDATETX SOURCEDATX SOURCEDATE SZIP
SSTATE SCITY SITEADD MZIP MSTATE MAILADD OWNNAME Percent
OWNTYPE PARVAL LANDVAL IMPROVVAL PARVALTYPE STRUCTYEAR STRUCTNO MULTISTRUCT STRUCT PARUSEDESC NPARNO PARNO CNTYNAME STNAME 0.0
10.0
20.0
30.0
40.0
50.0
60.0
70.0
80.0
90.0
100.0
22
Cloud-based Transformer
Saves county schema, data and transforms to turn the local data into the standard
23
Cloud-based Transformer
Multiple transform functions can be performed on county data to produce standard data content
24
Jobs Output and Publishing…
Polygon and Point (automated on cloud) Shapefile output …
25
These are files…
Polygon and Point Shapefile output …
26
Jobs Output and Publishing…
Lets make them services…
Hit ‘Publish’ to send the standard data to WFS and EN REST
27
WFS • Key service interface for
Integrated Cadastral Data Exchange is Web Feature Service (WFS) • Provides interactive
geographic features, each of which is a representation of a “real-world” parcel • Standard, well known
Operations and Filters…
28
EPA Exchange Network http://ncservices.cloudapp.net/wfs/
29
WFS in AutoCAD
30
31
32
NC OneMap – Discovery and Access • http://data.nconemap.com • Parcels • Create feature class in NC OneMap Database (25 counties) • Publish web services • Package downloadable data • Use WFS from the Cloud to update database
33
Reaching More Consumers • Web Services from the Cloud (Carbon Project) • WFS and open geographic data • EPA Exchange Network REST • Open Data formats • JSON • KML • GML • CSV
• Web Services from NC OneMap (ArcGIS Server) • Esri REST • WMS • WFS • JSON
34
Web Services on Desktop • Example of ArcMap and web services • Land development example • Display 4-foot contours and parcel boundaries over orthoimagery • Identify attributes of parcel of interest
35
36
Benefits • Standard data fields – consistent for multi-county areas • One source for web services with statewide parcels • Data consumers • Business uses range from environmental assessment, emergency response, to many other government and commercial functions • Data producers • New customers and eyes on data, ‘opens’ data • Metadata is a product • Data retention (disaster recovery / archiving)
• Application developers • Much easier to create applications that solve problems • Reusable services and cloud
37
Questions and Discussion?
EPA PARCELS PROJECT Contacts: [email protected] [email protected] [email protected]
