{ "currentVersion": 10.81, "cimVersion": "2.6.0", "id": 3, "name": "Individual", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "creationdate", "creatorField": "creator", "editDateField": "editdate", "editorField": "editor" }, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "cabqgis.ACS.Cases", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "rel_globalid", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsDistinct": true, "supportsPagination": true, "supportsOrderBy": true, "supportsPaginationOnAggregatedQueries": true, "supportsQueryWithResultType": true, "supportsHavingClause": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsOrderByOnlyOnLayerFields": false, "supportsPercentileStatistics": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithDatumTransformation": true }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "globalid", "displayField": "lastname", "typeIdField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "nullable": false, "defaultValue": null, "modelName": "OBJECTID", "editable": false }, { "name": "lastname", "type": "esriFieldTypeString", "alias": "LastName", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "LastName" }, { "name": "firstname", "type": "esriFieldTypeString", "alias": "FirstName", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "FirstName" }, { "name": "dob", "type": "esriFieldTypeDate", "alias": "DOB", "domain": null, "editable": true, "nullable": true, "length": 29, "defaultValue": null, "modelName": "DOB" }, { "name": "age", "type": "esriFieldTypeSmallInteger", "alias": "Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Age" }, { "name": "gender", "type": "esriFieldTypeString", "alias": "Gender", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Gender" }, { "name": "race", "type": "esriFieldTypeString", "alias": "Race", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Race" }, { "name": "ethnicity", "type": "esriFieldTypeString", "alias": "Ethnicity", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Ethnicity" }, { "name": "primarylanguage", "type": "esriFieldTypeString", "alias": "PrimaryLanguage", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PrimaryLanguage" }, { "name": "homeless", "type": "esriFieldTypeString", "alias": "Homeless", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Homeless" }, { "name": "veteran", "type": "esriFieldTypeString", "alias": "Veteran", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Veteran" }, { "name": "physicaldisability", "type": "esriFieldTypeString", "alias": "PhysicalDisability", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PhysicalDisability" }, { "name": "mentalillness", "type": "esriFieldTypeString", "alias": "MentalIllness", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "MentalIllness" }, { "name": "children", "type": "esriFieldTypeString", "alias": "Children", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Children" }, { "name": "pets", "type": "esriFieldTypeString", "alias": "Pets", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Pets" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "rel_globalid", "type": "esriFieldTypeGUID", "alias": "REL_GlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "rel_globalid" }, { "name": "prefer_contact", "type": "esriFieldTypeString", "alias": "prefer_contact", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "prefer_contact" }, { "name": "contact_email", "type": "esriFieldTypeString", "alias": "email", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contact_email" }, { "name": "child_age_lt_5", "type": "esriFieldTypeInteger", "alias": "child_age_lt_5", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "child_age_lt_5" }, { "name": "child_age_6_to_12", "type": "esriFieldTypeInteger", "alias": "child_age_6_to_12", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "child_age_6_to_12" }, { "name": "child_age_13_to_17", "type": "esriFieldTypeInteger", "alias": "child_age_13_to_17", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "child_age_13_to_17" }, { "name": "child_age_18_plus", "type": "esriFieldTypeInteger", "alias": "child_age_18_plus", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "child_age_18_plus" }, { "name": "total_children", "type": "esriFieldTypeInteger", "alias": "total_children", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "total_children" }, { "name": "contact_phone", "type": "esriFieldTypeString", "alias": "contact_phone", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "contact_phone" }, { "name": "contact_phone_alt", "type": "esriFieldTypeString", "alias": "contact_phone_alt", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "contact_phone_alt" }, { "name": "gender_other", "type": "esriFieldTypeString", "alias": "gender_other", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "gender_other" }, { "name": "language_other", "type": "esriFieldTypeString", "alias": "language_other", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "language_other" }, { "name": "race_ethnicity", "type": "esriFieldTypeString", "alias": "race_ethnicity", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "race_ethnicity" }, { "name": "race_ethnicity_other", "type": "esriFieldTypeString", "alias": "race_ethnicity_other", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "race_ethnicity_other" }, { "name": "lgbtq_plus_community", "type": "esriFieldTypeString", "alias": "LGBTQ_plus_community", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "lgbtq_plus_community" }, { "name": "individual_followup", "type": "esriFieldTypeString", "alias": "individual_followup", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "individual_followup" }, { "name": "indiv_followup_notes", "type": "esriFieldTypeString", "alias": "indiv_followup_notes", "domain": null, "editable": true, "nullable": true, "length": 2000, "defaultValue": null, "modelName": "indiv_followup_notes" }, { "name": "indiv_follup_date", "type": "esriFieldTypeDate", "alias": "indiv_follup_date", "domain": null, "editable": true, "nullable": true, "length": 29, "defaultValue": null, "modelName": "indiv_follup_date" }, { "name": "creationdate", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": false, "nullable": true, "length": 29, "defaultValue": null, "modelName": "creationdate" }, { "name": "creator", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "creator" }, { "name": "editdate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": false, "nullable": true, "length": 29, "defaultValue": null, "modelName": "editdate" }, { "name": "editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "editor" } ], "indexes": [ { "name": "g72rel_globalid", "fields": "rel_globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "r45_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "uuid_45", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Individual", "description": "", "prototype": { "attributes": { "indiv_followup_notes": null, "indiv_follup_date": null, "lastname": null, "firstname": null, "dob": null, "age": null, "gender": null, "race": null, "ethnicity": null, "primarylanguage": null, "homeless": null, "veteran": null, "physicaldisability": null, "mentalillness": null, "children": null, "pets": null, "individual_followup": null, "rel_globalid": null, "prefer_contact": null, "contact_email": null, "child_age_lt_5": 0, "child_age_6_to_12": 0, "child_age_13_to_17": 0, "child_age_18_plus": 0, "total_children": 0, "contact_phone": null, "contact_phone_alt": null, "gender_other": null, "language_other": null, "race_ethnicity": null, "race_ethnicity_other": null, "lgbtq_plus_community": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "useStandardizedQueries": true, "standardMaxRecordCount": 16000, "tileMaxRecordCount": 4000, "maxRecordCountFactor": 1, "supportedQueryFormats": "JSON, geoJSON, PBF", "maxRecordCount": 2000, "allowGeometryUpdates": true, "capabilities": "Query", "enableZDefaults": true, "zDefault": 0, "allowUpdateWithoutMValues": true, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ] }, "supportsApplyEditsWithGlobalIds": true, "serviceItemId": "f9396001cfaa46db8c75005f6165b4a9", "hasMetadata": true, "supportsAppend": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection", "supportsQuantizationEditMode": true, "supportsAttachmentsByUploadId": true, "supportsAsyncDelete": true, "supportsFieldDescriptionProperty": true, "supportsExceedsLimitStatistics": true, "sqlParserVersion": "PG_10.8.1" }