Name: LIVE.CLV_BUS

Display Field: STNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description: A Spatial data set of CLV Business Licenses. Geocoded from data in INFOR.

Copyright Text: Busines Licensing, Information Technologies/GIS

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 607398.779260091
YMin: 26508247.9839281
XMax: 1098302.83321118
YMax: 26997526.7225603
Spatial Reference: 102707 (3421)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[82,168,95,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"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)
• GIS_ZIP (type: esriFieldTypeInteger, alias: GIS_ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUS_ADDRESS (type: esriFieldTypeString, alias: BUS_ADDRESS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_CITY_ST_ZIP (type: esriFieldTypeString, alias: BUS_CITY_ST_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_COUNTRY (type: esriFieldTypeString, alias: BUS_COUNTRY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STRNO (type: esriFieldTypeString, alias: STRNO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STDIR (type: esriFieldTypeString, alias: STDIR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STNAME (type: esriFieldTypeString, alias: STNAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• STRTYPE (type: esriFieldTypeString, alias: STRTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SUITE_NUM (type: esriFieldTypeString, alias: SUITE_NUM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_CITY (type: esriFieldTypeString, alias: BUS_CITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_STATE (type: esriFieldTypeString, alias: BUS_STATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_ZIP (type: esriFieldTypeString, alias: BUS_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SECONDARY_SUITE (type: esriFieldTypeString, alias: SECONDARY_SUITE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDRKEY (type: esriFieldTypeString, alias: ADDRKEY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDRESS_EXPDATE (type: esriFieldTypeString, alias: ADDRESS_EXPDATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PRCLID (type: esriFieldTypeString, alias: PRCLID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WARD (type: esriFieldTypeString, alias: WARD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PMTSTARTDATE (type: esriFieldTypeString, alias: PMTSTARTDATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PMTENDDATE (type: esriFieldTypeString, alias: PMTENDDATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICENSENO (type: esriFieldTypeString, alias: LICENSENO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICENSETYPE (type: esriFieldTypeString, alias: LICENSETYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICENSETYPEDESC (type: esriFieldTypeString, alias: LICENSETYPEDESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CATEGORY (type: esriFieldTypeString, alias: CATEGORY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FEEGROUP (type: esriFieldTypeString, alias: FEEGROUP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RENEWALTYPE (type: esriFieldTypeString, alias: RENEWALTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICENSECATDESC (type: esriFieldTypeString, alias: LICENSECATDESC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICSTATUSCODE (type: esriFieldTypeString, alias: LICSTATUSCODE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICSTATUS (type: esriFieldTypeString, alias: LICSTATUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CURRENTMILESTONE (type: esriFieldTypeString, alias: CURRENTMILESTONE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICENSEDTTM (type: esriFieldTypeDate, alias: LICENSEDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ISSDTTM (type: esriFieldTypeDate, alias: ISSDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXPDTTM (type: esriFieldTypeDate, alias: EXPDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GROSS_REPORT_TO_DATE (type: esriFieldTypeString, alias: GROSS_REPORT_TO_DATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INACTVDTTM (type: esriFieldTypeDate, alias: INACTVDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INACTVFLAG (type: esriFieldTypeString, alias: INACTVFLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LSTACTDTTM (type: esriFieldTypeDate, alias: LSTACTDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LSTRNWDTTM (type: esriFieldTypeDate, alias: LSTRNWDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NEXTRNWDT (type: esriFieldTypeString, alias: NEXTRNWDT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GRACEEXPDT (type: esriFieldTypeString, alias: GRACEEXPDT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_NAME (type: esriFieldTypeString, alias: BUS_NAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DBANAME (type: esriFieldTypeString, alias: DBANAME, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUS_TYPE (type: esriFieldTypeString, alias: BUS_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CAPACITY (type: esriFieldTypeString, alias: CAPACITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PRI (type: esriFieldTypeInteger, alias: PRI, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRIDESCRIPT (type: esriFieldTypeString, alias: PRIDESCRIPT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TYPEOFBUS (type: esriFieldTypeString, alias: TYPEOFBUS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ADDDTTM (type: esriFieldTypeDate, alias: ADDDTTM, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: COMMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APKEY (type: esriFieldTypeString, alias: APKEY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APLICKEY (type: esriFieldTypeString, alias: APLICKEY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTTYPE (type: esriFieldTypeString, alias: CNTCTTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTADDR1 (type: esriFieldTypeString, alias: CNTCTADDR1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTADDR2 (type: esriFieldTypeString, alias: CNTCTADDR2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTCITY (type: esriFieldTypeString, alias: CNTCTCITY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTSTATE (type: esriFieldTypeString, alias: CNTCTSTATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTZIP (type: esriFieldTypeString, alias: CNTCTZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTPHONE (type: esriFieldTypeString, alias: CNTCTPHONE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTEMAIL (type: esriFieldTypeString, alias: CNTCTEMAIL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCSTATEID (type: esriFieldTypeString, alias: CNTCSTATEID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CNTCTIDTYPE (type: esriFieldTypeString, alias: CNTCTIDTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAIL_OPTION (type: esriFieldTypeString, alias: MAIL_OPTION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAIL_FULL_STREET (type: esriFieldTypeString, alias: MAIL_FULL_STREET, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MAIL_CITY_ST_ZIP (type: esriFieldTypeString, alias: MAIL_CITY_ST_ZIP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NAICS_GROUP (type: esriFieldTypeString, alias: NAICS_GROUP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MONITION_GROUP (type: esriFieldTypeString, alias: MONITION_GROUP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MJBLNO (type: esriFieldTypeString, alias: MJBLNO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MJBLSELECTED (type: esriFieldTypeString, alias: MJBLSELECTED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MJBL_GROUP (type: esriFieldTypeString, alias: MJBL_GROUP, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LICAPPLDETAILTYPEKEY (type: esriFieldTypeString, alias: LICAPPLDETAILTYPEKEY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APPLICATIONSOURCE (type: esriFieldTypeString, alias: APPLICATIONSOURCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• APPLICATIONTYPE (type: esriFieldTypeString, alias: APPLICATIONTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CSSNOTSUBJECTTO (type: esriFieldTypeString, alias: CSSNOTSUBJECTTO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CSSSUBJECTTOINCOMPLIANCE (type: esriFieldTypeString, alias: CSSSUBJECTTOINCOMPLIANCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CSSSUBJECTTONOTCOMPLIANCE (type: esriFieldTypeString, alias: CSSSUBJECTTONOTCOMPLIANCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EMAILALLCORRESPONDENCE (type: esriFieldTypeString, alias: EMAILALLCORRESPONDENCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GENERALACKNOWLEDGEMENT (type: esriFieldTypeString, alias: GENERALACKNOWLEDGEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HOMEACKNOWLEDGEMENT (type: esriFieldTypeString, alias: HOMEACKNOWLEDGEMENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INITIALUNIT (type: esriFieldTypeString, alias: INITIALUNIT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOCATIONTYPE (type: esriFieldTypeString, alias: LOCATIONTYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NUMBERSEATS (type: esriFieldTypeString, alias: NUMBERSEATS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OCCUPANCYLOAD (type: esriFieldTypeString, alias: OCCUPANCYLOAD, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ORIGINATIONFEEPRCT (type: esriFieldTypeString, alias: ORIGINATIONFEEPRCT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SQUAREFOOTAGE (type: esriFieldTypeString, alias: SQUAREFOOTAGE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TEMPLICENSEREQUESTDATE (type: esriFieldTypeString, alias: TEMPLICENSEREQUESTDATE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• TEMPLICENSEREQUESTED (type: esriFieldTypeString, alias: TEMPLICENSEREQUESTED, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WITHINCITYLIMIT (type: esriFieldTypeString, alias: WITHINCITYLIMIT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ZONING (type: esriFieldTypeString, alias: ZONING, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOC_ADDRESS (type: esriFieldTypeString, alias: LOC_ADDRESS, 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: LIVE.CLV_BUS
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ZONING:
• LOC_ADDRESS:
• GIS_ZIP: 0
• BUS_ADDRESS:
• BUS_CITY_ST_ZIP:
• BUS_COUNTRY:
• STRNO:
• STDIR:
• STNAME:
• STRTYPE:
• SUITE_NUM:
• BUS_CITY:
• BUS_STATE:
• BUS_ZIP:
• SECONDARY_SUITE:
• ADDRKEY:
• ADDRESS_EXPDATE:
• PRCLID:
• WARD:
• PMTSTARTDATE:
• PMTENDDATE:
• LICENSENO:
• LICENSETYPE:
• LICENSETYPEDESC:
• CATEGORY:
• FEEGROUP:
• RENEWALTYPE:
• LICENSECATDESC:
• LICSTATUSCODE:
• LICSTATUS:
• CURRENTMILESTONE:
• GROSS_REPORT_TO_DATE:
• INACTVFLAG:
• NEXTRNWDT:
• GRACEEXPDT:
• BUS_NAME:
• DBANAME:
• BUS_TYPE:
• CAPACITY:
• PRI: 0
• PRIDESCRIPT:
• TYPEOFBUS:
• COMMENTS:
• APKEY:
• APLICKEY:
• CNTCTTYPE:
• CNTCTADDR1:
• CNTCTADDR2:
• CNTCTCITY:
• CNTCTSTATE:
• CNTCTZIP:
• CNTCTPHONE:
• CNTCTEMAIL:
• CNTCSTATEID:
• CNTCTIDTYPE:
• MAIL_OPTION:
• MAIL_FULL_STREET:
• MAIL_CITY_ST_ZIP:
• NAICS_GROUP:
• MONITION_GROUP:
• MJBLNO:
• MJBLSELECTED:
• MJBL_GROUP:
• LICAPPLDETAILTYPEKEY:
• APPLICATIONSOURCE:
• APPLICATIONTYPE:
• CSSNOTSUBJECTTO:
• CSSSUBJECTTOINCOMPLIANCE:
• CSSSUBJECTTONOTCOMPLIANCE:
• EMAILALLCORRESPONDENCE:
• GENERALACKNOWLEDGEMENT:
• HOMEACKNOWLEDGEMENT:
• INITIALUNIT:
• LOCATIONTYPE:
• NUMBERSEATS:
• OCCUPANCYLOAD:
• ORIGINATIONFEEPRCT:
• SQUAREFOOTAGE:
• TEMPLICENSEREQUESTDATE:
• TEMPLICENSEREQUESTED:
• WITHINCITYLIMIT:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2024 9:07:12 PM

Schema Last Edit Date: 3/19/2024 9:07:12 PM

Data Last Edit Date: 3/19/2024 9:07:12 PM

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