CREATE LAYER


LandVision™ Help > Documentation > Create Layer

Creating a layer is the first step in using Data Loader to:

  • Load your spreadsheet Address or Coordinate data sets (csv files) into LandVision™

  • Manually build a Spatial data layer. You create an empty layer in LandVision™, and can then manually add spatial data (points, lines, or polygons) and attribute information to your layer. This is a flexible way to create a Spatial layer for specific information tracking needs. (See Drawing Tools in Related Documents for information about drawing points, lines, or polygons.)

Preparing Address or Coordinate Data for Importing


It is important to correctly prepare your Address and Coordinate data sets (csv files) before loading them into LandVision™. The requirements in this section are for both Address and Coordinate data sets. Differences in requirements are noted.

Requirements

  • Required File Type: Address and Coordinate data must be stored in Comma Delimited (*.csv) files.
    • To save a database or spreadsheet file as a Comma Delimited file, perform a ďSave AsĒ and select ďCSV (Comma Delimited) (*.csv)Ē for ďSave as type.Ē

  • Upload File Size Limit: 30MB

  • Required Fields: Your Address and Coordinate *.csv files must contain, at a minimum, the exact fields below:
    • Required Address fields: source_address, source_city, source_state, source_zipcode
    • Required Coordinate fields: latitude, longitude

  • Not Supported in Fields: Your csv file cannot include fields with these values:
    • Field names: spaces, special characters, field names starting with numbers

      Tip: Use underscores to replace the spaces in your field names.

    • Currency (e.g., dollar signs)
    • Commas
    • Percent signs

  • Character Limit in Fields: 100

  • Reserved Field Names: Your csv file cannot include these field names: Key, Geometry, Sidx, _Cftid, _Geo_Type, _Dmp_Id, _Sessionid, _Recseq, _Createdby, _Createddate, _Retiredby, _Retireddate, _Status, _X_Coord, _Y_Coord, _Xmin, _Ymin, _Xmax, _Ymax, Unit, Address_number, Predirectional, Prefix, Street, Suffix, Postdirectional, UnitDesignation, City, StreetAbbr, Zipcode, Countycode, Geostatus, MatchStatus, State, Score, Parcel_id, AddressID, GEOMETRY_BIN, Opacity, Size, Color, Image, _SEQ_ID, _SYMBOLOGY, DRAW_TYPE, Location_ID.

    • The full reserved keyword list can be found, here

Return to Top

Creating an Address or Coordinate Layer


Adding Fields

Creating an Address or Coordinate layer involves deciding which fields in your csv file that you want to load into LandVision™. You then identify those fields by their field names in the Create Layer window. The examples to the right show the field names in a csv file which have been added to the Create Layer window.

Here are some guidelines for adding fields:

  • You donít have to load all the fields in your csv file for a successful Data Load. Donít add fields to the Create Layer window that you donít want to be part of your layer.

  • You can add fields in any order in the Create Layer window. The order doesnít have to match the order in your csv file.


  • Hereís how to create an Address or Coordinate Layer:
    1. Click the More Layers button LandVision Thematic Mapper Button More Layers at the bottom of the Legend. The Browse Layers window appears.

    2. Select a folder from the Folder drop-down list LandVision D Loader Folder in which to save your data set.

      Note: To create a new folder for your data set, select New. The Create Folder window appears. Enter the name of your new folder and click OK. Your new folder appears in the Folder drop-down list.

    3. Click the Create Layer buttonLandVision Create Layer Button . The Create Layer window appears.

      Note: If you donít have permission to use your selected folder, the Create Layer button is grayed out. Select another folder to save your data set.

    4. In the Create Layer window:
      1. Folder Name: Automatically filled in with your selected folder name.

        Note: The folder name starts with your LandVision™ Account name.
      2. Layer Name: Enter the name of your layer. You can use spaces and mixed cases. Do not use special characters.
      3. Geometry Type: Select Point from the drop-down list. Address and Coordinate layers are Point layers.

    5. Click the Add Field button LandVision Create Layer Button Add Field for every field in your csv file that you want to load into LandVision™ (See Adding Fields above for more information).

    6. Perform the following for each field:
      1. Name: Enter an exact field name from your csv file.
      2. Displayed Name (optional): If the meaning of the field name is not easy to understand, enter an alternate field name.
      3. Type: Select the data type from the drop-down list.
        • Text: All text fields including addresses with numbers.
          Tip: If you donít know the data type for a field, select Text.
        • Integer: Whole numbers
          Tip: The integer type has a length limit of 9 digits. If your number field contains data with more than 9 digits, select text for Type.
        • Decimal: Integers with decimals. You must select this data type for latitude and longitude fields.
        • True / False: A conditional filter for certain data types
        • Xml: Not applicable

    7. Click the Create Button LandVision Create Layer Button Create . Your layer name appears in the Available list of the Browse Layers window.
LandVision CSV File Example

LandVision Create Layer Adding Fields

LandVision Legend Button More Layers

LandVision Browse Layers Folder Layer

LandVision Create Layer Window_Fillin

LandVision Create Layer Adding Fields-2

Return to Top

Creating a Spatial Data Layer


  1. Click the More Layers button LandVision Thematic Mapper Button More Layers at the bottom of the Legend. The Browse Layers window appears.

  2. Select a folder from the Folder drop-down list LandVision D Loader Folder in which to save your data set.

    Note: To create a new folder for your data set, select New. The Create Folder window appears. Enter the name of your new folder and click OK. Your new folder appears in the Folder drop-down list.

  3. Click the Create Layer button LandVision Create Layer Button . The Create Layer window appears.

    Note: If you donít have permission to use your selected folder, the Create Layer button is grayed out. Select another folder to save your data set.

  4. In the Create Layer window:
    1. Folder Name: Automatically filled in with your selected folder name. Note: The folder name starts with your LandVision™ Account name.
    2. Layer Name: Enter the name of your layer. You can use spaces and mixed cases.
    3. Geometry Type: Select Line, Point, or Polygon from the drop-down list, depending on the type of Spatial layer that youíd like to create.

  5. Click the Add Field button LandVision Create Layer Button Add Field to add attribute fields to your layer.

  6. Perform the following for each field:
    1. Name: Enter an attribute name.
    2. Displayed Name (optional): Not applicable
    3. Type: Select the data type from the drop-down list.
      • Text: All text fields

      • Tip: If you donít know the data type for a field, select Text.
      • Integer: Whole numbers
      • Decimal: Integers with decimals. You must select this data type for latitude and longitude fields.
      • True / False: A conditional filter for certain data types
      • Xml: Not applicable

  7. Click the Create Button LandVision Create Layer Button Create . Your layer name appears in the Available list of the Browse Layers window.
LandVision Legend Button More Layers

LandVision Browse Layers Folder Layer

LandVision Create Layer Window_Fillin

LandVision Create Layer Adding Fields-2

Return to Top

Related Information



© Copyright 2014 Digital Map Products About DMP | Contact Us