Difference between revisions of "Import Geospatial Data from Shapefile"

From IMSMA Wiki
Jump to: navigation, search
(Created page with "<p>Various windows in IMSMA allow you to import geospatial data from external source files. These external source files can be either Excel spreadsheets (with a .xls or .xlsx ...")
 
 
(27 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
<p>Various windows in IMSMA allow you to import geospatial data from external source files. These external source files can be either Excel spreadsheets (with a .xls or .xlsx file extension), or shapefiles (with a .shp file extension).</p>
+
To import geospatial data from the shapefile (.shp format):
−
<p>To import geospatial data:</p>
 
 
<ol>
 
<ol>
−
<li>Click the [[Image:EditReportIcon.png | Import Points]] button.</li>
+
<li>Click the [[Image:EditReportIcon.png |Import Points]] button. The Open window displays
−
: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">
−
<li>Navigate to the directory where the file that you would like to import is located.</li>
+
<li>Navigate to the directory where the file that you would like to import is located</li>
−
<li>Select the file name.</li>
+
<li>Select the file (.shp format)</li>
−
<li>Click the '''Open''' button.</li>
+
<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.
 
−
</ol>
 
−
</ol>
 
  
−
{{note|You must follow certain business rules to create and format the source file from which you wish to import data:
+
The geospatial data from the spreadsheet is appended to any existing data in the Points or Polygons table.
−
* For an Excel spreadsheet, follow the [[Geospatial Data#Excel Import Business Rules | Excel Import Business Rules]].
 
−
* For a shapefile, follow the [[Geospatial Data#Shapefile Import Business Rules | Shapefile Import Business Rules]].}}
 
  
−
===Shapefile Import Business Rules===__NOEDITSECTION__
+
{{note|'''[[Image:EditReportIcon.png]] Import Points''' button imports both point and polygon shapefiles. Point shapefile will be imported into '''''Points table''''', Polygon and Polyline shapefiles - into '''''Polygon and Polyline Points''''' table.}}
 +
 +
{{Note|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.}}
  
−
<p>To import geospatial data from a shapefile, the file must be created according to the following business rules:</p>
+
{{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__
 +
===Point Shapefile Import Business Rules===__NOEDITSECTION__
 +
{| class="wikitable"
 +
|-
 +
|[[Image:Point attributes1.png|300px|center]]
 +
<div align="center">
 +
'' Attribute table ''
 +
</div>
 +
|[[Image:Point attributes2.png|400px|center]]
 +
<div align="center">
 +
'' Attribute properties''
 +
</div>
 +
|-
 +
|}
 +
 
 +
To import geospatial data from a point shapefile, the file must be created according to the following business rules:
 
<ol>
 
<ol>
−
<li>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.</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>If a PointID value is not provided in the shapefile, each coordinate data will be automatically assigned a unique PointID value.</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>If a PointID is provided in the shapefile, it must be unique across all coordinate data listed in the Points table and in the Polygon/Polyline Points table on the Point and Polygon/Polyline List window.</li>
+
 
−
<li>If the coordinate data is a point on a polygon/polyline, a unique PolyID value must be provided.</li>
+
[[Image:Point import.png|700px|center]]
−
<li>The PolyID value must be unique across all polygons/polylines data listed in the Points table and Polygon/Polyline Points table on the Point and Polygon/Polyline List window.</li>
+
<div align="center">
−
</ol>
+
'' Points imported into {{IMSMANG}}''
 +
</div>
 +
Download the example of a Point shape file from '''[[Media:PointImportTemplate.rar|here]]'''.
 +
 
 +
===Polygon Shapefile Import Business Rules===__NOEDITSECTION__
 +
{| class="wikitable"
 +
|-
 +
| [[Image:Polygon_attribute.png|500px|center]]
 +
<div align="center">
 +
'' Attribute table''
 +
</div>
 +
| [[Image:Polygon attributes2.png|450px|center]]
 +
<div align="center">
 +
'' Attribute properties''
 +
</div>
 +
|}
 +
 
 +
To import geospatial data from a polygon shapefile, the file must be created according to the following business rules:
 +
<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>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. </ol>
 +
 
 +
 
 +
[[Image:Polygon import2.png|700px|center]]
 +
<div align="center">
 +
'' Polygon imported into {{IMSMANG}} ''
 +
</div>
 +
Download the example of a Polygon shape file from '''[[Media:PolygonImportTemplate.rar| here]]'''.
  
 
{{NavBox HowTo Enter Data}}
 
{{NavBox HowTo Enter Data}}
 +
 +
[[Category:CRI]]

Latest revision as of 05:01, 13 January 2017

To import geospatial data from the shapefile (.shp format):

  1. Click the Import Points button. The Open window displays
    PointandPolyListWindow.png
  2. From the Open window:
    1. Navigate to the directory where the file that you would like to import is located
    2. Select the file (.shp format)
    3. 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.

Note.jpg EditReportIcon.png Import Points button imports both point and polygon shapefiles. Point shapefile will be imported into Points table, Polygon and Polyline shapefiles - into Polygon and Polyline Points table.
Note.jpg 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.
Note.jpg 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

Point attributes1.png

Attribute table

Point attributes2.png

Attribute properties

To import geospatial data from a point shapefile, the file must be created according to the following business rules:

  1. 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.
  2. 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.
Point import.png

Points imported into IMSMANG

Download the example of a Point shape file from here.

Polygon Shapefile Import Business Rules

Polygon attribute.png

Attribute table

Polygon attributes2.png

Attribute properties

To import geospatial data from a polygon shapefile, the file must be created according to the following business rules:

  1. The Polygon attribute table must contain field called PolyID of Short Integer type and have a value e.g. 0 or 1.
  2. 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 import2.png

Polygon imported into IMSMANG

Download the example of a Polygon shape file from here.

Using Data Entry Forms
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Import_Geospatial_Data_from_Shapefile&oldid=22536"