
A brief overview of all the sections of the course. There are 6 sections in this course.
Introduction to Geodatabase data format which is a spatial data storage in the form of a database. This format is owned by ESRI which is also the owner of the Shapefile/SHP format
Copy sample data from course page to your local storage (in ZIP format), put in to your favorite folder and extract it
We will open some SHPs data, create new GDB data and export those SHPs data into GDB
Before being processed in ArcMAP, field data in XLSX format is first cleaned, such as column names that must not contain spaces. Then this XLSX is exported to CSV. CSV is then plotted to ArcMAP using 2 (two) columns/fields of Longitude and Latitude coordinates. 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.
Field titles or names can be a disaster for us now or in the future if we use too many abbreviations such as ROAD becomes RD, NAME becomes NM or INCOME becomes INCM. This happens in SHP format where the field name ONLY contains 10 characters/letters including spaces. We have exported survey point plotting data from CSV to GDB, the field names are complete, nothing is cut off. In this meeting we will export survey point plotting data from CSV to SHP and see the comparison of field titles between SHP and GDB.
Layers in an ArcMAP document may be lost, missed or misplaced, so we will fix the path or location of the layer.
Although it does not happen often, data type errors when we export from csv to GDB can occur. 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_Rp AND Yearly_income_Rp, these field should be in long/double or integer data type) then just skip this lesson. IF these fields are in STRING/TEXT then follow this lesson
In an ArcMAP Project document (MXD), we can create several thematic maps from one layer or several map layers.
In an ArcMAP Project document (MXD), we can create several choropleth maps from one layer or several map layers.
ArcGIS Desktop (ArcMAP) does not support the use of multiple layouts in a single MXD project document. Therefore, the layers that have been spatially modeled into thematic ones must be separated into different MXDs and each MXD will have its own layout.
ArcGIS Desktop (ArcMAP) does not support the use of multiple layouts in a single MXD project document. Therefore, the layers that have been spatially modeled into choropleths must be separated into different MXDs and each MXD will have its own layout.
Designing a thematic map layout for Business Assets attribute field in Layout View in ArcMAP. Put some layout elements for present to 3rd parties or clients
Designing a thematic map layout for others MXDs thematic USING template from Business Assets Layout above. Put some layout elements for present to 3rd parties or clients
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 ArcMAP, 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 ArcMAP, XY data in Geographic Coordinate System (GCS) in decimal degree (DD) format
The CSV data is then added and plotted to ArcMAP. Plotting or displaying the distribution of survey points on the ArcMAP canvas is done using 2 (two) columns/fields, a combination of X/Longitude/Longitude and 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 ArcMAP canvas is temporarily stored in memory (temporary layer), to make it permanent we will export this point distribution data to 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 thematic and choropleth. 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 an ArcMAP document (MXD).
We will create a layout in ArcMAP. We create a layout for each of the spatial models above.