View In:   ArcGIS Online Map Viewer

Name: DBO.dataAxle_mixedbusiness_points

Display Field: LAST_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c6935907258648efacdfcafdd0ff6f9e

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.31839117392E7
YMin: 3989331.156300001
XMax: -1.31586614681E7
YMax: 4023709.673100002
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [72, 155, 37, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Date_List ( type: esriFieldTypeString, alias: Date List, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Date_List )
• Record_Obs ( type: esriFieldTypeString, alias: Record Obs, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Record_Obs )
• Source ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Source )
• COMPANY_NA ( type: esriFieldTypeString, alias: COMPANY NA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMPANY_NA )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADDRESS )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: STATE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: STATE )
• ZIP_CODE ( type: esriFieldTypeString, alias: ZIP CODE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ZIP_CODE )
• MAILING_CA ( type: esriFieldTypeString, alias: MAILING CA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MAILING_CA )
• MAILING_DE ( type: esriFieldTypeDouble, alias: MAILING DE, editable: true, nullable: true, defaultValue: null, modelName: MAILING_DE )
• LOCATION_A ( type: esriFieldTypeString, alias: LOCATION A, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION_A )
• LOCATION_1 ( type: esriFieldTypeString, alias: LOCATION_1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION_1 )
• LOCATION_2 ( type: esriFieldTypeString, alias: LOCATION_2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION_2 )
• LOCATION_3 ( type: esriFieldTypeString, alias: LOCATION_3, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION_3 )
• LOCATION_4 ( type: esriFieldTypeDouble, alias: LOCATION_4, editable: true, nullable: true, defaultValue: null, modelName: LOCATION_4 )
• LOCATION_5 ( type: esriFieldTypeString, alias: LOCATION_5, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION_5 )
• COUNTY ( type: esriFieldTypeString, alias: COUNTY, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COUNTY )
• PRIMARY_SI ( type: esriFieldTypeInteger, alias: PRIMARY SI, editable: true, nullable: true, defaultValue: null, modelName: PRIMARY_SI )
• PRIMARY__1 ( type: esriFieldTypeString, alias: PRIMARY _1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PRIMARY__1 )
• SECONDARY ( type: esriFieldTypeInteger, alias: SECONDARY, editable: true, nullable: true, defaultValue: null, modelName: SECONDARY )
• SECONDAR_1 ( type: esriFieldTypeString, alias: SECONDAR_1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SECONDAR_1 )
• SECONDAR_2 ( type: esriFieldTypeDouble, alias: SECONDAR_2, editable: true, nullable: true, defaultValue: null, modelName: SECONDAR_2 )
• SECONDAR_3 ( type: esriFieldTypeString, alias: SECONDAR_3, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SECONDAR_3 )
• METRO_AREA ( type: esriFieldTypeString, alias: METRO AREA, editable: true, nullable: true, length: 254, defaultValue: null, modelName: METRO_AREA )
• DATA_AXLE ( type: esriFieldTypeInteger, alias: DATA AXLE, editable: true, nullable: true, defaultValue: null, modelName: DATA_AXLE )
• LAST_NAME ( type: esriFieldTypeString, alias: LAST NAME, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LAST_NAME )
• FIRST_NAME ( type: esriFieldTypeString, alias: FIRST NAME, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FIRST_NAME )
• CONTACT_PR ( type: esriFieldTypeString, alias: CONTACT PR, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CONTACT_PR )
• CONTACT_TI ( type: esriFieldTypeString, alias: CONTACT TI, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CONTACT_TI )
• CONTACT_GE ( type: esriFieldTypeString, alias: CONTACT GE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CONTACT_GE )
• EMPLOYEE_S ( type: esriFieldTypeString, alias: EMPLOYEE S, editable: true, nullable: true, length: 254, defaultValue: null, modelName: EMPLOYEE_S )
• SALES_VOLU ( type: esriFieldTypeString, alias: SALES VOLU, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SALES_VOLU )
• ACTUAL_EMP ( type: esriFieldTypeInteger, alias: ACTUAL EMP, editable: true, nullable: true, defaultValue: null, modelName: ACTUAL_EMP )
• ACTUAL_SAL ( type: esriFieldTypeDouble, alias: ACTUAL SAL, editable: true, nullable: true, defaultValue: null, modelName: ACTUAL_SAL )
• lat ( type: esriFieldTypeDouble, alias: lat, editable: true, nullable: true, defaultValue: null, modelName: lat )
• long ( type: esriFieldTypeDouble, alias: long, editable: true, nullable: true, defaultValue: null, modelName: long )
• Match_Code ( type: esriFieldTypeString, alias: Match Code, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Match_Code )
• PRIMARY_NA ( type: esriFieldTypeInteger, alias: PRIMARY NA, editable: true, nullable: true, defaultValue: null, modelName: PRIMARY_NA )
• PRIMARY__2 ( type: esriFieldTypeString, alias: PRIMARY _2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PRIMARY__2 )
• sector ( type: esriFieldTypeInteger, alias: sector, editable: true, nullable: true, defaultValue: null, modelName: sector )
• sector_des ( type: esriFieldTypeString, alias: sector_des, editable: true, nullable: true, length: 254, defaultValue: null, modelName: sector_des )
• subsector ( type: esriFieldTypeInteger, alias: subsector, editable: true, nullable: true, defaultValue: null, modelName: subsector )
• subsector_ ( type: esriFieldTypeString, alias: subsector_, editable: true, nullable: true, length: 254, defaultValue: null, modelName: subsector_ )
• half_grand ( type: esriFieldTypeDouble, alias: half_grand, editable: true, nullable: true, defaultValue: null, modelName: half_grand )
• half_tot_6 ( type: esriFieldTypeDouble, alias: half_tot_6, editable: true, nullable: true, defaultValue: null, modelName: half_tot_6 )
• half_pct_6 ( type: esriFieldTypeDouble, alias: half_pct_6, editable: true, nullable: true, defaultValue: null, modelName: half_pct_6 )
• half_tot_7 ( type: esriFieldTypeDouble, alias: half_tot_7, editable: true, nullable: true, defaultValue: null, modelName: half_tot_7 )
• half_pct_7 ( type: esriFieldTypeDouble, alias: half_pct_7, editable: true, nullable: true, defaultValue: null, modelName: half_pct_7 )
• half_tot_8 ( type: esriFieldTypeDouble, alias: half_tot_8, editable: true, nullable: true, defaultValue: null, modelName: half_tot_8 )
• half_pct_8 ( type: esriFieldTypeDouble, alias: half_pct_8, editable: true, nullable: true, defaultValue: null, modelName: half_pct_8 )
• half_tot_5 ( type: esriFieldTypeDouble, alias: half_tot_5, editable: true, nullable: true, defaultValue: null, modelName: half_tot_5 )
• half_pct_5 ( type: esriFieldTypeDouble, alias: half_pct_5, editable: true, nullable: true, defaultValue: null, modelName: half_pct_5 )
• half_tot_4 ( type: esriFieldTypeDouble, alias: half_tot_4, editable: true, nullable: true, defaultValue: null, modelName: half_tot_4 )
• half_pct_4 ( type: esriFieldTypeDouble, alias: half_pct_4, editable: true, nullable: true, defaultValue: null, modelName: half_pct_4 )
• half_tot_1 ( type: esriFieldTypeDouble, alias: half_tot_1, editable: true, nullable: true, defaultValue: null, modelName: half_tot_1 )
• half_pct_1 ( type: esriFieldTypeDouble, alias: half_pct_1, editable: true, nullable: true, defaultValue: null, modelName: half_pct_1 )
• half_tot_2 ( type: esriFieldTypeDouble, alias: half_tot_2, editable: true, nullable: true, defaultValue: null, modelName: half_tot_2 )
• half_pct_2 ( type: esriFieldTypeDouble, alias: half_pct_2, editable: true, nullable: true, defaultValue: null, modelName: half_pct_2 )
• half_tot_3 ( type: esriFieldTypeDouble, alias: half_tot_3, editable: true, nullable: true, defaultValue: null, modelName: half_tot_3 )
• half_pct_3 ( type: esriFieldTypeDouble, alias: half_pct_3, editable: true, nullable: true, defaultValue: null, modelName: half_pct_3 )
• half_tot_9 ( type: esriFieldTypeDouble, alias: half_tot_9, editable: true, nullable: true, defaultValue: null, modelName: half_tot_9 )
• half_pct_9 ( type: esriFieldTypeDouble, alias: half_pct_9, editable: true, nullable: true, defaultValue: null, modelName: half_pct_9 )
• half_tot10 ( type: esriFieldTypeDouble, alias: half_tot10, editable: true, nullable: true, defaultValue: null, modelName: half_tot10 )
• half_pct10 ( type: esriFieldTypeDouble, alias: half_pct10, editable: true, nullable: true, defaultValue: null, modelName: half_pct10 )
• half_tot11 ( type: esriFieldTypeDouble, alias: half_tot11, editable: true, nullable: true, defaultValue: null, modelName: half_tot11 )
• half_pct11 ( type: esriFieldTypeDouble, alias: half_pct11, editable: true, nullable: true, defaultValue: null, modelName: half_pct11 )
• half_tot12 ( type: esriFieldTypeDouble, alias: half_tot12, editable: true, nullable: true, defaultValue: null, modelName: half_tot12 )
• half_pct12 ( type: esriFieldTypeDouble, alias: half_pct12, editable: true, nullable: true, defaultValue: null, modelName: half_pct12 )
• half_tot13 ( type: esriFieldTypeDouble, alias: half_tot13, editable: true, nullable: true, defaultValue: null, modelName: half_tot13 )
• half_pct13 ( type: esriFieldTypeDouble, alias: half_pct13, editable: true, nullable: true, defaultValue: null, modelName: half_pct13 )
• half_media ( type: esriFieldTypeDouble, alias: half_media, editable: true, nullable: true, defaultValue: null, modelName: half_media )
• half_tot14 ( type: esriFieldTypeDouble, alias: half_tot14, editable: true, nullable: true, defaultValue: null, modelName: half_tot14 )
• half_pct14 ( type: esriFieldTypeDouble, alias: half_pct14, editable: true, nullable: true, defaultValue: null, modelName: half_pct14 )
• quarter_gr ( type: esriFieldTypeDouble, alias: quarter_gr, editable: true, nullable: true, defaultValue: null, modelName: quarter_gr )
• quarter_to ( type: esriFieldTypeDouble, alias: quarter_to, editable: true, nullable: true, defaultValue: null, modelName: quarter_to )
• quarter_pc ( type: esriFieldTypeDouble, alias: quarter_pc, editable: true, nullable: true, defaultValue: null, modelName: quarter_pc )
• quarter__1 ( type: esriFieldTypeDouble, alias: quarter__1, editable: true, nullable: true, defaultValue: null, modelName: quarter__1 )
• quarter__2 ( type: esriFieldTypeDouble, alias: quarter__2, editable: true, nullable: true, defaultValue: null, modelName: quarter__2 )
• quarter__3 ( type: esriFieldTypeDouble, alias: quarter__3, editable: true, nullable: true, defaultValue: null, modelName: quarter__3 )
• quarter__4 ( type: esriFieldTypeDouble, alias: quarter__4, editable: true, nullable: true, defaultValue: null, modelName: quarter__4 )
• quarter__5 ( type: esriFieldTypeDouble, alias: quarter__5, editable: true, nullable: true, defaultValue: null, modelName: quarter__5 )
• quarter__6 ( type: esriFieldTypeDouble, alias: quarter__6, editable: true, nullable: true, defaultValue: null, modelName: quarter__6 )
• quarter__7 ( type: esriFieldTypeDouble, alias: quarter__7, editable: true, nullable: true, defaultValue: null, modelName: quarter__7 )
• quarter__8 ( type: esriFieldTypeDouble, alias: quarter__8, editable: true, nullable: true, defaultValue: null, modelName: quarter__8 )
• quarter__9 ( type: esriFieldTypeDouble, alias: quarter__9, editable: true, nullable: true, defaultValue: null, modelName: quarter__9 )
• quarter_10 ( type: esriFieldTypeDouble, alias: quarter_10, editable: true, nullable: true, defaultValue: null, modelName: quarter_10 )
• quarter_11 ( type: esriFieldTypeDouble, alias: quarter_11, editable: true, nullable: true, defaultValue: null, modelName: quarter_11 )
• quarter_12 ( type: esriFieldTypeDouble, alias: quarter_12, editable: true, nullable: true, defaultValue: null, modelName: quarter_12 )
• quarter_13 ( type: esriFieldTypeDouble, alias: quarter_13, editable: true, nullable: true, defaultValue: null, modelName: quarter_13 )
• quarter_14 ( type: esriFieldTypeDouble, alias: quarter_14, editable: true, nullable: true, defaultValue: null, modelName: quarter_14 )
• quarter_15 ( type: esriFieldTypeDouble, alias: quarter_15, editable: true, nullable: true, defaultValue: null, modelName: quarter_15 )
• quarter_16 ( type: esriFieldTypeDouble, alias: quarter_16, editable: true, nullable: true, defaultValue: null, modelName: quarter_16 )
• quarter_17 ( type: esriFieldTypeDouble, alias: quarter_17, editable: true, nullable: true, defaultValue: null, modelName: quarter_17 )
• quarter_18 ( type: esriFieldTypeDouble, alias: quarter_18, editable: true, nullable: true, defaultValue: null, modelName: quarter_18 )
• quarter_19 ( type: esriFieldTypeDouble, alias: quarter_19, editable: true, nullable: true, defaultValue: null, modelName: quarter_19 )
• quarter_20 ( type: esriFieldTypeDouble, alias: quarter_20, editable: true, nullable: true, defaultValue: null, modelName: quarter_20 )
• quarter_me ( type: esriFieldTypeDouble, alias: quarter_me, editable: true, nullable: true, defaultValue: null, modelName: quarter_me )
• quarter_21 ( type: esriFieldTypeDouble, alias: quarter_21, editable: true, nullable: true, defaultValue: null, modelName: quarter_21 )
• quarter_22 ( type: esriFieldTypeDouble, alias: quarter_22, editable: true, nullable: true, defaultValue: null, modelName: quarter_22 )
• quarter_23 ( type: esriFieldTypeDouble, alias: quarter_23, editable: true, nullable: true, defaultValue: null, modelName: quarter_23 )
• quarter_24 ( type: esriFieldTypeDouble, alias: quarter_24, editable: true, nullable: true, defaultValue: null, modelName: quarter_24 )
• quarter_25 ( type: esriFieldTypeDouble, alias: quarter_25, editable: true, nullable: true, defaultValue: null, modelName: quarter_25 )
• quarter_26 ( type: esriFieldTypeDouble, alias: quarter_26, editable: true, nullable: true, defaultValue: null, modelName: quarter_26 )
• F__index_le ( type: esriFieldTypeDouble, alias: __index_le, editable: true, nullable: true, defaultValue: null, modelName: F__index_le )

Templates:

• Name: DBO.dataAxle_mixedbusiness_points
  Description:
  Prototype:
  quarter_26: null
  Date_List: null
  Record_Obs: null
  Source: null
  COMPANY_NA: null
  ADDRESS: null
  CITY: null
  STATE: null
  ZIP_CODE: null
  MAILING_CA: null
  MAILING_DE: null
  LOCATION_A: null
  LOCATION_1: null
  LOCATION_2: null
  LOCATION_3: null
  LOCATION_4: null
  LOCATION_5: null
  COUNTY: null
  PRIMARY_SI: null
  PRIMARY__1: null
  SECONDARY: null
  SECONDAR_1: null
  SECONDAR_2: null
  SECONDAR_3: null
  METRO_AREA: null
  DATA_AXLE: null
  LAST_NAME: null
  FIRST_NAME: null
  CONTACT_PR: null
  CONTACT_TI: null
  CONTACT_GE: null
  EMPLOYEE_S: null
  SALES_VOLU: null
  ACTUAL_EMP: null
  ACTUAL_SAL: null
  lat: null
  long: null
  Match_Code: null
  PRIMARY_NA: null
  PRIMARY__2: null
  sector: null
  sector_des: null
  subsector: null
  subsector_: null
  half_grand: null
  half_tot_6: null
  half_pct_6: null
  half_tot_7: null
  half_pct_7: null
  half_tot_8: null
  half_pct_8: null
  half_tot_5: null
  half_pct_5: null
  half_tot_4: null
  half_pct_4: null
  half_tot_1: null
  half_pct_1: null
  half_tot_2: null
  half_pct_2: null
  half_tot_3: null
  half_pct_3: null
  half_tot_9: null
  half_pct_9: null
  half_tot10: null
  half_pct10: null
  half_tot11: null
  half_pct11: null
  half_tot12: null
  half_pct12: null
  half_tot13: null
  half_pct13: null
  half_media: null
  half_tot14: null
  half_pct14: null
  quarter_gr: null
  quarter_to: null
  quarter_pc: null
  quarter__1: null
  quarter__2: null
  quarter__3: null
  quarter__4: null
  quarter__5: null
  quarter__6: null
  quarter__7: null
  quarter__8: null
  quarter__9: null
  quarter_10: null
  quarter_11: null
  quarter_12: null
  quarter_13: null
  quarter_14: null
  quarter_15: null
  quarter_16: null
  quarter_17: null
  quarter_18: null
  quarter_19: null
  quarter_20: null
  quarter_me: null
  quarter_21: null
  quarter_22: null
  quarter_23: null
  quarter_24: null
  quarter_25: null
  F__index_le: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata