{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 2000, "description": null, "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [], "indexes": [{ "name": "r425_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }], "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.7.0", "isDataArchived": false, "id": 1, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithDistance": true, "supportsQueryWithCacheHint": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "serviceItemId": "10d431ecea094d0b83dbc386f568669e", "capabilities": "Map,Query,Data", "hasLastEditTime": false, "supportsExceedsLimitStatistics": true, "standardMaxRecordCount": 32000, "isDataVersioned": false, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "tileMaxRecordCount": 2000, "currentVersion": 12.1, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "Business License Types", "displayField": "business_name", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "account_id", "length": 20, "alias": "Account_ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "business_status", "length": 1, "alias": "Business_Status", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "business_name", "length": 40, "alias": "Business_Name", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "startdate", "length": 8, "alias": "StartDate", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "territory", "length": 4, "alias": "Territory", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "jurisdiction", "length": 13, "alias": "Jurisdiction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "gislayers.sde.BUSINESS_LICENSE_TYPES.area", "length": 19, "alias": "gislayers.sde.BUSINESS_LICENSE_TYPES.area", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "hsn", "alias": "HSN", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "hsn_suffix", "length": 5, "alias": "HSN_Suffix", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "pre_direction", "length": 4, "alias": "Pre_Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "street", "length": 30, "alias": "Street", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "street_type", "length": 4, "alias": "Street_Type", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "post_direction", "length": 4, "alias": "Post_Direction", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "unit_type", "length": 5, "alias": "Unit_Type", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "unit", "length": 5, "alias": "Unit", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "zip", "length": 10, "alias": "Zip", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "city", "length": 4, "alias": "City", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "state", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "gis_address_id", "length": 20, "alias": "GIS_Address_ID", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "delinquent", "length": 1, "alias": "DELINQUENT", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "unfiled", "length": 1, "alias": "UNFILED", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "addressid", "length": 25, "alias": "ADDRESSID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "x_location", "alias": "X_Location", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "y_location", "alias": "Y_location", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "datetime_data_pulled", "length": 8, "alias": "DateTime_Data_Pulled", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "licensetypecode", "length": 10, "alias": "licensetypecode", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "licensestatus", "length": 10, "alias": "licensestatus", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "licensedesc1", "length": 50, "alias": "licensedesc1", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "licensedesc2", "length": 50, "alias": "licensedesc2", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "naics_code", "length": 10, "alias": "naics_code", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": null }