﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

/*
 * There are 29 tables.
 * This script migrates 13 tables from RepoDb to Repo Manager 
 * @Deprecated this script is only needed if you are starting over and should be run manually...
 
delete from RepoManualStatus;
delete from VehicleFloorPricingParameters;
delete from IMSAutoFileData;
delete from AuctionAssignmentsToCollaterals;
delete from RepoCompanySelections;
delete from AuctionAssignments;
delete from Auctions;
delete from AllowedStatusChanges;
delete from Collaterals;
delete from BodyStyleCodes;
delete from CleaningLevelCodes;
delete from HoldStatusCodes;
delete from Letters;
delete from LocationTypeCodes;
delete from CollateralTypesToVehicleTypes;
delete from VehicleTypeCodes;
delete from CollateralTypes;
delete from AccountTypeCodes;
delete from LoanCategories;

delete from Borrowers;
delete from Repos;
delete from EventAlert;
delete from RepoStatusChanges;
delete from RepoCompany;

SET IDENTITY_INSERT [RepoManualStatus] ON 

INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (1, 'PSKP', 0, 0)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (2, 'NOT ACTIVE', 0, 0)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (3, 'SOLD', 0, 0)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (4, 'REDEEMED', 0, 1)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (5, 'O4R', 1, 1)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (6, 'REPO', 1, 1)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (7, 'RECA', 1, 1)
INSERT [RepoManualStatus] ([ID], [Description], [IsActiveStatus], [WatchForStatusChanges]) VALUES (8, 'REHO', 1, 1)
SET IDENTITY_INSERT [RepoManualStatus] OFF

SET IDENTITY_INSERT [VehicleFloorPricingParameters] ON 

INSERT [VehicleFloorPricingParameters] ([ID], [LowCondition], [HighCondition], [NADAFirstValue], [NADASecondValue], [MMRAdjustedValue], [PercentageOf], [ValuationServiceType]) VALUES (4, CAST(0.0 AS Decimal(18, 1)), CAST(1.5 AS Decimal(18, 1)), N'low', N'low', N'regional', CAST(95.00 AS Decimal(18, 2)), 0)
INSERT [VehicleFloorPricingParameters] ([ID], [LowCondition], [HighCondition], [NADAFirstValue], [NADASecondValue], [MMRAdjustedValue], [PercentageOf], [ValuationServiceType]) VALUES (5, CAST(1.6 AS Decimal(18, 1)), CAST(2.5 AS Decimal(18, 1)), N'low', N'avg', N'regional', CAST(95.00 AS Decimal(18, 2)), 0)
INSERT [VehicleFloorPricingParameters] ([ID], [LowCondition], [HighCondition], [NADAFirstValue], [NADASecondValue], [MMRAdjustedValue], [PercentageOf], [ValuationServiceType]) VALUES (6, CAST(2.6 AS Decimal(18, 1)), CAST(3.5 AS Decimal(18, 1)), N'avg', N'avg', N'regional', CAST(95.00 AS Decimal(18, 2)), 0)
INSERT [VehicleFloorPricingParameters] ([ID], [LowCondition], [HighCondition], [NADAFirstValue], [NADASecondValue], [MMRAdjustedValue], [PercentageOf], [ValuationServiceType]) VALUES (7, CAST(3.6 AS Decimal(18, 1)), CAST(4.5 AS Decimal(18, 1)), N'avg', N'high', N'regional', CAST(95.00 AS Decimal(18, 2)), 0)
INSERT [VehicleFloorPricingParameters] ([ID], [LowCondition], [HighCondition], [NADAFirstValue], [NADASecondValue], [MMRAdjustedValue], [PercentageOf], [ValuationServiceType]) VALUES (8, CAST(4.6 AS Decimal(18, 1)), CAST(5.0 AS Decimal(18, 1)), N'high', N'high', N'regional', CAST(95.00 AS Decimal(18, 2)), 0)
SET IDENTITY_INSERT [VehicleFloorPricingParameters] OFF

SET IDENTITY_INSERT [RepoCompany] ON 

INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (1, N'Par', N'testemail@test.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (2, N'Surrender', N'Email@email.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (4, N'Repossessors', N'test@gmail.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (5, N'Allied Skip Claim', N'dianavandebogert@landmarkcu.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (7, N'Badgerland', N'test@gmail.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (8, N'No Repo Company Assigned', N'none@none.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (9, N'All City Towing', N'morgan@allcitytowing@yahoo.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (10, N'National Asset Solutions,Inc. ', N'dennis@nas-now.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (11, N'Location Services', N'Jodie.Selby@location-services.com')
INSERT [RepoCompany] ([ID], [Name], [Email]) VALUES (12, N'Insurance Company', N'billjohns@landmarkcu.com')
SET IDENTITY_INSERT [RepoCompany] OFF

INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2CUV', N'2 Door Crossover Utility Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2D', N'2 Door Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DCP', N'2 Door Coupe')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DCV', N'2 Door Convertible')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DHB', N'2 Door Hatch Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DHT', N'2 Door Hard Top')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DLB', N'2 Door Lift Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DSN', N'2 Door Sedan')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2DST', N'2 Door Soft Top')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2MPV', N'2 Door Multi-Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2PUT', N'2 Door Pickup Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2STK', N'Stake Bed Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2SUT', N'2 Door Sport Utility Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2SUV', N'2 Door Sport Utility Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'2VAN', N'2 Door Van')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3APV', N'3 Door All Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3D', N'3 Door Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3DCP', N'3 Door Coupe')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3DHB', N'3 Door Hatch Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3DLB', N'3 Door Lift Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3DSN', N'3 Door Sedan')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3DTT', N'3 Door T-Top')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3DVN', N'3 Door Van')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3MPV', N'3 Door Multi-Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3PUT', N'3 Door Extended Cab Pickup Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3TRK', N'3 Door Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3VAN', N'3 Door Cargo Van')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'3WGN', N'3 Door Wagon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4APV', N'4 Door All Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4CAB', N'Crew Cab')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4CUV', N'4 Door Crossover Utility Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4D', N'4 Door Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4DCP', N'4 Door Coupe')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4DHB', N'4 Door Hatch Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4DHT', N'4 Door Hard Top')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4DLB', N'4 Door Lift Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4DSN', N'4 Door Sedan')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4MPV', N'4 Door Multi-Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4PUT', N'4 Door Pickup Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4SUT', N'4 Door Sport Utility Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4SUV', N'4 Door Sport Utility Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4VAN', N'4 Door Van')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'4WGN', N'4 Door Wagon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'5DHB', N'5 Door Hatch Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'5DLB', N'5 Door Lift Back')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'5DSN', N'5 Door Sedan')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'5MPV', N'5 Door Multi-Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'5WHL', N'5th Wheel')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'APV', N'All Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'ATV', N'All Terrain Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BBOW', N'Bowrider')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BCAB', N'Cabin/Cuddy')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BDCK', N'Deck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BDIN', N'Canoe/Dinghie')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BFIS', N'Fishing')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BHOU', N'House Boat')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BOAT', N'Boat')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BPER', N'Performance')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BPON', N'Pontoon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BSAI', N'Sail Boat')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BSKI', N'Skiboat')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'BUS', N'Bus')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CABO', N'Cabover Tractor')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CAMP', N'Camper')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CBKT', N'Bucket Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CCMP', N'Air Compressor')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CCRN', N'Crane')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CDD', N'Digger Derrick')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CDOZ', N'Bulldozer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CEXE', N'Excavator')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CFRK', N'Forklift')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CGEN', N'Generator')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CLOD', N'Loader')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CONS', N'Construction Equip.')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CONV', N'Conventional Tractor')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CPAC', N'Packer Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CREW', N'4 Door Full Rear Door Cab')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CTRN', N'Trencher')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CVAN', N'Cargo Van')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'CWLD', N'Welder')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'DCAB', N'Double Cab Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'FARM', N'Farm Equip.')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'GOLF', N'Golf Cart')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HBOX', N'Box Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HC3', N'Class 3')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HC4', N'Class 4')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HC5', N'Class 5')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HC6', N'Class 6')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HC7', N'Class 7')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HC8', N'Class 8')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HCAB', N'Cab/Chassis')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HCR', N'Car Carrier')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HDMP', N'Dump')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HFLT', N'Flatbed')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HLFT', N'Lift Platform')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HSTP', N'Stepvan')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HTNK', N'Tanker')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HTRK', N'Heavy Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HTRL', N'Horse Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HUSV', N'Cutaway Chassis w/UB')
GO
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'HUTL', N'Utility Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'INC', N'Incomplete Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'JSKI', N'Jet Ski')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'KOMB', N'Volkswagen Bus (Truck)')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'LIMO', N'Limousine')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'M/C', N'Motorcycle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'MEGA', N'Mega Body')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'MH', N'Motor Home')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'MIC', N'Motorcycle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'MPV', N'Multi-Purpose Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'OTH', N'Other')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PART', N'Parts')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PDIR', N'Dirt Bike')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PDUN', N'Dune Buggy')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PMTR', N'Park Model Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PS', N'Powersports')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PUT', N'Pickup Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'PWTR', N'Personal Watercraft')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'QUAD', N'Quad Cab')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RCAB', N'Regular Cab')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RMOB', N'Mobile Home')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RV', N'Recreation Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVCA', N'RV Class A')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVCB', N'RV Class B')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVCC', N'RV Class C')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVFD', N'Fold Down')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVFW', N'Fifth Wheel')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVHT', N'Horse Trailer w/Living')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVSU', N'SURV-w/Garage')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'RVTC', N'Truck Camper')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'SEMI', N'Semi Tractor')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'SNOW', N'Snowmobile')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'SUV', N'Sport Utility Vehicle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'SW2D', N'2 Door Station Wagon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'SW4D', N'4 Door Station Wagon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'SW5D', N'5 Door Station Wagon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TNTR', N'Tent Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRAC', N'Tractor Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRB', N'Boat Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRCM', N'Truck Camper')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TREN', N'Utility Enclosed')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRK', N'Truck')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRLR', N'Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRMC', N'Rail Motorcycle')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TROP', N'Utility Open')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TRSE', N'Semi Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'TTRL', N'Travel Trailer')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'UTIL', N'Heavy Equipment')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'VAN', N'Van')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'WGN', N'Wagon')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'XC2D', N'Extended Cab - 2 Doors')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'XC3D', N'Extended Cab - 3 Doors')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'XC4D', N'Extended Cab - 4 Doors (Not Crew)')
INSERT [BodyStyleCodes] ([Code], [Description]) VALUES (N'XCAB', N'Extended Cab')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (1, N'No Cleaning')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (2, N'Full Detail')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (3, N'Wash and Vacuum Only')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (4, N'Value/Standard')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (5, N'Deluxe/Front Line Ready')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (6, N'Deluxe/High Line Detail')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (7, N'Deluxe/Sponsored Plus')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (8, N'Deluxe/Extra Step')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (9, N'Partial Detail')
INSERT [CleaningLevelCodes] ([Code], [Description]) VALUES (10, N'Ultra Detail')
SET IDENTITY_INSERT [CollateralTypes] ON 

INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (2, N'Vehicle', N'NADAValueLookup')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (6, N'Motorcycle', N'')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (7, N'Boat', N'')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (8, N'Motor', N'')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (9, N'Trailer', N'')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (10, N'Powersport', N'')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (11, N'Other', N'')
INSERT [CollateralTypes] ([ID], [Description], [LookupHandler]) VALUES (12, N'Camper', N'')
SET IDENTITY_INSERT [CollateralTypes] OFF
SET IDENTITY_INSERT [CollateralTypesToVehicleTypes] ON 

INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (1, 2, 0)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (2, 2, 1)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (3, 2, 8)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (4, 6, 4)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (5, 7, 3)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (6, 8, 3)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (7, 9, 3)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (8, 9, 7)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (9, 6, 13)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (10, 10, 11)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (11, 10, 12)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (12, 10, 14)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (13, 10, 6)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (14, 2, 9)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (15, 11, 5)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (16, 11, 10)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (17, 12, 2)
INSERT [CollateralTypesToVehicleTypes] ([ID], [CollateralTypeId], [VehicleTypeId]) VALUES (18, 9, 6)
SET IDENTITY_INSERT [CollateralTypesToVehicleTypes] OFF
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (0, N'No Hold')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (1, N'Bankruptcy')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (2, N'Insurance')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (3, N'Legal')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (4, N'Other Buyer')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (5, N'Repo')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (6, N'Special Promotion')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (7, N'Moved')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (9, N'Other')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (10, N'Error')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (11, N'Inspection')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (12, N'Title Problem')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (13, N'Redemption')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (14, N'Dealer Repurchase')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (15, N'Keys')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (16, N'Mechanical')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (17, N'Paint & Body')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (18, N'Transportation Delay')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (19, N'Corrections')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (20, N'Military')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (21, N'Notice Of Intent')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (22, N'Notice Of Sale')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (23, N'Upstream/Online Sale')
INSERT [HoldStatusCodes] ([Code], [Description]) VALUES (24, N'Recall')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'700  ', N'RTC-Illinois', 15, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'701  ', N'Right to Reinstate/Redeem-Illinois', 22, N'AfterO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'702  ', N'Affidavit of Defense-Illinois', 22, N'AfterO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'703  ', N'Notice of Plan to Sell-Illinois', 22, N'AfterO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'704  ', N'Repo: Surplus-Deficiency Notice', 0, N'AfterSale')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'ILLSU', N'ILLINOIS SURRENDER', 0, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'LTR34', N'Repo-Notice of Repossession', 15, N'AfterO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'LTR35', N'WI Repo-Notice of Sale', 15, N'AfterO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'LTR36', N'WI Repo-Sale of Collateral Notice', 15, N'AfterO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'RTC  ', N'Notice to repossess/prior expired RTC', 0, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'RTC 1', N'RTC Non Auto & Non Cycle', 15, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'RTC 3', N'RTC-AUTO LOANS-WI', 15, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'RTC2 ', N'RTC New Law', 15, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'RTCSP', N'SPANISH RTC WI AUTO LOANS', 15, N'BeforeO4R')
INSERT [Letters] ([ActionCode], [Description], [DaysToWait], [WhenLetterIsSent]) VALUES (N'VOL', N'Wisconsin Surrender', 0, N'BeforeO4R')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (1, N'Business')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (2, N'Residence')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (3, N'Marshalling Yard')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (4, N'Auction')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (5, N'Dealership')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (6, N'Impound Lot')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (7, N'Repo Agent')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (8, N'Body Shop')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (9, N'Repair Shop')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (10, N'Government')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (11, N'Tow Company')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (12, N'Street')
INSERT [LocationTypeCodes] ([Code], [Description]) VALUES (13, N'Unknown')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'0', N'Car or Light Truck')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'1', N'Medium or Heavy Truck')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'10', N'Yellow Steel')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'11', N'jet Ski')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'12', N'ATV')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'13', N'Moped')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'14', N'Snowmobile')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'2', N'RV')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'3', N'Boat')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'4', N'Motorcycle')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'5', N'Other')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'6', N'Powersport')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'7', N'Trailer')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'8', N'Box Truck')
INSERT [VehicleTypeCodes] ([Code], [Description]) VALUES (N'9', N'Tractor Trailer')

SET IDENTITY_INSERT [LoanCategories] ON 

INSERT [LoanCategories] ([ID], [CategoryName]) VALUES (1, N'Vehicle')
INSERT [LoanCategories] ([ID], [CategoryName]) VALUES (2, N'Marine')
INSERT [LoanCategories] ([ID], [CategoryName]) VALUES (3, N'Recreation')
INSERT [LoanCategories] ([ID], [CategoryName]) VALUES (4, N'Motorcycle')
SET IDENTITY_INSERT [LoanCategories] OFF

SET IDENTITY_INSERT [AccountTypeCodes] ON 

INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (10, N'L-A3 ', N'36 MO USED AUTO RPM LOAN', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (11, N'L-A4 ', N'48 MO USED AUTO RPM LOAN', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (12, N'L-A5 ', N'60 MO USED AUTO RPM LOAN', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (13, N'L-AB ', N'NEW AUTOS/TRUCKS', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (14, N'L-AC ', N'USED AUTO/TRUCK', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (15, N'L-AD ', N'MOTORCYCLES NEW', 1, 4)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (16, N'L-AE ', N'RECREATIONAL VEHICLE', 1, 3)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (17, N'L-AF ', N'MOTORCYCLES USED', 1, 4)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (18, N'L-AN ', N'NEW INDIRECT REC VEHICLE', 1, 3)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (19, N'L-AU ', N'USED INDIRECT REC VEHICLE', 1, 3)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (20, N'L-B4 ', N'NEW BOAT DEALER', 1, 2)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (21, N'L-B5 ', N'BOAT LOAN', 1, 2)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (23, N'L-BN ', N'DEALER NEW MOTORCYCLE', 1, 4)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (24, N'L-BO ', N'BOATS', 1, 2)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (25, N'L-BU ', N'DEALER USED MOTORCYCLE', 1, 4)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (26, N'L-CA ', N'CENTRIX AUTO', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (36, N'L-H1 ', N'FIXED AUTO/TRUCK', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (50, N'L-HT ', N'HARTFORD-USED AUTO/TRUCK', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (61, N'L-NB ', N'DEALER BUS NEW VEHICLE', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (62, N'L-NF ', N'DEALER NEW FRESH START', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (63, N'L-NR ', N'Dealer New Rec. Vehicle-IL', 1, 3)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (69, N'L-P1 ', N'DEALER USED 1YR OLD', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (70, N'L-P2 ', N'DEALER USED 2YRS OLD', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (71, N'L-P3 ', N'DEALER USED 3YRS OLD', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (72, N'L-P4 ', N'DEALER USED 4YRS OLD', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (73, N'L-P5 ', N'DEALER USED 5 +YRS OLD', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (74, N'L-P6 ', N'Dealer 1st Time Buyer New-IL', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (75, N'L-P7 ', N'Dealer 1st Time Buyer Used-IL', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (76, N'L-P8 ', N'Dealer College Grad New-IL', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (77, N'L-P9 ', N'Dealer College Grad Used-IL', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (80, N'L-PN ', N'DEALER NEW', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (113, N'L-UB ', N'DEALER BUS USED VEHICLE', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (114, N'L-UF ', N'DEALER USER FRESH START', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (115, N'L-UM ', N'Dealer Used Motorcycle-IL', 1, 4)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (116, N'L-UV ', N'BRANCH USED DEALER', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (120, N'L-X4 ', N'DEALER USED RPM LOAN', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (121, N'L-XB ', N'DEALER NEW 1ST TIME BUYER', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (123, N'L-XL ', N'USED DEALER 1ST TIME BUYER', 1, 1)
INSERT [AccountTypeCodes] ([ID], [AccountTypeCode], [Description], [IsVisible], [CategoryId]) VALUES (178, N'L-NI', N'Dealer New Auto-IL', 1, 1)
SET IDENTITY_INSERT [AccountTypeCodes] OFF

GO
SET IDENTITY_INSERT [AllowedStatusChanges] ON 

INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (1, N'REPO', N'SOLD')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (3, N'O4R', N'REPO')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (4, N'O4R', N'REHO')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (5, N'O4R', N'RECA')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (6, N'O4R', N'PSKP')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (7, N'REDEEMED', N'O4R')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (8, N'RECA', N'O4R')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (9, N'REHO', N'O4R')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (10, N'REHO', N'O4R')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (12, N'REPO', N'REDEEMED')
INSERT [AllowedStatusChanges] ([ID], [CurrentStatus], [AllowedChangeStatus]) VALUES (15, N'REDEEMED', N'REPO')
SET IDENTITY_INSERT [AllowedStatusChanges] OFF

INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1060', N'Dealers Auto Auction Southwest', N'yes', N'1433 South 19th Avenue', N'-', N'Phoenix', N'AZ', '85009', N'USA', N'(602) 253-7766', N'(602) 253-4646', 33.4337272644043, -112.09916687011719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1061', N'ADESA Portland', N'yes', N'23585 NE Sandy Blvd.', N'-', N'Wood Village', N'OR', '97060', N'USA', N'(800) 300-3200', N'(503) 661-7286', 45.545101165771484, -122.41893005371094)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1062', N'ADESA Northwest', N'yes', N'90485 Auction Way', N'-', N'Eugene', N'OR', '97402', N'USA', N'(800) 905-3901', N'(541) 689-6049', 44.122535705566406, -123.17698669433594)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1063', N'ADESA Sacramento Brasher`s', N'yes', N'6233 Blacktop Road', N'PO Box 73000', N'Rio Linda', N'CA', '95673', N'USA', N'(800) 288-6882', N'(916) 992-8764', 38.67979, -121.48175)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1064', N'Carolina Auto Auction', N'yes', N'140 Webb Road', N'-', N'Williamston', N'SC', '29697', N'USA', N'(864) 231-7000', N'(864) 622-0003', 34.64129738509655, -82.58376382291317)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1066', N'Columbus Fair Auto Auction', N'yes', N'4700 Groveport Road', N'-', N'Obetz', N'OH', '43207', N'USA', N'(614) 497-2000', N'(614) 497-1711', 39.873294830322266, -82.941635131835938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1067', N'Dealers Auto Auction of Oklahoma City, Inc.', N'yes', N'1028 South Portland Avenue', N'-', N'Oklahoma City', N'OK', '73108', N'USA', N'(405) 947-2886', N'(405)947-7642', 35.455406188964844, -97.580070495605469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1068', N'Greater Quad City Auto Auction', N'yes', N'4015 78th Avenue', N'P.O. Box 409', N'Milan', N'IL', '61264', N'USA', N'(309) 787-6300', N'(309) 787-4541', 41.439964, -90.53186)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1069', N'Indiana Auto Auction', N'yes', N'4425 W. Washington Center Road', N'-', N'Fort Wayne', N'IN', '46818', N'USA', N'(260) 489-2776', N'(260) 489 5476', 41.128410339355469, -85.2020034790039)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1071', N'ADESA Little Rock', N'yes', N'8700 Highway 70', N'-', N'North Little Rock', N'AR', '72117', N'USA', N'(501) 945-2444', N'501-945-2605', 34.76812744140625, -92.1676254272461)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1073', N'Port City Auto Auction', N'yes', N'28 Port City Lane', N'P.O. Box 220', N'Richmond', N'ME', NULL, N'USA', N'(207) 737-8331', N'(207) 737-8346', 44.098858237266541, -69.86102856695652)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1074', N'Rawls Auto Auction Inc.', N'yes', N'2818 Pond Branch Rd.', N'-', N'Leesville', N'SC', '29070', N'USA', N'(803) 657-5111', N'(803) 657-6763', 33.8741340637207, -81.415969848632812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1075', N'State Line Auto Auction Inc.', N'yes', N'830 Talmadge Hill Road South', N'-', N'Waverly', N'NY', '14892', N'USA', N'(607) 565-8151', N'(607) 565-8659', 42.010963, -76.504127)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1076', N'ADESA Fargo', N'yes', N'1650 East Main Ave.', N'PO Box 772', N'West Fargo', N'ND', '58078', N'USA', N'(701) 282-8203', N'(701) 281-0888', 46.877986907958984, -96.872528076171875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1078', N'Central Pennsylvania Auto Auction', N'yes', N'PO Box 41', N'EXIT 178 OFF I-80 AIRSTRIP DR', N'Lock Haven', N'PA', '17745', N'USA', N'(570) 726-4300', N'(570) 726-7841', 41.236843109130859, -77.47662353515625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1079', N'Dealers Auto Auction of Chattanooga, LLC', N'yes', N'2120 Stein Drive', N'-', N'Chattanooga', N'TN', '37421', N'USA', N'(423) 499-0015', N'(423) 499-0304', 35.059501647949219, -85.183555603027344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1080', N'Corry Auto Dealers Exchange', N'yes', N'12141 Route 6', N'P.O. Box 317', N'Corry', N'PA', '16407', N'USA', N'(814) 664-7721', N'(814) 664-7724', 41.916713714599609, -79.717788696289062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1081', N'ADESA Pittsburgh', N'yes', N'378 Hunker Waltz Mill Road', N'P.O. Box 431', N'New Stanton', N'PA', '15672', N'USA', N'(724)925-4700', N'(724) 925-4702', 40.219378173351288, -79.638031795620918)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1082', N'Dyer Auto Auction', N'yes', N'P.O. Box 115', N'-', N'Dyer', N'IN', NULL, N'USA', N'(219) 865-2361', N'(219) 865-4472', 39.210121154785156, -86.857940673828125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1083', N'Flint Auto Auction, Inc.', N'yes', N'3711 Western Road', N'-', N'Flint', N'MI', NULL, N'USA', N'(800) 284-0034', N'(810) 736-3351', 43.049087524414062, -83.657241821289062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1084', N'Greater Kalamazoo Auto Auction', N'yes', N'900 North U.S. 131', N'P.O. Box 697', N'Schoolcraft', N'MI', '49087', N'USA', N'(800) 536-2047', N'(269) 679-4542', 42.145351409912109, -85.6377182006836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1085', N'ADESA Boise', N'yes', N'7355 S. Eisenman Road', N'-', N'Boise', N'ID', '83716', N'USA', N'(800)346-7839', N'(208) 395-3126', 43.535114288330078, -116.16232299804688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1086', N'Kesler Schaefer Auto Auction', N'yes', N'5333 West 46th Street', N'-', N'Indianapolis', N'IN', '46254', N'USA', N'(317) 297-2300', N'(317) 297-6234', 39.838397204875946, -86.25303715467453)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1087', N'ADESA San Diego', N'yes', N'2175 Cactus Road', N'-', N'San Diego', N'CA', '92154', N'USA', N'(619) 661-5565', N'866-926-4281', 32.558074, -116.986175)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1088', N'Morton Auto Auction', N'yes', N'410 Erie Ave', N'P.O. Box 442', N'Morton', N'IL', '61550', N'USA', N'(309) 263-7467', N'(309) 266-5414', 40.607376, -89.48001)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1089', N'KCI Auto Auction', N'yes', N'11101 North Congress', N'-', N'Kansas City', N'MO', '64153', N'USA', N'(816) 502-3318', N'(816) 801-8924', 39.294700622558594, -94.665802001953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1092', N'Southern Auto Auction', N'yes', N'161-164 South Main Street', N'-', N'East Windsor', N'CT', NULL, N'USA', N'(860) 292-7500', N'(860) 292-7599', 41.88697, -72.613151)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1094', N'ABC Virginia', N'yes', N'656 S MILITARY HWY', N'-', N'Virginia Beach', N'VA', '23464', N'USA', N'(757)-487-3464', N'(757)-485-2227', 36.823005676269531, -76.2085952758789)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1095', N'Acadia Auto Auction', N'yes', N'8 Murray Rd', NULL, N'Carmel', N'ME',' 4419', N'USA', N'(207) 848-2848', N'(207) 848-2080', 44.762305, -68.992913)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1096', N'Airport Auto Auction, Inc.', N'yes', N'PO Box 420', N'', N'Alcoa', N'TN', '37701', N'USA', N'(865) 970-9600', N'(865) 970-9603', 35.799949645996094, -83.977188110351562)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1097', N'ADESA Sarasota', N'yes', N'6005 24TH ST EAST', N'-', N'BRADENTON', N'FL', '34203', N'USA', N'(941) 756-8478', N'941-756-7546', 27.435420155525208, -82.5339337438345)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1098', N'Corpus Christi Auto Auction', N'yes', N'2149 IH 69 Access Rd.', N'-', N'Robstown', N'TX', '78380', N'USA', N'(800) 733-2133', N'(361) 767-9840', 27.78729248046875, -97.754470825195312)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1099', N'DAA Northwest', N'yes', N'2215 South Hayford Road', N'PO Box 19190', N'Spokane', N'WA', '99224', N'USA', N'(509) 244-4500', N'(509) 244-8244', 47.634048461914062, -117.55593109130859)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1100', N'America`s Auto Auction - Harrisburg', N'yes', N'1100 South York Street', N'-', N'Mechanicsburg', N'PA', '17055', N'USA', N'(717) 697-2222', N'(717) 697-2234', 40.197174072265625, -77.009918212890625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1101', N'Poplar Bluff Auto Auction', N'yes', N'Route 7, Box 587', N'-', N'Poplar Bluff', N'MO', '63901', N'USA', N'(573) 686-1188', N'(573) 686-1870', 36.7733154296875, -90.4489974975586)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1102', N'ADESA Sioux Falls', N'yes', N'46893 271st Street', N'-', N'Tea', N'SD', '57064', N'USA', N'(605) 368-5364', N'(605) 368-2808', 43.460903167724609, -96.827133178710938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1103', N'ADESA Syracuse', N'yes', N'5930 Route 31', N'-', N'Cicero', N'NY', '13039', N'USA', N'(315)699-2792', N'(315) 699-9620', 43.175739794969559, -76.112033352255821)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1104', N'Memphis Auto Auction', N'yes', N'3719 Old Getwell Road', N'-', N'Memphis', N'TN', '38118', N'USA', N'901-433-2302', N'901-334-4702', 35.046817779541016, -89.938682556152344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1109', N'Manheim Knottingley', N'yes', N'Tadcaster Road, Brotherton', N'-', N'Knottingley', N'West Yorkshire', NULL, N'England', N'(101144) 1977-674151', N'(101144) 1977-607192', 53.738134, -1.263747)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1117', N'Manheim Bristol', N'yes', N'Ashton Vale Road', N'-', N'Ashton Vale', N'Bristol', NULL, N'England', N'(101144) 117-300-4400', N'(101144) 117-300-4444', 51.43916, -2.625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1118', N'Manheim Rotherham', N'yes', N'Canklow Meadows Ind. Estate', N'West Bawtry Road', N'Rotherham', N'Rotherham', NULL, N'England', N'(101144) 1709-378989', N'(101144) 1709-369256', 53.405568, -1.352908)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1119', N'Manheim Birmingham United Kingdom', N'yes', N'Whitworth Close', N'Heath Road', N'Darlaston', N'AB', NULL, N'England', N'(101144) 0121-568-7500', N'(101144) 0121-568-7501', 55.1693954467773, -114.511039733887)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1120', N'Manheim Colchester', N'yes', N'Colchester Road', N'Frating', N'Colchester', N'Essex', NULL, N'England', N'(101144) 1206-250230', N'(101144) 1206-251190', 51.87098, 1.047389)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1121', N'Manheim Haydock', N'yes', N'Yewtee Trading Estate', N'Kilbuck Lane', N'Haydock', N'Lancashire', NULL, N'England', N'(101144) 1942-721245', N'9101144) 1942-271138', 53.4678, -2.6609)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1122', N'Manheim Mansfield', N'yes', N'Fulwood Industrial Estate', N'Common Road', N'Huthwaite', N'Sutton in Ashfield', NULL, N'England', N'(101144) 1623-554232', N'(101144) 1623-440285', 53.113551042643273, -1.3012484752668228)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1123', N'Manheim Northampton', N'yes', N'Salthouse Road', N'Brackmills Indistrial Estate', N'Northampton', N'-', NULL, N'England', N'(101144) 1604-764041', N'(101144) 1604-701749', 52.220713, -0.862687)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1124', N'Manheim Washington', N'yes', N'District 15', N'Pattinson Road', N'Washington', N'Tyne and Wear', NULL, N'England', N'(101144) 191-419-0000', N'(10144) 191-419-0033', 54.903955, -1.488957)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1129', N'ADESA Winnipeg', N'yes', N'Highway 7 North', N'PO Box 19, Group 242, RR 2', N'Winnipeg', N'MB', NULL, N'Canada', N'204-697-4400; 888-531-7653', N'204-694-4942', 49.95332, -97.2296999)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1130', N'ADESA Moncton', N'yes', N'47 Edinburgh Drive', N'-', N'Moncton', N'NB', NULL, N'Canada', N'(506) 857-0198', N'(506) 857-8258', 46.07162, -64.83233)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1131', N'ADESA Edmonton', N'yes', N'1701 9th Street', N'-', N'Nisku', N'AB', NULL, N'Canada', N'(780) 955-4400', N'780-955-4344', 53.3308104, -113.5127651)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1132', N'ADESA Toronto', N'yes', N'55 Auction Lane', N'-', N'Brampton', N'ON', NULL, N'Canada', N'(905) 790-7653', N'(905) 790-9454', 43.74926, -79.68764)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1135', N'ADESA Saskatoon', N'yes', N'618 48th Street East', N'-', N'Saskatoon', N'SK', NULL, N'Canada', N'306-242-8771; 800-667-1162', N'306-934-4630', 52.16917, -106.65918)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1137', N'Decatur Auto Auction, Inc.', N'yes', N'1991 W. Mound Rd.', N'-', N'Decatur', N'IL', '62526', N'USA', N'(217) 875-4220', N'(217) 875-2927', 39.889949798583984, -88.989761352539062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1143', N'ADESA Tampa', N'yes', N'3225 North 50th Street', N'-', N'Tampa', N'FL', '33619', N'USA', N'(813) 620-3600', N'(813) 621-3199', 27.972984313964844, -82.398483276367188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1145', N'ADESA Colorado Springs', N'yes', N'10680 Charter Oak Ranch Road', N'-', N'Fountain', N'CO', '80817', N'USA', N'(719) 391-6673', N'(719) 392-9385', 38.678710609674454, -104.71517868340015)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1151', N'ADESA Golden Gate', N'yes', N'18501 W. STANFORD RD.', N'-', N'TRACY', N'CA', '95377', N'USA', N'(209) 839-3972', N'(209) 834-2946', 37.731395, -121.537841)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1154', N'ADESA Kansas City', N'yes', N'15511 ADESA Dr.', N'-', N'Belton', N'MO', '64012', N'USA', N'816-348-7200', N'(816) 348-7331', 38.789482116699219, -94.551910400390625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1160', N'ADESA Seattle', N'yes', N'621 - 37th Street NW', N'-', N'Auburn', N'WA', '98001', N'USA', N'(253) 735-1600', N'(253) 939-7875', 47.341682434082031, -122.23735046386719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1163', N'ADESA Atlanta', N'yes', N'5055 Oakley Industrial Blvd', N'-', N'Fairburn', N'GA', '30213', N'USA', N'(770) 357-2277', N'(770) 357-2109', 33.5431022644043, -84.550567626953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1165', N'ADESA Shreveport', N'yes', N'7666 Highway 80 West', N'P.O. Box 19040 (71149)', N'Shreveport', N'LA', '71119', N'USA', N'(318) 938-4400', N'(318) 938-7960', 32.446987, -93.923194)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1166', N'ADESA Austin', N'yes', N'2108 Ferguson Lane', N'-', N'Austin', N'TX', '78754', N'USA', N'(512) 873-4000', N'(512) 873-4022', 30.346481323242188, -97.665718078613281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1167', N'ADESA Birmingham', N'yes', N'804 Sollie Drive', N'-', N'Moody', N'AL', '35004', N'USA', N'(205) 640-1010', N'(205) 640-2585', 33.5791090875864, -86.511187702417374)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1168', N'ADESA Boston', N'yes', N'63 Western Avenue', NULL, N'Framingham', N'MA',' 1702', N'USA', N'(508) 626-7000', N'(508) 626-7111', 42.26317, -71.411078)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1169', N'ADESA Buffalo', N'yes', N'12200 Main Street', N'-', N'Akron', N'NY', '14001', N'USA', N'(716) 542-3300', N'716-542-3448', 43.020210266113281, -78.5027084350586)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1170', N'ADESA Charlotte', N'yes', N'11600 Fruehauf Drive', N'-', N'Charlotte', N'NC', '28273', N'USA', N'(704) 587-7653', N'(704) 587-9831', 35.129165649414062, -80.960258483886719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1171', N'ADESA Cincinnati/Dayton', N'yes', N'4400 William C. Good Boulevard', N'-', N'Franklin', N'OH', '45005', N'USA', N'(937) 746-4000', N'(937) 746-1140', 39.542690277099609, -84.286376953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1172', N'ADESA Cleveland', N'yes', N'210 East Twinsburg Road', N'-', N'Northfield', N'OH', '44067', N'USA', N'(330) 467-8280', N'(330) 468-3196', 41.277317047119141, -81.504302978515625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1173', N'ADESA Dallas', N'yes', N'3501 Lancaster-Hutchins Rd', N'-', N'Hutchins', N'TX', '75141', N'USA', N'972-225-6000', N'972-284-4799', 32.624584, -96.735504)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1174', N'ADESA Halifax', N'yes', N'300 Bell Boulevard', N'-', N'Enfield', N'NS', NULL, N'Canada', N'(902) 873-4400', N'(902) 873-3622', 44.88035, -63.52234)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1175', N'ADESA Houston', N'yes', N'4526 North Sam Houston', N'Parkway West', N'Houston', N'TX', '77086', N'USA', N'(281) 580-1800', N'(281) 885-5269', 29.940837860107422, -95.492240905761719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1176', N'ADESA Indianapolis', N'yes', N'2950 East Main Street', N'-', N'Plainfield', N'IN', '46168', N'USA', N'317-838-8000', N'317-838-7809', 39.724506378173828, -86.352607727050781)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1177', N'ADESA Jacksonville', N'yes', N'11700 New Kings Road', N'-', N'Jacksonville', N'FL', '32219', N'USA', N'(904) 764-1004', N'(904) 766-0406', 30.445795, -81.770812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1178', N'ADESA Knoxville', N'yes', N'1011 ADESA Parkway', N'-', N'Lenoir City', N'TN', '37771', N'USA', N'(865) 988-8000', N'(865) 988-5674', 35.821281433105469, -84.284736633300781)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1179', N'ADESA Lansing', N'yes', N'PO Box 359', N'6956 Lansing Road', N'Dimondale', N'MI', '48821', N'USA', N'517 322-2444', N'(517) 646-9160', 42.670719146728516, -84.660896301269531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1180', N'ADESA Lexington', N'yes', N'672 Blue Sky Parkway', N'-', N'Lexington', N'KY', '40509', N'USA', N'(859) 263-5163', N'(859) 263-5693', 37.959514617919922, -84.378890991210938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1181', N'ADESA Memphis', N'yes', N'5400 Getwell at Holmes Road', N'-', N'Memphis', N'TN', '38118', N'USA', N'(901) 365-6300', N'(901) 365-7716', 35.000778, -89.947647)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1183', N'ADESA Montreal', N'yes', N'300 Albert Mondou Boulevard', N'-', N'St-Eustache', N'QC', NULL, N'Canada', N'450-974-5746', N'-', 45.5473118, -73.9314186)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1184', N'ADESA New Jersey', N'yes', N'200 North Main St', NULL, N'Manville', N'NJ',' 8835', N'USA', N'(908) 725-2200', N'(908)725-3446', 40.54649, -74.58644)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1185', N'ADESA Ottawa', N'yes', N'1717 Burton Road', N'-', N'Vars', N'ON', NULL, N'Canada', N'(613) 443-4400', N'(613) 443-0523', 45.33391, -75.35299)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1186', N'ADESA Mercer', N'yes', N'758 Franklin Road', N'-', N'Mercer', N'PA', '16137', N'USA', N'(724) 662-4500', N'(724) 662-4513', 41.262695789337158, -80.178905948996544)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1187', N'ADESA Sacramento', N'yes', N'8649 Kiefer Boulevard', N'-', N'Sacramento', N'CA', '95826', N'USA', N'(916) 388-8899', N'(916) 388-0838', 38.547996520996094, -121.3841552734375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1188', N'ADESA San Antonio', N'yes', N'200 South Callaghan Road', N'-', N'San Antonio', N'TX', '78227', N'USA', N'210-434-4999', N'(210) 431-0645', 29.433109283447266, -98.592521667480469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1191', N'ADESA St. Louis', N'yes', N'7858 Highway 61-67', N'-', N'Barnhart', N'MO', '63012', N'USA', N'(636) 475-1320', N'(636) 479-7778', 38.319454193115234, -90.396072387695312)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1192', N'Iginite Portage', N'yes', N'W 10415 State Road 33', NULL, N'Portage', N'WI', '53901', NULL, N'(608) 742-8245', NULL, 43.51585, -89.518913)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1194', N'America`s Auto Auction - Greenville', N'yes', N'2415 Highway 101 South', N'-', N'Greer', N'SC', '29651', N'USA', N'(864) 801-1199', N'(864) 801-1085', 34.869384765625, -82.139106750488281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1196', N'ADESA Minneapolis', N'yes', N'18270 Territorial Road', N'P.O. Box 360', N'Dayton', N'MN', '55369', N'USA', N'(763) 428-8777', N'(763) 428-6906', 45.16407, -93.513366)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1197', N'Auto Auction of Montana', N'yes', N'4432 S Frontage Road', N'P.O. Box 1433', N'Billings', N'MT', '59101', N'USA', N'(406) 252-6332', N'(406) 252-8126', 45.749431, -108.527832)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1198', N'Houston`s 1st Choice Auto Auction', N'yes', N'825 Rankin Road', N'-', N'Houston', N'TX', '77073', N'USA', N'(281) 821-2300', N'(281)821-2977', 29.968757629394531, -95.397880554199219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1201', N'Auto Dealers Exchange - Indianapolis', N'yes', N'8635 Brookville Road', N'P O Box 39069', N'Indianapolis', N'IN', '46239', N'USA', N'(317) 352-0121', N'(317) 356-6597', 39.744422, -86.013336)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1202', N'ADESA Calgary', N'yes', N'1621 Veterans Blvd. NE', N'-', N'Airdrie', N'AB', NULL, N'Canada', N'403-912-4400', N'403-912-2018', 51.2986099, -113.98036)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1208', N'ADESA Des Moines', N'yes', N'1800 SE Gateway Drive', N'-', N'Grimes', N'IA', '50111', N'USA', N'(515) 986-1200', N'(515) 986-1260', 41.673925369977951, -93.7776754796505)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1209', N'Central Mass Auto Auction', N'yes', N'12 Industrial Park East', N'-', N'OXFORD', N'MA', NULL, N'USA', N'(508) 987-8396', N'(508) 987-6430', 42.087780833244324, -71.858730465173721)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1211', N'Mid-State Auto Auction', N'yes', N'310 Bach Avenue', N'PO Box 100', N'New York Mills', N'MN', '56567', N'USA', N'(218) 385-3777', N'(218) 385-3232', 46.522376909852028, -95.364027097821236)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1213', N'Auto Auction of New England', N'yes', N'8 Action Blvd', NULL, N'Londonderry', N'NH',' 3053', N'USA', N'603-437-5700', N'603-437-5858', 42.8720805004944, -71.337659320127)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1216', N'ADESA Concord', N'yes', N'77 HOSMER ST', NULL, N'ACTON', N'MA',' 1720', N'USA', N'(978) 263-7400', N'(978)263-7842', 42.4697093442174, -71.426227976053)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1225', N'Rochester-Syracuse Auto Auction, L.P.', N'yes', N'PO Box 129', N'1826 Route 414', N'Waterloo', N'NY', NULL, N'USA', N'(315) 539-5006', N'(315) 539-9508', 42.93634794652462, -76.8414144963026)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1227', N'ABC Detroit/Toledo', N'yes', N'9797 Fremont Pike', N'-', N'Perrysburg', N'OH', '43551', N'USA', N'(419) 872-0872', N'(419) 872-8617', 41.539768218994141, -83.582901000976562)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1228', N'ADESA Los Angeles', N'yes', N'11625 Nino Way', N'-', N'Mira Loma', N'CA', '91752', N'USA', N'951-361-9400', N'951-361-0595', 34.0059814453125, -117.53770446777344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1229', N'ADESA Ocala', N'yes', N'540 SW 38th Avenue', N'-', N'Ocala', N'FL', '34474', N'USA', N'352-351-5100', N'352-390-2023', 29.181507110595703, -82.188896179199219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1236', N'Indianapolis Car Exchange', N'yes', N'5161 South Indianapolis Road', N'Suite A', N'Whitestown', N'IN', '46075', N'USA', N'(317) 769-7777', N'(317) 769-7070', 39.96586, -86.37919)
GO
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1237', N'Greensboro Auto Auction', N'yes', N'3907 West Wendover Avenue', N'-', N'Greensboro', N'NC', '27407', N'USA', N'(336) 299-7777', N'(336) 854-2689', 36.059242248535156, -79.878158569335938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1238', N'ADESA Tulsa', N'yes', N'16015 East Admiral Place', N'-', N'Tulsa', N'OK', '74116', N'USA', N'(918) 437-9044', N'(918) 437-9027', 36.161464691162109, -95.798110961914062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1239', N'ADESA Nashville', N'yes', N'631 Burnett Road', N'-', N'Old Hickory', N'TN', '37188', N'USA', N'615-847-7400', N'(615) 847-0100', 36.281364440917969, -86.668220520019531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1240', N'ADESA Great Lakes', N'yes', N'573 South Tuscola Road', N'-', N'Bay City', N'MI', '48708', N'USA', N'(989) 891-9570', N'(989) 891-9575', 43.548130035400391, -83.828033447265625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1244', N'Mountain State Auto Auction', N'yes', N'5546 Benedum Drive', N'Interstate I-79, Exit 125', N'Shinnston', N'WV', '26431', N'USA', N'(304) 592-5300', N'(304) 592-2286', 39.35746, -80.21433)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1245', N'ADESA Washington D. C.', N'yes', N'43375 Old Ox Road', N'-', N'Dulles', N'VA', '20166', N'USA', N'(703) 996-1100', N'(703) 996-8812', 38.954814910888672, -77.501678466796875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1246', N'West Michigan Auto Auction LLC', N'yes', N'4758 Division Street', N'-', N'Wayland', N'MI', '49348', N'USA', N'(800) 577-2886', N'(616) 877-2040', 42.682098388671875, -85.643539428710938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1247', N'Norwalk Auto Auction', N'yes', N'12405 East Rosecrans Avenue', N'-', N'Norwalk', N'CA', '90650', N'USA', N'(562) 864-7464', N'(562) 863-6133', 33.902976, -118.068161)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1248', N'ADESA Reno', N'yes', N'6000 Echo Avenue', N'-', N'Reno', N'NV', '89506', N'USA', N'(775) 828-2437', N'(775) 828-2438', 39.653938293457031, -119.88975524902344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1249', N'Rea Family Auction dba Rea Brothers Mid South Auc', N'yes', N'1657 Old Whitfield Road', N'PO Box 97509', N'Pearl', N'MS', NULL, N'USA', N'(800) 261-2671', N'(601) 956-5603', 32.260036, -90.089126)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1250', N'America`s Auto Auction - Chicago', N'yes', N'14001 South Karlov Avenue', N'-', N'Crestwood', N'IL', '60445', N'USA', N'(708) 389-4488', N'(708) 389-4558', 41.640579, -87.720458)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1251', N'Quincy Auto Auction', N'yes', N'196 Ricciuti Drive', N'PO BOX 690535', N'Quincy', N'MA',' 2269', N'USA', N'(617) 773-5000', N'(617)-472-8204', 42.24024, -71.03837)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1252', N'ADESA Vancouver', N'yes', N'7111 No. 8 Road', N'-', N'Richmond', N'BC', NULL, N'Canada', N'604-232-4403; 800-822-9882', N'604-232-4461', 49.1634851, -123.0244085)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1257', N'Greater Rockford Auto Auction', N'yes', N'5937 Sandy Hollow Road', N'-', N'Rockford', N'IL', '61109', N'USA', N'(815) 874-7800', N'(815) 874-7009', 42.224202677607536, -88.999971225857735)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1259', N'Wisconsin State Auto Auction', N'yes', N'N11577 Industrial Drive', N'-', N'Lomira', N'WI', '53048', N'USA', N'(920) 269-1129', N'(920) 269-1116', 43.610122, -88.439537)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1260', N'Dealers Auto Auction of the Rockies', N'yes', N'7175 York Street', N'-', N'Denver', N'CO', NULL, N'USA', N'(303) 289-7716', N'(303) 289-8653', 39.826099395751953, -104.96135711669922)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1261', N'Long Beach Auto Auction', N'yes', N'8494 County Farm Road', N'PO Box 958', N'Long Beach', N'MS', NULL, N'USA', N'(228) 452-2030', N'(228) 452-9588', 30.411161422729492, -89.188774108886719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1263', N'Missouri Auto Auction', N'yes', N'421 N. Rangeline Road', N'-', N'Columbia', N'MO', '65201', N'USA', N'(573) 886-0032', N'-', 38.95330810546875, -92.2060775756836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1264', N'Expressway Auto Auction', N'yes', N'10010 Main Street', N'-', N'Dansville', N'NY', '14437', N'USA', N'(585) 335-6071', N'(585) 335-3486', 42.545829, -77.680656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1265', N'Oak View Auto Auction', N'yes', N'13451 Florida Blvd', N'-', N'Baton Rouge', N'LA', '70815', N'USA', N'(225) 272-5139', N'(225) 272-5314', 30.463291, -91.036132)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1266', N'Auction Training Demo', N'yes', N'50 Glenlake Pkwy', N'-', N'Atlanta', N'GA', '30328', N'-', N'678.597.3900', N'-', 33.940643310546875, -84.3619384765625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1268', N'Lubbock Auto Auction', N'yes', N'1122 E. 34th Street', N'-', N'Lubbock', N'TX', '79404', N'USA', N'(806) 744-1444', N'(806) 763-1214', 33.563343062996864, -101.82234384119511)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1270', N'Carriage Trade Auto Auction', N'yes', N'1200 Ridge Pike', N'-', N'Conshohocken', N'PA', '19428', N'USA', N'215-CAR-SALE', N'(610) 834-8274', 40.103263854980469, -75.306343078613281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1271', N'Alliance Auto Auction of Abilene', N'yes', N'6657 Highway 80 West', N'-', N'Abilene', N'TX', '79605', N'USA', N'(325) 698-4391', N'(325) 691-0263', 32.453262329101562, -99.813980102539062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1272', N'Capital City Auto Auction', N'yes', N'600 Winfield Rd', N'-', N'St. Albans', N'WV', '25177', N'USA', N'(304) 201-2270', N'(304)201-2284', 38.398265540599823, -81.855732500553131)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1273', N'Greater Cleveland Auto Auction', N'yes', N'5801 Engle Road', N'-', N'Cleveland', N'OH', '44142', N'USA', N'(800) 929-4222 x 201', N'(216) 676-4200', 41.405735, -81.819145)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1274', N'America`s Auto Auction - Pensacola, Inc', N'yes', N'6615 Mobile Highway', N'-', N'Pensacola', N'FL', NULL, N'USA', N'(850) 944-1945', N'(850) 944-8482', 30.472261428833008, -87.312828063964844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1275', N'Charleston Auto Auction-SC', N'yes', N'651 Precast Lane', N'-', N'Monck`s Corner', N'SC', '29461', N'USA', N'(843) 719-1900', N'(843) 719-1909', 33.102447688579559, -80.073434114456177)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1276', N'ADESA Long Island', N'yes', N'425 Patchogue Yaphank Road', N'-', N'Yaphank', N'NY', '11980', N'USA', N'(631) 205-5000', N'(631) 205-5508', 40.816108703613281, -72.946075439453125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1277', N'Ocean State Auto Auction', N'yes', N'10 Industrial Drive', NULL, N'Exeter', N'RI',' 2822', N'USA', N'(401) 397-2801', N'(401) 397-2474', 41.57091, -71.65622)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1280', N'ADESA East Tennessee', N'yes', N'195 Joe McCrary Road', N'PO Box 247', N'Fall Branch', N'TN', NULL, N'USA', N'(423) 348-8419', N'(423) 348-5117', 36.417530059814453, -82.622726440429688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1281', N'AAAG-MI, LLC dba Grand Rapids Auto Auction', N'yes', N'2380 Port Sheldon Court', N'-', N'Jenison', N'MI', '49428', N'USA', N'(616) 669-1050', N'(616) 669-5522', 42.884521, -85.84037)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1282', N'Akron Auto Auction', N'yes', N'2471 Ley Drive', N'-', N'Akron', N'OH', '44319', N'USA', N'3304365818', N'(330) 773-3921', 41.025070190429688, -81.538497924804688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1283', N'North East Pennsylvania Auto Auction', N'yes', N'860 North Keyser Avenue', N'-', N'Scranton', N'PA', '18504', N'USA', N'(570) 207-2277', N'(570) 558-0959', 41.432004868984222, -75.688910186290741)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1284', N'Clarksville Auto Auction', N'yes', N'247 Needmore Road', N'PO Box 30485', N'Clarksville', N'TN', NULL, N'USA', N'800-969-4920', N'931-645-3973', 36.584419, -87.302772)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1289', N'North Bay Auto Auction', N'yes', N'250 Dittmer Road', N'-', N'Fairfield', N'CA', '94534', N'USA', N'707-646-7178', N'707-864-2518', 38.210624, -122.141021)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1290', N'Louisiana`s 1st Choice Auto Auction', N'yes', N'18310 Woodscale Road', N'-', N'Hammond', N'LA', '70401', N'USA', N'(985) 345-3302', N'(985) 345-5735', 30.517592802643776, -90.431617051362991)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1291', N'Dealer Direct', N'yes', N'1620 S. Stapley Drive', N'Ste. 232', N'Mesa', N'AZ', '85204', N'USA', N'877-522-3372', N'866-924-9420', 33.384059906005859, -111.80847930908203)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1292', N'Orlando Longwood Auto Auction', N'yes', N'2800 N Highway 17-92', N'-', N'Longwood', N'FL', '32750', N'USA', N'(407)324-3339', N'(321)275-0028', 28.725849151611328, -81.316215515136719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1293', N'Dealers Auto Auction of Idaho', N'yes', N'3323 Port Street', N'-', N'Nampa', N'ID', '83687', N'USA', N'(208) 463-8250', N'(208) 463-7617', 43.5809440612793, -116.52721405029297)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1294', N'ABC Bowling Green', N'yes', N'555 Bluegrass Farms Blvd', N'-', N'Bowling Green', N'KY', '42104', N'USA', N'270-781-2422', N'270-781-5361', 36.926612854003906, -86.4209213256836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1295', N'ABC Birmingham', N'yes', N'1046 A E Moore Rd', N'-', N'Moody', N'AL', '35004', N'USA', N'205 640-4040', N'205 640-3071', 33.566371947526932, -86.52554489672184)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1296', N'ADESA Orlando', N'yes', N'2851 Saint Johns Parkway', N'-', N'Sanford', N'FL', '32771', N'USA', N'407-328-7300', N'407-936-1326', 28.803495407104492, -81.300033569335938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1297', N'Dixie Auto Auction', N'yes', N'15673 Highway 8W', N'-', N'Grenada', N'MS', '38901', N'USA', N'6622265637', N'662-227-9060', 33.768337249755859, -89.7842025756836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1298', N'Oklahoma Auto Exchange', N'yes', N'2728 SW 25th Street', N'-', N'Oklahoma City', N'OK', '73108', N'USA', N'(405) 680-8660', N'(405) 680-9020', 35.438217163085938, -97.562744140625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1299', N'Lone Star Auto Auction', N'yes', N'2706 Slaton Highway', N'-', N'Lubbock', N'TX', '79404', N'USA', N'888-299-6606', N'806-745-9280', 33.525558471679688, -101.80677795410156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1300', N'America`s Auto Auction - Atlanta', N'yes', N'444 Joe Frank Harris Parkway', N'-', N'Cartersville', N'GA', '30120', N'USA', N'(770) 382-1010', N'-', 34.146915435791016, -84.746078491210938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1301', N'Greater Erie Auto Auction', N'yes', N'7700 Avonia Road', N'PO Box 916', N'Fairview', N'PA', '16415', N'USA', N'(814) 474-3900', N'(814) 474-4969', 42.005489, -80.242523)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1303', N'CNY Auto Auction', N'yes', N'3181 US Route 11', N'POB 527', N'Lafayette', N'NY', NULL, N'USA', N'315-677-5201', N'315-677-9321', 42.925071, -76.121139)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1304', N'Plaza Auto Auction', N'yes', N'320 Highway 30 West', N'PO Box 147', N'Mt Vernon', N'IA', NULL, N'USA', N'319-895-6232', N'319-895-6727', 41.917129516601562, -91.4477310180664)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1305', N'America`s Auto Auction - Jacksonville', N'yes', N'11982 New Kings Rd', N'-', N'Jacksonville', N'FL', '32219', N'USA', N'904-764-7653', N'904-764-9528', 30.451816558837891, -81.771957397460938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1307', N'Hartford Springfield Auction Co-op LLC', N'yes', N'49 Russell Road', N'PO box 1380', N'East Granby', N'CT', NULL, N'USA', N'860-784-1950', N'860-784-1952', 41.994888, -72.805877)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1308', N'Deanco Auto Auction of Dothan', N'yes', N'3664 South Oates Street', N'-', N'Dothan', N'AL', '36301', N'USA', N'334-792-1116', N'334-792-1575', 31.16566276550293, -85.404975891113281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1310', N'Metro Phoenix Auto Auction', N'yes', N'2475 S. 59th Avenue', N'-', N'Phoenix', N'AZ', '85043', N'USA', N'602-279-9500', N'-', 33.426116943359375, -112.18428802490234)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1311', N'KASP', N'yes', N'5921 Athens Boonesboro Rd', N'-', N'Lexington', N'KY', '40509', N'USA', N'859-263-2129', N'859-263-9564', 37.957950592041016, -84.374862670898438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1312', N'Abingdon Auto Auction', N'yes', N'20216 Auction Drive', N'-', N'Bristol', N'VA', '24202', N'USA', N'276-644-1684', N'276-644-9594', 36.65892206132412, -82.073769271373749)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1313', N'Augusta Auto Auction', N'yes', N'1200 E. Buena Vista Drive', N'-', N'North Augusta', N'SC', '29841', N'USA', N'803-279-3234', N'803-279-7191', 33.482070922851562, -81.9466781616211)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1316', N'Lincoln Auto Auction', N'yes', N'11909 US Hwy 6', N'-', N'Waverly', N'NE', '68462', N'USA', N'402-475-5500; 800-830-3191', N'402-475-5508', 40.8974494934082, -96.561065673828125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1317', N'Greenville Auto Auction, Inc.', N'yes', N'4330 Dickinson Ave', N'-', N'Greenville', N'NC', '27834', N'USA', N'252-355-4111', N'252-355-2011', 35.576801300048828, -77.438911437988281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1318', N'Insurance Auto Auctions Austin', N'yes', N'2191 Highway 21 W', N'-', N'Dale', N'TX', '78616', N'USA', N'512-321-8075', N'512-321-8303', 30.068012326955795, -97.581063956022263)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1319', N'Insurance Auto AuctionsNational Remarketing Center', N'yes', N'69 Hinckley Road', NULL, N'Clinton', N'ME',' 4927', N'USA', N'888-839-4220', N'207-426-9034', 44.63813, -69.51607)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1320', N'Insurance Auto Auctions Central NJ', N'yes', N'426 Texas Road', NULL, N'Morganville', N'NJ',' 7751', N'USA', N'732-591-8173', N'732-591-8393', 40.374846, -74.271223)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1321', N'Insurance Auto Auctions Dallas/Ft.Worth', N'yes', N'4226 E. Main St', N'-', N'Grand Prairie', N'TX', '75050', N'USA', N'972-522-5000', N'-', 32.749955132603645, -96.936435252428055)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1322', N'Insurance Auto Auctions Dallas', N'yes', N'204 MArs Road', N'-', N'Wilmer', N'TX', '75172', N'USA', N'972-525-6401', N'972-525-6403', 32.579318359494209, -96.670941486954689)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1323', N'Insurance Auto Auctions Denver', N'yes', N'409 W 66th Avenue', N'-', N'Denver', N'CO', '80221', N'USA', N'303-428-3024', N'303-428-3502', 39.816384986042976, -104.98972423374653)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1324', N'Insurance Auto Auctions Fontana', N'yes', N'13901 San Bernardino Avenue', N'-', N'Fontana', N'CA', '92335', N'USA', N'909-355-9400', N'909-822-9311', 34.075832366943359, -117.49990081787109)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1325', N'Insurance Auto Auctions Fremont', N'yes', N'6700 Stevenson Blvd', N'-', N'Fremont', N'CA', '94538', N'USA', N'510-668-1665', N'510-668-0106', 37.506160736083984, -121.99204254150391)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1326', N'Insurance Auto Auctions Houston', N'yes', N'2535 W Mt Houston Rd', N'-', N'Houston', N'TX', '77038', N'USA', N'281-847-4700', N'281-847-4799', 29.89448356628418, -95.4505615234375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1327', N'Insurance Auto Auctions Houston-North', N'yes', N'16602 E HArdy', N'-', N'Houston', N'TX', '77032', N'USA', N'281-443-1300', N'281-443-4433', 29.958946, -95.384483)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1328', N'Insurance Auto Auctions Kansas City', N'yes', N'2663 S 88th Street', N'-', N'Kansas City', N'KS', '66111', N'USA', N'913-422-9303', N'913-422-7421', 39.054969787597656, -94.778114318847656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1329', N'Insurance Auto Auctions Miami-North', N'yes', N'5901 205th Ave', N'-', N'Pembroke Pine', N'FL', '33332', N'USA', N'954-680-4370', N'954-680-4372', 26.047386, -80.422698)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1330', N'Insurance Auto Auctions Milwaukee', N'yes', N'N70 W26277 Indian Grass Lane', N'-', N'Sussex', N'WI', '53089', N'USA', N'262-246-8822', N'262-246-4411', 43.129592895507812, -88.209281921386719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1331', N'Insurance Auto Auctions No. Hollywood', N'yes', N'7245 Laurel Canyon Blvd', N'-', N'North Hollywood', N'CA', '91605', N'USA', N'818-487-2222', N'818-487-2402', 37.878952026367188, -122.27028656005859)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1332', N'Insurance Auto Auctions Northern NJ', N'yes', N'700 Federal Blvd', NULL, N'Carteret', N'NJ',' 7008', N'USA', N'732-634-5601', N'732-602-0259', 40.58381, -74.24725)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1333', N'Insurance Auto Auctions Orlando', N'yes', N'151 Taft Vineland Road', N'-', N'Orlando', N'FL', '32824', N'USA', N'407-438-7191', N'407-816-4294', 28.422496795654297, -81.378402709960938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1334', N'Insurance Auto Auctions Phoenix', N'yes', N'2299 W Broadway Road', N'-', N'Phoenix', N'AZ', '85041', N'USA', N'602-305-5300', N'602-268-5242', 33.403514, -112.10588)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1335', N'Insurance Auto Auctions Portland', N'yes', N'4415 NE 158th Avenue', N'-', N'Portland', N'OR', '97230', N'USA', N'503-253-1500', N'503-253-9359', 45.557243347167969, -122.50673675537109)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1336', N'Insurance Auto Auctions San Antonio-South.', N'yes', N'11275 South Zarzamora', N'-', N'San Antonio', N'TX', '78224', N'USA', N'210-628-6770', N'210-628-6778', 29.308429718017578, -98.537345886230469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1337', N'Insurance Auto Auctions San Diego', N'yes', N'2380 Britannia Blvd', N'-', N'San Diego', N'CA', '92154', N'USA', N'619-710-2876', N'619-710-2878', 32.554939761757851, -116.97998709976673)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1338', N'Insurance Auto Auctions Seattle', N'yes', N'8801 E Marginal Way S', N'-', N'Tukwila', N'WA', '98108', N'USA', N'206-658-6900', N'206-658-6990', 47.521995544433594, -122.30352020263672)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1339', N'ADESA PA', N'yes', N'30 Industrial Road', N'-', N'York', N'PA', '17406', N'USA', N'(717) 266-7627', N'(717) 266-7600', 40.084841921925545, -76.764396876096725)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1340', N'ADESA Kitchener', N'yes', N'55 Waydom Drive', N'RR # 1, Wayadom Drive', N'Ayr', N'ON', NULL, N'Canada', N'519-622-9500; 800-661-2598', N'519-621-2361', 43.33489, -80.4458)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1341', N'ADESA Raleigh', N'yes', N'30 Sadisco Highway', N'-', N'Clayton', N'NC', '27520', N'USA', N'919-550-4092', N'919-262-0399', 35.592078119516373, -78.4067764878273)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1343', N'South Bend Mishawaka Auto Auction', N'yes', N'55920 Maplehurst Ave', N'-', N'Mishawaka', N'IN', '46545', N'USA', N'574-256-5625', N'574-256-5655', 41.682529449462891, -86.16448974609375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1344', N'ADESA St. John`s', N'yes', N'80- Clyde Ave', N'P.O. Box 13157', N'Mount Pearl', N'NL', NULL, N'Canada', N'709-364-3250; 877-364-3250', N'709-364-3251', 47.5221487, -52.8393149)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1348', N'Dealers Auto Auction of Huntsville', N'yes', N'26125 US Highway 72', N'-', N'Athens', N'AL', '35613', N'USA', N'256-232-0201', N'-', 34.7647819519043, -86.8624496459961)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1349', N'Farmington Auto Auction', N'yes', N'1661 W Murray Dr.', N'-', N'Farmington', N'NM', '87401', N'USA', N'505-326-1005', N'505-326-1007', 36.729221343994141, -108.23280334472656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1350', N'South Bay Auto Auction', N'yes', N'13210 S. Normandie Ave', N'-', N'Gardena', N'CA', '90249', N'USA', N'310-719-2000', N'310-243-1240', 33.912113189697266, -118.29947662353516)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1351', N'Albany Auto Auction', N'yes', N'1421 Liberty Exp SE', N'P O BOX 1622', N'Albany', N'GA', '31702', N'USA', N'229-435-7708', N'229-888-8035', 31.556060791015625, -84.1151123046875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1352', N'Dealers Auto Auction of Memphis', N'yes', N'2560 RENTAL RD', N'-', N'MEMPHIS', N'TN', '38118', N'USA', N'901-480-4250', N'800-915-9985', 35.069428905844688, -89.978604689240456)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1353', N'Loveland Auto Auction', N'yes', N'4660 Chapman Road', N'-', N'Loveland', N'CO', '80534', N'USA', N'970-669-4994', N'-', 40.392749786376953, -105.07392120361328)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1354', N'Insurance Auto Auctions Albany', N'yes', N'1210 Kings Road', N'-', N'Schenectady', N'NY', '12303', N'USA', N'(518) 347-3810', N'(518) 346-0351', 42.741920471191406, -73.8863296508789)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1355', N'Insurance Auto Auctions Albuquerque', N'yes', N'4400 Broadway Blvd SE', N'-', N'Albuquerque', N'NM', '87105', N'USA', N'(505) 873-2081', N'(505) 873-3029', 35.01267671585083, -106.64868660271168)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1356', N'Insurance Auto Auctions Appleton', N'yes', N'2591 S Casaloma Drive', N'-', N'Appleton', N'WI', '54914', N'USA', N'(920) 734-1446', N'(920) 734-3603', 44.240116119384766, -88.474288940429688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1357', N'Insurance Auto Auctions Atlanta-South', N'yes', N'1930 Rex Road', N'-', N'Lake City', N'GA', '30260', N'USA', N'(404) 366-2298', N'(404) 366-1011', 33.600720316171646, -84.326421171426773)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1358', N'Insurance Auto Auctions Baltimore', N'yes', N'3131 Hawkins Point Rd', N'-', N'Baltimore', N'MD', '21226', N'USA', N'(410) 354-3344', N'(410) 354-1340', 39.202829003334045, -76.558717712759972)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1359', N'Insurance Auto Auctions Baton Rouge', N'yes', N'29000 S Frost Rd', N'-', N'Livingston', N'LA', '70754', N'USA', N'(225) 686-9197', N'(225) 686-8197', 30.477354973554611, -90.74805736541748)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1360', N'Insurance Auto Auctions Birmingham', N'yes', N'1600 Highway 150', N'-', N'Birmingham', N'AL', '35022', N'USA', N'(205) 426-2300', N'(205) 428-5332', 33.355018615722656, -86.841072082519531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1361', N'Insurance Auto Auctions Boise', N'yes', N'3707 E. Linden St', N'-', N'Caldwell', N'ID', '83605', N'USA', N'(208) 455-1642', N'(208) 455-1622', 43.649692535400391, -116.65222930908203)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1362', N'Insurance Auto Auctions Boston Shirley', N'yes', N'2 Going Rd', NULL, N'Shirley', N'MA',' 1464', N'USA', N'978-425-0990', N'-', 42.58543, -71.664)
GO
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1363', N'Insurance Auto Auctions Buffalo', N'yes', N'366 Vulcan Street', N'-', N'Buffalo', N'NY', '14204', N'USA', N'(716) 874-9890', N'(716) 874-9605', 42.963603213429451, -78.902724981307983)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1364', N'Insurance Auto Auctions Burlington', N'yes', N'304 Colchester Road', NULL, N'Essex', N'VT',' 5451', N'USA', N'(802) 872-7838', N'(802) 878-8353', 44.52666, -73.12947)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1365', N'Insurance Auto Auctions Miami', N'yes', N'12700 NW 42nd Avenue', N'-', N'Opa Locka', N'FL', '33054', N'USA', N'(800) 526-8402', N'(305) 685-9215', 25.88776969909668, -80.269500732421875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1366', N'Insurance Auto Auctions Charleston', N'yes', N'430 Tannenbaum Rd', N'-', N'Ravenel', N'SC', '29470', N'USA', N'(843) 556-7620', N'(843) 571-3006', 32.8443603515625, -80.2373275756836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1367', N'Insurance Auto Auctions Charlotte', N'yes', N'1710 Starita Rd', N'-', N'Charlotte', N'NC', '28206', N'USA', N'(704) 596-5854', N'(704) 596-7492', 35.271232604980469, -80.817390441894531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1368', N'Insurance Auto Auctions Chicago North', N'yes', N'605 Healy Road', N'-', N'East Dundee', N'IL', '60118', N'USA', N'847.426.5913', N'847.426.8595', 42.085151672363281, -88.235099792480469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1369', N'Insurance Auto Auctions Chicago South', N'yes', N'16425 S Crawford Ave', N'-', N'Markham', N'IL', '60426', N'USA', N'708-333-5700', N'(708) 333-5756', 41.590564, -87.71257)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1370', N'Insurance Auto Auctions Chicago West', N'yes', N'280 E Sullivan Road', N'-', N'Aurora', N'IL', '60504', N'USA', N'(630) 896-5300', N'(630) 896-5699', 41.790313720703125, -88.307540893554688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1371', N'Insurance Auto Auctions Clearwater', N'yes', N'5152 126 Avenue North', N'-', N'Clearwater', N'FL', '33760', N'USA', N'(727) 572-4050', N'(727) 572-4065', 27.884408950805664, -82.7034912109375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1373', N'Insurance Auto Auctions Cleveland', N'yes', N'7437 Deer Trail Lane', N'-', N'Lorain', N'OH', '44053', N'USA', N'(877) 917-6877', N'(440) 960-1093', 41.411849975585938, -82.277008056640625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1374', N'Insurance Auto Auctions Greenville', N'yes', N'422 Scuffletown Rd', N'-', N'Simpsonville', N'SC', '29681', N'USA', N'(864) 242-3093', N'(864) 271-6510', 34.7992218285799, -82.222437411546707)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1375', N'Insurance Auto Auctions Concord', N'yes', N'5100 Merle Road', N'-', N'Concord', N'NC', '28025', N'USA', N'(704) 788-4421', N'(704) 784-2414', 35.465682983398438, -80.493293762207031)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1376', N'Insurance Auto Auctions Corpus Christi', N'yes', N'4701 Agnes St', N'-', N'Corpus Christi', N'TX', '78405', N'USA', N'(361) 881-9555', N'(361) 887-8880', 27.783945083618164, -97.44915771484375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1377', N'Insurance Auto Auctions Detroit', N'yes', N'8251 Rawsonville Road', N'-', N'Belleville', N'MI', '48111', N'USA', N'(734) 461-9441', N'(734) 461-9419', 42.172046661376953, -83.5377197265625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1378', N'Insurance Auto Auctions East Bay', N'yes', N'2780 Willow Pass Road', N'-', N'Bay Point', N'CA', '94565', N'USA', N'(925) 458-7610', N'(925) 458-7615', 38.032478, -121.944656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1379', N'Insurance Auto Auctions Erie', N'yes', N'261 Hamilton Road', N'-', N'Garland', N'PA', '16416', N'USA', N'(814) 563-3113', N'(814) 563-4921', 41.817504, -79.454986)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1380', N'Insurance Auto Auctions Eugene', N'yes', N'1000 Bethel Drive', N'-', N'Eugene', N'OR', '97402', N'USA', N'(541) 689-4000', N'(541) 689-0083', 44.071796417236328, -123.14012145996094)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1381', N'Insurance Auto Auctions Fargo', N'yes', N'1650 E. Main Ave.', N'-', N'West Fargo', N'ND', '58078', N'USA', N'(701) 492-4501', N'(701) 492-2950', 46.877986907958984, -96.872528076171875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1382', N'Insurance Auto Auctions Grand Rapids', N'yes', N'700 100th Street SW', N'-', N'Byron Center', N'MI', '49315', N'USA', N'(616) 877-1000', N'(616) 877-0300', 42.7826613932848, -85.680529028177261)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1383', N'Insurance Auto Auctions Greensboro', N'yes', N'171 Carden Road', N'-', N'Graham', N'NC', '27253', N'USA', N'(336) 226-4224', N'(336) 226-4254', 36.007419586181641, -79.38751220703125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1384', N'Insurance Auto Auctions Lincoln', N'yes', N'301 Madigan Dr', N'-', N'Lincoln', N'IL', '62656', N'USA', N'(217) 732-8555', N'(217) 732-7555', 40.154411718249321, -89.408243000507355)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1385', N'Insurance Auto Auctions Hartford', N'yes', N'47 Newberry Road', NULL, N'East Windsor', N'CT',' 6088', N'USA', N'(860) 623-9760', N'(860) 623-3873', 41.91915, -72.60241)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1386', N'Insurance Auto Auctions Hartford-South', N'yes', N'1462 Saybrook Rd.', NULL, N'Middletown', N'CT',' 6457', N'USA', N'(860) 854-6761', N'(860) 347-6236', 41.52144, -72.60226)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1387', N'Insurance Auto Auctions Honolulu', N'yes', N'91-445A Komohana St', N'-', N'Kapolei', N'HI', '96707', N'USA', N'(808) 682-2858', N'(808) 682-3988', 21.334220886230469, -158.08192443847656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1388', N'Insurance Auto Auctions Indianapolis', N'yes', N'3302 S. Harding Street', N'-', N'Indianapolis', N'IN', '46217', N'USA', N'(317) 787-3202', N'(317)783-0586', 39.715614318847656, -86.19580078125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1389', N'Insurance Auto Auctions Jackson', N'yes', N'100 Beasley Rd', N'-', N'Jackson', N'MS', '39206', N'USA', N'(601) 956-2787', N'(601) 957-8814', 32.385799661278725, -90.15824094414711)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1390', N'Insurance Auto Auctions Jacksonville', N'yes', N'14492 New Kings Rd', N'-', N'Jacksonville', N'FL', '32219', N'USA', N'(904) 768-6500', N'(904) 768-6499', 30.496864318847656, -81.7900390625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1391', N'Insurance Auto Auctions Knoxville', N'yes', N'3634 E. Gov. John Seveir Hwy.', N'-', N'Knoxville', N'TN', '37914', N'USA', N'(865) 525-7349', N'(865) 522-8813', 35.980083465576172, -83.799667358398438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1392', N'Insurance Auto Auctions Las Vegas', N'yes', N'1239 North Boulder Hwy Ste 900', N'-', N'Henderson', N'NV', '89011', N'USA', N'(702) 564-6553', N'(702) 565-8795', 36.052108, -114.998924)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1393', N'Insurance Auto Auctions Laurel', N'yes', N'7131 Virginia Manor Ct', N'-', N'Laurel', N'MD', '20707', N'USA', N'(301) 419-2865', N'(301) 470-7079', 39.078060150146484, -76.882858276367188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1395', N'Insurance Auto Auctions Little Rock', N'yes', N'4900 S Kerr Rd', N'-', N'Scott', N'AR', '72142', N'USA', N'(501) 961-2886', N'(501) 961-1805', 34.794122949242592, -92.0589280128479)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1396', N'Insurance Auto Auctions Long Island', N'yes', N'66 Peconic Avenue', N'-', N'Medford', N'NY', '11763', N'USA', N'(631) 207-3477', N'(631) 207-3386', 40.816429138183594, -72.973251342773438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1397', N'Insurance Auto Auctions Manchester', N'yes', N'75 Lowell Road', NULL, N'Salem', N'NH',' 3079', N'USA', N'(603) 893-2300', N'(603) 898-3870', 42.76327, -71.24803)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1398', N'Insurance Auto Auctions Memphis', N'yes', N'5400 Getwell Rd.', N'-', N'Memphis', N'TN', '38118', N'USA', N'(901) 794-9901', N'(901) 794-9914', 35.000213623046875, -89.933708190917969)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1399', N'Insurance Auto Auctions Metro DC', N'yes', N'14149 Brandywine Rd', N'-', N'Brandywine', N'MD', '20613', N'USA', N'(301) 372-8876', N'(301) 372-8285', 38.694995880126953, -76.846763610839844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1400', N'Insurance Auto Auctions Minneapolis/St. Paul', N'yes', N'1280 Jackson Street', N'-', N'St. Paul', N'MN', '55117', N'USA', N'(651) 488-0581', N'(651) 488-3644', 44.978603363037109, -93.094512939453125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1401', N'Insurance Auto Auctions Missoula', N'yes', N'10131 Garrymore Lane', N'-', N'Missoula', N'MT', '59802', N'USA', N'(406) 542-3442', N'(406) 549-8933', 46.939884185791016, -114.13915252685547)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1402', N'Insurance Auto Auctions Nashville', N'yes', N'3896 Stewarts Lane', N'-', N'Nashville', N'TN', '37218', N'USA', N'(615) 742-0006', N'(615) 726-4008', 36.196334838867188, -86.857330322265625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1403', N'Insurance Auto Auctions Newburgh', N'yes', N'39 Stone Castle Road', N'-', N'Rock Tavern', N'NY', '12575', N'USA', N'(845) 567-6360', N'(845) 567-6366', 41.538295745849609, -74.136299133300781)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1404', N'Insurance Auto Auctions North Virginia', N'yes', N'15 Le Way Drive', N'-', N'Fredericksburg', N'VA', '22406', N'USA', N'(540) 373-7800', N'(540) 371-4123', 38.351856231689453, -77.514091491699219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1405', N'Insurance Auto Auctions Oklahoma City', N'yes', N'5555 SW 44th St', N'-', N'Oklahoma City', N'OK', '73179', N'USA', N'(405) 680-9211', N'(405) 680-9204', 35.421859741210938, -97.611625671386719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1406', N'Insurance Auto Auctions Omaha', N'yes', N'14749 Meredythe Plaza', N'-', N'Springfield', N'NE', '68059', N'USA', N'(402) 733-2424', N'(402) 733-0483', 41.064769744873047, -96.160400390625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1407', N'Insurance Auto Auctions Orlando-North', N'yes', N'2500 ADESA Drive', N'-', N'Sanford', N'FL', '32773', N'USA', N'(407) 323-4090', N'(407) 323-4557', 28.784786224365234, -81.216400146484375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1408', N'Insurance Auto Auctions Pensacola', N'yes', N'11221 Highway 90 East', N'-', N'Milton', N'FL', '32583', N'USA', N'(850) 623-2993', N'(850) 626-7973', 30.596855163574219, -86.9754867553711)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1409', N'Insurance Auto Auctions Philadelphia', N'yes', N'100 Industrial Way', N'-', N'Conshohocken', N'PA', '19428', N'USA', N'(610) 277-0894', N'(610) 277-9276', 40.102576017379761, -75.308788865804672)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1410', N'Insurance Auto Auctions Pittsburgh-North', N'yes', N'49 Bairdford Road', N'-', N'Gibsonia', N'PA', '15044', N'USA', N'(724) 443-7881', N'(724) 443-7888', 40.650802612304688, -79.895378112792969)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1411', N'Insurance Auto Auctions Pulaski', N'yes', N'1250 E Main St', N'-', N'Pulaski', N'VA', '24301', N'USA', N'(540) 994-6490', N'(540) 994-6495', 37.045253753662109, -80.761344909667969)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1412', N'Insurance Auto Auctions Raleigh', N'yes', N'60 Sadisco Road', N'-', N'Clayton', N'NC', '27520', N'USA', N'(919) 553-6148', N'(919) 553-2857', 35.589534759521484, -78.399421691894531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1413', N'Insurance Auto Auctions Richmond', N'yes', N'10390 Sadisco Drive', N'-', N'Ashland', N'VA', '23005', N'USA', N'(804) 798-6091', N'(804) 798-9327', 37.720127105712891, -77.465118408203125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1414', N'Insurance Auto Auctions Rochester', N'yes', N'522 Trolley Blvd', N'-', N'Rochester', N'NY', '14606', N'USA', N'(585) 426-5420', N'(585) 426-5413', 43.173114776611328, -77.685264587402344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1415', N'Insurance Auto Auctions Sacramento', N'yes', N'11499 Dougals Road', N'-', N'Rancho Cordova', N'CA', '95742', N'USA', N'(916) 635-4271', N'(916) 635-1637', 38.560012817382812, -121.25255584716797)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1416', N'Insurance Auto Auctions Salt Lake City', N'yes', N'1800 South 1100 West', N'-', N'West Haven', N'UT', '84401', N'USA', N'(801) 399-2818', N'(801) 393-2325', 41.233524084091187, -112.00638704001904)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1417', N'Insurance Auto Auctions Southern NJ', N'yes', N'250 Blackwood Barnsboro Rd', NULL, N'Turnersville', N'NJ',' 8012', N'USA', N'(856) 227-8760', N'(856) 227-8943', 39.7889053497052, -75.0880893522219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1418', N'Insurance Auto Auctions Scranton', N'yes', N'103 Thompson Street', N'-', N'Pittston', N'PA', '18640', N'USA', N'(570) 654-1709', N'(570) 654-5010', 41.3089714050293, -75.805419921875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1419', N'Insurance Auto Auctions Spokane', N'yes', N'8018 W. Sunset Hgwy', N'-', N'Spokane', N'WA', '99224', N'USA', N'(509) 458-3244', N'(509) 458-4112', 47.643168121576309, -117.52401888370514)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1420', N'Insurance Auto Auctions St. Louis', N'yes', N'4460 Highway 162', N'-', N'Granite City', N'IL', '62040', N'USA', N'(618) 797-0200', N'(618) 797-0001', 38.726328536868095, -90.057689622044563)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1421', N'Insurance Auto Auctions Syracuse', N'yes', N'8459 Brewerton Road', N'-', N'Cicero', N'NY', '13039', N'USA', N'(315) 699-2622', N'(315) 699-5481', 43.181224912405014, -76.121611520648)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1422', N'Insurance Auto Auctions Tampa', N'yes', N'1208 17th Street East', N'-', N'Palmetto', N'FL', '34221', N'USA', N'(941) 729-9393', N'(941) 723-3934', 27.529575347900391, -82.551597595214844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1423', N'Insurance Auto Auctions Taunton', N'yes', N'580 Myricks Street', NULL, N'East Taunton', N'MA',' 2718', N'USA', N'(508) 823-7440', N'(508) 822-7938', 41.8494203820286, -70.9917747126342)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1424', N'Insurance Auto Auctions Wilmington', N'yes', N'415 Madeline Trask Dr', N'-', N'Castle Hayne', N'NC', '28429', N'USA', N'(910) 675-2311', N'(910) 675-1619', 34.330131530761719, -77.905731201171875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1427', N'Copart Sacramento', N'yes', N'8600 Morrison Creek Dr', N'-', N'Sacramento', N'CA', '95828', N'USA', N'916-381-3999', N'916 381 4159', 38.505634307861328, -121.38424682617188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1428', N'Copart Fresno', N'yes', N'1255 East Central', N'-', N'Fresno', N'CA', '93725', N'USA', N'559-266-6400', N'559 266 5202', 36.676010131835938, -119.76742553710938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1429', N'Copart Bakersfield', N'yes', N'2216 Coy Avenue', N'-', N'Bakersfield', N'CA', '93307', N'USA', N'661-834-2556', N'661 834 1563', 35.322261810302734, -119.00022888183594)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1430', N'Copart Portland', N'yes', N'6900 N.E. Cornfoot Drive', N'-', N'Portland', N'OR', '97218', N'USA', N'503-281-0848', N'503 281 2019', 45.573764801025391, -122.59199523925781)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1431', N'Copart Houston', N'yes', N'1655 Rankin Road', N'-', N'Houston', N'TX', '77073', N'USA', N'281-214-7800', N'281 443 0753', 29.96830940246582, -95.373908996582031)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1432', N'Copart Dallas', N'yes', N'505 Idlewild Road', N'-', N'Grand Prairie', N'TX', '75051', N'USA', N'972-263-2711', N'972 263 9137', 32.741608768701553, -96.953269466757774)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1433', N'Copart Longview', N'yes', N'3046 Highway 322 South', N'-', N'Longview', N'TX', '75603', N'USA', N'903-643-9705', N'903 643 9958', 32.403656005859375, -94.71087646484375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1434', N'Copart Atlanta West', N'yes', N'2568 Old Alabama Road', N'-', N'Austell', N'GA', '30168', N'USA', N'770-941-9775', N'(770) 944-7289', 33.796840667724609, -84.62847900390625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1435', N'Copart Kansas City', N'yes', N'6211 Kansas Ave.', N'-', N'Kansas City', N'KS', '66111', N'USA', N'913-287-6200', N'913 287 4665', 39.082965850830078, -94.7246322631836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1436', N'Copart Oklahoma City', N'yes', N'2829 Se 15th St', N'-', N'Oklahoma City', N'OK', '73129', N'USA', N'405-672-5674', N'405 672 9523', 35.452190399169922, -97.460678100585938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1437', N'Copart St. Louis', N'yes', N'13033 Taussig Ave', N'-', N'Bridgeton', N'MO', '63044', N'USA', N'314-291-8400', N'314 291 6287', 38.779037296772, -90.421834364533424)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1438', N'Copart Memphis', N'yes', N'5545 Swinnea Rd', N'-', N'Memphis', N'TN', '38118', N'USA', N'901-398-8989', N'901 398 2377', 35.000789642333984, -89.974212646484375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1439', N'Copart Hartford', N'yes', N'138 Christian Lane', NULL, N'New Britain', N'CT',' 6051', N'USA', N'860-666-1183', N'860 667 2630', 41.65041, -72.75101)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1440', N'Copart Newburgh', N'yes', N'Route 9w North', N'P.O. BOX 615', N'Marlboro', N'NY', '12542', N'USA', N'845-236-3371', N'845 236 7544', 41.462581634521484, -74.021087646484375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1441', N'Copart Syracuse', N'yes', N'46 Zuk-Pierce Rd', N'-', N'Central Square', N'NY', '13036', N'USA', N'315-676-7153', N'315 676 5147', 43.246589660644531, -76.145500183105469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1442', N'Copart Philadelphia', N'yes', N'2704 Geryville Pike', N'-', N'Pennsburg', N'PA', '18073', N'USA', N'215-679-3164', N'215 679 4322', 40.399772644042969, -75.471595764160156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1443', N'Copart Long Island', N'yes', N'1983 Montauk Highway', N'-', N'Brookhaven', N'NY', '11719', N'USA', N'631-776-0994', N'631 776 1724', 40.77775776386261, -72.928082942962646)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1444', N'Copart Glassboro East', N'yes', N'200 Grove St.', NULL, N'Glassboro', N'NJ',' 8028', N'USA', N'856-881-6700', N'856 863 1683', 39.69481, -75.10625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1445', N'Copart Washington Dc', N'yes', N'11055 Billingsley Road', N'-', N'Waldorf', N'MD', '20602', N'USA', N'301-870-7844', N'301 870 7490', 38.589458465576172, -76.933189392089844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1446', N'Copart Tampa South', N'yes', N'12020 Us Highway 301 South', N'-', N'Riverview', N'FL', '33578', N'USA', N'813-671-5550', N'813 671 5452', 27.823944091796875, -82.328575134277344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1447', N'Copart Rochester', N'yes', N'4 West Ave', N'-', N'Leroy', N'NY', '14482', N'USA', N'585-768-8160', N'585 768 9391', 42.981510162353516, -78.003715515136719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1448', N'Copart Milwaukee', N'yes', N'4825 S. Whitnall Ave', N'-', N'Cudahy', N'WI', '53110', N'USA', N'414-769-7665', N'414 769 0885', 42.956382751464844, -87.874229431152344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1449', N'Copart Jackson', N'yes', N'205 S. Rankin Industrial Drive', N'-', N'Florence', N'MS', '39073', N'USA', N'601-939-7941', N'601 939 6438', 32.185405731201172, -90.13226318359375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1450', N'Copart China Grove', N'yes', N'1081 Recovery Road', N'-', N'China Grove', N'NC', '28023', N'USA', N'704-857-5177', N'704 857 5186', 35.5784912109375, -80.559097290039062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1451', N'Copart Jacksonville West', N'yes', N'450 Hammond Blvd', N'-', N'Jacksonville', N'FL', '32220', N'USA', N'904-781-3141', N'904 781 3654', 30.318880081176758, -81.788284301757812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1452', N'Copart Van Nuys', N'yes', N'7519 Woodman Ave.', N'-', N'Van Nuys', N'CA', '91405', N'USA', N'818-782-5315', N'818 782 5318', 34.207592010498047, -118.43097686767578)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1453', N'Copart Indianapolis', N'yes', N'4040 Office Plaza Blvd', N'-', N'Indianapolis', N'IN', '46254', N'USA', N'317-216-2186', N'317 216 2185', 39.828085452318192, -86.244633793830872)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1454', N'Copart El Paso', N'yes', N'501 Valley Chili Road', N'-', N'El Paso', N'TX', '79821', N'USA', N'915-886-5556', N'915 886 6113', 31.974055096507072, -106.59019365906715)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1455', N'Copart Phoenix', N'yes', N'615 So. 51st Avenue', N'-', N'Phoenix', N'AZ', '85043', N'USA', N'602-484-7075', N'602 484 7074', 33.439345210790634, -112.16916896402836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1456', N'Copart North Seattle', N'yes', N'16701 51st Ave Ne', N'-', N'Arlington', N'WA', '98223', N'USA', N'360-651-6299', N'360 651 8403', 48.146796450018883, -122.16160923242569)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1457', N'Copart North Boston', N'yes', N'55r High St', NULL, N'North Billerica', N'MA',' 1862', N'USA', N'978-667-6787', N'978 667 0073', 42.578256, -71.272952)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1458', N'Copart Raleigh', N'yes', N'310 Copart Road', N'-', N'Dunn', N'NC', '28334', N'USA', N'910-891-1252', N'910 891 1858', 35.266799926757812, -78.620903015136719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1459', N'Copart Orlando', N'yes', N'8100 Mccoy Rd', N'-', N'Orlando', N'FL', '32822', N'USA', N'407-888-2424', N'407 888 2223', 28.451524749398232, -81.272014081478119)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1460', N'Copart Columbia', N'yes', N'4324 Highway 321 South', N'-', N'Gaston', N'SC', '29053', N'USA', N'803-794-3252', N'803 794 3718', 33.8638523966074, -81.0794898122549)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1461', N'Copart Las Vegas', N'yes', N'4810 N. Lamb Blvd', N'-', N'Las Vegas', N'NV', '89115', N'USA', N'702-638-9300', N'702 638 9494', 36.248855590820312, -115.07749938964844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1462', N'Copart San Diego', N'yes', N'7847 Airway Rd', N'-', N'San Diego', N'CA', '92154', N'USA', N'619 671-0900', N'619 671 0965', 32.5570068359375, -116.97223663330078)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1463', N'Copart Des Moines', N'yes', N'3300 Vandalia Road', N'-', N'Des Moines', N'IA', '50317', N'USA', N'515-262-1900', N'515 262 1990', 41.571163177490234, -93.550643920898438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1464', N'Copart Detroit', N'yes', N'21000 Hayden Drive', N'-', N'Woodhaven', N'MI', '48183', N'USA', N'734-365-0070', N'734 365 0080', 42.122192904353142, -83.236244022846222)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1465', N'Copart Nashville', N'yes', N'865 Stumpy Lane', N'-', N'Lebanon', N'TN', '37090', N'USA', N'615-449-6195', N'615 449 6936', 36.167392730712891, -86.295745849609375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1466', N'Copart McAllen', N'yes', N'301 Mile 1 East', N'-', N'Mercedes', N'TX', '78570', N'USA', N'956-514-4840', N'956 565 5078', 26.113518923521042, -97.893246933817863)
GO
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1467', N'Copart Denver', N'yes', N'1281 County Road 27', N'-', N'Brighton', N'CO', '80603', N'USA', N'303-659-0066', N'303 659 8113', 40.016487166285515, -104.81168791651726)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1468', N'Copart West Palm Beach', N'yes', N'7876 Belvedere Road', N'-', N'West Palm Beach', N'FL', '33411', N'USA', N'561-798-5158', N'561 798 3750', 26.690938949584961, -80.1731185913086)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1469', N'Copart San Antonio', N'yes', N'11130 Applewhite Rd', N'-', N'San Antonio', N'TX', '78224', N'USA', N'210-628-1690', N'210 628 1077', 29.308361053466797, -98.545669555664062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1470', N'Copart Albuquerque', N'yes', N'7705 Broadway SE', N'-', N'Albuquerque', N'NM', '87105', N'USA', N'505-877-2424', N'(505) 873-1152', 34.985279083251953, -106.65862274169922)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1471', N'Copart Martinez', N'yes', N'2701 Waterfront Road', N'-', N'Martinez', N'CA', '94553', N'USA', N'925-370-3900', N'925 370 3925', 38.030784606933594, -122.09603118896484)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1472', N'Copart New Orleans', N'yes', N'14600 Gentilly Highway', N'-', N'New Orleans', N'LA', '70129', N'USA', N'504-254-3944', N'504 254 9875', 30.033399760723114, -89.9099387973547)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1473', N'Copart Minneapolis North', N'yes', N'1526 Bunker Lake Blvd', N'-', N'Ham Lake', N'MN', '55304', N'USA', N'763-772-0700', N'763 772 0800', 45.218759626150131, -93.229107409715652)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1474', N'Copart Chicago South', N'yes', N'89 E. Sauk Trail', N'-', N'Chicago Heights', N'IL', '60411', N'USA', N'708-755-0506', N'708 755 0116', 41.483055114746094, -87.627029418945312)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1475', N'Copart Pittsburgh South', N'yes', N'526 Thompson Run Rd', N'-', N'West Mifflin', N'PA', '15122', N'USA', N'412-464-4340', N'412 464 4343', 40.367099761962891, -79.894447326660156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1476', N'Copart Charleston', N'yes', N'2481, Rte. 60', N'-', N'Hurricane', N'WV', '25526', N'USA', N'304-562-2088', N'304 562 2231', 38.418817296624184, -82.034501060843468)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1477', N'Copart Somerville', N'yes', N'2124 West Camplain Road', NULL, N'Hillsborough', N'NJ',' 8844', N'USA', N'908-541-2200', N'908 541 2270', 40.536733, -74.604936)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1478', N'Copart Springfield', N'yes', N'2889 E. Us Highway 60', N'-', N'Rogersville', N'MO', '65742', N'USA', N'417-225-7000', N'417 753 3443', 37.120479583740234, -93.199790954589844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1479', N'Copart Rancho Cucamonga', N'yes', N'12167 Arrow Route', N'-', N'Rancho Cucamonga', N'CA', '91739', N'USA', N'909-581-3595', N'909 581 3564', 34.0956916809082, -117.53875732421875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1480', N'Copart Baltimore', N'yes', N'2251 Old Westminster Pike', N'-', N'Finksburg', N'MD', '21048', N'USA', N'410-871-9080', N'410 871 9515', 39.519677683711052, -76.917264685034752)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1481', N'Copart Eugene', N'yes', N'29815 Enid Road East', N'-', N'Eugene', N'OR', '97402', N'USA', N'541-689-3533', N'541 689 0379', 44.117473602294922, -123.17357635498047)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1482', N'Copart Miami Central', N'yes', N'11858 Nw 36th Ave', N'-', N'Miami', N'FL', '33167', N'USA', N'305-685-6608', N'305 685 9921', 25.88177002966404, -80.258210152387619)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1483', N'Copart Lexington East', N'yes', N'5801 Kasp Ct', N'-', N'Lexington', N'KY', '40509', N'USA', N'859-264-7401', N'859 264 7750', 37.96014404296875, -84.371818542480469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1484', N'Copart Spokane', N'yes', N'11019 West Mcfarlane Road', N'-', N'Airway Heights', N'WA', '99001', N'USA', N'509-244-8585', N'509 244 8788', 47.626716, -117.566574)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1485', N'Copart York Haven', N'yes', N'795 Sipe Rd', N'-', N'York Haven', N'PA', '17370', N'USA', N'717-938-1879', N'717 938 2851', 40.111286163330078, -76.789741516113281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1486', N'Copart Richmond', N'yes', N'5701 Whiteside Rd', N'-', N'Sandston', N'VA', '23150', N'USA', N'804-328-1023', N'804 737 8482', 37.522365570068359, -77.289741516113281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1487', N'Dealers Auto Auction of Alaska, INC.', N'yes', N'8400 Arlon Street', N'-', N'Anchorage', N'AK', '99507', N'USA', N'907-563-8343', N'907-563-8307', 61.144382476806641, -149.83731079101563)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1488', N'Central Auto Auction', N'yes', N'185 Welton St.', NULL, N'Hamden', N'CT',' 6517', N'USA', N'203-787-2277', N'203-787-6564', 41.329427, -72.895923)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1489', N'Dealers Auto Auction of Murfreesboro', N'yes', N'1815 Old Fort Parkway', N'-', N'Murfreesboro', N'TN', '37129', N'USA', N'615-439-7187', N'615-217-6994', 35.843204498291016, -86.421127319335938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1490', N'South Georgia Auto Auction', N'yes', N'1407 Silica Road', N'-', N'Albany', N'GA', '31705', N'USA', N'229-439-0005, 229-733-1350', N'229-878-1005', 31.567058563232422, -84.120719909667969)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1491', N'Wolfe`s Evansville Auto Auction', N'yes', N'2229 S. Kentucky Ave.', N'-', N'Evansville', N'IN', '47714', N'USA', N'812-492-3525', N'812-425-4570', 37.946002960205078, -87.549575805664062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1492', N'ADESA Las Vegas', N'yes', N'1000 E Gowan Road', N'-', N'N. Las Vegas', N'NV', '89030', N'USA', N'702-800-8000', N'702-800-8149', 36.226856, -115.127372)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1493', N'Des Moines Auto Auction', N'yes', N'1530 SE Mckinley', N'-', N'Des Moines', N'IA', '50320', N'USA', N'515-285-8911', N'515-256-9161', 41.541732, -93.594223)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1494', N'America`s Auto Auction - Pittsburgh', N'yes', N'55 East Buffalo Church Road', N'-', N'Washington', N'PA', '15301', N'USA', N'724-225-1777', N'724-225-7223', 40.130893439054489, -80.3304836153984)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1495', N'America`s Auto Auction - Dallas', N'yes', N'219 North Loop 12', N'-', N'Irving', N'TX', '75061', N'USA', N'972-445-1044', N'972-591-2742 & 2743', 32.816471099853516, -96.923835754394531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1496', N'America`s Auto Auction - North Houston, Inc.', N'yes', N'1440 FM 3083', N'-', N'Conroe', N'TX', '77301', N'USA', N'936-441-2882', N'936-788-2842', 30.340014472603798, -95.427547842264175)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1497', N'Copart Columbus', N'yes', N'1680 Williams Road', N'-', N'Columbus', N'OH', '43207', N'USA', N'614-497-1590', N'614 497 3698', 39.892505645751953, -82.946815490722656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1498', N'Copart Birmingham', N'yes', N'3101 Davey Allison Blvd', N'PO Box 3533', N'Hueytown', N'AL', '35023', N'USA', N'205-424-0257', N'205 424 0955', 33.438411, -86.966735)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1499', N'Insurance Auto Auctions Portland/Gorham', N'yes', N'9 Moodys Dr', NULL, N'Gorham', N'ME',' 4038', N'USA', N'207 839-2045', N'2078392701', 43.66524, -70.46072)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1500', N'Insurance Auto Auctions Columbus', N'yes', N'1601 Thrailkill Road', N'-', N'Grove City', N'OH', '43123', N'-', N'614-875-7484', N'-', 39.886909484863281, -83.035804748535156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1502', N'Insurance Auto Auctions South Bend', N'yes', N'25631 SR2', N'-', N'South Bend', N'IN', '46619', N'US', N'574-287-6212', N'-', 41.659507751464844, -86.35333251953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1504', N'America`s Auto Auction - Tulsa', N'yes', N'8544 East Admiral Place', N'-', N'Tulsa', N'OK', '74115', N'USA', N'918-832-1050', N'918-832-1676', 36.16071380674839, -95.881601572036743)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1505', N'America`s Auto Auction - Austin', N'yes', N'16611 S Interstate Highway 35', N'-', N'Buda', N'TX', '78610', N'USA', N'512-268-6600', N'(512) 295-6666', 30.069538116455078, -97.826416015625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1506', N'All Valley Dealer Auto Auction', N'yes', N'7331 Laurel Canyon Blvd.', N'-', N'North Hollywood', N'CA', '91605', N'USA', N'818-381-8333', N'818-381-8338', 37.878952026367188, -122.27028656005859)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1508', N'Insurance Auto Auctions Billings', N'yes', N'75 Cerise Road', N'-', N'Billlings', N'MT', '59101', N'USA', N'4062592377', N'4062592302', 45.797854587435722, -108.46670933067799)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1509', N'Insurance Auto Auctions Bridgeport', N'yes', N'396 River Rd', N'-', N'Bridgeport', N'PA', '19405', N'USA', N'610-279-7123', N'610-279-3346', 40.104198455810547, -75.328079223632812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1510', N'Insurance Auto Auctions Buckhannon', N'yes', N'200 Auction Lane', N'-', N'Buckhannon', N'WV', '26201', N'USA', N'304-472-3900', N'304-472-0871', 38.997915610671043, -80.256493538618088)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1511', N'Insurance Auto Auctions Cincinnati', N'yes', N'10100 Windisch Road', N'-', N'West Chester', N'OH', '45069', N'USA', N'513-779-0075', N'513-779-4267', 39.30154, -84.435546)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1512', N'Insurance Auto Auctions Des Moines', N'yes', N'1914 East Euclid', N'-', N'Des Moines', N'IA', '50313', N'USA', N'515-262-3710', N'515-262-7903', 41.631927490234375, -93.583938598632812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1513', N'Insurance Auto Auctions El Paso', N'yes', N'14651 Gateway West', N'-', N'El Paso', N'TX', '79927', N'USA', N'915-852-2489', N'915-852-2235', 31.700080871582031, -106.28225708007813)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1514', N'Insurance Auto Auctions Fresno', N'yes', N'1805 N Lafayette', N'-', N'Fresno', N'CA', '93705', N'USA', N'559-264-5033', N'559-264-4251', 36.767555236816406, -119.84036254882813)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1515', N'Insurance Auto Auctions Los Angeles', N'yes', N'18300 S Vermont Ave', N'-', N'Gardena', N'CA', '90248', N'USA', N'310-965-0499', N'310-965-0455', 33.864238739013672, -118.28898620605469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1516', N'Insurance Auto Auctions Paducah', N'yes', N'1701 Land Road', N'-', N'Paducah', N'KY', '42003', N'USA', N'270-443-8565', N'270-443-8549', 37.009456634521484, -88.586799621582031)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1517', N'Insurance Auto Auctions Savannah', N'yes', N'348 Commerce Dr.', N'-', N'Rincon', N'GA', '31326', N'USA', N'912-826-1219', N'912-826-1387', 32.246645987033844, -81.201188340783119)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1518', N'Insurance Auto Auctions Sioux Falls', N'yes', N'1700 E. 34th St N', N'-', N'Sioux Falls', N'SD', '57104', N'USA', N'605-271-8855', N'605-271-4662', 43.580749, -96.70578)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1519', N'Insurance Auto Auctions Springfield', N'yes', N'1155 North Eldon, Bldg B', N'-', N'Springfield', N'MO', '65803', N'USA', N'417-863-8976', N'417-865-5466', 37.221675872802734, -93.360137939453125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1520', N'ABC St. Louis', N'yes', N'721 S. 45th', N'-', N'Centreville', N'IL', NULL, N'USA', N'618-332-1227', N'618-332-2227', 38.578147888183594, -90.1253662109375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1521', N'South Florida Auto Auction of Ft Lauderdale', N'yes', N'3500 NW 21st Street', N'-', N'Lauderdale Lakes', N'FL', '33311', N'USA', N'954-739-9996', N'954-739-3359', 26.152622222900391, -80.194366455078125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1523', N'Greater Milwaukee Auto Auction', N'yes', N'8711 W. Brown Deer Road', N'-', N'Milwaukee', N'WI', '53224', N'USA', N'414-365-3500', N'414-362-0391', 43.176456451416016, -88.019363403320312)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1525', N'Lynnway Auto Auction', N'yes', N'400 Charter Way', N'-', N'North Billerica', N'MA',' 1862', N'USA', N'781-596-8500', N'781-667-2343', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1526', N'Prime Auto Auction', N'yes', N'777 w. 190th Street', N'-', N'Gardena', N'CA', '90248', N'USA', N'310-380-4686', N'-', 33.860492929816246, -118.28695379197598)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1528', N'Houston Auto Auction', N'yes', N'6767 North Freeway', N'-', N'Houston', N'TX', '77076', N'USA', N'713-644-5566', N'713-644-4036', 29.861097, -95.406661)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1529', N'San Antonio Auto Auction', N'yes', N'13510 Toepperwein Road', N'-', N'San Antonio', N'TX', '78233', N'USA', N'210-298-5477', N'210-298-5484', 29.561416625976562, -98.348876953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1530', N'Wolfe`s Terre Haute Auto Auction Inc.', N'yes', N'1717 E Margaret Dr.', N'-', N'Terre Haute', N'IN', NULL, N'USA', N'812-238-1431', N'812-235-6257', 39.432830810546875, -87.392120361328125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1531', N'Wolfe`s South Bend Auto Auction', N'yes', N'25784 State Road 2', N'-', N'South Bend', N'IN', '46619', N'USA', N'574-289-7767', N'574-288-2731', 41.6715087890625, -86.366813659667969)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1532', N'El Paso Independent Auto Auction', N'yes', N'7930 Artcraft Rd.', N'-', N'El Paso', N'TX', '79932', N'USA', N'915 587 6700', N'915 496 6060', 31.880897521972656, -106.58445739746094)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1533', N'Insurance Auto Auctions Pittsburgh', N'yes', N'57 Woodlawn Rd.', N'-', N'Aliquippa', N'PA', '15001', N'USA', N'(724) 375-6130', N'(724) 375-6975', 40.623146057128906, -80.2409439086914)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1534', N'Statewide Auto Auction', N'yes', N'1756 North Broad St', N'-', N'Meriden', N'CT',' 6450', N'USA', N'2032371975', N'2032371975', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1536', N'ADESA San Jose', N'yes', N'344 B Tully Rd', N'-', N'San Jose', N'CA', '95111', N'USA', N'408-890-2990', N'408-890-2991', 37.300121307373047, -121.8515625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1537', N'Insurance Auto Auctions Ashland', N'yes', N'123 Four Wheel Drive', N'-', N'Ashland', N'KY', NULL, N'USA', N'(606) 928-1234', N'-', 38.438583374023438, -82.72283935546875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1538', N'Insurance Auto Auctions Longview', N'yes', N'5577 Hwy 80 East', N'-', N'Longview', N'TX', '75605', N'USA', N'(903) 553-9248', N'-', 32.505160644650459, -94.643938466906548)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1539', N'Insurance Auto Auctions Permian Basin', N'yes', N'701 W 81st St', N'-', N'Odessa', N'TX', '79764', N'US', N'(432) 550-7277', N'-', 31.921186447143555, -102.41138458251953)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1540', N'Dealers Auto Auction of Mobile', N'yes', N'3030 McVay Drive North', N'-', N'Mobile', N'AL', '36606', N'USA', N'251-338-7653', N'-', 30.653472900390625, -88.11346435546875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1541', N'Copart Hammond', N'yes', N'1849 Summer Street', N'-', N'Hammond', N'IN', '46320', N'USA', N'563-823-6955', N'-', 41.602504730224609, -87.48309326171875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1542', N'Insurance Auto Auctions Tidewater', N'yes', N'211 Production Drive', N'-', N'Yorktown', N'VA', '23693', N'USA', N'757-595-8493', N'757-595-8691', 37.111793518066406, -76.464126586914062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1544', N'Texas Lone Star Auto Auction', N'yes', N'2205 Country Club Drive', N'-', N'Carrollton', N'TX', '75006', N'USA', N'214-483-3597', N'-', 32.961627960205078, -96.8797378540039)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1545', N'166 Auto Auction', N'yes', N'2944 W. Sunshine Street', N'-', N'Springfield', N'MO', '65807', N'USA', N'4172279364', N'-', 37.182687744498253, -93.3368369936943)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1546', N'Central Maine Auction Center', N'yes', N'44 Concord Drive', N'-', N'Hermon', N'ME',' 4401', N'USA', N'207-848-7027', N'207-848-0739', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1547', N'Nebraska Auto Auction, Inc.', N'yes', N'7500 North 56th Street', N'-', N'Lincoln', N'NE', '68514', N'USA', N'402-466-8477', N'402-466-7932', 40.88641357421875, -96.639572143554688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1548', N'ABC Lancaster, LLC', N'yes', N'1040 Commercial Ave.', N'-', N'East Peterburg', N'PA', '17520', N'USA', N'717-569-5220', N'-', 40.084171295166016, -76.34783935546875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1549', N'WSM Auctions, LLC', N'yes', N'2701 Auto Mall Dr.', N'-', N'Bakersfield', N'CA', '93313', N'USA', N'661-829-6924', N'-', 35.300266265869141, -119.0325927734375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1550', N'Western Wisconsin Auto Auction LLC', N'yes', N'3272 County Highway P', N'-', N'Chippewa Falls', N'WI', '54729', N'USA', N'715-723-1100', N'-', 44.890787824988365, -91.388871967792511)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1552', N'ADESA Quebec City', N'yes', N'500 1st Avenue', N'-', N'St- Romuald', N'QC', NULL, N'Canada', N'905-896-4400', N'905-896-3244', 46.7457804, -71.2414715)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1553', N'Insurance Auto Auctions Specialty Salvage', N'yes', N'2040 E ALGONQUIN RD', N'STE 501', N'SHAUMBURG', N'IL', '60173', N'USA', N'847-221-0901', N'847-221-0891', 42.0641274885869, -88.0336206925713)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1554', N'Fort Wayne Auto and Truck Auction LLC', N'yes', N'3600 E Washington Blvd.', N'-', N'Fort Wayne', N'IN', '46803', N'USA', N'260-748-2000', N'-', 41.07220458984375, -85.094047546386719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1555', N'Insurance Auto Auctions Gulf Coast', N'yes', N'8209 Old Stage Rd.', N'-', N'Moss Point', N'MS', '39562', N'USA', N'228-474-5559', N'228-474-5551', 30.418205261230469, -88.469642639160156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1557', N'Insurance Auto Auctions Dothan', N'yes', N'15994 US Hwy 431', N'-', N'Headland', N'AL', '36345', N'USA', N'334-693-4910', N'334-693-4920', 31.3639497756958, -85.327290818095207)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1558', N'Insurance Auto Auctions Avenel New Jersey', N'yes', N'87 Randolph Ave.', N'-', N'Avenel', N'NJ',' 7001', N'USA', N'732-499-6802', N'732-499-6807', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1559', N'Crosspoint NW Dealer Auctions', N'yes', N'6803 SE Johnson Creek Blvd.', N'-', N'Portland', N'OR', '97206', N'USA', N'503-594-2800', N'503-654-2225', 45.457687377929688, -122.59140014648438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1560', N'Insurance Auto Auctions Anchorage', N'yes', N'221 E. Centaur', N'-', N'Wasilla', N'AK', '99654', N'USA', N'907-376-5364', N'(907)376-3749', 61.57586669921875, -149.44651794433594)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1561', N'Insurance Auto Auctions Louisville', N'yes', N'1825 S. Preston Highway', N'-', N'Shepherdsville', N'KY', '40165', N'USA', N'502-543-0831', N'(502) 543-1289', 37.969535827636719, -85.7109603881836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1562', N'Alliance Auto Auction of Waco', N'yes', N'15735 N. I35', N'-', N'Elm Mott', N'TX', '76640', N'USA', N'254-829-0123', N'-', 31.689729690551758, -97.071250915527344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1563', N'Insurance Auto Auctions Asheville', N'yes', N'4900 Hendersonville Hwy.', N'-', N'Fletcher', N'NC', '28732', N'USA', N'828-684-1564', N'-', 35.414432525634766, -82.505691528320312)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1564', N'Insurance Auto Auctions Columbia', N'yes', N'1416 Atlas Rd.', N'-', N'Columbia', N'SC', '29209', N'USA', N'803-217-0109', N'-', 33.953140258789062, -80.955856323242188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1565', N'Insurance Auto Auctions Lafayette', N'yes', N'301 Malapart Rd.', N'-', N'Lafayette', N'LA', '70507', N'USA', N'337-896-3829', N'-', 30.28839111328125, -92.056427001953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1566', N'Badger State Auto Auction', N'yes', N'215 N. Pioneer Road', N'-', N'North Fond du Lac', N'WI', '54935', N'USA', N'800-554-1126 ext 112', N'1566', 43.800380706787109, -88.487800598144531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1567', N'Alpine Auto Auction of Gaylord, LLC.', N'yes', N'5216 Old 27 N.', N'-', N'Gaylord', N'MI', '49735', N'USA', N'989-966-2060', N'989-966-2064', 45.10235595703125, -84.6629638671875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1568', N'Auto Auction of Montgomery LLC', N'yes', N'6142 Troy Hwy', N'-', N'Pike Road', N'AL', '36064', N'USA', N'334-288-3399', N'334-288-4875', 32.284206300973892, -86.184001788496971)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1569', N'Metro Auto Auction Dallas, Inc.', N'yes', N'1836 Midway Road', N'-', N'Lewisville', N'TX', '75056', N'USA', N'972-492-0900', N'972-492-0944', 33.046724796295166, -96.939348801970482)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1570', N'South Bay Auto Auction of Stockton', N'yes', N'4101 Airport Way', N'-', N'Stockton', N'CA', '95206', N'USA', N'209-690-9191', N'209-944-7725', 37.909011840820312, -121.25974273681641)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1572', N'Big Valley Auto Auction, LP', N'yes', N'4315 N Hutto Rd', N'-', N'Donna', N'TX', '78537', N'USA', N'956-461-9000', N'956-461-9005', 26.197065711021423, -98.063609451055527)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1573', N'Insurance Auto Auctions New Orleans East', N'yes', N'6600 Almonaster Avenue', N'-', N'New Orleans', N'LA', '70126', N'USA', N'504 240-2298', N'9858921039', 30.002780914306641, -90.010581970214844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1574', N'Midland Odessa Auto Auction', N'yes', N'2521 N Marco Avenue', N'-', N'Odessa', N'TX', '79762', N'USA', N'432-367-3063', N'432-367-3358', 31.883092880249023, -102.294921875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1575', N'ABC Baton Rouge, LLC', N'yes', N'3960 Blount Road', N'-', N'Baton Rouge', N'LA', '70807', N'USA', N'225 778-3737', N'-', 30.544628128409386, -91.1518357694149)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1576', N'DAA Seattle', N'yes', N'3130 D Street SE', N'-', N'Auburn', N'WA', '98002', N'USA', N'253-737-2200', N'509-244-8244', 47.280676290392876, -122.22398668527603)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1577', N'Skipco Auto Auction', N'yes', N'700 Elm Ridge Avenue', N'-', N'Canal Fulton', N'OH', '44614', N'USA', N'800-824-7881', N'330-854-3005', 40.886058807373047, -81.567619323730469)
GO
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1578', N'Richmond Auto Auction of Virginia, Inc.', N'yes', N'3600 Deepwater Terminal Road', N'-', N'Richmond', N'VA', '23234', N'USA', N'804-232-7355', N'804-232-1818', 37.4753532409668, -77.425987243652344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1579', N'Mason Dixon Auto Auction', N'yes', N'12876 Molly Pitcher Highway', N'-', N'Greencastle', N'PA', '17225', N'USA', N'717-597-3121', N'717-597-0220', 39.759323671460152, -77.727190554142)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1580', N'National Powersport Auctions', N'yes', N'12400 Stowe Drive', N'-', N'Poway', N'CA', '92064', N'USA', N'404-348-8709', N'-', 32.942489624023438, -117.05381774902344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1581', N'Clark County Auto Auction', N'yes', N'1611 Highway 62', N'-', N'Jeffersonville', N'IN', '47130', N'USA', N'812-283-5555', N'812-288-0834', 38.352699279785156, -85.703628540039062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1582', N'Southeastern Auto Auction of Savannah', N'yes', N'1712 Dean Forest Road', N'-', N'Savannah', N'GA', '31408', N'USA', N'912-965-9901', N'912-965-0525', 32.086719, -81.195419)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1585', N'Insurance Auto Auctions Akron/Canton', N'yes', N'2932 State Route 259SE', N'-', N'New Philadelphia', N'OH', '44663', N'USA', N'303-339-1995', N'303-339-5773', 40.45581, -81.401473)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1587', N'Insurance Auto Auctions Culpeper', N'yes', N'15201 Review Rd', N'-', N'Culpeper', N'VA', '22701', N'USA', N'540-825-2229', N'540-825-2258', 38.492706298828125, -77.9278793334961)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1588', N'Insurance Auto Auctions Dayton', N'yes', N'400 Cherokee Drive', N'-', N'Dayton', N'OH', '45417', N'USA', N'937-268-6666', N'937-268-0852', 39.739753723144531, -84.29217529296875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1589', N'Insurance Auto Auctions New Castle', N'yes', N'417 Old Airport Rd', N'-', N'New Castle', N'DE', '19720', N'USA', N'302-322-1808', N'302-322-5165', 39.698451995849609, -75.617446899414062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1590', N'Insurance Auto Auctions Wichita', N'yes', N'270 W 53rd ST North', N'-', N'Wichita', N'KS', '67204', N'USA', N'316-832-1101', N'316-832-1226', 37.782497406005859, -97.339935302734375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1591', N'Winchester Auto Auction', N'yes', N'12828 Winchester Ave.', N'-', N'Bunker Hill', N'WV', '25413', N'USA', N'304 229-4400', N'304 229-9067', 39.295180812478065, -78.079226464033127)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1592', N'Z66 Auto Auction', N'yes', N'66 North Mingo', N'-', N'Tulsa', N'OK', '74116', N'USA', N'918.794.0660', N'918 794-0740', 36.162815093994141, -95.8711166381836)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1593', N'ABC Cincinnati', N'yes', N'120 Citycentre Drive', N'-', N'Cincinnati', N'OH', '45216', N'USA', N'513-679-7910', N'513-679-7913', 39.200519561767578, -84.470748901367188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1596', N'Insurance Auto Auctions Denver East', N'yes', N'8510 Brighton Rd.', N'-', N'Commerce City', N'CO', '80022', N'USA', N'303-287-9737', N'303-287-1214', 39.85094390809536, -104.91712421178818)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1597', N'Western Canada Remarketing', N'yes', N'1623 Cliveden Avenue', N'-', N'Delta', N'BC', NULL, N'Canada', N'604 540-8422', N'604 540-8423', 49.16295, -122.97281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1599', N'Insurance Auto Auctions Amarillo', N'yes', N'11150 S. FM 1541', N'-', N'Amarillo', N'TX', '79118', N'USA', N'806-622-1322', N'806-622-2678', 35.096538543701172, -101.84954833984375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1600', N'Speedway Auto Auction of Charlotte', N'yes', N'224 Highway 49', N'-', N'South Concord', N'NC', '28025', N'USA', N'(980) 781-4700', N'(980) 781-4192', 35.367274805903435, -80.578815266489983)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1601', N'Your Auction of Tampa Bay', N'yes', N'3010 Scherer Dr, North', N'-', N'St. Petersburg', N'FL', '33716', N'USA', N'(727) 572-8850', N'(727) 556-2898', 27.885547801852226, -82.67511248588562)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1602', N'ADESA Fresno', N'yes', N'3260 E. Annadale Ave.', N'-', N'Fresno', N'CA', '93725', N'USA', N'(559) 549-6576', N'-', 36.700031280517578, -119.77001190185547)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1603', N'Insurance Auto Auctions National Network', N'yes', N'69 Hinckley Road', N'-', N'Clinton', N'ME',' 4927', N'USA', N'800-872-1501', N'207-426-2010', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1604', N'Copart Toronto', N'yes', N'175 OSBORNE ROAD', N'-', N'COURTICE', N'ON', NULL, N'Canada', N'(905) 436-2045', N'-', 43.87257, -78.74925)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1605', N'Copart Hampton', N'yes', N'16 NETTLES LANE', N'-', N'HAMPTON', N'VA', '23666', N'USA', N'(757) 766-2750', N'-', 37.070167064666748, -76.3860934227705)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1606', N'Copart Montgomery', N'yes', N'6044 TROY HIGHWAY', N'-', N'MONTGOMERY', N'AL', '36116', N'USA', N'(334) 281-7264', N'-', 32.285467609763145, -86.185297295451164)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1607', N'Copart Greer', N'yes', N'2465 HIGHWAY 101 SOUTH', N'GREER', N'GREER', N'SC', '29651', N'USA', N'(864) 877-9113', N'-', 34.867618560791016, -82.139122009277344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1608', N'Copart Louisville', N'yes', N'3100 POND STATION ROAD', N'-', N'LOUISVILLE', N'KY', '40272', N'USA', N'(502) 361-1881', N'-', 38.112087249755859, -85.819175720214844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1609', N'Copart Salisbury', N'yes', N'26029 BETHEL CONCORD ROAD', N'-', N'SEAFORD', N'DE', '19973', N'USA', N'(302) 628-5412', N'-', 38.6302604675293, -75.5628890991211)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1610', N'Copart Columbia', N'yes', N'8485 RICHLAND RD', N'-', N'COLUMBIA', N'MO', '65201', N'USA', N'(573) 814-0070', N'-', 38.949932098388672, -92.2078857421875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1611', N'Copart Lincoln', N'yes', N'13603 238TH ST', N'-', N'GREENWOOD', N'NE', '68366', N'USA', N'(402) 944-3255', N'-', 40.974891662597656, -96.39154052734375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1612', N'Copart Tallahassee', N'yes', N'1825 Commerce Blvd.', N'-', N'Midway', N'FL', '32343', N'USA', N'850-575-2075', N'-', 30.498054921627045, -84.408170878887177)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1613', N'Copart Knoxville', N'yes', N'6355 B HIGHWAY 411', N'-', N'MADISONVILLE', N'TN', '37354', N'USA', N'(423) 442-5866', N'-', 35.455901026725769, -84.4363608956337)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1614', N'Copart Anchorage', N'yes', N'401 W Chipperfield Dr', N'-', N'Anchorage', N'AK', '99501', N'USA', N'(907) 278-2221', N'-', 61.218994140625, -149.8287353515625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1615', N'Copart Cleveland West', N'yes', N'34417 E. ROYALTON ROAD', N'-', N'COLUMBIA STATION', N'OH', '44028', N'USA', N'(440) 748-8100', N'-', 41.310607, -81.98545)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1616', N'Copart Honolulu', N'yes', N'91-542 AWAKUMOKU ST', N'-', N'KAPOLEI', N'HI', '96707', N'USA', N'(808) 682-8770', N'-', 21.317626610398293, -158.11629787087441)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1617', N'Copart Atlanta East', N'yes', N'6089 HIGHWAY 20', N'-', N'LOGANVILLE', N'GA', '30052', N'USA', N'770-554-6366', N'-', 33.804505169391632, -83.951904326677322)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1618', N'Copart Helena', N'yes', N'3333 Bozeman Avenue', N'-', N'Helena', N'MT', '59601', N'USA', N'(406) 443-5060', N'-', 46.597072601318359, -111.97350311279297)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1619', N'Copart Lansing', N'yes', N'3902 South Canal Road', N'-', N'Lansing', N'MI', '48917', N'USA', N'(517) 322-2455', N'-', 42.691696166992188, -84.66412353515625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1620', N'Copart Reno', N'yes', N'9915 N. Virginia Street', N'-', N'Reno', N'NV', '89506', N'USA', N'(775) 322-4377', N'-', 39.615032196044922, -119.88481903076172)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1621', N'Copart Amarillo', N'yes', N'3999 S Loop 335 E', N'-', N'Amarillo', N'TX', '79118', N'USA', N'(806) 335-3701', N'-', 35.120822712779045, -101.79081246256828)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1622', N'Copart Albany', N'yes', N'1916 Central Ave', N'-', N'Albany', N'NY', '12205', N'USA', N'(518) 452-9313', N'-', 42.735668182373047, -73.8563232421875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1623', N'Copart Tucson', N'yes', N'5600 S. Arcadia Ave', N'-', N'Tucson', N'AZ', '85706', N'USA', N'(520) 663-1900', N'-', 32.150173187255859, -110.88906097412109)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1624', N'Copart Lyman', N'yes', N'136 Kennebunk Pond Road', N'-', N'Lyman', N'ME',' 4002', N'USA', N'(207) 499-7255', N'-', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1625', N'Copart Boise', N'yes', N'3716 North Middleton Road', N'-', N'Nampa', N'ID', '83651', N'USA', N'(208) 463-4040', N'-', 43.618644, -116.614463)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1626', N'Copart Wichita', N'yes', N'4510 S Madison', N'-', N'Wichita', N'KS', '67216', N'USA', N'(316) 554-0123', N'-', 37.611289978027344, -97.308341979980469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1627', N'Copart Mobile', N'yes', N'4763 Lott Road', N'-', N'Eight Mile', N'AL', '36613', N'USA', N'(251) 649-5011', N'-', 30.788215, -88.218269)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1628', N'Copart Peoria', N'yes', N'14417 VFW Road', N'-', N'Pekin', N'IL', '61554', N'USA', N'(309) 347-4196', N'-', 40.527996063232422, -89.656509399414062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1629', N'Copart Baton Rouge', N'yes', N'21595 Greenwell Springs Road', N'-', N'Greenwell Springs', N'LA', '70739', N'USA', N'(225) 261-0102', N'-', 30.559904098510742, -90.996505737304688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1630', N'Copart Salt Lake City', N'yes', N'170 W. Center Street', N'-', N'North Salt Lake', N'UT', '84054', N'USA', N'(801) 294-3000', N'-', 40.841911509633064, -111.91717810928822)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1631', N'Copart Little Rock', N'yes', N'703 Main Street', N'-', N'Conway', N'AR', '72032', N'USA', N'(501) 796-2812', N'-', 35.0836067199707, -92.28961181640625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1632', N'Copart Tulsa', N'yes', N'2408 W 21st Street', N'-', N'Tulsa', N'OK', '74107', N'USA', N'918-582-3828', N'-', 36.1315803527832, -96.021232604980469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1633', N'Copart San Jose', N'yes', N'13895 LLAGAS AVE', N'-', N'San Martin', N'CA', '95046', N'USA', N'(408) 683-9393', N'-', 37.093673706054688, -121.61157989501953)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1635', N'Music City Auto Auction of Nashville', N'yes', N'3639 Royal Park Blvd,', N'-', N'Spring Hill', N'TN', '37174', N'USA', N'(931) 674-8000', N'(931) 674-8004', 35.727392882108688, -86.920372769236565)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1637', N'Alliance Auto Auction of Dallas', N'yes', N'9426 Lakefield Blvd.', N'-', N'Dallas', N'TX', '75220', N'USA', N'(214) 646-3136', N'(469) 828-8225', 32.8585319519043, -96.862838745117188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1638', N'135 Auto Auction', N'yes', N'4716 S Santa Fe Street', N'-', N'Wichita', N'KS', '67216', N'USA', N'316-351-5001', N'316-522-7032', 37.609153747558594, -97.327743530273438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1639', N'Insurance Auto Auctions McAllen', N'yes', N'900 N. Hutto Road', N'-', N'Donna', N'TX', '78537', N'USA', N'(956) 464-8393', N'(956) 464-8510', 26.182461082935333, -98.066010028123856)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1640', N'Insurance Auto Auctions Abilene', N'yes', N'7700 US Hwy 277', N'-', N'Hawley', N'TX', '79601', N'USA', N'(325) 675-0699', N'(325) 675-5073', 32.671507224440575, -99.856866672635078)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1641', N'Insurance Auto Auctions Shreveport', N'yes', N'4836 McGee Rd.', N'-', N'Greenwood', N'LA', '71033', N'USA', N'(318) 938-5108', N'(318) 938-5838', 32.447151184082031, -93.97210693359375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1642', N'Insurance Auto Auctions Davenport', N'yes', N'5403 Rockingham Rd.', N'-', N'Davenport', N'IA', '52802', N'USA', N'(563) 322-8562', N'(563) 322-8896', 41.485019683837891, -90.65057373046875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1643', N'Insurance Auto Auctions Tifton', N'yes', N'368 Oak Ridge Church Rd.', N'-', N'Tifton', N'GA', '31794', N'USA', N'(229) 386-2640', N'(229-386-2650)', 31.400556564331055, -83.490196228027344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1644', N'Insurance Auto Auctions Huntsville', N'yes', N'16326 Ennis Road', N'-', N'Athens', N'AL', '35613', N'USA', N'(256) 233-5899', N'(256) 233-2366', 34.79376220703125, -86.872055053710938)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1645', N'America`s Auto Auction - Houston', N'yes', N'1826 Almeda-Genoa Road', N'-', N'Houston', N'TX', '77047', N'USA', N'(281) 819-3600', N'(281) 819-3601', 29.613801687955856, -95.395094454288483)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1646', N'Detroit Distribution Center', N'yes', N'6301 Wyoming Ave', N'-', N'Dearborn', N'MI', '48126', N'USA', N'810-736-8174', N'(810) 736-3351', 42.336300909519196, -83.157016262412071)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1647', N'Insurance Auto Auctions Lubbock', N'yes', N'5311 N. Country Road 2000', N'-', N'Lubbock', N'TX', '79415', N'USA', N'(806) 747-5458', N'(806) 747-5472', 33.648868, -101.906509)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1648', N'Insurance Auto Auctions Macon', N'yes', N'2200 Trade Ave.', N'-', N'Macon', N'GA', '31217', N'-', N'(478) 314-0031', N'(478) 314-0040', 32.8480339050293, -83.5848159790039)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1649', N'Insurance Auto Auctions Reno', N'yes', N'4086 Peru Drive', N'-', N'McCarran', N'NV', '89434', N'USA', N'(775) 636-8829', N'(775) 636-7280', 36.083145141601562, -115.14917755126953)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1650', N'Insurance Auto Auctions Riverside', N'yes', N'3760 Pyrite Street', N'-', N'Riverside', N'CA', NULL, N'USA', N'(909)355-9400', N'(909)822-9311', 34.018917083740234, -117.46300506591797)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1651', N'Insurance Auto Auctions Suffolk', N'yes', N'1389 Portsmouth Blvd.', N'-', N'Suffolk', N'VA', '23434', N'USA', N'(757) 539-0571', N'(757) 539-0573', 36.749214172363281, -76.5201416015625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1652', N'Insurance Auto Auctions Tulsa', N'yes', N'5311 W. 46th Street S', N'-', N'Tulsq', N'OK', '74107', N'USA', N'(918) 445-4691', N'(918) 445-4905', 36.099376, -96.052215)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1653', N'Insurance Auto Auctions York Springs', N'yes', N'10 Auction Dr', N'-', N'York Springs', N'PA', '17372', N'USA', N'(717) 528-4336', N'(717) 528-4346', 40.020839691162109, -77.095733642578125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1655', N'Insurance Auto Auctions Atlanta-North', N'yes', N'6242 Black Acre Trail', N'-', N'Acworth', N'GA', '30101', N'USA', N'(770) 975-1107', N'(770) 975-1250', 34.079168736934662, -84.732352048158646)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1656', N'Dealers Auto Auction of Las Vegas', N'yes', N'3038 Losee Rd', N'-', N'North Las Vegas', N'NV', '89030', N'USA', N'702-255-0990', N'702-255-0991', 36.215164, -115.127944)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1657', N'ADESA Chicago', N'yes', N'2785 Beverly Road', N'-', N'Hoffman Estates', N'IL', '60169', N'USA', N'847-636-7985', N'-', 42.075476199388504, -88.223549500107765)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1658', N'Auctions In Motion', N'yes', N'1901 East Edinger', N'-', N'Santa Ana', N'CA', '92705', N'USA', N'(805) 499-7640', N'(805) 426-8114', 33.726912885904312, -117.83978663384914)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1659', N'ADESA Windsor', N'yes', N'18800 County Road 42', N'-', N'Tilbury', N'ON', NULL, N'Canada', N'519-682-9500', N'519-682-9814', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1660', N'CrashedToys', N'yes', N'7777 John Carpenter Fwy', N'-', N'Dallas', N'TX', '75247', N'USA', N'(214) 920-9664', N'(214) 920-9668', 32.818576812744141, -96.87451171875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1661', N'Insurance Auto Auctions Louisville North', N'yes', N'891 Ballardsville Road', N'-', N'Eminence', N'KY', '40019', N'USA', N'(502) 215-4804', N'-', 38.370294123888016, -85.192626491189)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1662', N'Value Auto Auction', N'yes', N'3776 S.R. 93 N. E.', N'-', N'Crooksville', N'OH', '43731', N'USA', N'(740) 982-3030', N'(740) 982-3055', 39.736516177654266, -82.099933549761772)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1663', N'Lake Charles Auto Auction', N'yes', N'2435 BROAD ST', N'-', N'Lake Charles', N'LA', '70601', N'USA', N'337-433-8664', N'337-436-7197', 30.227977752685547, -93.181526184082031)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1664', N'Insurance Auto Auctions Shady Spring', N'yes', N'4163 Pluto Road', N'-', N'Shady Spring', N'WV', '25918', N'USA', N'(304) 253-4970', N'-', 37.75385744869709, -80.983975678682327)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1665', N'Bar None Auction - Portland', N'yes', N'1501 N. Schmeer Road', N'-', N'Portland', N'OR', '97217', N'USA', N'916-246-2156', N'916-638-8961', 45.590789794921875, -122.68500518798828)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1666', N'Bar None Auction - Riverside', N'yes', N'9400 Galena Street', N'-', N'Riverside', N'CA', '92509', N'USA', N'916-246-2156', N'916-638-8961', 34.004467874765396, -117.48855002224445)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1667', N'Bar None Auction - Sacramento', N'yes', N'4751 Power Inn Road', N'-', N'Sacramento', N'CA', '95826', N'USA', N'916-246-2156', N'916-638-8961', 38.532817840576172, -121.40796661376953)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1668', N'Mid Kansas Auto Auction', N'yes', N'700 W. 48th Street', N'-', N'Hays', N'KS', '67601', N'United States', N'785-621-2100', N'785-621-2101', 38.905391693115234, -99.328910827636719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'1669', N'Ken Porter Auctions', N'yes', N'21140 S. Avalon Blvd.', N'-', N'Carson', N'CA', '90745', N'USA', N'310-353-7140', N'310-353-5740', 33.8844108581543, -118.26509094238281)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'2003', N'Manheim Leicester', N'yes', N'Charnwood Road', N'-', N'Shepshed', N'Leicestershire', NULL, N'England', N'(101144) 1509-502171', N'(101144) 1509-507570', 52.765161, -1.295592)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'2005', N'TRA - Casper', N'yes', N'1998 N Oil Field Center Road', N'-', N'Casper', N'WY', '82604', N'USA', N'303-395-8366', N'303-470-5447', 42.874477, -106.427871)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'3512', N'TRA - Springfield', N'yes', N'1619 S Golden', N'-', N'Springfield', N'MO', '65807', N'USA', N'417-447-9742', N'417-447-9743', 37.186206817626953, -93.340904235839844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'4444', N'ADESA.com', N'yes', N'-', N'-', N'-', N'AZ', NULL, N'USA', N'480-556-5236', N'480-291-9618', 34.292964935302734, -111.66469573974609)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'5555', N'Demonstration Auction', N'yes', N'50 Glenlake Parkway', N'Suite 400', N'Atlanta', N'GA', NULL, N'USA', N'(678) 597-3900', N'(678) 597-3939', 33.940643310546875, -84.3619384765625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'6777', N'Copart National Network', N'yes', N'14185 Dallas Parkway, Suite 300', N'-', N'Dallas', N'TX', '75254', N'USA', N'800-269-4885', N'(800) 269-4880', 32.939014, -96.822944)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'7777', N'Demo Salvage Auction', N'yes', N'-', N'-', N'-', N'GA', NULL, N'-', N'-', N'-', 32.648323059082031, -83.444534301757812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'AAA', N'Manheim Atlanta', N'yes', N'4900 Buffington Rd', N'-', N'College Park', N'GA', '30349', N'USA', N'-', N'-', 33.621177, -84.495666)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'AAAI', N'Manheim New England', N'yes', N'123 Williams Street', N'-', N'North Dighton', N'MA',' 2764', N'USA', N'(508) 823-6600', N'(508) 821 3432', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'AAAW', N'Manheim Georgia', N'yes', N'7205 Campbellton Rd SW', N'-', N'Atlanta', N'GA', '30331', N'USA', N'404-349-5555', N'-', 33.695892333984375, -84.62249755859375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'ALBA', N'Manheim New Mexico', N'yes', N'3411 Broadway BLVD SE', N'-', N'Albuquerque', N'NM', '87105', N'USA', N'(505) 242-9191', N'(505) 247-7415', 35.037357330322266, -106.64808654785156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'ALOH', N'Manheim Hawaii', N'yes', N'1001 Ahua St', N'-', N'Honolulu', N'HI', '96819', N'USA', N'(808) 840-8900', N'(808) 840-8999', 21.342338562011719, -157.89483642578125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'AREN', N'Manheim Arena Illinois', N'yes', N'200 West Old Chicago Drive', N'-', N'Bolingbrook', N'IL', '60440', N'USA', N'630-759-3800', N'630-679-8321', 41.679855, -88.068267)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'AYCA', N'Manheim North Carolina', N'yes', N'318 Bagley Road', N'P O Box 760', N'Kenly', N'NC', '27542', N'USA', N'(919) 284-4052', N'(919) 284-5706', 35.574802, -78.163902)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'BAA', N'Manheim Pittsburgh', N'yes', N'21095 Route 19 North', N'-', N'Cranberry Township', N'PA', NULL, N'USA', N'(724) 452-5555', N'(724) 452-2046', 40.728466, -80.109886)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'BCAA', N'Manheim San Francisco Bay', N'yes', N'29900 Auction Way', N'-', N'Hayward', N'CA', '94544', N'USA', N'(510) 786-4500', N'(510) 786-2338', 37.615676879882812, -122.06822967529297)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'BELA', N'Bel Air Auto Auction, Inc.', N'yes', N'803 Bel Air Rd. U.S. Rte.1', N'P.O. BOX 516', N'Bel Air', N'MD', '21014', N'USA', N'(410) 879-7950', N'(410) 893-1515', 39.519593194127083, -76.360890045762062)
GO
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'BELS', N'Bel Air Auto Auction, Inc. (Salvage)', N'yes', N'803 Bel Air Rd. U.S. Rte.1', N'P.O. BOX 516', N'Bel Air', N'MD', '21014', N'USA', N'(410) 879-7950', N'(410) 893-1515', 39.519593194127083, -76.360890045762062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'BIGH', N'Manheim Houston', N'yes', N'14450 West Road', N'-', N'Houston', N'TX', NULL, N'USA', N'281-955-4650', N'(281) 955-4626', 29.901294, -95.618049)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'BWAE', N'Manheim Balt Wash', N'yes', N'7120 Dorsey Run Road', N'-', N'Elkridge', N'MD', '21075', N'USA', N'(800) 533-2923', N'(410) 799-0512', 39.175437927246094, -76.759140014648438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'CAAI', N'Manheim Darlington', N'yes', N'1111 Harry Byrd Highway', N'-', N'Darlington', N'SC', NULL, N'USA', N'(843) 395-5696', N'(843) 395-5663', 34.294353485107422, -79.8949966430664)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'CADE', N'Manheim California', N'yes', N'1320 N. Tustin Avenue', N'-', N'Anaheim', N'CA', NULL, N'USA', N'714 996 2400', N'714-985-8351', 33.865203857421875, -117.84103393554688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'CANM', N'Manheim Vancouver', N'yes', N'400-628 Sixth Avenue', N'-', N'New Westminster', N'BC', NULL, N'Canada', N'604-545-2277', N'-', 49.2127713, -122.9207721)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'CINA', N'Manheim Cincinnati', N'yes', N'4969 Mulhauser Road', N'-', N'Hamilton', N'OH', NULL, N'USA', N'(800) 489-7253', N'5138741531', 39.316280364990234, -84.4549789428711)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'CLEV', N'Manheim Cleveland', N'yes', N'4720 Brookpark Road', N'-', N'Cleveland', N'OH', '44134', N'USA', N'216-539-1701', N'-', 41.419589996337891, -81.7196273803711)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DAA', N'Manheim Denver', N'yes', N'17500 E. 32nd Avenue', N'-', N'Aurora', N'CO', NULL, N'USA', N'(800) 822-1177', N'(303) 343-6466', 39.7588005065918, -104.78585815429688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DAAE', N'Manheim El Paso', N'yes', N'485 Coates Drive', N'-', N'El Paso', N'TX', NULL, N'USA', N'915-585-5230', N'915-581-9645', 31.869251251220703, -106.58005523681641)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DADE', N'Manheim Daytona Beach', N'yes', N'1305 Indian Lake Road', N'-', N'Daytona Beach', N'FL', NULL, N'USA', N'800-881-3233', N'(386)255-1249 FAX', 29.144857406616211, -81.142669677734375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DALA', N'Manheim Dallas', N'yes', N'5333 West Kiest Boulevard', N'-', N'Dallas', N'TX', NULL, N'USA', N'(214) 330-1800', N'(214) 339-9361', 32.708354949951172, -96.913093566894531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DETA', N'Manheim Detroit', N'yes', N'600 Will Carleton Rd', N'-', N'Carleton', N'MI', '48117', N'USA', N'(734) 654-7100', N'(734) 654-7146', 42.088588714599609, -83.370887756347656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DFWA', N'Manheim DFW', N'yes', N'12101 Trinity Blvd', N'-', N'Euless', N'TX', '76040', N'USA', N'(817) 399-4000', N'(817) 399-4251', 32.816577911376953, -97.1060562133789)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'DRIV', N'Manheim DRIVE Center', N'yes', N'3000 Walter Way', N'-', N'Stockbridge', N'GA', '30281', N'USA', N'(678) 284-4188', N'-', 33.540401458740234, -84.260917663574219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'EDMO', N'Manheim Edmonton', N'yes', N'12866 153 St. NW', N'-', N'Edmonton', N'AB', NULL, N'Canada', N'780-784-5555', N'780-784-5565', 53.5869, -113.58635)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'FAA', N'Manheim Fredericksburg', N'yes', N'120 Auction Drive', N'-', N'Fredericksburg', N'VA', '22406', N'USA', N'(540) 368-3400', N'(540) 368-3618', 38.350517272949219, -77.488037109375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'FAAO', N'Manheim Orlando', N'yes', N'11801 West Colonial Drive', N'-', N'Ocoee', N'FL', NULL, N'USA', N'(800) 337-8491', N'(407) 656-7846', 28.555801391601562, -81.553024291992188)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'FADA', N'Manheim Central California', N'yes', N'278 North Marks Avenue', N'-', N'Fresno', N'CA', NULL, N'USA', N'(559) 268-8051', N'(559)-459-5248', 36.740097045898438, -119.84201049804688)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'GCAA', N'Manheim Chicago', N'yes', N'20401 Cox Avenue', N'-', N'Matteson', N'IL', '60443', N'USA', N'815 806 4222', N'815 806 4228', 41.518272399902344, -87.778282165527344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'GOAA', N'Manheim Central Florida', N'yes', N'9800 Bachman Road', N'-', N'Orlando', N'FL', '32824', N'USA', N'(407)438-1000', N'(407) 438-2828', 28.426340103149414, -81.39373779296875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'HAA', N'Manheim Harrisonburg', N'yes', N'3560 Early Rd.', N'-', N'Harrisonburg', N'VA', NULL, N'USA', N'(540) 434-5991', N'(540) 433-7348', 38.399169921875, -78.903961181640625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'HATA', N'Manheim Philadelphia', N'yes', N'2280 Bethlehem Pike, Route 309', N'-', N'Hatfield', N'PA', '19440', N'USA', N'(215) 822-1935', N'2679541058', 40.295291900634766, -75.2833023071289)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'HLFX', N'Manheim Halifax', N'yes', N'376 Lower Sackville Dr.', N'-', N'Lower Sackville', N'NS', NULL, N'Canada', N'902-865-8650', N'902-865-9948', 44.76306, -63.67581)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'IBSL', N'ADESA Salt Lake', N'yes', N'780 South 5600 West', N'-', N'Salt Lake City', N'UT', NULL, N'USA', N'(801) 322-1234', N'(801) 322-1315', 40.754661560058594, -112.02791595458984)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'INDY', N'Manheim Indianapolis', N'yes', N'3110 South Post Road', N'-', N'Indianapolis', N'IN', '46239', N'USA', N'(317) 862-8622', N'(317) 862-8623', 39.722957611083984, -86.009071350097656)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'JAX', N'Manheim Jacksonville', N'yes', N'10817 New Kings Rd', N'-', N'Jacksonville', N'FL', '32219', N'USA', N'(904) 768-9981', N'(904) 768-9989', 30.432090759277344, -81.757728576660156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'KCAA', N'Manheim Kansas City', N'yes', N'3901 Skiles Avenue', N'-', N'Kansas City', N'MO', '64161', N'USA', N'816-459-2454', N'(816) 459-2612', 39.166412353515625, -94.4857177734375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'KEYA', N'Manheim Keystone PA', N'yes', N'488 Firehouse Road', N'PO Box 608', N'Grantville', N'PA', '17028', N'USA', N'(717) 469-7900', N'(717) 469-2842', 40.385042130947113, -76.650227308273315)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'LAA', N'Manheim Lakeland', N'yes', N'8025 State Road 33 North', N'Exit 20', N'Lakeland', N'FL', '33809', N'USA', N'(800) 967-2886', N'(863) 984-3029', 28.144853, -81.890625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'LATL', N'Manheim Metro Atlanta', N'yes', N'2244 Metropolitan Parkway', N'-', N'Atlanta', N'GA', '30315', N'USA', N'(404) 464-4567', N'(404) 464-4568', 33.692138671875, -84.405921936035156)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'LHST', N'Manheim South Houston', N'yes', N'9605 Galveston Road', N'-', N'Houston', N'TX', '77034', N'USA', N'(713) 948-0001', N'(713) 948-0300', 29.626176834106445, -95.198051452636719)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'LMAA', N'Manheim Ft. Lauderdale', N'yes', N'5353 South State Road 7', N'RE: 200182', N'Davie', N'FL', '33314', N'USA', N'(954) 791-3520', N'(954) 453-8435', 26.0656795501709, -80.234733581542969)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'LOUA', N'Manheim Louisville', N'yes', N'5425 Highway 31 East', N'-', N'Clarksville', N'IN', '47129', N'USA', N'(800) 489-2886', N'(812) 283-1731', 38.341991, -85.750793)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'LPHX', N'Manheim Arizona', N'yes', N'3420 South 48th Street', N'-', N'Phoenix', N'AZ', '85040', N'USA', N'602-794-2575', N'602-794-2585', 33.415821075439453, -111.98167419433594)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MAA', N'Manheim PA', N'yes', N'1190 Lancaster Road', N'-', N'Manheim', N'PA', '17545', N'USA', N'(717) 665-3571', N'(717) 665-9265', 40.139694213867188, -76.396820068359375)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MAAI', N'Manheim Minneapolis', N'yes', N'8001 Jefferson Highway', N'PO Box 408', N'Maple Grove', N'MN', '55369', N'USA', N'(763) 425-7653', N'(763) 493-0307', 45.099945, -93.405792)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MISS', N'Manheim Mississippi', N'yes', N'7510 U.S. Hwy 49', N'-', N'Hattiesburg', N'MS', NULL, N'USA', N'(601) 268-7550', N'(601) 579-7202', 31.40849494934082, -89.389419555664062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MLRA', N'Manheim Little Rock', N'yes', N'5809 S. University Avenue', N'-', N'Little Rock', N'AR', '72209', N'USA', N'314-739-1300', N'-', 34.697349548339844, -92.344497680664062)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MMAA', N'Manheim Milwaukee', N'yes', N'561 27th Street', N'-', N'Caledonia', N'WI', '53108', N'USA', N'(800) 662-2947', N'(262) 824-2552', 42.834582924842834, -87.953261956572533)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MONC', N'Manheim Moncton', N'yes', N'43 Somers Dr.', N'-', N'Moncton', N'NB', NULL, N'Canada', N'506-389-3890', N'-', 46.12872, -64.76421)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'MTRL', N'Manheim Montreal', N'yes', N'715 Rue Dubois', N'-', N'Saint Eustache', N'QC', NULL, N'Canada', N'450-974-4600; 866-668-5610', N'450-974-4601', 45.5928867, -73.8691547)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NAA', N'Manheim New York', N'yes', N'2000 Dealer Drive', N'PO Box 10900', N'Newburgh', N'NY', NULL, N'USA', N'845-567-8400', N'845-567-8410', 41.511132717132568, -74.095185175538063)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NADE', N'Manheim New Jersey', N'yes', N'730 Route 68', N'PO Box 188', N'Bordentown', N'NJ',' 8505', N'USA', N'(609) 298-3400', N'(609) 291-7918', 40.10759, -74.69391)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NASH', N'Manheim Nashville', N'yes', N'8400 Eastgate Blvd.', N'-', N'Mt. Juliet', N'TN', '37122', N'USA', N'(615) 773-3800', N'(615) 773-4856', 36.184944, -86.445945)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NOAA', N'Manheim New Orleans', N'yes', N'61077 Saint Tammany Ave.', N'-', N'Slidell', N'LA', NULL, N'USA', N'(985) 643-2061', N'(985) 6051245', 30.31743161380291, -89.779652506113052)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NSAA', N'Manheim Northstar Minnesota', N'yes', N'4908 Valley Ind. Blvd. N', N'-', N'Shakopee', N'MN', '55379', N'USA', N'(952)-445-5544', N'952-445-6188', 44.753520965576172, -93.51812744140625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NVAA', N'Manheim Nevada', N'yes', N'6600 Auction Lane', N'-', N'North Las Vegas', N'NV', '89165', N'USA', N'(702) 730-1400', N'(702) 730-1541', 36.289543, -115.016311)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'NWE', N'Manheim Albany', N'yes', N'459 Route 146', N'P.O. Box 440', N'Clifton Park', N'NY', NULL, N'USA', N'(518) 371-7500', N'(518) 373-0392', 42.864795, -73.759559)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'OAA', N'Manheim Ohio', N'yes', N'3905 Jackson Pike', N'-', N'Grove City', N'OH', NULL, N'USA', N'(614) 801-6909', N'(614) 871-6894', 39.8809926956892, -83.027727082371712)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'OMAA', N'Manheim Omaha', N'yes', N'9201 S. 144th St.', N'-', N'Omaha', N'NE', '68138', N'USA', N'402-896-8000', N'(402) 896-0475', 41.167610168457031, -96.1346206665039)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'PAA', N'Manheim Portland', N'yes', N'3000 North Hayden Island Drive', N'-', N'Portland', N'OR', NULL, N'USA', N'(503) 286-3000', N'(503) 286-5226', 45.6178092956543, -122.6962890625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'PCAA', N'Manheim Pensacola', N'yes', N'6359 North W Street', N'-', N'Pensacola', N'FL', '32505', N'USA', N'(888) 477-3063', N'(850) 479-4762', 30.4780216217041, -87.259140014648438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'PRAA', N'Manheim Caribbean', N'yes', N'Carrettera #865 - KM 4.7', N'Barrio Candelaria', N'Toa Baja', N'PR', 949, N'-', N'(787) 261-7300', N'(787) 261-7260', NULL, NULL)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'PTAF', N'Manheim Flint', N'yes', N'4109 Holiday Drive', N'-', N'Flint', N'MI', '48507', N'USA', N'(810) 341-5206', N'(810) 341-5206', 42.97094039618969, -83.719590157270432)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'PXAA', N'Manheim Phoenix', N'yes', N'201 North 83rd Avenue', N'-', N'Tolleson', N'AZ', '85353', N'USA', N'(800) 449-4749', N'(623) 907-7097', 33.450245037674904, -112.2382814437151)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'RAA', N'Manheim Riverside', N'yes', N'6446 Fremont St.', N'', N'Riverside', N'CA', NULL, N'USA', N'(951) 689-6000', N'-', 33.955402374267578, -117.438232421875)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'RSAA', N'Manheim Digital Marketplace', N'yes', N'6325 Peachtree Dunwoody Road, NE', N'-', N'Atlanta', N'GA', '30328', N'USA', N'678-645-6716', N'-', 32.648323059082031, -83.444534301757812)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SAAA', N'Manheim San Antonio', N'yes', N'2042 Ackerman Road', N'-', N'San Antonio', N'TX', '78219', N'USA', N'(800) 874-2897', N'(210) 662-3196', 29.449121475219727, -98.378692626953125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SAPL', N'Manheim Lafayette', N'yes', N'1611 St. Mary Street', N'-', N'Scott', N'LA', '70583', N'USA', N'(337) 237-5620', N'(337) 237-0762', 30.24073600769043, -92.101493835449219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SAPT', N'Manheim Tulsa', N'yes', N'9101 Frankoma Rd.', N'-', N'Sapulpa', N'OK', '74066', N'USA', N'918-227-3542', N'918-227-3644', 36.03106689453125, -96.096687316894531)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SCAA', N'Manheim Southern Cal', N'yes', N'10700 Beech Avenue', N'-', N'Fontana', N'CA', NULL, N'USA', N'(909) 829-7467', N'-', 34.057846069335938, -117.47371673583984)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SDAA', N'Manheim San Diego', N'yes', N'4691 Calle Joven', N'-', N'Oceanside', N'CA', '92057', N'USA', N'(760)754-3600', N'(760)754-3690', 33.242889, -117.309089)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SKYA', N'Manheim NY Metro Skyline', N'yes', N'100 U.S. Highway 46', NULL, N'Fairfield', N'NJ',' 7004', N'USA', N'(973) 227-0100 ext. 245', N'973-227-3047', 40.86689, -74.30435)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SLAA', N'Manheim St. Louis', N'yes', N'13813 St. Charles Rock Road', N'-', N'Bridgeton', N'MO', NULL, N'USA', N'(314) 298-3365', N'(314) 298-3365', 38.781665802001953, -90.452720642089844)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SMRT', N'SmartAuction', N'yes', N'-', N'-', N'-', N'MI', NULL, N'-', N'877-273-5572', N'-', 44.862617492675781, -85.735137939453125)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SONB', N'Manheim Birmingham', N'yes', N'5750 Highway 78 East', N'-', N'Birmingham', N'AL', '35210', N'USA', N'(205) 956-4700', N'(205) 956-8688', 33.552406311035156, -86.628250122070312)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SPAA', N'Manheim St. Pete', N'yes', N'14950 Roosevelt Blvd', N'-', N'Clearwater', N'FL', NULL, N'USA', N'(727)531-7717', N'(727)524-1937', 27.906791687011719, -82.6987075805664)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SSAA', N'Manheim Seattle', N'yes', N'19711 77th Avenue South', N'-', N'Kent', N'WA', '98032', N'USA', N'206-762-1600', N'253-395-2275', 47.424569427967072, -122.23890446126461)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SVAA', N'Manheim Statesville', N'yes', N'145 Auction Lane', N'-', N'Statesville', N'NC', '28625', N'USA', N'(704) 876-1111', N'(704) 978-2539', 35.842212677001953, -80.857872009277344)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SWAA', N'ADESA Phoenix', N'yes', N'400 N. Beck Avenue', N'-', N'Chandler', N'AZ', NULL, N'USA', N'(480) 961-1161', N'(480) 940-9008', 33.309661865234375, -111.95646667480469)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'SWFL', N'Manheim Ft. Myers', N'yes', N'2100 Rockfill Road', N'-', N'Ft. Myers', N'FL', '33916', N'USA', N'239-476-9846', N'239-476-9809', 26.64006233215332, -81.830741882324219)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'TAA', N'Manheim Toronto', N'yes', N'8277 Lawson Road', N'-', N'Milton', N'ON', NULL, N'Canada', N'(905) 275-3000', N'(905) 875-2910', 43.5419555, -79.8828761)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'TALA', N'Tallahassee Auto Auction', N'yes', N'5249 Capital Circle SW', N'-', N'Tallahassee', N'FL', '32305', N'USA', N'(850) 878-6200', N'(850) 942-9830', 30.376922607421875, -84.282821655273438)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'TBAA', N'Manheim Tampa', N'yes', N'401 South 50th Street', N'-', N'Tampa', N'FL', NULL, N'USA', N'(800) 622-7292', N'(813) 247-1714', 27.948028564453125, -82.406875610351562)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'TCAA', N'Manheim Tucson', N'yes', N'7090 South Craycroft', N'-', N'Tucson', N'AZ', '85706', N'USA', N'(520) 574 2222', N'(520) 574-2554', 32.143989562988281, -110.87503051757813)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'THAA', N'Manheim Texas Hobby', N'yes', N'8215 kopman dr', N'-', N'Houston', N'TX', NULL, N'USA', N'(713) 649-8233', N'(713) 640-8382', 29.636899948120117, -95.303863525390625)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'UAA', N'Manheim Utah', N'yes', N'1650 West 500 South', N'-', N'West Bountiful', N'UT', NULL, N'USA', N'(801) 298-7900', N'(801) 951-4111', 40.885097, -111.926437)
INSERT [Auctions] ([AuctionID], [Name], [Active], [Address_Line_1], [Address_Line_2], [City], [State], [ZIP], [Country], [Phone], [Fax], [Latitude], [Longitude]) VALUES (N'WPBA', N'Manheim Palm Beach', N'yes', N'600 SANSBURY WAY', N'-', N'WEST PALM BEACH', N'FL', '33411', N'USA', N'561-333-3511', N'(561) 753-1893', 26.687171936035156, -80.182647705078125)
*/
