Name: Dairy Farms / Cheese Manufacturing

Display Field: BusName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: D&B 20150101 Dairy Cattle Farms Points for the United States, including Puerto Rico and the US Virgin Islands, Canada, and Mexico, Released Quarterly including feature types for NAICS 11212 - "Dairy Cattle and Milk Production" and all child NAICS codes, SIC 0240 - "Dairy farms".

Copyright Text: D&B data is collected from thousands of sources around the world including interviews with business principals, financial statements, public databases, corporate trade tapes, legal proceedings, yellow-pages, websites, and other information.

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 1500

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -17745071.8937997
YMin: 1960272.92116532
XMax: -5865904.75877832
YMax: 9345691.98748736
Spatial Reference: 3395 (3395)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,77,168,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.5}},"label":"","description":""},"transparency":30,"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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• RecordId (type: esriFieldTypeInteger, alias: Record Id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BusName (type: esriFieldTypeString, alias: Business Name, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• OffName (type: esriFieldTypeString, alias: Office Name, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• Address2 (type: esriFieldTypeString, alias: Secondary Address, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CountyFIPS (type: esriFieldTypeString, alias: CountyFIPS, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZipCode (type: esriFieldTypeString, alias: ZipCode, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ZipPlus4 (type: esriFieldTypeString, alias: Zip Code +4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SourceType (type: esriFieldTypeString, alias: Source Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SourceDate (type: esriFieldTypeDate, alias: SourceDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PosAcc (type: esriFieldTypeString, alias: Positional Reliability, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• Sector (type: esriFieldTypeString, alias: Sector, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Layer (type: esriFieldTypeString, alias: Layer, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SubTypeC (type: esriFieldTypeString, alias: Primary Subtype Code, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Subtype (type: esriFieldTypeString, alias: Primary Subtype Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SubType2C (type: esriFieldTypeString, alias: Primary Subtype Code 2, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Subtype2 (type: esriFieldTypeString, alias: Primary Subtype Code 2 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LocType (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ManFactSta (type: esriFieldTypeString, alias: Manufacturing Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NAICSCode (type: esriFieldTypeString, alias: NAICS Code, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• NAICSDesc (type: esriFieldTypeString, alias: NAICS Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SICCode (type: esriFieldTypeString, alias: SIC Code, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SICDesc (type: esriFieldTypeString, alias: SIC Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SICCode1 (type: esriFieldTypeString, alias: Second SIC Code, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SICCode1De (type: esriFieldTypeString, alias: Second SIC Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SICCode2 (type: esriFieldTypeString, alias: Third SIC Code, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SICCode2De (type: esriFieldTypeString, alias: Third SIC Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC2_2C1 (type: esriFieldTypeString, alias: Second Subtype Code, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SIC2_2C1De (type: esriFieldTypeString, alias: Second Subtype Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SIC2_2C2 (type: esriFieldTypeString, alias: Third Subtype Code, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SIC2_2C2De (type: esriFieldTypeString, alias: Third Subtype Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Telephone (type: esriFieldTypeString, alias: Telephone, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• EConName (type: esriFieldTypeString, alias: Emergency Contact Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• EConTitle (type: esriFieldTypeString, alias: Emergency Contact Title, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• eTelephone (type: esriFieldTypeString, alias: Emergency Telephone, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• EmerFax (type: esriFieldTypeString, alias: Emergency Fax, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• UseStatus (type: esriFieldTypeString, alias: Use Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EmploySize (type: esriFieldTypeString, alias: Employment Size Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TotPerson (type: esriFieldTypeInteger, alias: Total Personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CorpEmSize (type: esriFieldTypeString, alias: Corporate Employment Size Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TotCorpPer (type: esriFieldTypeInteger, alias: Total Corporate Personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AnSaleVolC (type: esriFieldTypeString, alias: Annual Corporate Sales Volume Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AnnSaleVol (type: esriFieldTypeDouble, alias: Annual Corporate Sales Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Area (type: esriFieldTypeDouble, alias: Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AreaUnits (type: esriFieldTypeString, alias: Area Units, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Website (type: esriFieldTypeString, alias: Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Dairy Farms / Cheese Manufacturing
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/30/2022 4:36:08 PM

Schema Last Edit Date: 11/30/2022 4:36:08 PM

Data Last Edit Date: 11/29/2022 6:33:43 PM

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