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