Looking to add arrowheads to line features to indicate flow or direction? Check out this article about how to do that in ArcGIS Pro.
Add Arrowheads to Line Features in Pro
Reply
Category Archives: GIS How To
Customize the Quick Access Toolbar in Pro
The Quick Access Toolbar, located above the ribbon in ArcGIS Pro, is where you can add commands you often need. This toolbar quickly puts those commands at your fingertips. Check out his article which shows you how to customize it.
Add Google Maps to ArcMap and Pro
So you want to add Google Maps to ArcMap or Pro? Impossible you say? Well here is an early Christmas present just for you … yes you can!
Before you proceed, think about why you would want a crowd sourced Google Maps basemap in your GIS anyway? There are better solutions today, like the basemaps provided by ESRI or even your own creations. For a government agency, replacing authoritative GIS data with crowd sourced data might not be a good idea.
Continue readingExcel Files in ArcGIS Pro
Ever get that annoying “Required Microsoft driver not installed” message when you try to open an Excel file in ArcGIS Pro? Check out ESRI’s guide to connecting to Excel files in ArcGIS Pro and fix it for good!
Creating Your First Dashboard
Looking to get a little fancy with your GIS data? Why not create a dashboard in ArcGIS Online? Click below to find out how to do it!
Excel Not Working in ArcMap
Maybe you used to be able to open up Excel files in ArcCatalog and ArcMap, or maybe your new install will not open them. You get this great message when you try to open Excel files:
Failed to connect to database. An underlying database error occurred. Class not registered
This happens when your IT group moves you to Microsoft Office 365 in the cloud, or you never had Microsoft Office on your computer. ArcCatalog and ArcMap depend on certain Microsoft Office system drivers to be installed on your computer which allows you to open Excel files in your GIS. Sure would be nice if the error message would tell you that!
Add Google Maps to QGIS 3
If you use QGIS version 3, you have the ability to add Google Maps layers to your map. The Google Maps layers are really Tile Map Services (TMS). The following is an example showing how to add Google Maps to QGIS.
Moving To PostgreSQL (Part 3)
Welcome back! Last time in Part 2 we configured PostgresSQL on a Linux server. Now it is finally time to create an Enterprise Geodatabase in PostgreSQL.
Keycodes File
You now need to find your keycodes file. This file was created when ArcGIS Server was installed on one of your servers. This file is written to \Program Files\ESRI\License<release#>\sysgen folder on Windows servers and /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release#>/sysgen on Linux. Copy the keycodes file to a computer that you run ArcGIS Desktop on. You will need access to it when creating the Enterprise Geodatabase. Continue reading
Moving To PostgreSQL (Part 2)
Welcome back! Last time in Part 1 we installed PostgresSQL on a Linux server. Now we need to do a few things to get it ready so we can create an Enterprise Geodatabase in it.
Postgres User
When PostgreSQL was installed, a postgres user was created. The postgres user is the default “superuser” to the PostgreSQL database. Right now the postgres user password is unknown to you. You must change it in Linux and in the PostgreSQL database.
Log back in to the Linux server and at the Linux prompt, use the passwd command to change the postgres user password. You might need to use the sudo command with it for it to work. Continue reading
Moving To PostgreSQL (Part 1)
Goodbye Oracle, hello PostgreSQL! I’ve decided to get out of the Oracle business and move our Enterprise Geodatabase to PostgreSQL. I’m tired of giving Oracle lots of money each year. PostgreSQL is open source and it is very mature. Though we do not have a dedicated DBA here that knows PostgreSQL, they can learn! And so can I. Besides, ESRI supports it and if something goes wrong, I can get them on the red hotline phone!
Over the past few years, I have been testing PostgreSQL on Windows by installing it with our ArcGIS Server installations and using it to store GIS data used in our map and feature services. I have had only one issue and it was a speed problem when selecting over 10,000 polygons in ArcMap. ESRI confirmed it was a bug. I believe that problem has gone away, so now is a good time to move to PostgreSQL. But just to be sure, we will be running both Oracle and PostgreSQL in parallel for a few months.
NOTE: To be able to install an Enterprise Geodatabase in PostgreSQL, you must be running ArcGIS Server (enterprise addition) somewhere. You need the keycodes file that was created with it to authorize the geodatabase. You will also need the st_geometry.so file that was created when you installed ArcGIS Desktop 10.6. More on that later. Continue reading
