FLORIDA GEOGRAPHIC DATA LIBRARY DOCUMENTATION

TITLE: LODGING FACILITIES 2008

Geodataset Name:       GC_HOTELS_JUL08
Geodataset Type:       SHAPEFILE
Geodataset Feature:    Point
Feature Count:         8406
GENERAL DESCRIPTION:
This dataset contains 2008 Lodging Facilities information for the State of Florida. It is a combination of geocoded; Hotels, Motels, Condominiums, and Bed & Breakfast addresses from the Department of Business and Professional Regulation (DBPR) and the Yellow Pages online. 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 2003 GC_HOTELS.shp layer.
DATA SOURCE(S):                    University of Florida GeoPlan Center
SCALE OF ORIGINAL SOURCE MAPS:     Varies
GEODATASET EXTENT:                 State of Florida
PUBLICATION DATE: 20090417 TIME PERIOD OF CONTENT: Begin Date: 2003 End Date: 20080721 DOWNLOAD LINK: http://www.fgdl.org/metadataexplorer/explorer.jsp

FEATURE ATTRIBUTE TABLES:

Datafile Name: GC_HOTELS_JUL08.DBF
ITEM NAME WIDTH TYPE
OBJECTID
4 OID
Status
1 String
Score
2 SmallInteger
Side
1 String
Match_addr
103 String
NAME
100 String
ADDRESS
65 String
CITY
40 String
ZIPCODE
4 Integer
PHONE
20 String
COUNTY
20 String
RENTAL_UNT
4 Integer
TYPE
30 String
LIC_TYPE
4 Integer
LIC_NAME
100 String
MOD_CODE
20 String
MNAME
100 String
MADDRESS
65 String
MADDRESS2
65 String
MCITY
40 String
MSTATE
30 String
MZIPCODE
4 Integer
MPHONE
20 String
LICENSE
50 String
LAT_DD
8 Double
LONG_DD
8 Double
USNG_FL_1K
10 String
SOURCE
20 String
DESCRIPT
100 String
UPDATEDAY
36 Date
FGDLAQDATE
36 Date
SHAPE
4 Geometry
AUTOID
4 Integer

FEATURE ATTRIBUTE TABLES CODES AND VALUES:

Item
Item Description
OBJECTID Internal feature number.
GRP = Group


Status ESRI item which denotes the status of the geocoded address whether it was matched or not).

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

Side ESRI item which denotes the side of the street to which the address was matched (for geocoding service styles that can match an address to a particular side of a street).

Match_addr ESRI item which denotes the full street layer address to which the address was matched.

NAME Name of the facility.

ADDRESS A description of a facility's physical location providing direction for delivery and provision of emergency services.

CITY City of facility's physical location.

ZIPCODE US postal delivery designation of facility's physical location.

PHONE The phone number of the facility.

COUNTY County of facility's physical location.

RENTAL_UNT Number of Rental Units.

TYPE Category of the facility derived from "Rank Code."
HOTEL = Hotel

MOTEL = Motel

BED & BREAKFAST = Bed and Breakfast

CONDOMINIUM = Condominium


LIC_TYPE License Type Code
2001 = Hotel

2002 = Motel

2005 = Bed & Breakfast

2006 = Resort Condominium


LIC_NAME Licensee Name

MOD_CODE Modifier Code
SNGL = Single

GRP = Group

CLCT = Collective


MNAME Mailing Name (if different from Licensee Name)

MADDRESS Mailing Address Line 1

MADDRESS2 Mailing Address Line 2

MCITY Mailing City

MSTATE Mailing State

MZIPCODE Mailing Zip Code

MPHONE Primary Telephone Number

LICENSE License Number

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. How to Read a United States National Grid (USNG) Spatial Address Website - http://www.fgdc.gov/usng/how-to-read-usng/index_html

SOURCE Source of the orginal data.

DESCRIPT Based on the field NAME.

UPDATEDAY The date the data was last updated by the Source.

FGDLAQDATE The date FGDL acquired the data from the Source.

SHAPE Feature geometry.

AUTOID Unique ID added by GeoPlan


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.
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

DEPARTMENT OF BUSINESS AND PROFESSIONAL REGULATION
LICENSEE DOWNLOAD FILES SITE DISCLAIMER

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 
Department provides copies of electronic records to the public through this free 
download site.

The Department is only required to provide data in the format in which they are 
maintained and, as a result, does not provide paper copies of this information. In 
addition, the Department 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. Therefore, the download files provided 
from this site are formatted as ASCII text, quote/comma delimited. 

Due to this, it is important that requestors know the following information before 
downloading a file:

- The Department does not offer technical support during or after the download 
process. Please refer to your software manuals, Corporate Help Desk, or Internet 
Service Provider for any assistance you require;

- File size may be larger than the space available on your computer; if so 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;

- Files require Windows 3.1 and a 486 or higher computer and may not be 
compatible with Macintosh or Apple computer systems;

- 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 are refreshed weekly, system maintenance may delay the updating 
of files. To determine the timeliness of data, please refer to the date posted. For up-
to-the-minute, license verification, please call the Department's Customer Contact 
Center at 850.487.1395 or access the Department's License search feature at 
https://www.myfloridalicense.com/Default.asp

- When downloading large data files such as the Construction, Cosmetology, and Real 
Estate licensees into Excel, you may exceed the number of rows that can be loaded.  
This error is usually encountered when an attempt to open a file with more than 65,536 
rows or 256 columns is made. Excel is limited to 65,536 rows of data and 256 columns 
per worksheet. You can have many worksheets with this number of rows and columns, 
but they are usually capable of fitting into one workbook (file).  The number of worksheets 
you can have per workbook is limited only by the amount of available memory your system 
has. By default, Excel can manage 3 worksheets, more if there is available memory to 
support the quantity of data. 

Truncation of rows or columns in excess of the limit is automatic and is not configurable. 
This issue can usually be remedied by opening the source file with a text editor, such as 
Microsoft Office Word, and then saving the file off into multiple files with row or column 
counts within the limits of an Excel worksheet. These files can then be opened or imported 
into Excel worksheets.

If you are using a data format that does not support use of a text editor, it may be easier to 
import the data into Microsoft Office Access and then use the export feature of Access to 
import the data to an Excel format. Other methods of importing large source material into 
multiple worksheets are available, but may be more complex than using either a text editor 
or Access

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:
Yellow Pages website: 
www.YellowPages.com

DEPARTMENT OF BUSINESS AND PROFESSIONAL REGULATION
LICENSEE DOWNLOAD FILES
http://www.myflorida.com/dbpr/sto/file_download/hr_lodging.shtml

DATA LINEAGE SUMMARY:
Process Steps for Yellow Pages Lodging Locations (2003):

GeoPlan downloaded Lodging facility locations from the online Yellow
Pages in 2003. 

-Searched for lodging addresses in www.yellowpages.com
-Selected lodging addresses under following categories:
 Hotels (3704)
 Motels (2260)
 Inns (1071)
 Bed and Breakfast Inns (144)
-All addresses from sections above were copied and pasted into a
 text file, which was then formatted so that it could be imported
 into Excel and converted to a database file format.
-The dbf was then geocoded against ARC Logistics Route GDT Roads 
 and converted into a shapefile with the FGDL Albers HPGN map projection.
Process Date: 20030601

Process Steps for Department Of Business And Professional Regulation (DBPR): GeoPlan downloaded the following public lodging files from the DBPR on 20080721 from the website listed below. http://www.myflorida.com/dbpr/sto/file_download/hr_lodging.shtml Hotels and Restaurants: Lodging License files File Name Size - Updated District 1 1,940,841 - 07/21/2008 District 2 1,408,442 - 07/21/2008 District 3 1,926,205 - 07/21/2008 District 4 3,136,906 - 07/21/2008 District 5 661,474 - 07/21/2008 District 6 793,944 - 07/21/2008 District 7 631,125 - 07/21/2008 Using the following DBPR file format information from the readme.txt that came with the data the seven district text files were formatted so that they could be imported into Excel and converted to a database file format. HOTELS ACTIVE LICENSURE BASE MAILING (File layout for public lodging files) ---------------------------------------------------- Application Number (New and Owner Change Extracts Only) Application Type (New and Owner Change Extracts Only) Application Approval Date (New and Owner Change Extracts Only) Board Code (200 identifies H&R 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 Rental Units (lodging) Next the dbfs were then geocoded against Tele Atlas Roads, and converted into seven shapefiles with the FGDL Albers HPGN map projection. The seven districts shapefiles were then combined into one statewide layer. Process Date: 20080721
Process Steps for Yellow Pages Lodging Locations (2009): -GeoPlan re-geocoded the 2003 Yellow Pages data against a 2009 roads datasets and spatial duplicates that occurred between it and the DPBR address information were removed. Process Date: 20090415
Process Steps for Combining the DBPR & Yellow Pages Lodging Locations (2009): The GeoPlan Center performed the following steps in order to create the 2009 statewide Lodging Facilities data layer. The two geocoded lodging facilities datasets, see below, were merged into one statewide layer. Lodging Facilities Datasets - GeoCoded Yellow Pages Data Shapefile - GeoCoded DBPR Data Shapefile Finally the following fields were added and populated. LAT_DD LONG_DD USNG_FL_1K SOURCE DESCRIPT UPDATEDAY FGDLAQDATE Process Date: 20090417
Data imported to ArcSDE and exported as a shapefile. Process Date: 20090430
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
431 ARCH BLDG
Gainesville, FL
32611


www.fgdl.org 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