{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Traps Inspection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CreatedDate", "creatorField": "CreatedBy", "editDateField": "ModifiedDate", "editorField": "ModifiedBY", "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "MSQControlTraps", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "InspectionID", "composite": false, "catalogID": "{DAFC4C50-DB4A-410E-AE37-2B3F74889B80}" } ], "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, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Inspector", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": { "type": "codedValue", "name": "MSQInspectorNames", "description": "MC Inspectors", "codedValues": [ { "name": "Adrian Gilbert", "code": "Adrian Gilbert" }, { "name": "Carlos Lanzas", "code": "Carlos Lanzas" }, { "name": "Carlos Varas", "code": "Carlos Varas" }, { "name": "Delfina Tirado", "code": "Delfina Tirado" }, { "name": "Derrick Ash", "code": "Derrick Ash" }, { "name": "Gabriel Dearmas", "code": "Gabriel Dearmas" }, { "name": "Joseph Blackman", "code": "Joseph Blackman" }, { "name": "Lawrence Smart", "code": "Lawrence Smart" }, { "name": "Margine Rodriguez", "code": "Margine Rodriguez" }, { "name": "Ormel Chavez", "code": "Ormel Chavez" }, { "name": "Pedro Castellanos", "code": "Pedro Castellanos" }, { "name": "Ramiro Arias", "code": "Ramiro Arias" }, { "name": "Robert Muxo", "code": "Robert Muxo" }, { "name": "Sanders Barrington", "code": "Sanders Barrington" }, { "name": "Sharon Feldman-Nagel", "code": "Sharon Feldman-Nagel" }, { "name": "Yasser Compagines", "code": "Yasser Compagines" }, { "name": "Olamide Farotade", "code": "Olamide Farotade" }, { "name": "John Iyaogeh", "code": "John Iyaogeh" }, { "name": "Ansler Campfort", "code": "Ansler Campfort" }, { "name": "Humberto Rodriguez", "code": "Humberto Rodriguez" }, { "name": "Brenton Betts", "code": "Brenton Betts" }, { "name": "Mario Moran", "code": "Mario Moran" }, { "name": "Wesley Dorneval", "code": "Wesley Dorneval" }, { "name": "Edwin Mozo", "code": "Edwin Mozo" }, { "name": "Yanet Chiong", "code": "Yanet Chiong" }, { "name": "Carlos Primo", "code": "Carlos Primo" }, { "name": "Chalmers Vasquez", "code": "Chalmers Vasquez" }, { "name": "Johana Medina", "code": "Johana Medina" }, { "name": "Maria Rodriguez", "code": "Maria Rodriguez" }, { "name": "Adrian Perez", "code": "Adrian Perez" }, { "name": "Alberto Pupo", "code": "Alberto Pupo" }, { "name": "Alejandro Beron", "code": "Alejandro Beron" }, { "name": "Andres Garcia", "code": "Andres Garcia" }, { "name": "Andres Madrid", "code": "Andres Madrid" }, { "name": "Daniel Diaz", "code": "Daniel Diaz" }, { "name": "Andres Hagar", "code": "Andres Hagar" }, { "name": "Diana St Plite", "code": "Diana St Plite" }, { "name": "Diego Rodriguez", "code": "Diego Rodriguez" }, { "name": "Earl Moise", "code": "Earl Moise" }, { "name": "Edgard Santos", "code": "Edgard Santos" }, { "name": "Eleshia Moss", "code": "Eleshia Moss" }, { "name": "Esteban Perez", "code": "Esteban Perez" }, { "name": "Fernando Arana", "code": "Fernando Arana" }, { "name": "Francisco Aguayo", "code": "Francisco Aguayo" }, { "name": "Glenton Gilzean II", "code": "Glenton Gilzean II" }, { "name": "Gregory Moise", "code": "Gregory Moise" }, { "name": "Hyoset Martin", "code": "Hyoset Martin" }, { "name": "Jaciel Cruz", "code": "Jaciel Cruz" }, { "name": "Jairo Marin", "code": "Jairo Marin" }, { "name": "Janet Rivera", "code": "Janet Rivera" }, { "name": "Jeffrey Horne", "code": "Jeffrey Horne" }, { "name": "Jeffrey Parajon", "code": "Jeffrey Parajon" }, { "name": "Jehiely Saavedra", "code": "Jehiely Saavedra" }, { "name": "Jesus Bahena", "code": "Jesus Bahena" }, { "name": "Juan Cartajena", "code": "Juan Cartajena" }, { "name": "Yader Parajon", "code": "Yader Parajon" }, { "name": "Leandro Andarcio", "code": "Leandro Andarcio" }, { "name": "Leeroy Joseph", "code": "Leeroy Joseph" }, { "name": "Louis Abraham", "code": "Louis Abraham" }, { "name": "Lucia Gutierrez", "code": "Lucia Gutierrez" }, { "name": "Maria Thompson", "code": "Maria Thompson" }, { "name": "Marvin Dubuisson", "code": "Marvin Dubuisson" }, { "name": "Netta Joseph", "code": "Netta Joseph" }, { "name": "Nicolas Dothee", "code": "Nicolas Dothee" }, { "name": "Nirva Jean Baptiste", "code": "Nirva Jean Baptiste" }, { "name": "Olga Pernia", "code": "Olga Pernia" }, { "name": "Pablo Vaquer", "code": "Pablo Vaquer" }, { "name": "Pedro Errasti", "code": "Pedro Errasti" }, { "name": "Rafael Marin", "code": "Rafael Marin" }, { "name": "Ralph Sharpe", "code": "Ralph Sharpe" }, { "name": "Rood Guerrier", "code": "Rood Guerrier" }, { "name": "Samantha Santelis", "code": "Samantha Santelis" }, { "name": "Sayda Sabillon", "code": "Sayda Sabillon" }, { "name": "Stephen Edwards", "code": "Stephen Edwards" }, { "name": "Stephen Parra", "code": "Stephen Parra" }, { "name": "Tania Ross", "code": "Tania Ross" }, { "name": "Tashelle Whyte", "code": "Tashelle Whyte" }, { "name": "Valerie Edwards", "code": "Valerie Edwards" }, { "name": "Velius Charles", "code": "Velius Charles" }, { "name": "Wallace Stirrup", "code": "Wallace Stirrup" }, { "name": "Yoel Sanchez", "code": "Yoel Sanchez" }, { "name": "Hector Mora", "code": "Hector Mora" }, { "name": "Arianne De La Torre", "code": "Arianne De La Torre" }, { "name": "Darrell Cochran", "code": "Darrell Cochran" }, { "name": "Veronica Nieves", "code": "Veronica Nieves" }, { "name": "Melissa Anderson", "code": "Melissa Anderson" }, { "name": "Melquiades Espinel", "code": "Melquiades Espinel" }, { "name": "Monica Ramirez", "code": "Monica Ramirez" }, { "name": "Augusto Carvajal", "code": "Augusto Carvajal" }, { "name": "Juan Lewis", "code": "Juan Lewis" }, { "name": "Teresa Belledent", "code": "Teresa Belledent" }, { "name": "Yadira Diaz", "code": "Yadira Diaz" }, { "name": "Laurin Gibson", "code": "Laurin Gibson" }, { "name": "Maday Moreno", "code": "Maday Moreno" }, { "name": "Leond Jones", "code": "Leond Jones" }, { "name": "Alonso Santiago", "code": "Alonso Santiago" }, { "name": "Natasha Clay", "code": "Natasha Clay" }, { "name": "Mark Kleese", "code": "Mark Kleese" }, { "name": "Dexter Quinn", "code": "Dexter Quinn" }, { "name": "Olajide Afolabi", "code": "Olajide Afolabi" }, { "name": "Evan Drago", "code": "Evan Drago" }, { "name": "Jeffrey Gregg", "code": "Jeffrey Gregg" }, { "name": "Eduardo Espinola", "code": "Eduardo Espinola" }, { "name": "Janel Kemp", "code": "Janel Kemp" }, { "name": "Clovina Knight", "code": "Clovina Knight" }, { "name": "Tanyeka Johnsonn", "code": "Tanyeka Johnson" }, { "name": "Dequan Higgs", "code": "Dequan Higgs" }, { "name": "Jorge Toruno", "code": "Jorge Toruno" }, { "name": "Kalyn Pretino", "code": "Kalyn Pretino" }, { "name": "Orlando Hernandez-Arroyo", "code": "Orlando Hernandez-Arroyo" }, { "name": "Rose Chikere", "code": "Rose Chikere" }, { "name": "Brian Avila", "code": "Brian Avila" }, { "name": "Voneisha Mckinney", "code": "Voneisha Mckinney" }, { "name": "Tadeo Monterrubio", "code": "Tadeo Monterrubio" }, { "name": "Casandra Penuela", "code": "Casandra Penuela" }, { "name": "Andrew Betsko", "code": "Andrew Betsko" }, { "name": "Sebastian Correa", "code": "Sebastian Correa" }, { "name": "Xavier Stinson", "code": "Xavier Stinson" }, { "name": "Jose Careaga", "code": "Jose Careaga" }, { "name": "David Donnelly", "code": "David Donnelly" }, { "name": "Kathleen Ottoway", "code": "Kathleen Ottoway" }, { "name": "Danny Bess", "code": "Danny Bess" }, { "name": "Andrew Gentes", "code": "Andrew Gentes" }, { "name": "Bill Quinn", "code": "Bill Quinn" }, { "name": "Chandler Carrico", "code": "Chandler Carrico" }, { "name": "Jackie Lindeman", "code": "Jackie Lindeman" }, { "name": "Jeffrey Paul", "code": "Jeffrey Paul" }, { "name": "Michelle Selander", "code": "Michelle Selander" }, { "name": "Rhonda Philp", "code": "Rhonda Philp" }, { "name": "John Dudley", "code": "John Dudley" }, { "name": "Tracy Ford", "code": "Tracy Ford" }, { "name": "Christlene Lazarre", "code": "Christlene Lazarre" }, { "name": "Jacqueline Lima", "code": "Jacqueline Lima" }, { "name": "Linda Palmer-Scopetta", "code": "Linda Palmer-Scopetta" }, { "name": "Maria Sanchez", "code": "Maria Sanchez" }, { "name": "Debbie Barahona", "code": "Debbie Barahona" }, { "name": "Christopher Garcia", "code": "Christopher Garcia" }, { "name": "Matthew Howard", "code": "Matthew Howard" }, { "name": "Ross McAfee", "code": "Ross McAfee" }, { "name": "Cornelius Robinson", "code": "Cornelius Robinson" }, { "name": "Bianca Jean-Pierre", "code": "Bianca Jean-Pierre" }, { "name": "Jose Suarez Ricalo", "code": "Jose Suarez Ricalo" }, { "name": "Alfredo Pernas", "code": "Alfredo Pernas" }, { "name": "Dublas Rodriguez San Jorge", "code": "Dublas Rodriguez San Jorge" }, { "name": "Marcos Martinez Alvarez", "code": "Marcos Martinez Alvarez" }, { "name": "Juan Julio Morales", "code": "Juan Julio Morales" }, { "name": "Kevin Rozon", "code": "Kevin Rozon" }, { "name": "Jose Mayorga", "code": "Jose Mayorga" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspector" }, { "name": "Activity", "type": "esriFieldTypeString", "alias": "Activity", "domain": { "type": "codedValue", "name": "MSQTrapActivity", "description": "MSQTrapActivity", "codedValues": [ { "name": "Picked Up", "code": "Picked Up" }, { "name": "Dropped Off", "code": "Dropped Off" }, { "name": "Serviced", "code": "Serviced" }, { "name": "Vandalised", "code": "Vandalised" }, { "name": "Landing Rate", "code": "Landing Rate" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Activity" }, { "name": "ActivityDate", "type": "esriFieldTypeDate", "alias": "ActivityDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ActivityDate" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Comments" }, { "name": "InspectionID", "type": "esriFieldTypeGUID", "alias": "InspectionID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "InspectionID" }, { "name": "LandRate", "type": "esriFieldTypeSmallInteger", "alias": "Landing Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LandRate" }, { "name": "CreatedBy", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "created_user" }, { "name": "CreatedDate", "type": "esriFieldTypeDate", "alias": "Created Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "ModifiedBY", "type": "esriFieldTypeString", "alias": "Modified BY", "domain": null, "editable": false, "nullable": true, "length": 50, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "ModifiedDate", "type": "esriFieldTypeDate", "alias": "Modified Date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R254_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_254", "isAscending": true, "isUnique": false, "description": "", "fields": "GlobalID" }, { "name": "MSQTIInspectionI", "isAscending": true, "isUnique": false, "description": "", "fields": "InspectionID" }, { "name": "MSQTIGlobalID", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Traps Inspection", "description": "", "prototype": { "attributes": { "InspectionID": null, "LandRate": null, "Inspector": null, "Activity": null, "ActivityDate": null, "Comments": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }