USE [your_dbname]
GO

/* Creates a SQL Server 2012 table that can be used to form the input for the DSHS   */
/* batch geocoding tool. */
/* This table meets the constraints of ArcGIS Desktop 10.3.1 for using a DBMS table  */
/* that is not registered with the geodatabase.  Load the source data into the       */
/* appropriate fields before exporting to the structured CSV file specified by the   */
/* batch geocoding tool. */

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [WAMAS_ACGC_IN_TEMPLATE](
	[OBJECTID] [int] IDENTITY(1,1) NOT NULL, --ArcGIS not null, unique ID requirement
--Uncomment the databaseID definition that aligns best with your input data id definition
	--[inDatabaseID_shortint] [smallint] NULL, --Data type and length should be based on the ID in your database
	--[inDatabaseID_longint] [int] NULL, --Data type and length should be based on the ID in your database
	--[inDatabaseID_float] [numeric](38, 8) NULL, --Data type and length should be based on the ID in your database
	--[inDatabaseID_double] [numeric](38, 8) NULL, --Data type and length should be based on the ID in your database
	--[inDatabaseID_text] [nvarchar](200) NULL, --Data type and length should be based on the ID in your database
	--[inDatabaseID_guid] [uniqueidentifier] NULL, --Data type and length should be based on the ID in your database
	[inCompany] [nvarchar](50) NULL, --or should match your database
	[inAddress1] [nvarchar](200) NULL, --or should match your database
	[inAddress2] [nvarchar](200) NULL, --or should match your database
	[inCity] [nvarchar](50) NULL, --or should match your database
	[inState_full] [nvarchar](25) NULL, --or should match your database
	[inState_abbr] [nvarchar](2) NULL, --or should match your database
	[inZip] [nvarchar](5) NULL, --or should match your database
	[inPlus4] [nvarchar](4) NULL, --or should match your database
PRIMARY KEY CLUSTERED 
(
	[OBJECTID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO