{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Access Points", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 0, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 1, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 2, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708901.0325999996, "ymin" : 5640768.7931, "xmax" : 1709535.3986, "ymax" : 5641992.9798, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[32,141,155,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "primary_secondary", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Primary", "code" : "Primary" }, { "name" : "Secondary", "code" : "Secondary" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85A9E743E4", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_ACCESS_POINTS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Access Points", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 1, "name" : "Devices", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 3, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 4, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 5, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708908.9354999997, "ymin" : 5641231.7279, "xmax" : 1709710.1224999996, "ymax" : 5641941.0334, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[142,38,147,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "device_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Water", "code" : "Water" }, { "name" : "Electric", "code" : "Electric" }, { "name" : "Effluent", "code" : "Effluent" }, { "name" : "Irrigation", "code" : "Irrigation" }, { "name" : "Soil", "code" : "Soil" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "device_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Energizer", "code" : "Energizer" }, { "name" : "Trough", "code" : "Trough" }, { "name" : "Tank", "code" : "Tank" }, { "name" : "System", "code" : "System" }, { "name" : "Well", "code" : "Well" }, { "name" : "Pond", "code" : "Pond" }, { "name" : "Gauge", "code" : "Gauge" }, { "name" : "Probe", "code" : "Probe" }, { "name" : "Test", "code" : "Test" }, { "name" : "Bore", "code" : "Bore" }, { "name" : "Meter", "code" : "Meter" } ] }, "defaultValue" : null }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "device_purpose", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Flow", "code" : "Flow" }, { "name" : "Rain", "code" : "Rain" }, { "name" : "Moisture", "code" : "Moisture" }, { "name" : "Nutrient", "code" : "Nutrient" } ] }, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "capacity", "type" : "esriFieldTypeDouble", "alias" : "Capacity", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "device_units", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "units", "code" : "units" }, { "name" : "millimetre", "code" : "millimetre" }, { "name" : "centimeter", "code" : "centimeter" }, { "name" : "meters", "code" : "meters" }, { "name" : "kilometers", "code" : "kilometers" }, { "name" : "kilogram", "code" : "kilogram" }, { "name" : "tonne", "code" : "tonne" }, { "name" : "litre", "code" : "litre" }, { "name" : "cubic metre", "code" : "cubic metre" } ] }, "defaultValue" : null }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "device_material", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Polyurethane", "code" : "Polyurethane" }, { "name" : "Wood", "code" : "Wood" }, { "name" : "Metal", "code" : "Metal" }, { "name" : "Asphalt", "code" : "Asphalt" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85C2A7E531", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_DEVICES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Devices", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 2, "name" : "Objects", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 6, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 7, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 8, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708891.7057999996, "ymin" : 5641190.7787, "xmax" : 1708924.4044000003, "ymax" : 5641985.9656, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[68,147,142,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "object_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Natural", "code" : "Natural" }, { "name" : "Topographic", "code" : "Topographic" }, { "name" : "Infrastructure", "code" : "Infrastructure" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "object_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Powerpole", "code" : "Powerpole" }, { "name" : "Tree", "code" : "Tree" }, { "name" : "Dam", "code" : "Dam" }, { "name" : "Cliff", "code" : "Cliff" } ] }, "defaultValue" : null }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "capacity", "type" : "esriFieldTypeDouble", "alias" : "Capacity", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "object_units", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "units", "code" : "units" }, { "name" : "millimetre", "code" : "millimetre" }, { "name" : "centimeter", "code" : "centimeter" }, { "name" : "meters", "code" : "meters" }, { "name" : "kilometers", "code" : "kilometers" }, { "name" : "kilogram", "code" : "kilogram" }, { "name" : "tonne", "code" : "tonne" }, { "name" : "litre", "code" : "litre" }, { "name" : "cubic metre", "code" : "cubic metre" } ] }, "defaultValue" : null }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "object_material", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Polyurethane", "code" : "Polyurethane" }, { "name" : "Wood", "code" : "Wood" }, { "name" : "Metal", "code" : "Metal" }, { "name" : "Asphalt", "code" : "Asphalt" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85A9EF50BD", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_OBJECTS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Objects", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 3, "name" : "Structures", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 9, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 10, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 11, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 12, "name" : "details", "relatedTableId" : 9, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 13, "name" : "measurements", "relatedTableId" : 14, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "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" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708903.5349000003, "ymin" : 5640796.8644, "xmax" : 1709636.91, "ymax" : 5641956.9361391366, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[153,105,76,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "structure_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Production", "code" : "Production" }, { "name" : "Storage", "code" : "Storage" }, { "name" : "Service", "code" : "Service" }, { "name" : "Management", "code" : "Management" }, { "name" : "Waste", "code" : "Waste" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "structure_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Vat", "code" : "Vat" }, { "name" : "Silo", "code" : "Silo" }, { "name" : "Tank", "code" : "Tank" }, { "name" : "Pit", "code" : "Pit" }, { "name" : "Shed", "code" : "Shed" }, { "name" : "Yard", "code" : "Yard" }, { "name" : "Ramp", "code" : "Ramp" }, { "name" : "House", "code" : "House" }, { "name" : "Office", "code" : "Office" }, { "name" : "Pond", "code" : "Pond" }, { "name" : "Sump", "code" : "Sump" }, { "name" : "Bunker", "code" : "Bunker" }, { "name" : "Pad", "code" : "Pad" } ] }, "defaultValue" : null }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "structure_purpose", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Milk", "code" : "Milk" }, { "name" : "Chemical", "code" : "Chemical" }, { "name" : "Fertiliser", "code" : "Fertiliser" }, { "name" : "Fuel", "code" : "Fuel" }, { "name" : "Silage", "code" : "Silage" }, { "name" : "Grain", "code" : "Grain" }, { "name" : "Hay", "code" : "Hay" }, { "name" : "Wood", "code" : "Wood" }, { "name" : "Recycling", "code" : "Recycling" }, { "name" : "Rubbish", "code" : "Rubbish" }, { "name" : "Offal", "code" : "Offal" }, { "name" : "Loading", "code" : "Loading" }, { "name" : "Holding", "code" : "Holding" }, { "name" : "Utility", "code" : "Utility" }, { "name" : "Residential", "code" : "Residential" }, { "name" : "Calf", "code" : "Calf" }, { "name" : "Machinery", "code" : "Machinery" }, { "name" : "Effluent", "code" : "Effluent" }, { "name" : "General", "code" : "General" }, { "name" : "Supplement", "code" : "Supplement" }, { "name" : "Stock", "code" : "Stock" }, { "name" : "Feed", "code" : "Feed" }, { "name" : "Standoff", "code" : "Standoff" } ] }, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "capacity", "type" : "esriFieldTypeDouble", "alias" : "Capacity", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "structure_units", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "units", "code" : "units" }, { "name" : "millimetre", "code" : "millimetre" }, { "name" : "centimeter", "code" : "centimeter" }, { "name" : "meters", "code" : "meters" }, { "name" : "kilometers", "code" : "kilometers" }, { "name" : "kilogram", "code" : "kilogram" }, { "name" : "tonne", "code" : "tonne" }, { "name" : "litre", "code" : "litre" }, { "name" : "cubic metre", "code" : "cubic metre" } ] }, "defaultValue" : null }, { "name" : "usage", "type" : "esriFieldTypeString", "alias" : "Usage", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "structure_material", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Polyurethane", "code" : "Polyurethane" }, { "name" : "Wood", "code" : "Wood" }, { "name" : "Metal", "code" : "Metal" }, { "name" : "Asphalt", "code" : "Asphalt" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85009B0DA4", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_STRUCTURES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Structures", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 4, "name" : "Network", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 14, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 15, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 16, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708901.0325999996, "ymin" : 5640803.5081, "xmax" : 1709730.5137999998, "ymax" : 5641995.0195, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[132,50,95,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "network_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Transport", "code" : "Transport" }, { "name" : "Water", "code" : "Water" }, { "name" : "Electric", "code" : "Electric" }, { "name" : "Effluent", "code" : "Effluent" }, { "name" : "Irrigation", "code" : "Irrigation" }, { "name" : "Barrier", "code" : "Barrier" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "network_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Fence", "code" : "Fence" }, { "name" : "Overhead Power Line", "code" : "Overhead Power Line" }, { "name" : "Underground Power Line", "code" : "Underground Power Line" }, { "name" : "Pipe", "code" : "Pipe" }, { "name" : "Race", "code" : "Race" }, { "name" : "Bridge", "code" : "Bridge" }, { "name" : "Cattlestop", "code" : "Cattlestop" }, { "name" : "Culvert", "code" : "Culvert" }, { "name" : "Gate", "code" : "Gate" }, { "name" : "Road Crossing", "code" : "Road Crossing" }, { "name" : "Hedge", "code" : "Hedge" }, { "name" : "Shelter Belt", "code" : "Shelter Belt" }, { "name" : "Waterway", "code" : "Waterway" } ] }, "defaultValue" : null }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "network_purpose", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Acquisition", "code" : "Acquisition" }, { "name" : "Distribution", "code" : "Distribution" }, { "name" : "General", "code" : "General" }, { "name" : "Permanent", "code" : "Permanent" }, { "name" : "Intermittent", "code" : "Intermittent" }, { "name" : "Ephemeral", "code" : "Ephemeral" } ] }, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "capacity", "type" : "esriFieldTypeDouble", "alias" : "Capacity", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "network_units", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "units", "code" : "units" }, { "name" : "millimetre", "code" : "millimetre" }, { "name" : "centimeter", "code" : "centimeter" }, { "name" : "meters", "code" : "meters" }, { "name" : "kilometers", "code" : "kilometers" }, { "name" : "kilogram", "code" : "kilogram" }, { "name" : "tonne", "code" : "tonne" }, { "name" : "litre", "code" : "litre" }, { "name" : "cubic metre", "code" : "cubic metre" } ] }, "defaultValue" : null }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "network_material", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Concrete", "code" : "Concrete" }, { "name" : "Polyurethane", "code" : "Polyurethane" }, { "name" : "Wood", "code" : "Wood" }, { "name" : "Metal", "code" : "Metal" }, { "name" : "Asphalt", "code" : "Asphalt" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D851DA07E80", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_NETWORK_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Network", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 5, "name" : "Zones", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 17, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 18, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 19, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -4020763.2677228367, "ymin" : 2036.0570636580535, "xmax" : 7220763.2677228367, "ymax" : 19997963.942936342, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,236,184,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "zone_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Operational", "code" : "Operational" }, { "name" : "Natural", "code" : "Natural" }, { "name" : "Water", "code" : "Water" }, { "name" : "Other", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "zone_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Irrigation", "code" : "Irrigation" }, { "name" : "Effluent", "code" : "Effluent" }, { "name" : "Fertiliser", "code" : "Fertiliser" }, { "name" : "Pest Control", "code" : "Pest Control" }, { "name" : "Native Vegetation", "code" : "Native Vegetation" }, { "name" : "Exotic Vegetation", "code" : "Exotic Vegetation" }, { "name" : "Wetland", "code" : "Wetland" }, { "name" : "Gulley", "code" : "Gulley" }, { "name" : "Swale", "code" : "Swale" }, { "name" : "Beautification", "code" : "Beautification" }, { "name" : "Collecting Yard", "code" : "Collecting Yard" }, { "name" : "Erosion Prone", "code" : "Erosion Prone" }, { "name" : "Flood Prone", "code" : "Flood Prone" }, { "name" : "Crop", "code" : "Crop" }, { "name" : "Waterbody", "code" : "Waterbody" }, { "name" : "Scrubland", "code" : "Scrubland" }, { "name" : "Forestry", "code" : "Forestry" } ] }, "defaultValue" : null }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D855A0CE3B5", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_ZONES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Zones", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 6, "name" : "Blocks", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 20, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 21, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 22, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708890.773, "ymin" : 5640768.6722, "xmax" : 1709738.8102000002, "ymax" : 5642011.1522, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[197,184,252,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "primary_secondary", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Primary", "code" : "Primary" }, { "name" : "Secondary", "code" : "Secondary" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "block_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Paddock", "code" : "Paddock" }, { "name" : "Corridor", "code" : "Corridor" }, { "name" : "Stand", "code" : "Stand" }, { "name" : "Residential", "code" : "Residential" } ] }, "defaultValue" : null }, { "name" : "purpose", "type" : "esriFieldTypeString", "alias" : "Purpose", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "purpose_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Transport", "code" : "Transport" }, { "name" : "Waterway", "code" : "Waterway" }, { "name" : "Forestry", "code" : "Forestry" }, { "name" : "Supplement", "code" : "Supplement" } ] }, "defaultValue" : null }, { "name" : "productive", "type" : "esriFieldTypeString", "alias" : "Productive", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "yes_no", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "protected", "type" : "esriFieldTypeString", "alias" : "Protected", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "yes_no", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "retired", "type" : "esriFieldTypeString", "alias" : "Retired", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "yes_no", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "riparian", "type" : "esriFieldTypeString", "alias" : "Riparian", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "yes_no", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85002E38D5", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_BLOCKS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Blocks", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 7, "name" : "Sites", "type" : "Feature Layer", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 23, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 24, "name" : "staff", "relatedTableId" : 15, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 25, "name" : "details", "relatedTableId" : 9, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 26, "name" : "measurements", "relatedTableId" : 14, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeAreaFieldName" : "Shape__Area", "shapeLengthFieldName" : "Shape__Length" }, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : true, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : 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" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPolygon", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 1708890.773, "ymin" : 5640768.6722, "xmax" : 1709738.8102000002, "ymax" : 5642011.1522, "spatialReference" : { "wkid" : 2193, "latestWkid" : 2193 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[252,199,233,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "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" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "primary_secondary", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Primary", "code" : "Primary" }, { "name" : "Secondary", "code" : "Secondary" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "site_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Dairy", "code" : "Dairy" }, { "name" : "Dry Stock", "code" : "Dry Stock" }, { "name" : "Forestry", "code" : "Forestry" }, { "name" : "Horticulture", "code" : "Horticulture" } ] }, "defaultValue" : null }, { "name" : "capacity", "type" : "esriFieldTypeSmallInteger", "alias" : "Capacity", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "site_units", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "units", "code" : "units" }, { "name" : "millimetre", "code" : "millimetre" }, { "name" : "centimeter", "code" : "centimeter" }, { "name" : "meters", "code" : "meters" }, { "name" : "kilometers", "code" : "kilometers" }, { "name" : "kilogram", "code" : "kilogram" }, { "name" : "tonne", "code" : "tonne" }, { "name" : "litre", "code" : "litre" }, { "name" : "cubic metre", "code" : "cubic metre" } ] }, "defaultValue" : null }, { "name" : "usage", "type" : "esriFieldTypeString", "alias" : "Usage", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Shape__Area", "type" : "esriFieldTypeDouble", "alias" : "Shape__Area", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85B4321D92", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_1926.FARM_DATA_MASTER_SITES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Area_Index", "fields" : "Shape__Area", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" }, { "name" : "unique_number_Index", "fields" : "unique_number", "isAscending" : true, "isUnique" : false, "description" : "unique_number_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Sites", "description" : "", "drawingTool" : "esriFeatureEditToolPolygon", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" } ], "tables" : [ { "currentVersion" : 12, "id" : 8, "name" : "Activities", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 27, "name" : "logs", "relatedTableId" : 13, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 1, "name" : "access_points", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_access_points_id", "composite" : false }, { "id" : 21, "name" : "blocks", "relatedTableId" : 6, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_blocks_id", "composite" : false }, { "id" : 7, "name" : "objects", "relatedTableId" : 2, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_objects_id", "composite" : false }, { "id" : 23, "name" : "sites", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_sites_id", "composite" : false }, { "id" : 15, "name" : "network", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_network_id", "composite" : false }, { "id" : 10, "name" : "structures", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_structures_id", "composite" : false }, { "id" : 4, "name" : "devices", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_devices_id", "composite" : false }, { "id" : 18, "name" : "zones", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_zones_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", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "category", "type" : "esriFieldTypeString", "alias" : "Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "activites_category", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Adjustment", "code" : "Adjustment" }, { "name" : "Training", "code" : "Training" }, { "name" : "Works", "code" : "Works" } ] }, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "activites_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Action", "code" : "Action" }, { "name" : "Routine", "code" : "Routine" } ] }, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "goal", "type" : "esriFieldTypeString", "alias" : "Goal", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "rate_of_return", "type" : "esriFieldTypeString", "alias" : "Rate of Return", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "rate_of_return", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Immediate", "code" : "Immediate" }, { "name" : "Gradual", "code" : "Gradual" }, { "name" : "Long Term", "code" : "Long Term" } ] }, "defaultValue" : null }, { "name" : "effectiveness_period", "type" : "esriFieldTypeString", "alias" : "Effectiveness Period", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "effectiveness_period", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "\u003c1 Year", "code" : "\u003c1 Year" }, { "name" : "2-5 Years", "code" : "2-5 Years" }, { "name" : "5-10 Years", "code" : "5-10 Years" }, { "name" : "10+ Years", "code" : "10+ Years" } ] }, "defaultValue" : null }, { "name" : "benefits", "type" : "esriFieldTypeString", "alias" : "Benefits", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "priority", "type" : "esriFieldTypeString", "alias" : "Priority", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "priority", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Low", "code" : "Low" }, { "name" : "Medium", "code" : "Medium" }, { "name" : "High", "code" : "High" }, { "name" : "Extreme", "code" : "Extreme" } ] }, "defaultValue" : null }, { "name" : "estimated_effort", "type" : "esriFieldTypeDouble", "alias" : "Estimated Effort", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "estimated_cost", "type" : "esriFieldTypeDouble", "alias" : "Estimated Cost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "actual_cost", "type" : "esriFieldTypeDouble", "alias" : "Actual Cost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "responsibility_of", "type" : "esriFieldTypeString", "alias" : "Responsibility Of", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "required_by", "type" : "esriFieldTypeDate", "alias" : "Required By", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_access_points_id", "type" : "esriFieldTypeGUID", "alias" : "Parent access points ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_devices_id", "type" : "esriFieldTypeGUID", "alias" : "Parent devices ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_objects_id", "type" : "esriFieldTypeGUID", "alias" : "Parent objects ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_structures_id", "type" : "esriFieldTypeGUID", "alias" : "Parent structures ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_network_id", "type" : "esriFieldTypeGUID", "alias" : "Parent network ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_zones_id", "type" : "esriFieldTypeGUID", "alias" : "Parent zones ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_blocks_id", "type" : "esriFieldTypeGUID", "alias" : "Parent blocks ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_sites_id", "type" : "esriFieldTypeGUID", "alias" : "Parent sites ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85C76B98B5", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_sites_", "fields" : "parent_sites_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_blocks", "fields" : "parent_blocks_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_zones_", "fields" : "parent_zones_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_networ", "fields" : "parent_network_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_struct", "fields" : "parent_structures_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_object", "fields" : "parent_objects_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_device", "fields" : "parent_devices_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G50parent_access", "fields" : "parent_access_points_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Activities", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 9, "name" : "Details", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 12, "name" : "structures", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_structures_id", "composite" : false }, { "id" : 25, "name" : "sites", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_sites_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", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Current", "code" : "Current" }, { "name" : "Proposed", "code" : "Proposed" }, { "name" : "Temporary", "code" : "Temporary" }, { "name" : "Historic", "code" : "Historic" } ] }, "defaultValue" : "Current" }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "detail_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "A2 Supplier", "code" : "A2 Supplier" }, { "name" : "Vet", "code" : "Vet" }, { "name" : "Chemical Company", "code" : "Chemical Company" }, { "name" : "Monitoring System", "code" : "Monitoring System" }, { "name" : "Cooling System", "code" : "Cooling System" }, { "name" : "Plant Wast System", "code" : "Plant Wast System" }, { "name" : "Internal Record", "code" : "Internal Record" }, { "name" : "Other", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "link", "type" : "esriFieldTypeString", "alias" : "Link", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_structures_id", "type" : "esriFieldTypeGUID", "alias" : "Parent structures ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_sites_id", "type" : "esriFieldTypeGUID", "alias" : "Parent sites ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85B3034900", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G69parent_sites_", "fields" : "parent_sites_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G69parent_struct", "fields" : "parent_structures_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Details", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 10, "name" : "Hazards", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "unique_number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 28, "name" : "logs", "relatedTableId" : 13, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 2, "name" : "access_points", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_access_points_id", "composite" : false }, { "id" : 16, "name" : "network", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_network_id", "composite" : false }, { "id" : 8, "name" : "objects", "relatedTableId" : 2, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_objects_id", "composite" : false }, { "id" : 19, "name" : "zones", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_zones_id", "composite" : false }, { "id" : 22, "name" : "blocks", "relatedTableId" : 6, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_blocks_id", "composite" : false }, { "id" : 5, "name" : "devices", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_devices_id", "composite" : false }, { "id" : 11, "name" : "structures", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_structures_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", "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" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "period", "type" : "esriFieldTypeString", "alias" : "Period", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exposure_description", "type" : "esriFieldTypeString", "alias" : "Exposure Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "exposure_consequence", "type" : "esriFieldTypeString", "alias" : "Exposure Consequence", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "exposure_consequence", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Superficial", "code" : "Superficial" }, { "name" : "Minor", "code" : "Minor" }, { "name" : "Moderate", "code" : "Moderate" }, { "name" : "Major", "code" : "Major" }, { "name" : "Catastrophic", "code" : "Catastrophic" } ] }, "defaultValue" : null }, { "name" : "exposure_likelihood", "type" : "esriFieldTypeString", "alias" : "Exposure Likelihood", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "exposure_likelihood", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Very Unlikely", "code" : "Very Unlikely" }, { "name" : "Unlikely", "code" : "Unlikely" }, { "name" : "Possible", "code" : "Possible" }, { "name" : "Likely", "code" : "Likely" }, { "name" : "Very Likely", "code" : "Very Likely" } ] }, "defaultValue" : null }, { "name" : "mitigation_class", "type" : "esriFieldTypeString", "alias" : "Mitigation Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "mitigation_description", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Eliminate", "code" : "Eliminate" }, { "name" : "Isolate", "code" : "Isolate" }, { "name" : "Minimise", "code" : "Minimise" }, { "name" : "Educate", "code" : "Educate" } ] }, "defaultValue" : null }, { "name" : "mitigation_description", "type" : "esriFieldTypeString", "alias" : "Mitigation Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_access_points_id", "type" : "esriFieldTypeGUID", "alias" : "Parent access points ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_devices_id", "type" : "esriFieldTypeGUID", "alias" : "Parent devices ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_objects_id", "type" : "esriFieldTypeGUID", "alias" : "Parent objects ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_structures_id", "type" : "esriFieldTypeGUID", "alias" : "Parent structures ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_network_id", "type" : "esriFieldTypeGUID", "alias" : "Parent network ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_zones_id", "type" : "esriFieldTypeGUID", "alias" : "Parent zones ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_blocks_id", "type" : "esriFieldTypeGUID", "alias" : "Parent blocks ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D8586892AB0", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_blocks", "fields" : "parent_blocks_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_zones_", "fields" : "parent_zones_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_networ", "fields" : "parent_network_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_struct", "fields" : "parent_structures_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_object", "fields" : "parent_objects_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_device", "fields" : "parent_devices_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G51parent_access", "fields" : "parent_access_points_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Hazards", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 11, "name" : "Incidents", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 29, "name" : "injuries", "relatedTableId" : 12, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleOrigin", "keyField" : "GlobalID", "composite" : false }, { "id" : 0, "name" : "access_points", "relatedTableId" : 0, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_access_points_id", "composite" : false }, { "id" : 17, "name" : "zones", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_zones_id", "composite" : false }, { "id" : 3, "name" : "devices", "relatedTableId" : 1, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_devices_id", "composite" : false }, { "id" : 6, "name" : "objects", "relatedTableId" : 2, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_objects_id", "composite" : false }, { "id" : 20, "name" : "blocks", "relatedTableId" : 6, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_blocks_id", "composite" : false }, { "id" : 9, "name" : "structures", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_structures_id", "composite" : false }, { "id" : 14, "name" : "network", "relatedTableId" : 4, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_network_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", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "alias", "type" : "esriFieldTypeString", "alias" : "Alias", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "incident_date", "type" : "esriFieldTypeDate", "alias" : "Date of Incident", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "report_date", "type" : "esriFieldTypeDate", "alias" : "Date of Report", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "incident_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Near-Miss", "code" : "Near-Miss" }, { "name" : "No Treatment", "code" : "No Treatment" }, { "name" : "First Aid", "code" : "First Aid" }, { "name" : "Doctor", "code" : "Doctor" }, { "name" : "Hospital", "code" : "Hospital" }, { "name" : "Serious Harm", "code" : "Serious Harm" } ] }, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "location", "type" : "esriFieldTypeString", "alias" : "Location", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "patient_name", "type" : "esriFieldTypeString", "alias" : "Patient Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "contact_number", "type" : "esriFieldTypeString", "alias" : "Contact Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "date_of_birth", "type" : "esriFieldTypeDate", "alias" : "Date of Birth", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "pronouns", "type" : "esriFieldTypeString", "alias" : "Pronouns", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "pronouns", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "She/her", "code" : "She/her" }, { "name" : "He/him", "code" : "He/him" }, { "name" : "They/them", "code" : "They/them" }, { "name" : "I prefer not to say", "code" : "I prefer not to say" } ] }, "defaultValue" : null }, { "name" : "address", "type" : "esriFieldTypeString", "alias" : "Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "job_title", "type" : "esriFieldTypeString", "alias" : "Job Title", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "employment_status", "type" : "esriFieldTypeString", "alias" : "Employment Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "employment_status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Permanent", "code" : "Permanent" }, { "name" : "Casual", "code" : "Casual" }, { "name" : "Contractor", "code" : "Contractor" }, { "name" : "Visitor", "code" : "Visitor" } ] }, "defaultValue" : null }, { "name" : "hours_at_work", "type" : "esriFieldTypeSmallInteger", "alias" : "Hours at Work", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "prevention_details", "type" : "esriFieldTypeString", "alias" : "Prevention Details", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "vehicle_involvement", "type" : "esriFieldTypeString", "alias" : "Vehicle Involvement", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_access_points_id", "type" : "esriFieldTypeGUID", "alias" : "Parent access points ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_devices_id", "type" : "esriFieldTypeGUID", "alias" : "Parent devices ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_objects_id", "type" : "esriFieldTypeGUID", "alias" : "Parent objects ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_structures_id", "type" : "esriFieldTypeGUID", "alias" : "Parent structures ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_network_id", "type" : "esriFieldTypeGUID", "alias" : "Parent network ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_zones_id", "type" : "esriFieldTypeGUID", "alias" : "Parent zones ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_blocks_id", "type" : "esriFieldTypeGUID", "alias" : "Parent blocks ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85800B938C", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_blocks", "fields" : "parent_blocks_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_zones_", "fields" : "parent_zones_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_networ", "fields" : "parent_network_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_struct", "fields" : "parent_structures_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_object", "fields" : "parent_objects_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_device", "fields" : "parent_devices_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G49parent_access", "fields" : "parent_access_points_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Incidents", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 12, "name" : "Injuries", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 29, "name" : "incidents", "relatedTableId" : 11, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_incidents_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", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "alias", "type" : "esriFieldTypeString", "alias" : "Alias", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "description", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "class", "type" : "esriFieldTypeString", "alias" : "Injury Class", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "injury_class", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Strain/Sprain", "code" : "Strain/Sprain" }, { "name" : "Cut", "code" : "Cut" }, { "name" : "Head Injury", "code" : "Head Injury" }, { "name" : "Fracture/Break", "code" : "Fracture/Break" }, { "name" : "Bruising", "code" : "Bruising" }, { "name" : "Burn", "code" : "Burn" }, { "name" : "Poison/Chemical", "code" : "Poison/Chemical" } ] }, "defaultValue" : null }, { "name" : "body_part", "type" : "esriFieldTypeString", "alias" : "Body Part", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "severity", "type" : "esriFieldTypeString", "alias" : "Severity", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "severity", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Superficial", "code" : "Superficial" }, { "name" : "Minor", "code" : "Minor" }, { "name" : "Moderate", "code" : "Moderate" }, { "name" : "Major", "code" : "Major" }, { "name" : "Catastrophic", "code" : "Catastrophic" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_incidents_id", "type" : "esriFieldTypeGUID", "alias" : "Parent incidents ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D8548E76A1E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G52parent_incide", "fields" : "parent_incidents_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Injuries", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 13, "name" : "Logs", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "unique_number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 27, "name" : "activities", "relatedTableId" : 8, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_activities_id", "composite" : false }, { "id" : 28, "name" : "hazards", "relatedTableId" : 10, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_hazards_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", "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" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "cost", "type" : "esriFieldTypeDouble", "alias" : "Cost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_activities_id", "type" : "esriFieldTypeGUID", "alias" : "Parent activities ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_hazards_id", "type" : "esriFieldTypeGUID", "alias" : "Parent hazards ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85003F7906", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G61parent_hazard", "fields" : "parent_hazards_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G61parent_activi", "fields" : "parent_activities_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Logs", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 14, "name" : "Measurements", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "unique_number", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 13, "name" : "structures", "relatedTableId" : 3, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_structures_id", "composite" : false }, { "id" : 26, "name" : "sites", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_sites_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", "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" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "measurement", "type" : "esriFieldTypeDouble", "alias" : "Measurement", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unit", "type" : "esriFieldTypeString", "alias" : "Unit", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "measurement_units", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "units", "code" : "units" }, { "name" : "millimetre", "code" : "millimetre" }, { "name" : "centimeter", "code" : "centimeter" }, { "name" : "meters", "code" : "meters" }, { "name" : "kilometers", "code" : "kilometers" }, { "name" : "kilogram", "code" : "kilogram" }, { "name" : "tonne", "code" : "tonne" }, { "name" : "litre", "code" : "litre" }, { "name" : "cubic metre", "code" : "cubic metre" } ] }, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_structures_id", "type" : "esriFieldTypeGUID", "alias" : "Parent structures ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "parent_sites_id", "type" : "esriFieldTypeGUID", "alias" : "Parent sites ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D85486F9E9B", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G70parent_sites_", "fields" : "parent_sites_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "G70parent_struct", "fields" : "parent_structures_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Measurements", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" }, { "currentVersion" : 12, "id" : 15, "name" : "Staff", "type" : "Table", "serviceItemId" : "d282ee76ed6d45d893ebe9c15cef44f2", "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "creation_date", "creatorField" : "creator", "editDateField" : "last_edit_date", "editorField" : "last_editor" }, "editingInfo" : { "lastEditDate" : 1666907863103, "schemaLastEditDate" : 1666907863103, "dataLastEditDate" : 1666907863103 }, "relationships" : [ { "id" : 24, "name" : "sites", "relatedTableId" : 7, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "parent_sites_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", "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" : "name", "type" : "esriFieldTypeString", "alias" : "Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "unique_number", "type" : "esriFieldTypeSmallInteger", "alias" : "Unique Number", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "start_date", "type" : "esriFieldTypeDate", "alias" : "Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "end_date", "type" : "esriFieldTypeDate", "alias" : "End Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "role", "type" : "esriFieldTypeString", "alias" : "Role", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "roles", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Manager", "code" : "Manager" }, { "name" : "Worker", "code" : "Worker" } ] }, "defaultValue" : null }, { "name" : "contact_number", "type" : "esriFieldTypeString", "alias" : "Contact Number", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "notes", "type" : "esriFieldTypeString", "alias" : "Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "parent_sites_id", "type" : "esriFieldTypeGUID", "alias" : "Parent sites ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "creation_date", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "last_editor", "type" : "esriFieldTypeString", "alias" : "Last Editor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "last_edit_date", "type" : "esriFieldTypeDate", "alias" : "Last Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 } ], "indexes" : [ { "name" : "PK__FARM_DAT__F4B70D858F7E3B3D", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "FDO_GlobalID", "fields" : "GlobalID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G74parent_sites_", "fields" : "parent_sites_id", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "creation_dateIndex", "fields" : "creation_date", "isAscending" : true, "isUnique" : false, "description" : "creation_date Field index", "indexType" : "Attribute" }, { "name" : "creatorIndex", "fields" : "creator", "isAscending" : false, "isUnique" : false, "description" : "creator Field index", "indexType" : "Attribute" }, { "name" : "last_edit_dateIndex", "fields" : "last_edit_date", "isAscending" : true, "isUnique" : false, "description" : "last_edit_date Field index", "indexType" : "Attribute" }, { "name" : "last_editorIndex", "fields" : "last_editor", "isAscending" : false, "isUnique" : false, "description" : "last_editor Field index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Staff", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "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,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Delete,Query,Update,Editing" } ] }