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: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 607398.767112105
YMin: 26640975.6892605
XMax: 881148.981008893
YMax: 26855774.6104388
Spatial Reference: 102707 (3421)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[52,130,107,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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SCORE (type: esriFieldTypeDouble, alias: SCORE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATCH_TYPE (type: esriFieldTypeString, alias: MATCH_TYPE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• MATCH_ADDR (type: esriFieldTypeString, alias: MATCH_ADDR, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• X (type: esriFieldTypeDouble, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Y (type: esriFieldTypeDouble, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDR_TYPE (type: esriFieldTypeString, alias: ADDR_TYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• 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: esriFieldTypeString, alias: LICENSEDTTM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ISSDTTM (type: esriFieldTypeString, alias: ISSDTTM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EXPDTTM (type: esriFieldTypeString, alias: EXPDTTM, SQL Type: sqlTypeOther, length: 255, 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: esriFieldTypeString, alias: INACTVDTTM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INACTVFLAG (type: esriFieldTypeString, alias: INACTVFLAG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LSTACTDTTM (type: esriFieldTypeString, alias: LSTACTDTTM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LSTRNWDTTM (type: esriFieldTypeString, alias: LSTRNWDTTM, SQL Type: sqlTypeOther, length: 255, 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: esriFieldTypeString, alias: ADDDTTM, SQL Type: sqlTypeOther, length: 255, 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)
• FULL_STREET (type: esriFieldTypeString, alias: 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)
• ADDR (type: esriFieldTypeString, alias: ADDR, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)

Templates:

Name: LIVE.CLV_BUS
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/20/2023 9:54:14 PM

Schema Last Edit Date: 12/20/2023 9:54:14 PM

Data Last Edit Date: 12/20/2023 9:54:14 PM

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