{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "Project Request", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102746, "latestWkid": 2283, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -110512500, "falseY": -88858000, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 158, 33, 133, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 4.265217292594695E7, "ymin": 6035973.924599066, "xmax": 4.265217292594695E7, "ymax": 6035973.924599066, "spatialReference": { "wkid": 102746, "latestWkid": 2283, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -110512500, "falseY": -88858000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "RequesterName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "RecordID", "type": "esriFieldTypeString", "alias": "RecordID", "length": 13, "domain": null }, { "name": "RequesterName", "type": "esriFieldTypeString", "alias": "Requester's Name", "length": 30, "domain": null }, { "name": "Email", "type": "esriFieldTypeString", "alias": "Email", "length": 30, "domain": null }, { "name": "Dept", "type": "esriFieldTypeString", "alias": "Department", "length": 30, "domain": { "type": "codedValue", "name": "Departments", "description": "PWC Departments", "codedValues": [ { "name": "GTS", "code": "GTS" }, { "name": "Fire and Rescue", "code": "Fire and Rescue" }, { "name": "Planning", "code": "Planning" }, { "name": "Police", "code": "Police" }, { "name": "Parks and Recreation", "code": "Parks and Recreation" }, { "name": "Public Works MFPM", "code": "Public Works MFPM" }, { "name": "Public Works SWM", "code": "Public Works SWM" }, { "name": "Real Estate Assessments", "code": "Real Estate Assessments" }, { "name": "Transportation", "code": "Transportation" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Supervisor", "type": "esriFieldTypeString", "alias": "Supervisor", "length": 30, "domain": null }, { "name": "SupervisorEmail", "type": "esriFieldTypeString", "alias": "Supervisor Email", "length": 30, "domain": null }, { "name": "Discussed", "type": "esriFieldTypeString", "alias": "Discussed w/Supervisor", "length": 3, "domain": { "type": "codedValue", "name": "Yes/No", "description": "Universal Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RequestType", "type": "esriFieldTypeString", "alias": "Request Type", "length": 26, "domain": { "type": "codedValue", "name": "ProjectRequestType", "description": "Project Request Type", "codedValues": [ { "name": "Update Existing Project", "code": "4: Update Existing Project" }, { "name": "New GIS Work Request", "code": "1: New Request" }, { "name": "Request research into a future project", "code": "2: Research" }, { "name": "Training on a GIS-related topic", "code": "3: Training" }, { "name": "New Account or Permissions Changes", "code": "5: Account or Permissions" }, { "name": "Report Outage, Broken Tool, Site, or App", "code": "6: Report Outage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Deliverables", "type": "esriFieldTypeString", "alias": "Deliverables", "length": 100, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Request Description", "length": 500, "domain": null }, { "name": "Dependencies", "type": "esriFieldTypeString", "alias": "Dependencies", "length": 255, "domain": null }, { "name": "DesiredCompletion", "type": "esriFieldTypeDate", "alias": "Desired Completion Date", "length": 8, "domain": null }, { "name": "Reviewer", "type": "esriFieldTypeString", "alias": "Reviewer's Name", "length": 30, "domain": null }, { "name": "RequestCategory", "type": "esriFieldTypeString", "alias": "Request Category", "length": 20, "domain": { "type": "codedValue", "name": "ProjectCatagory", "description": "", "codedValues": [ { "name": "Minor Task", "code": "0" }, { "name": "Major Task", "code": "1" }, { "name": "Minor Project", "code": "2" }, { "name": "Major Project", "code": "3" }, { "name": "Strategic Plan", "code": "4" }, { "name": "Ongoing Maintenance", "code": "5" }, { "name": "Governance Initiative", "code": "6" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AssignedTo", "type": "esriFieldTypeString", "alias": "Assigned To", "length": 30, "domain": null }, { "name": "Due", "type": "esriFieldTypeDate", "alias": "Due", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Internal Notes", "length": 500, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "Project Name", "length": 50, "domain": null }, { "name": "CreateSharepoint", "type": "esriFieldTypeString", "alias": "Create SharePoint Channel", "length": 12, "domain": { "type": "codedValue", "name": "SharePoint", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Use Existing", "code": "Use Existing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SubmitDate", "type": "esriFieldTypeDate", "alias": "Submit Date", "length": 8, "domain": null }, { "name": "ProjectStatus", "type": "esriFieldTypeString", "alias": "Project Status", "length": 15, "domain": { "type": "codedValue", "name": "ProjectStatus", "description": "", "codedValues": [ { "name": "Submitted", "code": "Submitted" }, { "name": "Under Review", "code": "Under Review" }, { "name": "Rejected", "code": "Rejected" }, { "name": "Assigned", "code": "Assigned" }, { "name": "In progress", "code": "In progress" }, { "name": "Complete", "code": "Complete" }, { "name": "Merged", "code": "Merged" }, { "name": "Maintenance", "code": "Maintenance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LastTask", "type": "esriFieldTypeString", "alias": "Last Task Completed", "length": 30, "domain": null }, { "name": "LastTaskDate", "type": "esriFieldTypeDate", "alias": "Last Task Date", "length": 8, "domain": null }, { "name": "PastDue", "type": "esriFieldTypeString", "alias": "Past Due", "length": 3, "domain": { "type": "codedValue", "name": "Yes/No", "description": "Universal Yes/No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CompleteDate", "type": "esriFieldTypeDate", "alias": "Complete Date", "length": 8, "domain": null }, { "name": "AltRecordID", "type": "esriFieldTypeString", "alias": "Alternative RecordID", "length": 12, "domain": null }, { "name": "Urgent", "type": "esriFieldTypeString", "alias": "Urgent", "length": 3, "domain": null }, { "name": "EmailBody", "type": "esriFieldTypeString", "alias": "Email Body", "length": 500, "domain": null }, { "name": "SharepointPath", "type": "esriFieldTypeString", "alias": "SharepointPath", "length": 255, "domain": null }, { "name": "TotalHoursWorked", "type": "esriFieldTypeSmallInteger", "alias": "Total Hours Worked", "domain": null }, { "name": "TotalTasksCompleted", "type": "esriFieldTypeSmallInteger", "alias": "Total Tasks Completed", "domain": null }, { "name": "GTSContributors", "type": "esriFieldTypeString", "alias": "GTS Contributors", "length": 255, "domain": null }, { "name": "TasksExpected", "type": "esriFieldTypeSmallInteger", "alias": "Tasks Expected", "domain": null }, { "name": "TaskList", "type": "esriFieldTypeString", "alias": "Task List", "length": 255, "domain": null }, { "name": "PercentComplete", "type": "esriFieldTypeInteger", "alias": "Percent Complete", "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "DisplayStatus", "type": "esriFieldTypeString", "alias": "Display Status", "length": 15, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R1629_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1629", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G10562RecordID", "fields": "RecordID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S1424_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "gisdb.METADATA.ProjectLessonsLearned", "relatedTableId": 1, "role": "esriRelRoleOrigin", "keyField": "RecordID", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 0, "name": "gisdb.METADATA.ProjectTasksProgress", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "RecordID", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }