Fall NEARC 2024: Full Schedule

arrow_back View All Dates

8:30am EDT

DIVE DEEPER INTO TECHNICAL SKILLS 2: Tiles and Tribulations

Wednesday October 30, 2024 8:30am - 9:00am EDT

Vector tiles are rapidly rising in popularity due to improved performance over raster tiles and the ability to dynamically style maps based on attribute data.

Traditionally vector tiles have required creating an entire static datset upfront before serving it. This can be quite time consuming and cumbersome -especially during the early phase of a web application build.

Recently the ArcGIS JS api has been quietly equipped with some features that allow reading of attributes from 3rd party vector tiles servers.

I plan to demonstrate how a developer can leverage pg_tileserv to automatically create instantaneous layers for any table, view or tileset returning function in a Postgis database and dynamically style them in the ArcGIS JS Api client without needing to pre-generate any static tilesets in advance.

I also plan to go over some tips for vector tile performance we've learned in recent projects at Stone.

Speakers

Andrew Joseph

Dev Ops Engineer, Stone Environmental, Inc.

Wednesday October 30, 2024 8:30am - 9:00am EDT
Lake Champlain A

User Session

Track Dive Deeper into Technical Skills 2

9:00am EDT

DIVE DEEPER INTO TECHNICAL SKILLS 2: Automating setup of Enterprise Geodatabase based Portal layers for data collection services

Wednesday October 30, 2024 9:00am - 9:30am EDT

Lake Champlain A

In my presentation, I will demonstrate our python based workflow for automating setup and the publishing of Enterprise Geodatabase layers within a Portal environment.
Enterprise Geodatabase is essential for managing large scale operations. In contrast, utilizing hosted layers for publishing data is convenient, however the data store is a black box and can only handle so much. In circumstances where domains are being updated on a regular basis, this puts a huge strain on the publishing services of an ArcGIS Server instance. As well as disconnected domains from one feature service to another.
Moving to Enterprise Geodatabase helps us properly manage our domains while not overwhelming ArcGIS Server’s publishing tools, by giving us direct access to the underlying data.
This process has streamlined our data maintenance procedures, along with standardizing our schema and improving our data life cycle management.

Speakers

Dallas Shearer

Software Developer, Terracon

Wednesday October 30, 2024 9:00am - 9:30am EDT
Lake Champlain A

User Session

Track Dive Deeper into Technical Skills 2

9:30am EDT

DIVE DEEPER INTO TECHNICAL SKILLS 2: Mixing Python with SQL

Wednesday October 30, 2024 9:30am - 10:00am EDT

Lake Champlain A

Python and the pandas library are great for processing data, but if you're working with a large database, SQL is often faster and more straightforward. While working on a large spatial data processing project, we've replaced much of our Python code with SQL while still using Python to run the data pipeline. We store our SQL code in a Git repository and use Python to test it, modify it using Jinja templates, and send it to the database. We've worked out a system in which each language does what it does best.

Speakers

Jason Wise, GISP

Software Architect, Terracon

Jason is a software architect with a background in Earth science, GIS, aviation, and utilities. He works with geotechnical engineers at Terracon to help clients choose locations for major renewable energy projects. He also volunteers with the Civil Air Patrol and as a trustee for... Read More →

Wednesday October 30, 2024 9:30am - 10:00am EDT
Lake Champlain A

User Session

Track Dive Deeper into Technical Skills 2