View In:   ArcGIS Online Map Viewer

Name: SDE.Business_License

Display Field: custCOMPANY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: fb9b6f98cfb14471ad34179057541c0e

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 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: -86.31046075373888
YMin: 32.37894340604544
XMax: 721337.5409799963
YMax: 751319.4160644859
Spatial Reference: 102629  (102629)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 255, 197, 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 )
• PaccNumber ( type: esriFieldTypeString, alias: PaccNumber, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: PaccNumber )
• custCOMPANY_NAME ( type: esriFieldTypeString, alias: custCOMPANY_NAME, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: custCOMPANY_NAME )
• custDBA ( type: esriFieldTypeString, alias: custDBA, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: custDBA )
• pvNUMBER ( type: esriFieldTypeBigInteger, alias: pvNUMBER, editable: true, nullable: true, defaultValue: null, modelName: pvNUMBER )
• custID ( type: esriFieldTypeInteger, alias: custID, editable: true, nullable: true, defaultValue: 0, modelName: custID )
• pvYEAR ( type: esriFieldTypeInteger, alias: pvYEAR, editable: true, nullable: true, defaultValue: 0, modelName: pvYEAR )
• pvEFFDATE ( type: esriFieldTypeDateOnly, alias: pvEFFDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pvEFFDATE )
• pvEXPIRE ( type: esriFieldTypeDateOnly, alias: pvEXPIRE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pvEXPIRE )
• contCREATED ( type: esriFieldTypeDateOnly, alias: contCREATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: contCREATED )
• contCALCDATE ( type: esriFieldTypeDateOnly, alias: contCALCDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: contCALCDATE )
• contPOSTDATE ( type: esriFieldTypeDateOnly, alias: contPOSTDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: contPOSTDATE )
• paccCOMPANY ( type: esriFieldTypeString, alias: paccCOMPANY, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: paccCOMPANY )
• addrNUMBER_MAIL ( type: esriFieldTypeString, alias: addrNUMBER_MAIL, editable: true, nullable: true, length: 1073741822, defaultValue: 0, modelName: addrNUMBER_MAIL )
• addrSTREET1_MAIL ( type: esriFieldTypeString, alias: addrSTREET1_MAIL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: addrSTREET1_MAIL )
• addrSTREET2_MAIL ( type: esriFieldTypeString, alias: addrSTREET2_MAIL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: addrSTREET2_MAIL )
• addrCITY_MAIL ( type: esriFieldTypeString, alias: addrCITY_MAIL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: addrCITY_MAIL )
• stABBR_MAIL ( type: esriFieldTypeString, alias: stABBR_MAIL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: stABBR_MAIL )
• addrZIP_MAIL ( type: esriFieldTypeDouble, alias: addrZIP_MAIL, editable: true, nullable: true, defaultValue: 0, modelName: addrZIP_MAIL )
• Full_Address ( type: esriFieldTypeString, alias: Full_Address, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: Full_Address )
• addrNUMBER_PHYSICAL ( type: esriFieldTypeString, alias: addrNUMBER_PHYSICAL, editable: true, nullable: true, length: 1073741822, defaultValue: 0, modelName: addrNUMBER_PHYSICAL )
• addrSTREET1_PHYSICAL ( type: esriFieldTypeString, alias: addrSTREET1_PHYSICAL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: addrSTREET1_PHYSICAL )
• addrSTREET2_PHYSICAL ( type: esriFieldTypeString, alias: addrSTREET2_PHYSICAL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: addrSTREET2_PHYSICAL )
• addrZIP_PHYSICAL ( type: esriFieldTypeDouble, alias: addrZIP_PHYSICAL, editable: true, nullable: true, defaultValue: 0, modelName: addrZIP_PHYSICAL )
• scID ( type: esriFieldTypeInteger, alias: scID, editable: true, nullable: true, defaultValue: 0, modelName: scID )
• scCODE ( type: esriFieldTypeString, alias: scCODE, editable: true, nullable: true, length: 1073741822, defaultValue: 0, modelName: scCODE )
• scNAME ( type: esriFieldTypeString, alias: scNAME, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: scNAME )
• pvscDESC ( type: esriFieldTypeString, alias: pvscDESC, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: pvscDESC )
• nbiCODE ( type: esriFieldTypeString, alias: nbiCODE, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: nbiCODE )
• pvrtCODE ( type: esriFieldTypeString, alias: pvrtCODE, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: pvrtCODE )
• pvrtDESC ( type: esriFieldTypeString, alias: pvrtDESC, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: pvrtDESC )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CITY )
• addrCITY_PHYSICAL ( type: esriFieldTypeString, alias: addrCITY_PHYSICAL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: addrCITY_PHYSICAL )
• stABBR_PHYSICAL ( type: esriFieldTypeString, alias: stABBR_PHYSICAL, editable: true, nullable: true, length: 1073741822, defaultValue: , modelName: stABBR_PHYSICAL )
• Id ( type: esriFieldTypeInteger, alias: Id, editable: true, nullable: true, defaultValue: null, modelName: Id )
• postYear ( type: esriFieldTypeString, alias: postYear, editable: true, nullable: true, length: 4, defaultValue: null, modelName: postYear )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: SDE.Business_License
  Description:
  Prototype:
  postYear: null
  Id: null
  PaccNumber:
  custCOMPANY_NAME:
  custDBA:
  pvNUMBER: null
  custID: 0
  pvYEAR: 0
  pvEFFDATE: null
  pvEXPIRE: null
  contCREATED: null
  contCALCDATE: null
  contPOSTDATE: null
  paccCOMPANY:
  addrNUMBER_MAIL: 0
  addrSTREET1_MAIL:
  addrSTREET2_MAIL:
  addrCITY_MAIL:
  stABBR_MAIL:
  addrZIP_MAIL: 0
  Full_Address:
  addrNUMBER_PHYSICAL: 0
  addrSTREET1_PHYSICAL:
  addrSTREET2_PHYSICAL:
  addrZIP_PHYSICAL: 0
  scID: 0
  scCODE: 0
  scNAME:
  pvscDESC:
  nbiCODE:
  pvrtCODE:
  pvrtDESC:
  CITY: null
  addrCITY_PHYSICAL:
  stABBR_PHYSICAL:
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: true

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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