
A brief overview of all the sections in this course
Introducing the geodatabase/GDB format, the future format at ESRI that is better than SHP. However, SHP can still be used for small-scale projects.
Open the ArcGIS PRO 3 application, create a new project in ArcGIS PRO 3. Copy the training data to the training folder.
Add some SHP data to ArcGIS PRO 3 canvas and convert it to Geodatabase/GDB format either individually or in bulk.
Before being processed in ArcGIS PRO 3, field data in XLS format is first cleaned, such as column names that should not contain spaces. Then this XLS is exported to CSV.
The CSV that has been exported from XLS is then plotted into ArcGIS PRO 3 using 2 (two) columns/coordinate fields Longitude and Latitude. The results of this plotting are then exported to GDB
After the data is plotted and exported to GDB, we will perform data cleaning. Every data always has errors, in spatial data often the location of the data that becomes an error such as the position of the point being off from where it should be. So we will shift these points using the existing attribute data, namely sub-district and village/urban village data. This technique is called Geocoding. We already have SHP data for administrative polygons of sub-districts and administrative polygons of sub-districts that have been exported to GDB. This administrative polygon data is a benchmark in performing geocoding to shift the points that are off.
Although it does not happen often, data type errors can occur when we export from csv to GDB. Therefore, we will clean or convert this data type, for example from text or string type to float, double or numeric type.
IF your conversion data from CSV to GDB has no data type constraints in the column/field Monthly_income_IDR AND Annually_income_IDR should be in the numeric data type, namely LONG/DOUBLE/FLOAT, then just skip this lesson.
HOWEVER IF both of these columns are in the STRING/TEXT data type, then follow this lesson
In an ArcGIS PRO 3 Project document, we can create several thematic maps from one layer or several map layers with various fields without having to separate them into different projects.
In an ArcGIS PRO 3 Project document, we can create several choropleth maps from one layer or several map layers with various fields without having to separate them into different projects.
Cluster analysis is a spatial analysis that can provide better spatial information in making decisions or viewing phenomena from existing data such as pollution levels, crime rates and so on.
Heatmap analysis is a spatial analysis that can provide better spatial information in making decisions or viewing phenomena from existing data such as pollution levels, crime rates and so on.
Design layout for thematic of business asset. This layout would becoming template for other layouts' design
Design layout for thematic of gender. This layout is using template from layouts of business asset
Designing layout for thematic of business duration based on template from business asset layout
Designing layout for thematic of business type based on template from business asset layout
Layout design using ONLY one single map as a frame/source will cause problems if we turn off and on the layer (check/uncheck layer), then other layouts that use the same map will be affected. Therefore, we create several different maps for each layout. To save time, we can just copy/paste from a single map and rename as needed.
The completed layout design will be exported to JPG and PDF formats.
Design layout for entire choropleth maps. This layout would using template from thematic layouts
Design layout for entire clusters maps. This layout would using template from choropleth layouts
Design layout for entire heatmap maps. This layout would using template from cluster layouts
1. Introduction to Geodatabase (.gdb).
Geodatabase is a spatial data storage format used in Geographic Information Systems (GIS). Developed by Esri, geodatabase functions as a container for storing, managing, and analyzing geographic data efficiently in an organized form. Geodatabase allows users to manage spatial data and its attributes in an integrated manner in one database.
2. Geodatabase VS Shapefile.
Geodatabase and Shapefile are two data formats that are often used in Geographic Information Systems (GIS) to store spatial data. However, both have significant differences in terms of capability, efficiency, and functionality. The comparison between the two includes storage structure, storage capacity, data and function support, scalability and collaboration, performance and compatibility
Choose Geodatabase if:
- You work with large and complex datasets.
- Need integrated data management (multi-layer, relations, topology rules).
- Using GIS on a large organizational scale.
Choose Shapefile if:
-You need a simple format to share data with multiple platforms.
-Your dataset is small, with simple analysis needs.
Although shapefiles are still widely used because of their simplicity, geodatabases offer far superior capabilities for modern GIS needs.
3. Export SHP to GDB
GDB is capable of creating new features, but on this occasion we will export existing SHP data to GDB, in addition to saving time, we can also practice. Besides SHP, other popular data formats are KML and geoJSON.
4. Process field survey data in XLS format, edit and clean data
Before being processed in ArcGIS PRO 3, field data in XLS format is first cleaned, such as column names that must not contain spaces.
5. Export XLS to CSV
After being cleaned, the XLS data is exported to CSV.
6. Plotting survey point distribution data CSV to ArcGIS PRO 3, XY data in Geographic Coordinate System (GCS) in Decimal Degree (DD) format
The CSV data is then added and plotted to ArcGIS PRO 3. Plotting or displaying the distribution of survey points on the ArcGIS PRO 3 canvas is done using 2 (two) columns/fields combination X/Longitude/Longitude and field Y/Latitude/Latitude as the coordinate points of the earth where the survey respondents are located. The coordinate system used in this course is the Geographic Coordinate System (GCS) with degrees (Degree) and in Decimal Degree/DD format
7. Export plotting data to GDB
The distribution of survey points that have been added to the ArcGIS PRO 3 canvas can be directly plotted onto the ArcGIS PRO 3 canvas and directly saved into GDB
8. Creating a spatial model
We will create a spatial model from the distribution of survey points that have been stored in GDB. This spatial model can be in the form of thematic choropleth, cluster and heatmap. The spatial model will provide a clearer picture of how this data is distributed based on the attribute data obtained such as the age spatial model, the monthly turnover spatial model, the annual turnover spatial model and others.
9. Designing a Layout in ArcGIS PRO 3.
We will create a layout in ArcGIS PRO 3. We create a Multi-layout for each of the spatial models above in one ArcGIS PRO Project Document.