Name: PointsofInterest

Display Field: coname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 012bcc26415c47218fc2226696979943

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: Object ID )
• esri_pid ( modelName: esri_pid, nullable: true, editable: true, defaultValue: null, length: 32, alias: Esri PID, type: esriFieldTypeString )
• coname ( modelName: coname, nullable: true, editable: true, defaultValue: null, length: 143, alias: Company/Business Name, type: esriFieldTypeString )
• street ( modelName: street, nullable: true, editable: true, defaultValue: null, length: 37, alias: Street, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 27, alias: City, type: esriFieldTypeString )
• state ( modelName: state, nullable: true, editable: true, defaultValue: null, length: 2, alias: State Abbreviation, type: esriFieldTypeString )
• state_name ( modelName: state_name, nullable: true, editable: true, defaultValue: null, length: 20, alias: State Name, type: esriFieldTypeString )
• zip ( modelName: zip, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIP Code, type: esriFieldTypeString )
• zip4 ( modelName: zip4, nullable: true, editable: true, defaultValue: null, length: 4, alias: ZIP+4 Extension, type: esriFieldTypeString )
• sic_all ( modelName: sic_all, nullable: true, editable: true, defaultValue: null, length: 398, alias: All SIC Codes, type: esriFieldTypeString )
• sic ( modelName: sic, nullable: true, editable: true, defaultValue: null, length: 6, alias: Primary SIC, type: esriFieldTypeString )
• naics_all ( modelName: naics_all, nullable: true, editable: true, defaultValue: null, length: 512, alias: All NAICS Codes, type: esriFieldTypeString )
• naics ( modelName: naics, nullable: true, editable: true, defaultValue: null, length: 8, alias: Primary NAICS, type: esriFieldTypeString )
• naics_sect ( modelName: naics_sect, nullable: true, editable: true, defaultValue: null, length: 40, alias: NAICS Industry Sector, type: esriFieldTypeString )
• esri_category_desc ( modelName: esri_category_desc, nullable: true, editable: true, defaultValue: null, length: 45, alias: Esri Category Description, type: esriFieldTypeString )
• salesvol ( modelName: salesvol, nullable: true, editable: true, defaultValue: null, alias: Sales Volume, type: esriFieldTypeDouble )
• empnum ( modelName: empnum, nullable: true, editable: true, defaultValue: null, alias: Employee Count, type: esriFieldTypeInteger )
• placetype ( modelName: placetype, nullable: true, editable: true, defaultValue: null, length: 12, alias: Business Category, type: esriFieldTypeString )
• hqname ( modelName: hqname, nullable: true, editable: true, defaultValue: null, length: 107, alias: Headquarters Name, type: esriFieldTypeString )
• corp_prnt ( modelName: corp_prnt, nullable: true, editable: true, defaultValue: null, length: 24, alias: Corporate Parent Name, type: esriFieldTypeString )
• sqfootage ( modelName: sqfootage, nullable: true, editable: true, defaultValue: null, length: 13, alias: Square Footage, type: esriFieldTypeString )
• min_sqft ( modelName: min_sqft, nullable: true, editable: true, defaultValue: null, alias: Square Foot Minimum, type: esriFieldTypeInteger )
• max_sqft ( modelName: max_sqft, nullable: true, editable: true, defaultValue: null, alias: Square Foot Maximum, type: esriFieldTypeInteger )
• affiliate ( modelName: affiliate, nullable: true, editable: true, defaultValue: null, length: 101, alias: Affiliated Orgs, type: esriFieldTypeString )
• brand ( modelName: brand, nullable: true, editable: true, defaultValue: null, length: 198, alias: Brands, type: esriFieldTypeString )
• loc_name ( modelName: loc_name, nullable: true, editable: true, defaultValue: null, length: 15, alias: Location Precision Level, type: esriFieldTypeString )
• loc_conf ( modelName: loc_conf, nullable: true, editable: true, defaultValue: null, length: 6, alias: Location Confidence, type: esriFieldTypeString )
• source ( modelName: source, nullable: true, editable: true, defaultValue: null, length: 9, alias: Source, type: esriFieldTypeString )
• lat ( modelName: lat, nullable: true, editable: true, defaultValue: null, alias: lat, type: esriFieldTypeDouble )
• lon ( modelName: lon, nullable: true, editable: true, defaultValue: null, alias: lon, type: esriFieldTypeDouble )

Templates:

• Name: PointsofInterest
  Description:
  Prototype:
  city: null
  coname: null
  zip4: null
  lon: null
  source: null
  sic: null
  min_sqft: null
  corp_prnt: null
  esri_category_desc: null
  naics_sect: null
  state_name: null
  street: null
  sic_all: null
  loc_name: null
  state: null
  brand: null
  lat: null
  zip: null
  placetype: null
  loc_conf: null
  sqfootage: null
  naics_all: null
  empnum: null
  esri_pid: null
  salesvol: null
  max_sqft: null
  hqname: null
  affiliate: null
  naics: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata