Name: CLV_BL_GIS

Display Field:

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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: 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)
• 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)
• 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)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/4/2022 12:23:00 AM

Schema Last Edit Date: 4/4/2022 12:23:00 AM

Data Last Edit Date: 4/4/2022 12:23:00 AM

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