{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 35, "name": "GIS.dbo.Cem_Master", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "RID", "type": "esriFieldTypeDouble", "alias": "RID", "domain": null }, { "name": "LNAME", "type": "esriFieldTypeString", "alias": "LNAME", "length": 25, "domain": null }, { "name": "FNAME", "type": "esriFieldTypeString", "alias": "FNAME", "length": 25, "domain": null }, { "name": "MNAME", "type": "esriFieldTypeString", "alias": "MNAME", "length": 25, "domain": null }, { "name": "DOB", "type": "esriFieldTypeString", "alias": "DOB", "length": 10, "domain": null }, { "name": "DOD", "type": "esriFieldTypeString", "alias": "DOD", "length": 10, "domain": null }, { "name": "DOI", "type": "esriFieldTypeString", "alias": "DOI", "length": 10, "domain": null }, { "name": "BRANCH", "type": "esriFieldTypeString", "alias": "BRANCH", "length": 10, "domain": null }, { "name": "UNIT", "type": "esriFieldTypeString", "alias": "UNIT", "length": 50, "domain": null }, { "name": "SSDATE", "type": "esriFieldTypeDate", "alias": "SSDATE", "length": 8, "domain": null }, { "name": "SEDATE", "type": "esriFieldTypeDate", "alias": "SEDATE", "length": 8, "domain": null }, { "name": "CEMETERY", "type": "esriFieldTypeString", "alias": "CEMETERY", "length": 10, "domain": null }, { "name": "SECTION", "type": "esriFieldTypeString", "alias": "SECTION", "length": 10, "domain": null }, { "name": "ROWBLOCK", "type": "esriFieldTypeString", "alias": "ROWBLOCK", "length": 10, "domain": null }, { "name": "LOTPLOT", "type": "esriFieldTypeString", "alias": "LOTPLOT", "length": 10, "domain": null }, { "name": "VERTPLACE", "type": "esriFieldTypeDouble", "alias": "VERTPLACE", "domain": null }, { "name": "CSITEID", "type": "esriFieldTypeString", "alias": "CSITEID", "length": 20, "domain": null }, { "name": "CAUSEDEATH", "type": "esriFieldTypeString", "alias": "CAUSEDEATH", "length": 50, "domain": null }, { "name": "MEMO", "type": "esriFieldTypeString", "alias": "MEMO", "length": 800, "domain": null }, { "name": "LASTRESID", "type": "esriFieldTypeString", "alias": "LASTRESID", "length": 50, "domain": null }, { "name": "INCHARGE", "type": "esriFieldTypeString", "alias": "INCHARGE", "length": 20, "domain": null }, { "name": "SEX", "type": "esriFieldTypeString", "alias": "SEX", "length": 1, "domain": null }, { "name": "RANK", "type": "esriFieldTypeString", "alias": "RANK", "length": 10, "domain": null }, { "name": "SUFNAME", "type": "esriFieldTypeString", "alias": "SUFNAME", "length": 10, "domain": null }, { "name": "DOBYR", "type": "esriFieldTypeSmallInteger", "alias": "DOBYR", "domain": null }, { "name": "DOBMON", "type": "esriFieldTypeSmallInteger", "alias": "DOBMON", "domain": null }, { "name": "DOBDAY", "type": "esriFieldTypeSmallInteger", "alias": "DOBDAY", "domain": null }, { "name": "DODYR", "type": "esriFieldTypeSmallInteger", "alias": "DODYR", "domain": null }, { "name": "DODMON", "type": "esriFieldTypeSmallInteger", "alias": "DODMON", "domain": null }, { "name": "DODDAY", "type": "esriFieldTypeSmallInteger", "alias": "DODDAY", "domain": null }, { "name": "AGEYR", "type": "esriFieldTypeSmallInteger", "alias": "AGEYR", "domain": null }, { "name": "AGEMON", "type": "esriFieldTypeSmallInteger", "alias": "AGEMON", "domain": null }, { "name": "AGEDAY", "type": "esriFieldTypeSmallInteger", "alias": "AGEDAY", "domain": null }, { "name": "DOIYR", "type": "esriFieldTypeSmallInteger", "alias": "DOIYR", "domain": null }, { "name": "DOIMON", "type": "esriFieldTypeSmallInteger", "alias": "DOIMON", "domain": null }, { "name": "DOIDAY", "type": "esriFieldTypeSmallInteger", "alias": "DOIDAY", "domain": null }, { "name": "PICTURE", "type": "esriFieldTypeString", "alias": "PICTURE", "length": 1, "domain": null }, { "name": "PLBIRTH", "type": "esriFieldTypeString", "alias": "PLBIRTH", "length": 50, "domain": null }, { "name": "MSTATUS", "type": "esriFieldTypeString", "alias": "MSTATUS", "length": 15, "domain": null }, { "name": "TIMEINT", "type": "esriFieldTypeString", "alias": "TIMEINT", "length": 15, "domain": null }, { "name": "OSECTION", "type": "esriFieldTypeString", "alias": "OSECTION", "length": 10, "domain": null }, { "name": "OROW", "type": "esriFieldTypeString", "alias": "OROW", "length": 10, "domain": null }, { "name": "ONUM", "type": "esriFieldTypeString", "alias": "ONUM", "length": 10, "domain": null }, { "name": "RESERVEDBY", "type": "esriFieldTypeString", "alias": "RESERVEDBY", "length": 50, "domain": null }, { "name": "FLOWERCOST", "type": "esriFieldTypeDouble", "alias": "FLOWERCOST", "domain": null }, { "name": "GRAVECOST", "type": "esriFieldTypeDouble", "alias": "GRAVECOST", "domain": null }, { "name": "OPENINGCOST", "type": "esriFieldTypeDouble", "alias": "OPENINGCOST", "domain": null }, { "name": "VCURBCOST", "type": "esriFieldTypeDouble", "alias": "VCURBCOST", "domain": null }, { "name": "PAIDDATE", "type": "esriFieldTypeDate", "alias": "PAIDDATE", "length": 8, "domain": null }, { "name": "CONTRACTYN", "type": "esriFieldTypeString", "alias": "CONTRACTYN", "length": 1, "domain": null }, { "name": "CREMCODE", "type": "esriFieldTypeString", "alias": "CREMCODE", "length": 2, "domain": null }, { "name": "VALULTTYPE", "type": "esriFieldTypeString", "alias": "VALULTTYPE", "length": 2, "domain": null }, { "name": "DISINTERCODE", "type": "esriFieldTypeString", "alias": "DISINTERCODE", "length": 2, "domain": null }, { "name": "WEBLINK", "type": "esriFieldTypeString", "alias": "WEBLINK", "length": 150, "domain": null }, { "name": "DISPLAY", "type": "esriFieldTypeString", "alias": "DISPLAY", "length": 1, "domain": null }, { "name": "MAP", "type": "esriFieldTypeString", "alias": "MAP", "length": 1, "domain": null }, { "name": "REPLACE_MARKER", "type": "esriFieldTypeString", "alias": "REPLACE_MARKER", "length": 10, "domain": null }, { "name": "DEATH_CERT_NUM", "type": "esriFieldTypeString", "alias": "DEATH_CERT_NUM", "length": 18, "domain": null }, { "name": "MEMONLY", "type": "esriFieldTypeString", "alias": "MEMONLY", "length": 1, "domain": null }, { "name": "CreateDate", "type": "esriFieldTypeDate", "alias": "CreateDate", "length": 8, "domain": null }, { "name": "LastModifiedDate", "type": "esriFieldTypeDate", "alias": "LastModifiedDate", "length": 8, "domain": null }, { "name": "LastModifiedIP", "type": "esriFieldTypeString", "alias": "LastModifiedIP", "length": 50, "domain": null }, { "name": "ESRI_OID", "type": "esriFieldTypeOID", "alias": "ESRI_OID", "domain": null } ], "indexes": [ { "name": "PK_Cem_Master", "fields": "RID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "NC_ID", "fields": "RID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "NC_NameSearch", "fields": "LNAME,FNAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "FDO_RID", "fields": "RID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "b10c622337dc46e09f608f3b8b11aad0" }