Name: Sheet1_GeocodeAddresses1

Display Field: Loc_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8236370.29782026
YMin: 4975545.04192607
XMax: -8213485.76400077
YMax: 4999459.86907169
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[115,160,64,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: ObjectID

Unique ID Field:

Name : ObjectID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• ObjectID (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Loc_name (type: esriFieldTypeString, alias: Loc_name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• Score (type: esriFieldTypeDouble, alias: Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Match_type (type: esriFieldTypeString, alias: Match_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• Match_addr (type: esriFieldTypeString, alias: Match_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LongLabel (type: esriFieldTypeString, alias: LongLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ShortLabel (type: esriFieldTypeString, alias: ShortLabel, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Addr_type (type: esriFieldTypeString, alias: Addr_type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PlaceName (type: esriFieldTypeString, alias: PlaceName, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Place_addr (type: esriFieldTypeString, alias: Place_addr, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• URL (type: esriFieldTypeString, alias: URL, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Rank (type: esriFieldTypeDouble, alias: Rank, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddBldg (type: esriFieldTypeString, alias: BuildingName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• AddNum (type: esriFieldTypeString, alias: AddressNumber, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumFrom (type: esriFieldTypeString, alias: AddNumFrom, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddNumTo (type: esriFieldTypeString, alias: AddNumTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddRange (type: esriFieldTypeString, alias: AddressRange, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• StPreDir (type: esriFieldTypeString, alias: StPreDir, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• StPreType (type: esriFieldTypeString, alias: StPreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StName (type: esriFieldTypeString, alias: StName, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• StType (type: esriFieldTypeString, alias: StType, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• StDir (type: esriFieldTypeString, alias: StDir, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgType (type: esriFieldTypeString, alias: BldgType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LevelType (type: esriFieldTypeString, alias: LevelType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LevelName (type: esriFieldTypeString, alias: LevelName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitType (type: esriFieldTypeString, alias: UnitType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• UnitName (type: esriFieldTypeString, alias: UnitName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SubAddr (type: esriFieldTypeString, alias: SubAddress, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• StAddr (type: esriFieldTypeString, alias: StAddr, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Block (type: esriFieldTypeString, alias: Block, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Nbrhd (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• District (type: esriFieldTypeString, alias: District, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• MetroArea (type: esriFieldTypeString, alias: MetroArea, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Subregion (type: esriFieldTypeString, alias: Subregion, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• RegionAbbr (type: esriFieldTypeString, alias: RegionAbbr, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Territory (type: esriFieldTypeString, alias: Territory, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Zone (type: esriFieldTypeString, alias: Zone, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Postal (type: esriFieldTypeString, alias: Postal, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PostalExt (type: esriFieldTypeString, alias: PostalExt, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• CntryName (type: esriFieldTypeString, alias: CountryName, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LangCode (type: esriFieldTypeString, alias: LangCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Distance (type: esriFieldTypeDouble, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayX (type: esriFieldTypeDouble, alias: DisplayX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisplayY (type: esriFieldTypeDouble, alias: DisplayY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmin (type: esriFieldTypeDouble, alias: Xmin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Xmax (type: esriFieldTypeDouble, alias: Xmax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymin (type: esriFieldTypeDouble, alias: Ymin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ymax (type: esriFieldTypeDouble, alias: Ymax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ExInfo (type: esriFieldTypeString, alias: ExtraInfo, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• IN_Address (type: esriFieldTypeString, alias: Address or Place, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Address3 (type: esriFieldTypeString, alias: Address3, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• IN_Neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Subregion (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Region (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IN_Postal (type: esriFieldTypeString, alias: ZIP, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_PostalExt (type: esriFieldTypeString, alias: ZIP4, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• IN_CountryCode (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_Vendor_Formal_Name (type: esriFieldTypeString, alias: Vendor_Formal_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Vendor_DBA (type: esriFieldTypeString, alias: Vendor_DBA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Contact_Name (type: esriFieldTypeString, alias: Contact_Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_telephone (type: esriFieldTypeDouble, alias: telephone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_fax (type: esriFieldTypeDouble, alias: fax, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_certification (type: esriFieldTypeString, alias: certification, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Cert_Renewal_Date (type: esriFieldTypeString, alias: Cert_Renewal_Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Ethnicity (type: esriFieldTypeString, alias: Ethnicity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Address1 (type: esriFieldTypeString, alias: Address1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Address2 (type: esriFieldTypeString, alias: Address2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_ZIP (type: esriFieldTypeDouble, alias: ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_MailingAddress1 (type: esriFieldTypeString, alias: MailingAddress1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_MailingAddress2 (type: esriFieldTypeString, alias: MailingAddress2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_MailingCity (type: esriFieldTypeString, alias: MailingCity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_MailingState (type: esriFieldTypeString, alias: MailingState, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_MailingZip (type: esriFieldTypeString, alias: MailingZip, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Date_Of_Establishment (type: esriFieldTypeString, alias: Date_Of_Establishment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Aggregate_Bonding_Limit (type: esriFieldTypeString, alias: Aggregate_Bonding_Limit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Signatory_To_Union_Contrac (type: esriFieldTypeString, alias: Signatory_To_Union_Contracts, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Business_Description (type: esriFieldTypeString, alias: Business_Description, SQL Type: sqlTypeOther, length: 32767, nullable: true, editable: true)
• USER_Goods_Materials_Suplier (type: esriFieldTypeString, alias: Goods_Materials_Suplier, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Types_of_Construction_Proj (type: esriFieldTypeString, alias: Types_of_Construction_Projects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp1_Name_of_Client (type: esriFieldTypeString, alias: Job_Exp1_Name_of_Client, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp1_Value_of_Contract (type: esriFieldTypeDouble, alias: Job_Exp1_Value_of_Contract, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Job_Exp1_Percent_Self_Perf (type: esriFieldTypeDouble, alias: Job_Exp1_Percent_Self_Performed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DATEOFJOB1 (type: esriFieldTypeString, alias: DATEOFJOB1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_EXPERIENCE1 (type: esriFieldTypeString, alias: EXPERIENCE1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp2_Name_of_Client (type: esriFieldTypeString, alias: Job_Exp2_Name_of_Client, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp2_Value_of_Contract (type: esriFieldTypeDouble, alias: Job_Exp2_Value_of_Contract, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Job_Exp2_Percent_Self_Perf (type: esriFieldTypeDouble, alias: Job_Exp2_Percent_Self_Performed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DATEOFJOB2 (type: esriFieldTypeString, alias: DATEOFJOB2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_EXPERIENCE2 (type: esriFieldTypeString, alias: EXPERIENCE2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp3_Name_of_Client (type: esriFieldTypeString, alias: Job_Exp3_Name_of_Client, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp3_Value_of_Contract (type: esriFieldTypeDouble, alias: Job_Exp3_Value_of_Contract, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Job_Exp3_Percent_Self_Perf (type: esriFieldTypeDouble, alias: Job_Exp3_Percent_Self_Performed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DATEOFJOB3 (type: esriFieldTypeString, alias: DATEOFJOB3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_EXPERIENCE3 (type: esriFieldTypeString, alias: EXPERIENCE3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp4_Name_of_Client (type: esriFieldTypeString, alias: Job_Exp4_Name_of_Client, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_Job_Exp4_Value_of_Contract (type: esriFieldTypeDouble, alias: Job_Exp4_Value_of_Contract, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_Job_Exp4_Percent_Self_Perf (type: esriFieldTypeDouble, alias: Job_Exp4_Percent_Self_Performed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• USER_DATEOFJOB4 (type: esriFieldTypeString, alias: DATEOFJOB4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_EXPERIENCE4 (type: esriFieldTypeString, alias: EXPERIENCE4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F46 (type: esriFieldTypeString, alias: F46, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F47 (type: esriFieldTypeString, alias: F47, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F48 (type: esriFieldTypeString, alias: F48, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F49 (type: esriFieldTypeString, alias: F49, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F50 (type: esriFieldTypeString, alias: F50, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F51 (type: esriFieldTypeString, alias: F51, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• USER_F52 (type: esriFieldTypeString, alias: F52, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Sheet1_GeocodeAddresses1
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• USER_F51:
• USER_F52:
• IN_Address:
• IN_Address2:
• IN_Address3:
• IN_Neighborhood:
• IN_City:
• IN_Subregion:
• IN_Region:
• IN_Postal:
• IN_PostalExt:
• IN_CountryCode:
• USER_Vendor_Formal_Name:
• USER_Vendor_DBA:
• USER_Contact_Name:
• USER_certification:
• USER_Cert_Renewal_Date:
• USER_Ethnicity:
• USER_Address1:
• USER_Address2:
• USER_City:
• USER_State:
• USER_MailingAddress1:
• USER_MailingAddress2:
• USER_MailingCity:
• USER_MailingState:
• USER_MailingZip:
• USER_Website:
• USER_Date_Of_Establishment:
• USER_Aggregate_Bonding_Limit:
• USER_Signatory_To_Union_Contrac:
• USER_Business_Description:
• USER_Goods_Materials_Suplier:
• USER_Types_of_Construction_Proj:
• USER_Job_Exp1_Name_of_Client:
• USER_DATEOFJOB1:
• USER_EXPERIENCE1:
• USER_Job_Exp2_Name_of_Client:
• USER_DATEOFJOB2:
• USER_EXPERIENCE2:
• USER_Job_Exp3_Name_of_Client:
• USER_DATEOFJOB3:
• USER_EXPERIENCE3:
• USER_Job_Exp4_Name_of_Client:
• USER_DATEOFJOB4:
• USER_EXPERIENCE4:
• USER_F46:
• USER_F47:
• USER_F48:
• USER_F49:
• USER_F50:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/29/2022 11:04:42 PM

Schema Last Edit Date: 7/29/2022 11:04:42 PM

Data Last Edit Date: 7/29/2022 11:04:42 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat