FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: LODGING FACILITIES IN FLORIDA - JUNE 2011

Geodataset Name:       GC_HOTELS_JUN11
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         4672
GENERAL DESCRIPTION:
This dataset contains registered lodging facilities (hotels, motels, and bed & breakfasts) in the state of Florida. Please note that previous versions of this dataset included records obtained from Yellow Pages Online. Due to an increase in difficulty of converting the information obtained from Yellow Pages Online into a format conducive to geocoding, this version only includes facilities registered with the Florida Department of Business & Professional Regulation (DBPR). This dataset contains fields denoting the physical address, number of units/rooms, and contact information for lodging facilities located in Florida. This data is meant to be used for planning purposes only and is not intended to represent a 100% inventory of lodging facilities in Florida. This dataset is an update to the gc_hotels_jul08 layer.
DATA SOURCE(S):                    University of Florida GeoPlan Center
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20110613 TIME PERIOD OF CONTENT: 20110613 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: GC_HOTELS_JUN11.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Shape
4 Geometry
Status
1 String
Score
2 SmallInteger
Match_type
2 String
Side
1 String
Match_addr
103 String
NAME
100 String
ADDRESS
65 String
CITY
40 String
ZIPCODE
4 Integer
STATE
3 String
COUNTY_COD
3 String
PHONE
17 String
PHONE2
17 String
BOARD_CODE
4 String
LIC_TYPE
5 String
LIC_NAME
100 String
RANK_CODE
5 String
MNAME
41 String
MADDRESS
37 String
MADDRESS2
40 String
MADDRESS3
36 String
MCITY
21 String
MSTATE
3 String
MZIPCODE
11 String
MCNT_CODE
3 String
DISTRICT
2 String
REGION
3 String
LIC_NUM
11 String
PRI_STATUS
3 String
SEC_STATUS
3 String
EXPIRE
11 String
INSPECT
11 String
SEATS
4 Integer
LAT_DD
8 Double
LONG_DD
8 Double
USNG_FL_1K
10 String
SOURCE
20 String
DESCRIPT
100 String
FLAG
5 String
UPDATE_DAY
36 Date
FGDLAQDATE
36 Date
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.

Shape Feature geometry.

Status ESRI item which denotes the status of the geocoded address (whether it was matched or not)
M = Matched

T = Tie


Score ESRI item which denotes the score with which the address was matched to a feature in the reference data.

Match_type ESRI item which donates a code showing how an address was matched.
A = Automatically matched or rematched.

M = Manually matched or unmatched using the Interactive Rematch dialog box.

PP = Pick by Point - The address was matched to the click point using the Pick Address from Map tool in the Interactive Rematch dialog box.

PA = Pick by Address - The address was matched to an address using the Pick Address from Map tool in the Interactive Rematch dialog box.


Side ESRI item which donates the side of the street to which an address was matched, if the address locator that was used to match the table contains address information for both sides of the street. This attribute has values of "L" for the left side of the street, "R" for the right side of the street, or nothing if the address locator could not determine the side of the street.

Match_addr ESRI item which donates the address that the matched location actually resides based on the information of the matched candidate. For example, an input address "123 Main St N" is matched to a candidate with the suffix direction "NW" and all other components matched correctly. The Match_addr field will contain "123 Main St NW" as the actual address that was matched.

NAME Name of the lodging facility.

ADDRESS Address of the lodging facility.

CITY City of the lodging facility.

ZIPCODE Zipcode of the lodging facility.

STATE State of the lodging facility.

COUNTY_COD County code of the lodging facility (see below).

PHONE Primary Telephone Number.

PHONE2 Secondary Telephone Number.

BOARD_CODE Board Code (200 identifies HR within the department).

LIC_TYPE License Type Code.
2001 = Hotel

2002 = Motel

2005 = Bed & Breakfast


LIC_NAME Licensee Name.

RANK_CODE Rank Code.
HOTL = Hotel

MOTL = Motel

BNB = Bed & Breakfast


MNAME Mailing Name (if different from Licensee Name).

MADDRESS Mailing Street Address Line 1.

MADDRESS2 Mailing Address Line 2.

MADDRESS3 Mailing Address Line 3.

MCITY Mailing City.

MSTATE Mailing State.

MZIPCODE Mailing Zip Code.

MCNT_CODE Mailing County Code (see table below).

DISTRICT District.

REGION Region.

LIC_NUM License Number.

PRI_STATUS Primary Status Code.
20 = Current

45 = Delinquent


SEC_STATUS Secondary Status Code.
10 = Active

20 = Active


EXPIRE Expiry Date.

INSPECT Last Inspection Date.

SEATS Number of rental units.

LAT_DD Latitude in Decimal Degrees.

LONG_DD Longitude in Decimal Degrees.

USNG_FL_1K Facility's 1-kilometer United States National Grid (USNG) address. The USNG is an alpha-numeric reference system based on the UTM coordinate system and is similar to the Military Grid Reference System. Use of the USNG ensures a uniform grid mapping and positional reporting system for search and rescue, emergency planning, response, and recovery.

SOURCE Source of the tabular information.

DESCRIPT Based on NAME.

FLAG This field is reserved for post FGDL field verification purposes. A blank value in this field indicates that verification edits have not taken place. Users that edit the location and/or attribute of a record are asked to mark this field with one of the following values
A = Attribute Edit

S = Spatial Edit

B = Both Attribute and Spatial Edit

N = New

D = Delete

NIN = Not in new


UPDATE_DAY The last day the record was updated.

FGDLAQDATE The date FGDL acquired the data from the source.

AUTOID Unique ID added by GeoPlan

County Codes by Region:

REGION 1 - Dade (23), Monroe (54)

REGION 2 - Broward (16), Martin (53), Palm Beach (60)

REGION 3 - Citrus (19), Hernando (37), Hillsborough (39), Pasco (61), Pinellas (62), 
Polk (63), Sumter (70)

REGION 4 - Brevard (15), Indian River (41), Lake (45), Orange (58), Osceola (59), 
St. Lucie (66), Seminole (69), Volusia (74)

REGION 5 - Alachua (11), Baker (12), Bradford (14), Clay (20), Columbia (22), 
Dixie (25), Duval (26), Flagler (28), Gilchrist (31), Hamilton (34), Lafayette (44), 
Levy (48), Marion (52), Nassau (55), Putnam (64), St. Johns (65), Suwannee (71), 
Union (73)

REGION 6 - Bay (13), Calhoun (17), Escambia (27), Franklin (29), Gadsden (30), 
Gulf (33), Holmes (40), Jackson (42), Jefferson (43), Leon (47), Liberty (49), 
Madison (50), Okaloosa (56), Santa Rosa (67), Taylor (72), Wakulla (75), Walton (76), 
Washington (77)

REGION 7 - Charlotte (18), Collier (21), Desoto (24), Glades (32), Hardee (35), Hendry (36), 
Highlands (38), Lee (46), Manatee (51), Okeechobee (57), Sarasota (68)
USER NOTES:
This data is provided 'as is'. GeoPlan relied on the integrity
of the original data layer's topology
This data is provided 'as is' by GeoPlan and is complete to our
knowledge.
GeoPlan relied on the integrity of the attribute information within
the original data.
The Florida Department of Business & Professional Regulation oversee licensing and 
regulation of a wide range of commercial activities in the state of Florida pursuant to 
Chapter 20.165, Florida Statutes.


What is Geocoding?
Geocoding is term used to describe the act of address matching.  Geocoding
is the process of finding a geographic location (x, y point) for an address
(such as street number and name, city, state, and ZIP Code) on a map.
Geocoding is based off the typical address scheme for the US, in which one
side of the street contains even house numbers while the other side of the
street contains odd house numbers.

The geocoding process uses an algorithm to find the geographic location
of addresses. First, a street segment is identified using the zip code and
street name. Next, the geographic location of the address is matched using
the building number to determine how far down the street and on which side
of the street the building is located. Geocoding Accuracy

The locational accuracy of geocoded addresses may vary from urban to rural
areas due to the algorithm used to generate the geographic locations of
addresses. The algorithm assumes that the size of parcels are equivalent
along a road route. This assumption tends to be more consistent in urban
areas, where the size of parcels vary less than in rural areas.
Consequently, the results of geocoded addresses in urban areas are usually
more reliable than those in rural areas.

For example, the locational accuracy of rural addresses can be slightly
off because some parcels along a rural route may be 15 acres while others
may be 2.5 acres, but the geocoding algorithm assumes that the addresses
are distributed evenly along the route.

The data was created to serve as base information for use in GIS systems for
a variety of planning and analytical purposes.

This data is provided 'as is' and its horizontal positional accuracy
has not been verified by GeoPlan

This data is provided 'as is' and its vertical positional accuracy
has not been verified by GeoPlan

Under Chapter 119, Florida Statutes, the Department of Business and 
Professional Regulation (DBPR) is required to make available for 
inspection and copying any public record regardless of physical 
format, which is not otherwise exempted from public access by 
general law. To fulfill this obligation, the DBPR provides copies 
of electronic records to the public through free download.

DBPR is only required to provide data in the format in which it is 
maintained and, as a result, does not provide paper copies of this 
information. In addition, the DBPR is not required to reformat its 
records to meet a requestor's particular needs.

Section 119.01(2)(b), F.S., requires only that the agency provide 
electronic data in some common format such as, but not limited to, 
the American Standard Code for Information Interchange (ASCII) text 
format. As, the download files provided by DBPR are formatted as 
ASCII text, quote/comma delimited.
Due to this, it is important that requestors know the following 
information before downloading a file:

DBPR does not offer technical support during or after the download 
process. If you require assistance, please refer to your computer 
manuals or contact your Corporate Help Desk or Internet Service Provider.

File sizes may be larger than the space available on your computer. 
If that is the case, free up additional space before attempting the download.

Some features such as tabs, font selection, and graphics may be lost when 
converting a file to ASCII text. The department is not responsible for 
damages sustained to existing user data, software and/or hardware from data 
obtained through the download process.

Although data is refreshed weekly, system maintenance may delay the updating 
of files. To determine the timeliness of the data, please refer to the date 
posted. For up-to-the-minute license verification, please call our Customer 
Contact Center at 850.487.1395 or access the DBPR's license search feature at
https://www.myfloridalicense.com/wl11.asp.

The Florida Geographic Data Library is a collection of Geospatial Data
compiled by the University of Florida GeoPlan Center with support from
the Florida Department of Transportation. GIS data available in FGDL is
collected from various state, federal, and other agencies (data sources)
who are data stewards, producers, or publishers. The data available in
FGDL may not be the most current version of the data offered by the
data source. University of Florida GeoPlan Center makes no guarantees
about the currentness of the data and suggests that data users check
with the data source to see if more recent versions of the data exist.

Furthermore, the GIS data available in the FGDL are provided 'as is'.
The University of Florida GeoPlan Center makes no warranties, guaranties
or representations as to the truth, accuracy or completeness of the data
provided by the data sources. The University of Florida GeoPlan Center
makes no representations or warranties about the quality or suitability
of the materials, either expressly or implied, including but not limited
to any implied warranties of merchantability, fitness for a particular
purpose, or non-infringement. The University of Florida GeoPlan Center
shall not be liable for any damages suffered as a result of using,
modifying, contributing or distributing the materials.

A note about data scale: 

Scale is an important factor in data usage.  Certain scale datasets
are not suitable for some project, analysis, or modeling purposes.
Please be sure you are using the best available data. 

1:24000 scale datasets are recommended for projects that are at the
county level.
1:24000 data should NOT be used for high accuracy base mapping such
as property parcel boundaries.
1:100000 scale datasets are recommended for projects that are at the
multi-county or regional level.
1:125000 scale datasets are recommended for projects that are at the
regional or state level or larger.

Vector datasets with no defined scale or accuracy should be
considered suspect. Make sure you are familiar with your data
before using it for projects or analysis. Every effort has been
made to supply the user with data documentation. For additional
information, see the References section and the Data Source Contact
section of this documentation. For more information regarding
scale and accuracy, see our webpage at:
http://geoplan.ufl.edu/education.html

REFERENCES:
Florida Department of Business & Professional 
Regulation Website:
http://www.myfloridalicense.com/dbpr/index.html

Florida Department of Business & Professional 
Regulation Lodging License Files:
http://www.myfloridalicense.com/dbpr/sto/file_download/hr_lodging.shtml

DATA LINEAGE SUMMARY:
GeoPlan Center Process Steps:

Lodging information was obtained from the 
Florida Department of Business & Professional Regulation via 
their Lodging License files public records download website (see below)

http://www.myfloridalicense.com/dbpr/sto/file_download/hr_lodging.shtml

Seven separate tables were downloaded representing different licensing 
and inspection districts across the state of Florida in CSV format. 

The tables were converted to DBF format, formatted, and merged together. 

There were 37,457 records in the merged table. The merged table contained 
timeshares representing condominiums, apartments, and rooming 
houses that were of no interest to this dataset. 

Motels, condominiums, and bed & breakfasts were exported to a new .dbf 
table that consisted of 4,697 records. 

This dbf was then geocoded against a statewide 2010 NAVTEQ street dataset 
and converted into a shapefile with the FGDL Albers HPGN map projection. 
(See "Map Projection Parameters" below). 

After geocoding the following steps were applied.

- Unmatched locations or locations receiving a score below 80 were 
  reevaluated using Google Maps. Locations' addresses that were 
  successfully located were modified to reflect the correct address using 
  the geocode rematch tool in ArcGIS. 
- 19 records were unable to be matched after reevaluation and therefore 
  removed from the database.
- Capitalized all fields.
- Removed the "Filler", "Location Address Line 2", and "Location Address Line 3" fields.
- Added and calculated the USNG_FL_1K, LONG_DD, and, LAT_DD fields.
- Added FLAG and UPDATE_DAY fields.
- Added FGDLAQDATE based on the date GeoPlan acquired the 
  data from the Source.
- Added the DESCRIPT field based on NAME


The original tables downloaded on 6/13/2011:

District    	File Name 	Records		 	
1 		hrlodge1.csv	7,196
2 		hrlodge2.csv	4,954
3 		hrlodge3.csv	7,391
4 		hrlodge4.csv	10,658
5 		hrlodge5.csv	2,477
6 		hrlodge6.csv	2,562
7 		hrlodge7.csv	2,219


Original table structure:

Board Code (200 identifies HR within the department)
License Type Code (see tables below)
Licensee Name
Rank Code (see tables below)
Modifier Code (see tables below)
Mailing Name (if different from Licensee Name)
Mailing Street Address Line 1
Mailing Address Line 2
Mailing Address Line 3
Mailing City
Mailing State
Mailing Zip Code
Mailing County Code (see table below)
Primary Telephone Number
Business Name (Location)
Filler
Location Street Address Line 1
Location Address Line 2
Location Address Line 3
Location City
Location State
Location Zip Code
Location County Code (see table below)
Secondary Telephone Number
District
Region
License Number
Primary Status Code (see table below)
Secondary Status Code (see table below)
Expiry Date
Last Inspection Date
Number of Seats (food service) or Rental Units (lodging)
Process Date: 20110630

MAP PROJECTION PARAMETERS:

Projection                          ALBERS
Datum                               HPGN
Units                               METERS
Spheroid                            GRS1980
1st Standard Parallel               24  0  0.000
2nd Standard Parallel               31 30  0.000
Central Meridian                   -84 00  0.000
Latitude of Projection's Origin     24  0  0.000
False Easting (meters)              400000.00000
False Northing (meters)             0.00000

DATA SOURCE CONTACT (S):

Name:
Abbr. Name:
Address:


Phone:

Web site:
E-mail:
Contact Person:
         Phone:
        E-mail:
University of Florida GeoPlan Center
GeoPlan
131 Architecture PO Box 115706
Gainesville, Florida
32611-5706


http://www.fgdl.org/metadataexplorer/explorer.jsp data@fgdl.org

FGDL CONTACT:
Name:                   FLORIDA GEOGRAPHIC DATA LIBRARY
Abbr. Name:             FGDL
Address:                Florida Geographic Data Library
                        431 Architecture Building
                        PO Box 115706
                        Gainesville, FL  32611-5706
Web site:               http://www.fgdl.org

Contact FGDL: 

      Technical Support:	        http://www.fgdl.org/fgdlfeed.html
      FGDL Frequently Asked Questions:  http://www.fgdl.org/fgdlfaq.html
      FGDL Mailing Lists:		http://www.fgdl.org/fgdl-l.html
      For FGDL Software:                http://www.fgdl.org/software.html