geodatabases

QGis, MySQL e LeafletJS [ENG-SUB]

QGis, MySQL e LeafletJS [ENG-SUB]

So it’s true, you can connect to MySQL QGis! From the connection to the local database to the production of a web map, which is updated with the database. Among the default connections of QGis are the databases Postgres / PostGIS, MSSQL and Spatialite, because these can manage geographic and geometric information. For about a year or so, even though ...

Read More »

Docker and ArcGIS – 02 – File, Client-Server, Services and WebGIS

Docker and ArcGIS – 02 –  File, Client-Server, Services and WebGIS

This episode was really exciting for me to record. First we talk about file geodatabases, then we discuss how Docker can fit in to swiftly deploy containers of ArcObjects for Linux clients with File geodatabases. Then we went ahead and talked about Client Server with enterprise geodatabase, which evolved into the ArcGIS for Server, to the mother of all weapons, ...

Read More »

Docker and ArcGIS – 01 – The ArcGIS Stack

Docker and ArcGIS

As a Geogeek, I always want to augment cool new technologies with my line of work, ArcGIS. Docker is proving to be the future in terms of simplifying deploying and scaling. This Youtube series is my attempt to start to unravel the marriage between these two technologies. This is something new and different in this channel. IGeometry has always been about programming with ArcGIS, ...

Read More »

WalkLite in Mobile GIS: A Schema to Extend and Symbolize SpatiaLite

WalkLite in Mobile GIS: A Schema to Extend and Symbolize SpatiaLite

The open source database SQLite/SpatiaLite has been widely used for presenting geospatial data in geographic information systems (GISs), especially those run on mobile devices. A SpatiaLite database defines tables with geometry column for layers, and spatial indices for speeding up spatial queries. However, one of the issues remained to be resolved is how to define a framework symbolizing the portable ...

Read More »

the_geom Vs. the_geom_webmercator columns in CartoDB/PostGIS

the_geom Vs. the_geom_webmercator columns in CartoDB/PostGIS

The differences between the_geom and the_geom_webmercator columns in CartoDB/PostGIS. Visit this github link to download the data and for the SQL statements used in this video https://github.com/TipsForGIS/geomVSG…

Read More »

PostGIS – Load shapefile

PostGIS – Load shapefile

PostGIS tutorial explaining how to create PostGIS database, import shapefile and connect database in ArcMap

Read More »

Analyzing Fire Department Response with PostGIS

Analyzing Fire Department Response with PostGIS

Local government fire departments always face scrutiny of their performance and efficiency. They are continuously asked to do a better job with fewer resources. In this highly technical session we will show how PostGIS is being used to analyze and measure performance throughout the city and plan for future resource requirements. Every city we work with is unique in some ...

Read More »