Difference between revisions of "Import Geospatial Data from Shapefile"
From IMSMA Wiki
| Line 1: | Line 1: | ||
| − | + | To import geospatial data from the shapefile (.shp format): | |
| − | |||
<ol> | <ol> | ||
| − | <li>Click the [[Image:EditReportIcon.png | Import Points]] button. The Open window displays | + | <li>Click the [[Image:EditReportIcon.png |Import Points]] button. The Open window displays |
| + | [[Image:PointandPolyListWindow.png|500px|center]]</li> | ||
<li>From the Open window:</li> | <li>From the Open window:</li> | ||
<ol type="a"> | <ol type="a"> | ||
| Line 8: | Line 8: | ||
<li>Select the file (.shp format)</li> | <li>Select the file (.shp format)</li> | ||
<li>Double click on the file name or click the '''Open''' button</li></ol></ol> | <li>Double click on the file name or click the '''Open''' button</li></ol></ol> | ||
| − | |||
The geospatial data from the spreadsheet is appended to any existing data in the Points or Polygons table. | The geospatial data from the spreadsheet is appended to any existing data in the Points or Polygons table. | ||
| Line 18: | Line 17: | ||
{{Note | The used decimal symbol in the shape file must be the same as the Regional settings of the importing computer.}} | {{Note | The used decimal symbol in the shape file must be the same as the Regional settings of the importing computer.}} | ||
| − | |||
==Shapefile Import Business Rules==__NOEDITSECTION__ | ==Shapefile Import Business Rules==__NOEDITSECTION__ | ||
===Point Shapefile Import Business Rules===__NOEDITSECTION__ | ===Point Shapefile Import Business Rules===__NOEDITSECTION__ | ||
| Line 33: | Line 31: | ||
|- | |- | ||
|} | |} | ||
| − | + | ||
| + | To import geospatial data from a point shapefile, the file must be created according to the following business rules: | ||
<ol> | <ol> | ||
<li>A PointID value is a mandatory field and should be provided for each point and be unique across all coordinate data listed in the Points table. It should be of '''Short Integer''' type.</li> | <li>A PointID value is a mandatory field and should be provided for each point and be unique across all coordinate data listed in the Points table. It should be of '''Short Integer''' type.</li> | ||
<li>A PointType is a mandatory field and should be provided for each point. It must correspond to the Geospatial Point types list defined by IMSMA. The field should have '''Text''' type.</li></ol> | <li>A PointType is a mandatory field and should be provided for each point. It must correspond to the Geospatial Point types list defined by IMSMA. The field should have '''Text''' type.</li></ol> | ||
| − | |||
[[Image:Point import.png|700px|center]] | [[Image:Point import.png|700px|center]] | ||
| Line 57: | Line 55: | ||
</div> | </div> | ||
|} | |} | ||
| − | + | ||
| + | To import geospatial data from a polygon shapefile, the file must be created according to the following business rules: | ||
<ol> | <ol> | ||
<li>The Polygon attribute table must contain field called '''PolyID''' of '''Short Integer''' type and have a '''value''' e.g. 0 or 1.</li> | <li>The Polygon attribute table must contain field called '''PolyID''' of '''Short Integer''' type and have a '''value''' e.g. 0 or 1.</li> | ||
Revision as of 10:33, 16 February 2015
To import geospatial data from the shapefile (.shp format):
- Click the
button. The Open window displays
- From the Open window:
- Navigate to the directory where the file that you would like to import is located
- Select the file (.shp format)
- Double click on the file name or click the Open button
The geospatial data from the spreadsheet is appended to any existing data in the Points or Polygons table.
 |
Import Point button works to import point and polygon shapefiles. Point shapefile will be imported into Points table, Polygon and Polyline shapefiles - into Polygon and Polyline Points table but will be split into points list that compose this polyline or polygon. |
| |
If the selected coordinate reference system at the Point and Polygon/Polyline List window is different from the coordinate reference system specified in the .prj file, the coordinate data will be re-projected to the selected coordinate system specified at the Point and Polygon/Polyline List window. |
| |
The used decimal symbol in the shape file must be the same as the Regional settings of the importing computer. |
Shapefile Import Business Rules
Point Shapefile Import Business Rules
 Attribute table |
 Attribute properties |
To import geospatial data from a point shapefile, the file must be created according to the following business rules:
- A PointID value is a mandatory field and should be provided for each point and be unique across all coordinate data listed in the Points table. It should be of Short Integer type.
- A PointType is a mandatory field and should be provided for each point. It must correspond to the Geospatial Point types list defined by IMSMA. The field should have Text type.
Points imported into IMSMANG
Download the example of the Point Shapefile PointImportTemplate.
Polygon Shapefile Import Business Rules
 Attribute table |
 Attribute properties |
To import geospatial data from a polygon shapefile, the file must be created according to the following business rules:
- The Polygon attribute table must contain field called PolyID of Short Integer type and have a value e.g. 0 or 1.
- Coordinate Format, Coordinate System, Bearing, Distance, Point ID, Point Number, Point Type, X/Long, Y/Lat are optional to be included into the attribute table.
Polygon imported into IMSMANG
Download the example of the Polygon Shapefile PolygonImportTemplate
