{
  "currentVersion" : 12, 
  "id" : 7, 
  "name" : "Structure_Deficiencies", 
  "type" : "Table", 
  "serviceItemId" : "2df1fb4a219c4dc3b31c294846a2f1b3", 
  "displayField" : "Station_Name", 
  "description" : "", 
  "copyrightText" : "", 
  "defaultVisibility" : true, 
  "serverGens" : {
    "minServerGen" : 590787, 
    "serverGen" : 590787
  }, 
  "editFieldsInfo" : {
    "creationDateField" : "CreationDate", 
    "creatorField" : "Creator", 
    "editDateField" : "EditDate", 
    "editorField" : "Editor"
  }, 
  "editingInfo" : {
    "lastEditDate" : 1779217447134, 
    "schemaLastEditDate" : 1778099567244, 
    "dataLastEditDate" : 1779217447134
  }, 
  "relationships" : [
    {
      "id" : 0, 
      "name" : "Structures", 
      "relatedTableId" : 4, 
      "cardinality" : "esriRelCardinalityOneToMany", 
      "role" : "esriRelRoleDestination", 
      "keyField" : "Build_ID", 
      "composite" : false
    }
  ], 
  "isDataVersioned" : false, 
  "hasContingentValuesDefinition" : false, 
  "supportsAppend" : true, 
  "supportsCalculate" : true, 
  "supportsASyncCalculate" : true, 
  "supportsTruncate" : false, 
  "supportsAttachmentsByUploadId" : true, 
  "supportsAttachmentsResizing" : true, 
  "supportsRollbackOnFailureParameter" : true, 
  "supportsStatistics" : true, 
  "supportsExceedsLimitStatistics" : true, 
  "supportsAdvancedQueries" : true, 
  "supportsValidateSql" : true, 
  "supportsCoordinatesQuantization" : true, 
  "supportsLayerOverrides" : true, 
  "supportsTilesAndBasicQueriesMode" : true, 
  "supportsFieldDescriptionProperty" : true, 
  "supportsQuantizationEditMode" : true, 
  "supportsColumnStoreIndex" : true, 
  "supportsApplyEditsWithGlobalIds" : true, 
  "advancedQueryCapabilities" : {
    "supportsPagination" : true, 
    "supportsPaginationOnAggregatedQueries" : true, 
    "supportsQueryRelatedPagination" : true, 
    "supportsQueryWithDistance" : true, 
    "supportsReturningQueryExtent" : false, 
    "supportsStatistics" : true, 
    "supportsOrderBy" : true, 
    "supportsDistinct" : true, 
    "supportsQueryWithResultType" : true, 
    "supportsSqlExpression" : true, 
    "supportsTimeRelation" : true, 
    "supportsAdvancedQueryRelated" : true, 
    "supportsCountDistinct" : true, 
    "supportsPercentileStatistics" : true, 
    "supportsApproxPercentileStatistics" : true, 
    "supportsSpatialAggregationStatistics" : true, 
    "supportedSpatialAggregationStatistics" : [
      "EnvelopeAggregate", 
      "CentroidAggregate", 
      "ConvexHullAggregate"
    ], 
    "supportsQueryAttachments" : true, 
    "supportsQueryAttachmentsCountOnly" : true, 
    "supportsQueryAttachmentOrderByFields" : true, 
    "supportsQueryAttachmentWithTypeWildcard" : true, 
    "supportsLod" : true, 
    "supportsQueryWithLodSR" : false, 
    "supportedLodTypes" : [
      "geohash"
    ], 
    "supportsReturningGeometryCentroid" : false, 
    "supportsReturningGeometryEnvelope" : true, 
    "supportsQueryWithDatumTransformation" : true, 
    "supportsCurrentUserQueries" : true, 
    "supportsHavingClause" : true, 
    "supportsOutFieldSQLExpression" : true, 
    "supportsMaxRecordCountFactor" : true, 
    "supportsTopFeaturesQuery" : true, 
    "supportsQueryWithCacheHint" : true, 
    "supportedOperationsWithCacheHint" : [
      "query", 
      "queryTopFilter", 
      "queryAnalytics", 
      "queryAttachments", 
      "queryRelated", 
      "queryBins", 
      "queryPivot"
    ], 
    "supportsQueryAttachmentsWithReturnUrl" : true, 
    "supportsQueryAnalytic" : true, 
    "supportsQueryPivot" : true, 
    "supportsQueryBins" : true, 
    "supportsDefaultSR" : true, 
    "supportsTranslations" : false, 
    "supportsAggIds" : true, 
    "supportsQueryWithCollation" : true, 
    "supportsISODOW" : true, 
    "supportsISOWeek" : true, 
    "supportsFullTextSearch" : true, 
    "fullTextSearchCapabilities" : {
      "supportsAccentSensitivity" : true, 
      "supportsStopWords" : true, 
      "supportsSearchOperator" : true, 
      "supportsOperator" : true
    }
  }, 
  "advancedQueryAnalyticCapabilities" : {
    "supportsLinearRegression" : true, 
    "supportsTrendlineRegression" : true, 
    "supportsAsync" : true, 
    "supportsPercentileAnalytic" : true
  }, 
  "queryBinsCapabilities" : {
    "supportsAsync" : true, 
    "supportsAutoIntervalBin" : true, 
    "supportsFixedIntervalBin" : true, 
    "supportsFixedBoundariesBin" : true, 
    "supportsDateBin" : true, 
    "supportsClassificationBin" : true, 
    "supportsStackBy" : true, 
    "supportsSplitBy" : true, 
    "supportsFirstDayOfWeek" : true, 
    "supportsSnapToData" : true, 
    "supportsReturnFullIntervalBin" : true, 
    "supportsReturnStackValueRange" : true, 
    "supportsNormalization" : true, 
    "supportedStatisticTypes" : [
      "COUNT", 
      "SUM", 
      "AVG", 
      "VAR", 
      "STDDEV", 
      "MIN", 
      "MAX", 
      "PERCENTILE_CONT", 
      "PERCENTILE_DISC", 
      "APPROX_PERCENTILE_CONT", 
      "APPROX_PERCENTILE_DISC", 
      "CentroidAggregate", 
      "EnvelopeAggregate", 
      "ConvexHullAggregate"
    ], 
    "supportedNormalizationTypes" : [
      "boxCox", 
      "field", 
      "inverse", 
      "log", 
      "naturalLog", 
      "percentOfTotal", 
      "squareRoot"
    ]
  }, 
  "supportedOperationsWithCollation" : "query,addField,updateField", 
  "advancedEditingCapabilities" : {
    "supportedSqlFormatsInCalculate" : [
      "standard"
    ], 
    "supportsAsyncApplyEdits" : true, 
    "supportsReturnEditResults" : true, 
    "supportsApplyEditsbyUploadID" : true, 
    "supportedApplyEditsUploadIDFormats" : "JSON,PBF", 
    "supportsTranslation" : false, 
    "supportsMaxTranslations" : 10
  }, 
  "infoInEstimates" : [
    "count"
  ], 
  "useStandardizedQueries" : true, 
  "allowGeometryUpdates" : true, 
  "hasAttachments" : true, 
  
  "attachmentProperties" : [
    {
      "name" : "id", 
      "fieldName" : "ATTACHMENTID", 
      "isEnabled" : true
    }, 
    {
      "name" : "globalId", 
      "fieldName" : "AttachmentGlobalID", 
      "isEnabled" : true
    }, 
    {
      "name" : "name", 
      "fieldName" : "ATT_NAME", 
      "isEnabled" : true
    }, 
    {
      "name" : "size", 
      "fieldName" : "DATA_SIZE", 
      "isEnabled" : true
    }, 
    {
      "name" : "contentType", 
      "fieldName" : "CONTENT_TYPE", 
      "isEnabled" : true
    }, 
    {
      "name" : "keywords", 
      "fieldName" : "Keywords", 
      "isEnabled" : true
    }, 
    {
      "name" : "exifInfo", 
      "fieldName" : "ExifInfo", 
      "isEnabled" : true
    }
  ], 
  "htmlPopupType" : "esriServerHTMLPopupTypeNone", 
  "hasMetadata" : true, 
  "hasM" : false, 
  "hasZ" : false, 
  "objectIdField" : "OBJECTID", 
  "uniqueIdField" : 
  {
    "name" : "OBJECTID", 
    "isSystemMaintained" : true
  }, 
  "globalIdField" : "GlobalID_2", 
  "typeIdField" : "", 
  "collation" : {
    "locale" : "neutral", 
    "caseSensitive" : false, 
    "accentSensitive" : true
  }, 
  "fields" : [
    {
      "name" : "OBJECTID", 
      "type" : "esriFieldTypeOID", 
      "alias" : "OBJECTID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Station_Name", 
      "type" : "esriFieldTypeString", 
      "alias" : "Station Name", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Build_ID", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Build ID", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Short_Name", 
      "type" : "esriFieldTypeString", 
      "alias" : "Short Name", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Deficiency_Project_Name", 
      "type" : "esriFieldTypeString", 
      "alias" : "Deficiency/Project Name", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Description", 
      "type" : "esriFieldTypeString", 
      "alias" : "Description", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Est__Cost", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "Est. Cost", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Project_Type", 
      "type" : "esriFieldTypeString", 
      "alias" : "Project Type", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Structure_Deficiencies_Project_Type_6a82d6a3-7965-4569-882f-32b1d8f8ee2d", 
        "codedValues" : [
          {
            "name" : "Routine Maintenance", 
            "code" : "Routine Maintenance"
          }, 
          {
            "name" : "Major Repair", 
            "code" : "Major Repair"
          }, 
          {
            "name" : "Capital Development", 
            "code" : "Capital Development"
          }, 
          {
            "name" : "Demolition", 
            "code" : "Demolition"
          }, 
          {
            "name" : "Monitor/Investigate", 
            "code" : "Monitor/Investigate"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Deficiency_Category", 
      "type" : "esriFieldTypeString", 
      "alias" : "Deficiency Category", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Structure_Deficiencies_Deficiency_Category_ce2974d6-5f7a-4d9a-8784-c85f173965a3", 
        "codedValues" : [
          {
            "name" : "Safety", 
            "code" : "Safety"
          }, 
          {
            "name" : "Damage/Wear Out", 
            "code" : "Damage/Wear Out"
          }, 
          {
            "name" : "Codes and Standards", 
            "code" : "Codes and Standards"
          }, 
          {
            "name" : "Environment Improvements", 
            "code" : "Environment Improvements"
          }, 
          {
            "name" : "Energy Conservation", 
            "code" : "Energy Conservation"
          }, 
          {
            "name" : "Building Improvements", 
            "code" : "Building Improvements"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "System", 
      "type" : "esriFieldTypeString", 
      "alias" : "System", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Structure_Deficiencies_System_e3b1b743-df2a-4ccc-867e-8dad9d5d761d", 
        "codedValues" : [
          {
            "name" : "Foundation", 
            "code" : "Foundation"
          }, 
          {
            "name" : "Envelope", 
            "code" : "Envelope"
          }, 
          {
            "name" : "Floor System", 
            "code" : "Floor System"
          }, 
          {
            "name" : "Roof System", 
            "code" : "Roof System"
          }, 
          {
            "name" : "Finishes", 
            "code" : "Finishes"
          }, 
          {
            "name" : "Specialties", 
            "code" : "Specialties"
          }, 
          {
            "name" : "HVAC", 
            "code" : "HVAC"
          }, 
          {
            "name" : "Plumbing System", 
            "code" : "Plumbing System"
          }, 
          {
            "name" : "Electrical System", 
            "code" : "Electrical System"
          }, 
          {
            "name" : "Safety System", 
            "code" : "Safety System"
          }, 
          {
            "name" : "Multiple", 
            "code" : "Multiple"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Status", 
      "type" : "esriFieldTypeString", 
      "alias" : "Status", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Station_Project_Priority__old_", 
      "type" : "esriFieldTypeString", 
      "alias" : "Station Project Priority (old)", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "Station_Priority", 
      "type" : "esriFieldTypeString", 
      "alias" : "Station Priority", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Structure_Deficiencies_Station_Priority_c1ba8c53-a9fa-4438-80e7-3fd599bded35", 
        "codedValues" : [
          {
            "name" : "High", 
            "code" : "High"
          }, 
          {
            "name" : "Medium", 
            "code" : "Medium"
          }, 
          {
            "name" : "Low", 
            "code" : "Low"
          }
        ]
      }, 
      "defaultValue" : null
    }, 
    {
      "name" : "Comments", 
      "type" : "esriFieldTypeString", 
      "alias" : "Comments", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "created_user", 
      "type" : "esriFieldTypeString", 
      "alias" : "created_user", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "created_date", 
      "type" : "esriFieldTypeString", 
      "alias" : "created_date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "last_edited_user", 
      "type" : "esriFieldTypeString", 
      "alias" : "last_edited_user", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "last_edited_date", 
      "type" : "esriFieldTypeString", 
      "alias" : "last_edited_date", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "GlobalID", 
      "type" : "esriFieldTypeString", 
      "alias" : "GlobalID", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "ParentGuid", 
      "type" : "esriFieldTypeString", 
      "alias" : "ParentGuid", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "x", 
      "type" : "esriFieldTypeString", 
      "alias" : "x", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "y", 
      "type" : "esriFieldTypeString", 
      "alias" : "y", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8000, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "GlobalID_2", 
      "type" : "esriFieldTypeGlobalID", 
      "alias" : "GlobalID_2", 
      "sqlType" : "sqlTypeOther", 
      "length" : 38, 
      "nullable" : false, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : "NEWID() WITH VALUES"
    }, 
    {
      "name" : "CreationDate", 
      "type" : "esriFieldTypeDate", 
      "alias" : "CreationDate", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "Creator", 
      "type" : "esriFieldTypeString", 
      "alias" : "Creator", 
      "sqlType" : "sqlTypeOther", 
      "length" : 128, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "EditDate", 
      "type" : "esriFieldTypeDate", 
      "alias" : "EditDate", 
      "sqlType" : "sqlTypeOther", 
      "length" : 8, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null, 
      "precision" : 1
    }, 
    {
      "name" : "Editor", 
      "type" : "esriFieldTypeString", 
      "alias" : "Editor", 
      "sqlType" : "sqlTypeOther", 
      "length" : 128, 
      "nullable" : true, 
      "editable" : false, 
      "domain" : null, 
      "defaultValue" : null
    }, 
    {
      "name" : "DefPercent", 
      "type" : "esriFieldTypeInteger", 
      "alias" : "DefPercent", 
      "sqlType" : "sqlTypeOther", 
      "nullable" : true, 
      "editable" : true, 
      "domain" : null, 
      "defaultValue" : null, 
      "description" : "{\"value\":\"\",\"fieldValueType\":\"percentageOrRatio\"}"
    }, 
    {
      "name" : "ToggletoEdit", 
      "type" : "esriFieldTypeString", 
      "alias" : "ToggletoEdit", 
      "sqlType" : "sqlTypeOther", 
      "length" : 256, 
      "nullable" : true, 
      "editable" : true, 
      "domain" : 
      {
        "type" : "codedValue", 
        "name" : "Structure_Deficiencies_ToggletoEdit_a2111d36-ef5a-4fa1-85cb-14a6b536108f", 
        "codedValues" : [
          {
            "name" : "Yes", 
            "code" : "Yes"
          }, 
          {
            "name" : "No", 
            "code" : "No"
          }
        ]
      }, 
      "defaultValue" : "No"
    }
  ], 
  "indexes" : [
    {
      "name" : "PK__FCA_MAES__F4B70D85496BB1E8", 
      "fields" : "OBJECTID", 
      "isAscending" : true, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "G4Build_ID", 
      "fields" : "Build_ID", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "GlobalID_2_Index", 
      "fields" : "GlobalID_2", 
      "isAscending" : false, 
      "isUnique" : true, 
      "description" : "", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "CreationDateIndex", 
      "fields" : "CreationDate", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "CreationDate Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "CreatorIndex", 
      "fields" : "Creator", 
      "isAscending" : false, 
      "isUnique" : false, 
      "description" : "Creator Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "EditDateIndex", 
      "fields" : "EditDate", 
      "isAscending" : true, 
      "isUnique" : false, 
      "description" : "EditDate Field index", 
      "indexType" : "Attribute"
    }, 
    {
      "name" : "EditorIndex", 
      "fields" : "Editor", 
      "isAscending" : false, 
      "isUnique" : false, 
      "description" : "Editor Field index", 
      "indexType" : "Attribute"
    }
  ], 
  "dateFieldsTimeReference" : {
    "timeZone" : "UTC", 
    "timeZoneIANA" : "Etc/UTC", 
    "respectsDaylightSaving" : false
  }, 
  "preferredTimeReference" : null, 
  "types" : [], 
  "templates" : [
    {
      "name" : "Structure_Deficiencies", 
      "description" : "", 
      "drawingTool" : "esriFeatureEditToolNone", 
      "prototype" : {
        "attributes" : {
          "x" : null, 
          "y" : null, 
          "Station_Name" : null, 
          "Build_ID" : null, 
          "Short_Name" : null, 
          "Deficiency_Project_Name" : null, 
          "Description" : null, 
          "Est__Cost" : null, 
          "Project_Type" : null, 
          "Deficiency_Category" : null, 
          "System" : null, 
          "Status" : null, 
          "Station_Project_Priority__old_" : null, 
          "Station_Priority" : null, 
          "Comments" : null, 
          "created_user" : null, 
          "created_date" : null, 
          "last_edited_user" : null, 
          "last_edited_date" : null, 
          "GlobalID" : null, 
          "ParentGuid" : null, 
          "ToggletoEdit" : "No"
        }
      }
    }
  ], 
  "supportedQueryFormats" : "JSON, geoJSON, PBF", 
  "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", 
  "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", 
  "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", 
  "supportedConvertFileFormats" : "JSON,PBF", 
  "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", 
  "guidFormat" : "", 
  "supportsContingentValues" : true, 
  "supportedContingentValuesFormats" : "JSON, PBF", 
  "supportsFieldGroups" : true, 
  "supportedSyncDataOptions" : 260, 
  "hasStaticData" : false, 
  "maxRecordCount" : 2000, 
  "standardMaxRecordCount" : 32000, 
  "tileMaxRecordCount" : 8000, 
  "maxRecordCountFactor" : 1, 
  "capabilities" : "Create,Delete,Query,Update,Editing,Extract,Sync,ChangeTracking"
}