LUPMIS - GIS User Manual for Land Use Planning
Main menu:
- Home Page
- 0. Rationale
- 1. GIS handling
- 2. GIS data entry
- 2.1 Create new layer
- 2.2 Digitize line
- 2.3 Digitize point
- 2.4 Digitize polygon
- 2.5 Edit existing layer
- 2.6 Delete feature
- 2.7 Split line
- 2.8 Split polygon
- 2.9 Merge lines from different layers
- 2.10 Unite lines
- 2.11 Snap lines
- 2.12 Join polygons
- 2.13 Extend polygon
- 2.14 Insert island
- 2.15 Define unit surrounding islands
- 2.16 Create 'doughnut'
- 2.17 Fill 'doughnut' polygon
- 2.18 Fill polygon with 'holes'
- 2.19 Digitize parcels from sector layout
- 3. GIS operations
- 3.1 Create buffer
- 3.2 Create exclusion zone
- 3.3 Overlay units
- 3.4 Convert line to polygon
- 3.5 Derive statistics (area size, length)
- 3.6 Clip unit according to other unit
- 3.7 Create geographic grid
- 3.8 Move entire vector map
- 3.9 Move or copy individual features on a map
- 3.10 Adjust polygon to line
- 3.11 Convert points to polygon
- 3.12 Define by distance
- 4. Attribute database
- 4.1 Start with database
- 4.2 Import database
- 4.3 Display database information
- 4.3 Retrieve database information
- 4.4 Enter attribute data
- 4.5 Edit attribute data
- 4.6 Seeds
- 4.7 Repair attribute data
- 4.8 Merge lines with attached database
- 4.9 Transfer attribute data from points to polygons
- 4.10 Export and import styles and labels
- 4.11 Select and display
- 4.12 Copy data: DRA, DBF
- 5. Conversion of data
- 5.1 Points
- 5.1.1 Import list of points from text file
- 5.1.2 Import list of points from Excel file
- 5.1.3 Convert point coordinates between projections
- 5.1.4 Convert point coordinates from Ghana War Office (feet)
- 5.1.5 Convert point coordinates from Ghana Clark 1880 (feet)
- 5.1.6 Track with GPS
- 5.1.7 Download GPS track from Garmin
- 5.1.8 Download GPS track from PDA
- 5.2 Vector maps
- 5.3 Raster maps
- 5.4 Communication with other GIS programs
- 5.1 Points
- 6. Presentation
- 7. GIS for land use planning
- 8. Database
- Annexes
- A1. Map Maker setup
- A2. Background to cartography and raster images
- A3. Glosssary
- A4. Troubleshooting
- A5. Styles
- A6. Classification for land use mapping and planning
- A7. GIS utilities
- A8. Map projection parameters
- A9. Maps in pilot areas
- A10.Standards
- A11. LUPMIS distribution CD
- A12. Garmin GPS
- A13. Training
- A14. ArcView
- A15. Population statistics
- A16. Entry and display of survey data
- A17. External exercises
- A18. MS Access
- A19. Paper sizes
- A20. Site map and references
4.1 Start with database
4. Attribute database
4.1 Start with Database
Level of expertise required for this Chapter: Advanced
Attribute data are ‘textual’ data, i.e. not graphical, not spatial, not with coordinates, but describing in quantitative terms or text. They are always linked to a feature on the map (polygon, line or point) and do not have to follow a strict syntax.
Styles (numbers) and labels (text) are considered by some GIS programs as attribute data, but handled in Map Maker in a different way, not in an attached database, but in the original DRA file. There are various ways of transfer styles and labels to / from the database (see Chapter 6.2.9).
- - - - -
You can enter display labels as temporary identifiers:
When you digitize in the live layer from the beginning, the tab Basics will enable the entry of display labels.
If your map is already digitized, use the Edit-tool from the toolbar left, click on the label point of the feature and the same window will open, to enter the display label.
You can check, that all units have the entered, numbered identifier with the selection manager:
Main menu > Edit > Show Selection Manager > Selection Manager window: Find > Find all > Find. The left column should show all identifier numbers.
- - - - -
You can edit the existing database, for example, in Excel.
Have the first row with explanatory names of the column, and the first column with the identifier numbers, relating to the numbers you gave when digitizing
Save this table. (If in Excel, you can save it as an XLS file, not XLSX)
Import the database to the digitized map (DRA) file:
Have the DRA file in the live layer, then: Main menu > Edit > Live layer data > Merge data table with live data > Select file type (can be DBF, MDB, XLS or csv file) > Select folder and database file, as prepared in the previous step > OK > Choose table window: Select Sheet1 > OK > Choose link column window: Select id > Leave both boxes ticked > OK > Pick columns to import window: Select the fields you want to import, except id > OK >
You have now created a DBF file with the database (‘attribute data’), which has the same file name as the master DRA file. The two files (DRA and DBF) are not automatically assigned to each other.
- - - - -
You link (‘associate’) a DBF file to a DRA file through the Project manager (right-mouse > Project manager > Select DRA file to be linked in the left panel > Data link > Database > Choose database > Select folder and attribute (DBF) file > Open
Sub-Menu:
- 4.1 Start with database ←
- 4.2 Import database
- 4.3 Display database information
- 4.3 Retrieve database information
- 4.4 Enter attribute data
- 4.5 Edit attribute data
- 4.6 Seeds
- 4.7 Repair attribute data
- 4.8 Merge lines with attached database
- 4.9 Transfer attribute data from points to polygons
- 4.10 Export and import styles and labels
- 4.11 Select and display
- 4.12 Copy data: DRA, DBF