Location Types
(Discontinued Access field names are listed in parenthesis.)
Location.LocationID
Location.ItemID
Location.OccupancyType (bl_typ_ref)
Location.OccupancyType = null (Unknown)
Location.OccupancyType = 0 (No occupants – a utility station, etc.)
Location.OccupancyType = 1 (Single Tenant)
Location.OccupancyType = 2 (Multi-Tenant)
Location.OccupancyType = 3 (Either - May be configured for single or multi-tenant)
Location.PropertyType - Industrial (for all in GeorgiaFacts) (property_type) - Legacy, ItemType table used instead.
Location.SquareFeet (bl_sz_qty)
Location.SquareFeetOffice (ofc_sz_qty)
Location.FloorsCount
Location.BuildingCount
Location.BuildingDimensions (bl_dim_dsc)
Location.FloorThickness (bl_flr_thck_qty)
Location.ElevationGroundLevel
Location.Acres (bl_lot_sz_qty)
Location.ExpandableLot (bl_lot_exp_ptntial) - True/False
Location.AcresExpandableAdjacent (bl_avl_adj_land_sz_qty)
Location.ParkingTotal (bl_park_area_dsc)
Location.YearBuilt (bl_cnst_dte)
Location.YearImproved (bl_impr_dte)
Location.FormerUse (bl_tnt_sic_cd)
Location.ConstructionMaterial (bl_mtrl_cd)
Location.CeilingMin (bl_ceil_hgt_min_qty)
Location.CeilingMax (bl_ceil_hgt_max_qty)
Location.MaximumOccupancy
Location.MaximumStaff
Location.MaximumVolunteers
Commercial Space Features:
Location.TruckDoorsHighDock (bl_trk_dr_dohi_no)
Location.TruckDoorsDriveIn (bl_trk_dr_drin_no)
Location.TruckDoorsUnknownType (bl_trk_dr_unk_no)
TruckDoorsTotal - Sum of 3 truck door fields above within XML feed
Location.BayDimensions (bl_min_bay)
Location.RailRoadDoors (bl_rr_do_no)
Location.RailRoadSiding (bl_rr_prvd)
Location.AirCondition (bl_air_cond_ind_cd) - Production Area A/C
Location.CraneCount (bl_crane_ind_cd) - Total Cranes
Location.FreezerSquareFeet (bl_rfrg_ind_cd)
Location.CoolerSquareFeet (cooler_no)
Location.Boiler (bl_boiler_ind_cd)
Location.Insulated (bl_insulated)
Location.Sprinkler (bl_sprnkr_ind_cd)
LocationUtility - List of utilities and providers
LocationUtilityID
LocationID - ItemID of Location table
UtilityID - ItemID of Utility
ServiceTypeID - TypeID of Service Provided - i.e Water, Sewer, Power
MainSize - Size of the main in inches
Capacity - gallons
Consumption - gallons per day average
Comments
StartDate - Start date of service
StopDate - End date of service
Modifier
ModifyDate
Listing
Variables that change each time a building is listed for sale reside in Listing table.
Listing.ListingID
Listing.ItemID
Listing.ListingStatus
Listing.LocationID
Listing.StartDate
Listing.EndDate (Removed Date)
Listing.SpacesOccupied
Listing.SpacesForLease
Listing.SpacesForSale
Listing.SpacesTotal
Listing.SquareFeetMinimum
Listing.SquareFeetContiguous
Listing.Expandable (bl_expn_ptntial)
Listing.ExpandableSquareFeet (bl_expn_sz_qty)
Listing.AcquisitionType - Sale/Lease, Sales, Unknown (bl_acq_typ_ref)
Listing.AskingPrice (bl_acq_sterm_dsc)
Listing.SalesPriceFinal (bl_acq_sterm_dsc)
Listing.LeasePrice (bl_acq_lterm_dsc)
Listing.OwnerType (bl_own_cls_ref) - private, public (county or development authority)
Listing.OwnerName (bl_owner)
Listing.OwnerID
Listing.AgentName (Name and contact info of the real estate agent.)
Listing.AgentID
Listing.SalesPersonID - Sales person (May be changed or removed)
Listing.Flyers (flyers)
Item.Notes (bl_gen_cmn) (bl_utl_cmn - Building Utility Comment) (util_comment - Utility Comment)
(rgn_cd) - RDC Region (Not carried forward. County now determines region.)