Geographic Reference File (Data Import) (Not Available in the Basic / 'Lite' Edition)

Geographic Reference File or (GeoFile) data can be imported from external systems via 'csv', 'xls or 'xml' file formats. The GeoFile Import feature is accessible via the Admin/Geofile Maintenance menu option. The GeoFile import form provide a mechanism to import the master street list, street segments and premise records. For more information of the definition of those GeoFile elements, see the Geographic Reference File topic.

The data record layout for these files is defined as follows:

Importing the Master Street List

The master street list is the basis for all other GeoFile Segment and Premise Records. Before any street segment or premise address can be defined the street name referenced by that segment or premise must be defined within the Master Street List table.

The table below defines the fields of the .csv import file.

Field Name	Maximum Size (bytes)	Data Type	Definition
PREFIX	2	Character	Street Prefix Code
STREET	30	Character	Root Street Name
TYPE	2	Character	Street Type Code
SUFFIX	2	Character	Street Suffix Code
CITY	20	Character	City Name
COUNTY	6	Character	County Code
ZIPCODE	10	Character	Postal Zip Code
EXTKEY	20	Character	External Key Reference

The sample below defines the fields of the XML import file.

<?xml version="1.0" encoding="Windows-1252" standalone="yes" ?>

<geo_msl>

<wcstreet>ABBY</wcstreet>
<wctype>LN</wctype>
<wcsfx>S</wcsfx>
<wccity>BAR HARBOR</wccity>
<wccounty>HANC</wccounty>
<wcstate>ME</wcstate>
<wczip>04609</wczip>
<wcexkey>1</wcexkey>

</geo_msl>

<geo_msl>

<wcstreet>ARNOLD</wcstreet>
<wctype>ST</wctype>
<wcsfx>N</wcsfx>
<wccity>BAR HARBOR</wccity>
<wccounty>HANC</wccounty>
<wcstate>ME</wcstate>
<wczip>04609</wczip>
<wcexkey>2</wcexkey>

</geo_msl>

</GeoData>

Import Notes:

All data is up-shifted to CAPITAL letters
Street Prefix, Type , Suffix and County codes are validated against the corresponding RMS code tables for those respective fields. Records that contain codes that cannot be validated will be skipped.

Importing the Street Segment List

A street segment is a portion of any given street segmented by two cross streets or other geographic delineations. Each street segment has beat, sector, district, agency and jurisdiction attributes for the even address and odd address sides of the street. Likewise each segment has a defined cross street which intersects the segment at the high address end of the segment and the low address end of the segment.

The table below defines the fields of the .csv import file.

Field Name	Maximum Size (bytes)	Data Type	Definition
STREET	30	Character	Root Segment Street Name
TYPE	2	Character	Segment Street Type Code
PREFIX	2	Character	Segment Street Prefix Code
SUFFIX	2	Character	Segment Street Suffix Code
CITY	20	Character	City Name
COUNTY	6	Character	County Code
STATE	2	Character	State Code
ZIP CODE	10	Character	Postal Zip Code
LOW LAT	12	Numeric Decimal	Latitude Coordinate for intersection of Segment Street and low address cross street
LOW LONG	12	Numeric Decimal	Longitude Coordinate for intersection of Segment Street and low address cross street
LOW STREET	30	Character	Low Address Cross Street
LOW TYPE	2	Character	Low Address Cross Street Type Code
LOW PREFIX	2	Character	Low Address Cross Street Prefix Code
LOW SUFFIX	2	Character	Low Address Cross Street Suffix Code
HIGH LAT	12	Numeric Decimal	Latitude Coordinate for intersection of Segment Street and high address cross street
HIGH LONG	12	Numeric Decimal	Longitude Coordinate for intersection of Segment Street and high address cross street
HIGH STREET	30	Character	High Address Cross Street
HIGH TYPE	2	Character	High Address Cross Street Type Code
HIGH PREFIX	2	Character	High Address Cross Street Prefix Code
HIGH SUFFIX	2	Character	High Address Cross Street Suffix Code
EVEN LOW	6	Numeric	Lowest address value for even address side of the street segment
EVEN HIGH	6	Numeric	Highest address value for even address side of the street segment
EVEN BEAT	2	Character	Beat Code value of even address side of the street segment
EVEN SECTOR	2	Character	Sector Code value of even address side of the street segment
EVEN DISTRICT	2	Character	District Code value of even address side of the street segment
EVEN AGENCY	6	Character	Agency Code value of even address side of the street segment
EVEN JURIS	6	Character	Jurisdiction Code value of even address side of the street segment
ODD LOW	6	Numeric	Lowest address value for odd address side of the street
ODD HIGH	6	Numeric	Highest address value for odd address side of the street
ODD BEAT	2	Character	Beat Code value of odd address side of the street segment
ODD SECTOR	2	Character	Sector Code value of odd address side of the street segment
ODD DISTRICT	2	Character	District Code value of odd address side of the street segment
ODD AGENCY	6	Character	Agency Code value of odd address side of the street segment
ODD JURIS	6	Character	Jurisdiction Code value of odd address side of the street segment
EXTKEY	20	Character	External Key Reference

The sample below defines the fields of the XML import file.

<?xml version="1.0" encoding="Windows-1252" standalone="yes" ?>

<geo_msl>

<wccity>BAR HARBOR</wccity>

<wclstreet>SALT WATER</wclstreet>

<wchstreet>ALAMO</wchstreet>

</geo_msl>

</GeoData>

Import Notes:

Once the external file is read the data, as read, will be immediately displayed in a GeoFile Data-Import - Verification window. This is your opportunity to preview the data that will be processed for the geo-file import / update. Selecting "OK" on the GeoFile Data-Import- Verification window will begin the data import process.
All data is up-shifted to CAPITAL letters before being imported into the Crimestar GeoFile.
Street Names (Root Segment, Low Cross Street & High Cross Street ) are validated against the Master Street Name list. Records that contain street names (including applicable street type, prefix and suffix) that cannot be validated will be skipped.
Street Prefix, Type , Suffix, County and State codes are validated against the corresponding RMS code tables for those respective fields. Records that contain codes that cannot be validated will be skipped.
The street segment file is searched using the address data provided in the data record being imported. If a matching street segment record is located it is updated accordingly. If no matching street segment record is located a new street segment record is created. If an external record key (EXT_KEY) value is provided in the import data that value will be used to find and match to an existing street segment record instead of the address.

Importing the Premise File

A Premise record is an entry which defines a specific address of location. A premise record can be a private residence or a business. The premise record has beat, sector, district and agency attributes and contain emergency contact names and phone numbers. The premise record can also be used to flag a location for the existence of various hazards that responding personnel may need to be aware of. A premise record would normally be associated with the street segment record for the premise address, however premise records can exist without being linked to a specific street segment

The table below defines the fields of the .csv import file.

Field Name	Maximum Size (bytes)	Data Type	Definition
DIGITS	6	Character	Street Address Digits
PREFIX	2	Character	Street Prefix Code
STREET	30	Character	Root Street Name
TYPE	2	Character	Street Type Code
SUFFIX	2	Character	Street Suffix Code
APT	6	Character	Street Address Apartment Number
CITY	20	Character	City Name
COUNTY	6	Character	County Code
STATE	2	Character	State Code
ZIP CODE	10	Character	Postal Zip Code
BUSINESS LICENSE	10	Character	Business License Number
COMMON NAME	30	Character	Premise Common Name/Business Name
AREA CODE	3	Character	Premise Phone Area Code
PHONE NUMBER	8	Character	Premise Phone Number
RESPONSIBLE PERSON (R/P) #1	40	Character	Responsible / Contact Person
PERSON #1 AREA CODE	3	Character	Contact Phone Area Code
PERSON #1 PHONE	8	Character	Contact Phone Number
RESPONSIBLE PERSON (R/P) #2	40	Character	Responsible / Contact Person
PERSON #2 AREA CODE	3	Character	Contact Phone Area Code
PERSON #2 PHONE	8	Character	Contact Phone Number
RESPONSIBLE PERSON (R/P) #3	40	Character	Responsible / Contact Person
PERSON #3 AREA CODE	2	Character	Contact Phone Area Code
PERSON #3 PHONE	8	Character	Contact Phone Number
RESPONSIBLE PERSON (R/P) #4	40	Character	Responsible / Contact Person
PERSON #4 AREA CODE	3	Character	Contact Phone Area Code
PERSON #4 PHONE	8	Character	Contact Phone Number
RESPONSIBLE PERSON (R/P) #5	40	Character	Responsible / Contact Person
PERSON #5 AREA CODE	3	Character	Contact Phone Area Code
PERSON #5 PHONE	8	Character	Contact Phone Number
RESPONSIBLE PERSON (R/P) #6	40	Character	Responsible / Contact Person
PERSON #6 AREA CODE	3	Character	Contact Phone Area Code
PERSON #6 PHONE	8	Character	Contact Phone Number
BEAT	2	Character	Beat Code value
SECTOR	2	Character	Sector Code value
DISTRICT	2	Character	District Code value
AGENCY	6	Character	Agency Code value
LATITUDE	12	Numeric Decimal	Latitude Coordinate for the premise
LONGITUDE	12	Numeric Decimal	Longitude Coordinate for the premise
HAZARD OCCUPANT	1	Logical	True/False Hazard Flag (Y/N) or (true/false)
HAZARD ANIMAL	1	Logical	True/False Hazard Flag (Y/N) or (true/false)
HAZARD MATERIAL	1	Logical	True/False Hazard Flag (Y/N) or (true/false)
HAZARD BIOLOGICAL	1	Logical	True/False Hazard Flag (Y/N) or (true/false)
COMMENT	200	Character	Comments
EXTKEY	20	Character	External Key Reference

The sample below defines the fields of the XML import file.

<?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>

<geo_msl>

<wcstreet>FIRST</wcstreet>

<wccity>WILHAM</wccity>

<wccounty>SMITH</wccounty>

<wccommname>AROUND THE BAY SPORTSWEAR</wccommname>

<wcresppers1>James P. Hayes</wcresppers1>

<wcresppers2>Marian Hayes</wcresppers2>

<wchzocc>false</wchzocc>

<wchzhazmat>false</wchzhazmat>

<wchzbio>false</wchzbio>

<wccmnt>Test Comments</wccmnt>

</geo_msl>

</GeoData>