{ "currentVersion": 10.71, "id": 2, "name": "imaps_spatial.sde.njm_applications", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "company_premise_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "id", "type": "esriFieldTypeInteger", "alias": "id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "id" }, { "name": "application_no", "type": "esriFieldTypeString", "alias": "application_no", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "application_no" }, { "name": "transaction_no", "type": "esriFieldTypeString", "alias": "transaction_no", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "transaction_no" }, { "name": "application_key", "type": "esriFieldTypeInteger", "alias": "application_key", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "application_key" }, { "name": "start_date", "type": "esriFieldTypeDate", "alias": "start_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "start_date" }, { "name": "end_date", "type": "esriFieldTypeDate", "alias": "end_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "end_date" }, { "name": "company_premise_name", "type": "esriFieldTypeString", "alias": "company_premise_name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "company_premise_name" }, { "name": "city_name", "type": "esriFieldTypeString", "alias": "city_name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "city_name" }, { "name": "state_name", "type": "esriFieldTypeString", "alias": "state_name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "state_name" }, { "name": "country_name", "type": "esriFieldTypeString", "alias": "country_name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "country_name" }, { "name": "longitude", "type": "esriFieldTypeDouble", "alias": "longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "longitude" }, { "name": "latitude", "type": "esriFieldTypeDouble", "alias": "latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "latitude" }, { "name": "created_at", "type": "esriFieldTypeDate", "alias": "created_at", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_at" }, { "name": "updated_at", "type": "esriFieldTypeDate", "alias": "updated_at", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "updated_at" }, { "name": "street", "type": "esriFieldTypeString", "alias": "street", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "street" }, { "name": "postcode", "type": "esriFieldTypeString", "alias": "postcode", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "postcode" } ], "indexes": [ { "name": "njm_applications_application_key_index", "fields": "application_key", "isAscending": true, "isUnique": false, "description": "" }, { "name": "njm_applications_application_no_index", "fields": "application_no", "isAscending": true, "isUnique": false, "description": "" }, { "name": "njm_applications_company_premise_name_index", "fields": "company_premise_name", "isAscending": true, "isUnique": false, "description": "" }, { "name": "njm_applications_transaction_no_index", "fields": "transaction_no", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r164_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "imaps_spatial.sde.njm_applications", "description": "", "prototype": { "attributes": { "street": null, "postcode": null, "id": null, "application_no": null, "transaction_no": null, "application_key": null, "start_date": null, "end_date": null, "company_premise_name": null, "city_name": null, "state_name": null, "country_name": null, "longitude": null, "latitude": null, "created_at": null, "updated_at": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 100000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 100000, "tileMaxRecordCount": 100000, "maxRecordCountFactor": 1 }