{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 1, "name": "Basic Business License - Last 30 Days", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "AGENT_FIRST_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "BILLING_ADDRESS", "type": "esriFieldTypeString", "alias": "BILLING_ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BILLING_ADDRESS" }, { "name": "BILLING_ADDRESS_CITY_STATE_ZIP", "type": "esriFieldTypeString", "alias": "BILLING_ADDRESS_CITY_STATE_ZIP", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BILLING_ADDRESS_CITY_STATE_ZIP" }, { "name": "AGENT_ENTITY", "type": "esriFieldTypeString", "alias": "AGENT_ENTITY", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "AGENT_ENTITY" }, { "name": "AGENT_FIRST_NAME", "type": "esriFieldTypeString", "alias": "AGENT_FIRST_NAME", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "AGENT_FIRST_NAME" }, { "name": "AGENT_LAST_NAME", "type": "esriFieldTypeString", "alias": "AGENT_LAST_NAME", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "AGENT_LAST_NAME" }, { "name": "AGENT_MIDDLE_NAME", "type": "esriFieldTypeString", "alias": "AGENT_MIDDLE_NAME", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "AGENT_MIDDLE_NAME" }, { "name": "AGENT_PHONE", "type": "esriFieldTypeString", "alias": "AGENT_PHONE", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "AGENT_PHONE" }, { "name": "SITE_ADDRESS", "type": "esriFieldTypeString", "alias": "SITE_ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "SITE_ADDRESS" }, { "name": "BBL_CITY_STATE_ZIP", "type": "esriFieldTypeString", "alias": "BBL_CITY_STATE_ZIP", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BBL_CITY_STATE_ZIP" }, { "name": "BILLING_NAME", "type": "esriFieldTypeString", "alias": "BILLING_NAME", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BILLING_NAME" }, { "name": "CUSTOMER_NUMBER", "type": "esriFieldTypeString", "alias": "CUSTOMER_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CUSTOMER_NUMBER" }, { "name": "DC_ADDR_FLAG", "type": "esriFieldTypeString", "alias": "DC_ADDR_FLAG", "domain": null, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "DC_ADDR_FLAG" }, { "name": "LICENSECATEGORY", "type": "esriFieldTypeString", "alias": "LICENSECATEGORY", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "LICENSECATEGORY" }, { "name": "ENTITY_NAME", "type": "esriFieldTypeString", "alias": "ENTITY_NAME", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ENTITY_NAME" }, { "name": "FIRST_NAME", "type": "esriFieldTypeString", "alias": "FIRST_NAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FIRST_NAME" }, { "name": "LAST_NAME", "type": "esriFieldTypeString", "alias": "LAST_NAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "LAST_NAME" }, { "name": "DCS_ADD_DATE", "type": "esriFieldTypeDate", "alias": "DCS_ADD_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DCS_ADD_DATE" }, { "name": "LICENSE_END_DATE", "type": "esriFieldTypeDate", "alias": "LICENSE_END_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LICENSE_END_DATE" }, { "name": "LICENSE_ISSUE_DATE", "type": "esriFieldTypeDate", "alias": "LICENSE_ISSUE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LICENSE_ISSUE_DATE" }, { "name": "LICENSE_START_DATE", "type": "esriFieldTypeDate", "alias": "LICENSE_START_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LICENSE_START_DATE" }, { "name": "LICENSE_CATEGORY_TEXT", "type": "esriFieldTypeString", "alias": "LICENSE_CATEGORY_TEXT", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "LICENSE_CATEGORY_TEXT" }, { "name": "LICENSE_CATEGORY_CODE", "type": "esriFieldTypeString", "alias": "LICENSE_CATEGORY_CODE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LICENSE_CATEGORY_CODE" }, { "name": "LICENSESTATUS", "type": "esriFieldTypeString", "alias": "LICENSESTATUS", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LICENSESTATUS" }, { "name": "PHONE_NUMBER", "type": "esriFieldTypeString", "alias": "PHONE_NUMBER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "PHONE_NUMBER" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "CITY" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "STATE" }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ZIP" }, { "name": "BBL_LICENSE_FACT_ID", "type": "esriFieldTypeInteger", "alias": "BBL_LICENSE_FACT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BBL_LICENSE_FACT_ID" }, { "name": "DCS_LAST_MOD_DTTM", "type": "esriFieldTypeDate", "alias": "DCS_LAST_MOD_DTTM", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DCS_LAST_MOD_DTTM" }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LATITUDE" }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONGITUDE" }, { "name": "XCOORD", "type": "esriFieldTypeDouble", "alias": "XCOORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "XCOORD" }, { "name": "YCOORD", "type": "esriFieldTypeDouble", "alias": "YCOORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YCOORD" }, { "name": "ZIPCODE", "type": "esriFieldTypeInteger", "alias": "ZIPCODE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ZIPCODE" }, { "name": "MARADDRESSREPOSITORYID", "type": "esriFieldTypeDouble", "alias": "MARADDRESSREPOSITORYID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MARADDRESSREPOSITORYID" }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "WARD", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "WARD" }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "ANC", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ANC" }, { "name": "SMD", "type": "esriFieldTypeString", "alias": "SMD", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SMD" }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DISTRICT" }, { "name": "PSA", "type": "esriFieldTypeString", "alias": "PSA", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PSA" }, { "name": "NEIGHBORHOODCLUSTER", "type": "esriFieldTypeString", "alias": "NEIGHBORHOODCLUSTER", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "NEIGHBORHOODCLUSTER" }, { "name": "BUSINESSIMPROVEMENTDISTRICT", "type": "esriFieldTypeString", "alias": "BUSINESSIMPROVEMENTDISTRICT", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BUSINESSIMPROVEMENTDISTRICT" }, { "name": "MAINSTREET", "type": "esriFieldTypeString", "alias": "MAINSTREET", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINSTREET" } ], "indexes": [ { "name": "BBL_FEED_IX1", "fields": "LICENSE_END_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX2", "fields": "LICENSE_ISSUE_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX3", "fields": "LICENSE_START_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX4", "fields": "ENTITY_NAME,BILLING_NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX5", "fields": "SITE_ADDRESS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX6", "fields": "MARADDRESSREPOSITORYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX7", "fields": "MARADDRESSREPOSITORYID,LICENSE_END_DATE,CUSTOMER_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R8740_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Basic Business License - Last 30 Days", "description": "", "prototype": { "attributes": { "BUSINESSIMPROVEMENTDISTRICT": null, "BILLING_ADDRESS": null, "BILLING_ADDRESS_CITY_STATE_ZIP": null, "AGENT_ENTITY": null, "AGENT_FIRST_NAME": null, "AGENT_LAST_NAME": null, "AGENT_MIDDLE_NAME": null, "AGENT_PHONE": null, "SITE_ADDRESS": null, "BBL_CITY_STATE_ZIP": null, "BILLING_NAME": null, "CUSTOMER_NUMBER": null, "DC_ADDR_FLAG": null, "LICENSECATEGORY": null, "ENTITY_NAME": null, "FIRST_NAME": null, "LAST_NAME": null, "DCS_ADD_DATE": null, "LICENSE_END_DATE": null, "LICENSE_ISSUE_DATE": null, "LICENSE_START_DATE": null, "LICENSE_CATEGORY_TEXT": null, "LICENSE_CATEGORY_CODE": null, "LICENSESTATUS": null, "PHONE_NUMBER": null, "MAINSTREET": null, "CITY": null, "STATE": null, "ZIP": null, "BBL_LICENSE_FACT_ID": null, "DCS_LAST_MOD_DTTM": null, "LATITUDE": null, "LONGITUDE": null, "XCOORD": null, "YCOORD": null, "ZIPCODE": null, "MARADDRESSREPOSITORYID": null, "WARD": null, "ANC": null, "SMD": null, "DISTRICT": null, "PSA": null, "NEIGHBORHOODCLUSTER": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }