{ "currentVersion" : 12, "id" : 0, "name" : "survey", "type" : "Feature Layer", "serviceItemId" : "42851ca9d5f14601bd01dc6f9a1c5e05", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : true, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : false, "allowAnonymousToDelete" : false }, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1788450279002, "schemaLastEditDate" : 1788450279002, "dataLastEditDate" : 1788450272530 }, "relationships" : [], "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, "supportsOBACForAnonymousUsers" : true, "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" : -180, "ymin" : -90, "xmax" : 180, "ymax" : 90, "spatialReference" : { "wkid" : 4326, "latestWkid" : 4326 } }, "spatialReference" : { "wkid" : 4326, "latestWkid" : 4326 }, "drawingInfo":{"labelingInfo":null,"renderer":{"label":"Survey Point","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "propagateVisibleFields" : true, "viewSourceHasAttachments" : 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", "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" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Contractor", "type" : "esriFieldTypeString", "alias" : "Contractor Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ContractorCompany", "type" : "esriFieldTypeString", "alias" : "Contractor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_ContractorCompany", "codedValues" : [ { "name" : "Binns & Stevens, Inc.", "code" : "Binns & Stevens, Inc." }, { "name" : "Crop Production Services", "code" : "Crop Production Services" }, { "name" : "Dunkerton Coop", "code" : "Dunkerton Coop" }, { "name" : "Jim Benter Petroleum", "code" : "Jim Benter Petroleum" }, { "name" : "M & K Dust Control, Inc.", "code" : "M & K Dust Control, Inc." }, { "name" : "O'Grady", "code" : "O'Grady" }, { "name" : "Three Rivers FS", "code" : "Three Rivers FS" }, { "name" : "Self", "code" : "Self" }, { "name" : "L.L. Pelling", "code" : "L.L. Pelling" }, { "name" : "Watson Service", "code" : "Watson Service" }, { "name" : "Nutrien AG", "code" : "Nutrien AG" }, { "name" : "Victor Oil Co.", "code" : "Victor Oil Co." }, { "name" : "Other", "code" : "other" }, { "name" : "Benter Inc.", "code" : "Benter Inc." }, { "name" : "Other", "code" : "Other" }, { "name" : "Victor Oil", "code" : "Victor Oil" }, { "name" : "Nutrien Ag", "code" : "Nutrien Ag" } ] }, "defaultValue" : null }, { "name" : "untitled_question_4_other", "type" : "esriFieldTypeString", "alias" : "Other - Contractor", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "contractor_name", "type" : "esriFieldTypeString", "alias" : "Contractor Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "contractor_email", "type" : "esriFieldTypeString", "alias" : "Contractor Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantFirstName", "type" : "esriFieldTypeString", "alias" : "First Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantLastName", "type" : "esriFieldTypeString", "alias" : "Last Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantEmail", "type" : "esriFieldTypeString", "alias" : "Email Contact", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantSameAsProperty", "type" : "esriFieldTypeString", "alias" : "Is applicant address the same as the dust control location?", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_ApplicantSameAsProperty", "codedValues" : [ { "name" : "Yes", "code" : "Y" }, { "name" : "No", "code" : "N" } ] }, "defaultValue" : null }, { "name" : "ApplicantAddress", "type" : "esriFieldTypeString", "alias" : "Applicant Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantCity", "type" : "esriFieldTypeString", "alias" : "Applicant City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantZip", "type" : "esriFieldTypeDouble", "alias" : "Applicant Zipcode", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicationYear", "type" : "esriFieldTypeDouble", "alias" : "Application Year", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Application", "type" : "esriFieldTypeString", "alias" : "Application", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_Application", "codedValues" : [ { "name" : "First", "code" : "First" }, { "name" : "Second", "code" : "Second" }, { "name" : "Both", "code" : "Both" } ] }, "defaultValue" : null }, { "name" : "Material", "type" : "esriFieldTypeString", "alias" : "Material", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_Material", "codedValues" : [ { "name" : "Calcium Chloride", "code" : "Calcium Chloride" }, { "name" : "Mag Chloride", "code" : "Mag Chloride" }, { "name" : "Lignin", "code" : "Lignin" }, { "name" : "Soy Oil", "code" : "Soy Oil" }, { "name" : "Seal Coat", "code" : "Seal Coat" }, { "name" : "Magnesium Chloride", "code" : "Magnesium Chloride" } ] }, "defaultValue" : null }, { "name" : "Footage", "type" : "esriFieldTypeDouble", "alias" : "Total Footage", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DatePaid1", "type" : "esriFieldTypeDate", "alias" : "Date Paid - First Application", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "approval_status", "type" : "esriFieldTypeString", "alias" : "Approval Status", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_approval_status", "codedValues" : [ { "name" : "Approved", "code" : "Approved" }, { "name" : "Denied", "code" : "Denied" }, { "name" : "Pending", "code" : "Pending" }, { "name" : "In Production", "code" : "In Production" } ] }, "defaultValue" : null }, { "name" : "PropertyAddress1", "type" : "esriFieldTypeString", "alias" : "Enter address of dust control work to be performed", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PropertyCity", "type" : "esriFieldTypeString", "alias" : "Property City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PropertyZip", "type" : "esriFieldTypeString", "alias" : "Property Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "phone_contact", "type" : "esriFieldTypeString", "alias" : "Phone Contact", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "applicant_state", "type" : "esriFieldTypeString", "alias" : "Applicant State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_applicant_state", "codedValues" : [ { "name" : "AK", "code" : "AK" }, { "name" : "AL", "code" : "AL" }, { "name" : "AR", "code" : "AR" }, { "name" : "AZ", "code" : "AZ" }, { "name" : "CA", "code" : "CA" }, { "name" : "CO", "code" : "CO" }, { "name" : "CT", "code" : "CT" }, { "name" : "DC", "code" : "DC" }, { "name" : "DE", "code" : "DE" }, { "name" : "FL", "code" : "FL" }, { "name" : "GA", "code" : "GA" }, { "name" : "HI", "code" : "HI" }, { "name" : "IA", "code" : "IA" }, { "name" : "ID", "code" : "ID" }, { "name" : "IL", "code" : "IL" }, { "name" : "IN", "code" : "IN" }, { "name" : "KS", "code" : "KS" }, { "name" : "KY", "code" : "KY" }, { "name" : "LA", "code" : "LA" }, { "name" : "MA", "code" : "MA" }, { "name" : "MD", "code" : "MD" }, { "name" : "ME", "code" : "ME" }, { "name" : "MI", "code" : "MI" }, { "name" : "MN", "code" : "MN" }, { "name" : "MO", "code" : "MO" }, { "name" : "MS", "code" : "MS" }, { "name" : "MT", "code" : "MT" }, { "name" : "NC", "code" : "NC" }, { "name" : "ND", "code" : "ND" }, { "name" : "NE", "code" : "NE" }, { "name" : "NH", "code" : "NH" }, { "name" : "NJ", "code" : "NJ" }, { "name" : "NM", "code" : "NM" }, { "name" : "NV", "code" : "NV" }, { "name" : "NY", "code" : "NY" }, { "name" : "OH", "code" : "OH" }, { "name" : "OK", "code" : "OK" }, { "name" : "OR", "code" : "OR" }, { "name" : "PA", "code" : "PA" }, { "name" : "RI", "code" : "RI" }, { "name" : "SC", "code" : "SC" }, { "name" : "SD", "code" : "SD" }, { "name" : "TN", "code" : "TN" }, { "name" : "TX", "code" : "TX" }, { "name" : "UT", "code" : "UT" }, { "name" : "VA", "code" : "VA" }, { "name" : "VT", "code" : "VT" }, { "name" : "WA", "code" : "WA" }, { "name" : "WI", "code" : "WI" }, { "name" : "WV", "code" : "WV" }, { "name" : "WY", "code" : "WY" } ] }, "defaultValue" : null }, { "name" : "DatePaid2", "type" : "esriFieldTypeDate", "alias" : "Date Paid - Second Application", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "PermitID", "type" : "esriFieldTypeDouble", "alias" : "Permit ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ApplicantSameAsProperty_TXT", "type" : "esriFieldTypeString", "alias" : "ApplicantSameAsProperty_TXT", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Contractor_SUBTYPE", "type" : "esriFieldTypeSmallInteger", "alias" : "Contractor_SUBTYPE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "GlobalIDIndex", "fields" : "globalid", "isAscending" : false, "isUnique" : true, "description" : "GlobalID index", "indexType" : "Attribute" }, { "name" : "survey123_c941ac1131b042268bae34f6bb37e765_SURVEY_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "PK__survey12__5242E632A1D11EE3", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "CreationDateIndex", "fields" : "CreationDate", "isAscending" : true, "isUnique" : false, "description" : "CreationDate Field index", "indexType" : "Attribute" }, { "name" : "CreatorIndex", "fields" : "Creator", "isAscending" : false, "isUnique" : false, "description" : "Creator Field index", "indexType" : "Attribute" }, { "name" : "EditDateIndex", "fields" : "EditDate", "isAscending" : true, "isUnique" : false, "description" : "EditDate Field index", "indexType" : "Attribute" }, { "name" : "EditorIndex", "fields" : "Editor", "isAscending" : false, "isUnique" : false, "description" : "Editor Field index", "indexType" : "Attribute" }, { "name" : "approval_status_Index", "fields" : "approval_status", "isAscending" : true, "isUnique" : false, "description" : "approval_status_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "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", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync" }