Changes

<p>Various windows in IMSMA allow you to 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 the shapefile (with a .shp file extensionformat).</p><p>To import geospatial data:</p>

<li>Click the [[Image:EditReportIcon.png | Import Points]] button.</li>:The Open window displays[[Image:PointandPolyListWindow.png|500px|center]]</li>

<li>Navigate to the directory where the file that you would like to import is located.</li><li>Select the file name(.shp format)</li><li>Click Double click on the file name or click the '''Open''' button.</li>: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 geospatial data from the source file from which you wish spreadsheet is appended to import any existing data:* For an Excel spreadsheet, follow the [[Geospatial Data#Excel Import Business Rules | Excel Import Business Rules]].* For a shapefile, follow in the [[Geospatial Data#Shapefile Import Business Rules | Shapefile Import Business Rules]]Points or Polygons table.}}

===Shapefile {{note|'''[[Image:EditReportIcon.png]] Import Business Rules===__NOEDITSECTION__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.}}

{{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''<p/div>|-|} To import geospatial data from a point shapefile, the file must be created according to the following business rules:</p>

<li>If the selected coordinate reference system at the Point A PointID value is a mandatory field and should be provided for each point and Polygon/Polyline List window is different from the be unique across all coordinate reference system specified data listed in the Points table.prj file, the coordinate data will It should be re-projected to the selected coordinate system specified at the Point and Polygon/Polyline List windowof '''Short Integer''' type.</li> <li>If A PointType is a PointID value is not mandatory field and should be provided in for each point. It must correspond to the shapefile, each coordinate data will be automatically assigned a unique PointID valueGeospatial Point types list defined by IMSMA. The field should have '''Text''' type.</li></ol> [[Image:Point import.png|700px|center]]<lidiv align="center">If a PointID is provided in the shapefile, it must be unique across all coordinate data listed in the '' Points table and in the Polygonimported into {{IMSMANG}}''</Polyline Points table on div>Download the example of a Point and shape file from '''[[Media:PointImportTemplate.rar|here]]'''. ===PolygonShapefile Import Business Rules===__NOEDITSECTION__{| class="wikitable"|-| [[Image:Polygon_attribute.png|500px|center]]<div align="center">'' Attribute table''</Polyline List windowdiv>| [[Image:Polygon attributes2.png|450px|center]]</lidiv align="center">'' Attribute properties''<li/div>If the coordinate |} To import geospatial data is a point on from a polygon/polylineshapefile, 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 unique PolyID '''value must be provided''' e.g. 0 or 1.</li><li>The PolyID value must Coordinate Format, Coordinate System, Bearing, Distance, Point ID, Point Number, Point Type, X/Long, Y/Lat are optional to be unique across all polygons/polylines data listed in included into the Points attribute table and Polygon. </Polyline Points table on the Point and ol>  [[Image:Polygon/Polyline List windowimport2.png|700px|center]]</lidiv align="center">'' Polygon imported into {{IMSMANG}} ''</oldiv>Download the example of a Polygon shape file from '''[[Media:PolygonImportTemplate.rar| here]]'''.