Name: Bristol_City_Council_Licensed_Premises

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: FID

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• EXTRACTDATE (type: esriFieldTypeString, alias: EXTRACTDATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ORGANISATIONURI (type: esriFieldTypeString, alias: ORGANISATIONURI, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ORGANISATIONLABEL (type: esriFieldTypeString, alias: ORGANISATIONLABEL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CASEREFERENCE (type: esriFieldTypeString, alias: CASEREFERENCE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CASEDATE (type: esriFieldTypeString, alias: CASEDATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SERVICETYPEURI (type: esriFieldTypeString, alias: SERVICETYPEURI, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SERVICETYPELABEL (type: esriFieldTypeString, alias: SERVICETYPELABEL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PREMISESNAME (type: esriFieldTypeString, alias: PREMISESNAME, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LOCATIONTEXT (type: esriFieldTypeString, alias: LOCATIONTEXT, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• POSTCODE (type: esriFieldTypeString, alias: POSTCODE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ENTERTAINMENTTYPEURI (type: esriFieldTypeString, alias: ENTERTAINMENTTYPEURI, SQL Type: sqlTypeNVarchar, length: 295, nullable: true, editable: true)
• ENTERTAINMENTTYPELABEL (type: esriFieldTypeString, alias: ENTERTAINMENTTYPELABEL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LATENIGHTREFRESHMENT (type: esriFieldTypeString, alias: LATENIGHTREFRESHMENT, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ALCOHOLSUPPLY (type: esriFieldTypeString, alias: ALCOHOLSUPPLY, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• OPENINGHOURS (type: esriFieldTypeString, alias: OPENINGHOURS, SQL Type: sqlTypeNVarchar, length: 779, nullable: true, editable: true)
• STATUSURI (type: esriFieldTypeString, alias: STATUSURI, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• STATUSLABEL (type: esriFieldTypeString, alias: STATUSLABEL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LICENCESTARTDATE (type: esriFieldTypeString, alias: LICENCESTARTDATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LICENCEENDDATE (type: esriFieldTypeString, alias: LICENCEENDDATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ONPREMISESALCOHOLSALE (type: esriFieldTypeString, alias: ONPREMISESALCOHOLSALE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• OFFPREMISESALCOHOLSALE (type: esriFieldTypeString, alias: OFFPREMISESALCOHOLSALE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LICENCEHOLDER (type: esriFieldTypeString, alias: LICENCEHOLDER, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LICENCEHOLDERADDRESS (type: esriFieldTypeString, alias: LICENCEHOLDERADDRESS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LICENCEHOLDERPOSTCODE (type: esriFieldTypeString, alias: LICENCEHOLDERPOSTCODE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• APPLICANTTYPEURI (type: esriFieldTypeString, alias: APPLICANTTYPEURI, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• APPLICANTTYPELABEL (type: esriFieldTypeString, alias: APPLICANTTYPELABEL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• DESIGNATEDPREMISESSUPERVISOR (type: esriFieldTypeString, alias: DESIGNATEDPREMISESSUPERVISOR, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SUPERVISORLICENCENO (type: esriFieldTypeString, alias: SUPERVISORLICENCENO, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SUPERVISORADDRESS (type: esriFieldTypeString, alias: SUPERVISORADDRESS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• SUPERVISORPOSTCODE (type: esriFieldTypeString, alias: SUPERVISORPOSTCODE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• CONDITIONS (type: esriFieldTypeString, alias: CONDITIONS, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• DECISIONDATE (type: esriFieldTypeString, alias: DECISIONDATE, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• DECIDEDBY (type: esriFieldTypeString, alias: DECIDEDBY, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• LICENCEURL (type: esriFieldTypeString, alias: LICENCEURL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• UPRN (type: esriFieldTypeInteger, alias: UPRN, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• GEOPOINTLICENSINGURL (type: esriFieldTypeString, alias: GEOPOINTLICENSINGURL, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• FID (type: esriFieldTypeInteger, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

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