Ask LOIS Knowledge Base

Are you an existing LOIS user with questions? Ask LOIS – Click on any of the questions listed below to view the answer.

How can I access the LOIS Data Dictionary?
Click Here to access LOIS Data Dictionary
How do I access the LOIS Presentation Site?
LOIS Presentation Site Address – https://secure.locationone.com/lois/logon.jsp
How does the Data Exchange Service work?
The Data Exchange service provided by LocationOne allows you to manage your data in a Microsoft Excel worksheet. Here the steps for using this service.

To Export an Excel File:

  1. Login to the Date Exchange Application at http://dataexchange.locationone.com.
  2. Log in using your current LOIS username and password.
  3. Choose a locality from the dropdown list box.
  4. Click the “Export Excel Data” button. A new window will open.
  5. Choose the version of Excel to export to. The standard is Excel 97-2003. If you have a newer version, click on the dropdown list box and select it.
  6. Click on the grey “Generate Excel file” button. A blue link will appear at the bottom of the current window.
  7. Click on the blue link entitled as “Download File” (Click Here).
  8. A File Download window will open, offering you the choice of opening the file or saving it. Make your selection.
  9. From this point on, you may now EDIT, DELETE or ADD records to this Excel file.

To Import an Excel File:

You must first Export an Excel file that contains ID numbers before you can import data into LOIS.

  1. Login to the Date Exchange Application at http://dataexchange.locationone.com.
  2.  Log in using your current LOIS username and password.
  3. Click on the grey “Import Excel Data” button.
  4. The LocationOne Data Portal Import window will open.
  5. Choose the Version of Excel you are using.
  6. Click on the Browse button to find the Excel file on your computer. Choose the filename.
  7. Click on the grey “Import Excel File” button and Select Confirm.

Quick Tips

  1. To add a new record in the Excel file, leave the Record ID field blank.
  2. To delete a record in the Excel File, place a minus sign (-) in front of the Record ID.
How do I link our website to our LocationOne account?
In order for the public to access your data in LOIS, each user will need to insert a hyperlink on their web site to allow the general public to view the information. Some users will have one single point of entry into LOIS while others may choose to have multiple entry points.

To create the URL, the user must decide which section or record in LOIS they want the public to view initially when accessing LOIS from their web site.

Once the initial access point has been determined, the URL can be created by incorporating the user id and or record number into a template. Below are the most common templates used to access LOIS.

Create Your Link

Connecting to LOIS – Templates
Replace and with your user id and the corresponding record number to create your customized link.

Building Results List
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=buildings

Site Results List
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=sites

Property Search Page
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=buildings&page=search

Building Record
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=buildings&building_id=

Site Record
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=sites&site_id=

Locality Record
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=localities&community_id=

County Record
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=counties&county_id=

Metro/Region Record
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=metros&metro_id=

State Record
http://www.locationone.com/lois/logon.do?username=<userid>&appsection=states&state_cd=

Are web tracking statistics available?
Yes. You can track your own statistics using Google Analytics. For information on how to create an account and setup your id in LOIS use the link below to access instructions.

Creating a Google Analytics Account

What do the colored push-pins stand for in the administration website?
Yellow- Not modified in 10 months.

Red- Not modified in 12 months.

Purple- No images attached.

Orange- Printable Flyer Fields incomplete.

Blue – Advanced Search Fields incomplete.

What is the difference between “Hide” and “Filter”?
Both the “hide” and “filters” features allow you to suppress the public view of specific data on your site. These two tools do NOT delete the data from the system. Here is when to use each feature:

  • Use the “hide” tool to suppress the view of a specific record.
  • Use the “filters” feature to set criteria across all records to be suppressed (not displayed).
  • Use the “Inactive” field within a record to take record off the market while remaining archived in the system.
  • Use “delete” record to completely eliminate a record from the system

Regional, state and utility users typically use the “hide” feature because they may not want to display competitive data on their sites. For example, a utility may want to hide an available building in its viewable database because it is located in a competitive service area.

The filters feature is handy for pre-setting criteria across all records automatically for marketing purposes. For example, you may want to display only buildings over 5,000 square feet, or only specific types such as industrial, etc.

Both the “hide” and “filters” features are in the dropdown menu in the Admin Site under “User Settings.”

The “delete” option is found on each individual records page next to “copy” or “edit” features. The “Inactive” feature is a radio button in the Overview section. An INACTIVE record will virtually take the building off the market, however the data will remain in the system for future use.