{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 4, "name": "Hauler License Review", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ApplicationNumber", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ApplicationNumber", "type": "esriFieldTypeString", "alias": "Application Number", "length": 255, "domain": null }, { "name": "ReviewStatus", "type": "esriFieldTypeString", "alias": "Review Status", "length": 255, "domain": { "type": "codedValue", "name": "SWReviewStatus", "description": "SWReviewStatus", "codedValues": [ { "name": "Approved", "code": "Approved" }, { "name": "Denied", "code": "Denied" }, { "name": "Incomplete", "code": "Incomplete" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 255, "domain": { "type": "codedValue", "name": "SWApplications", "description": "SWApplications", "codedValues": [ { "name": "Solid Waste Facility License & Checklist", "code": "LIC" }, { "name": "Solid Waste Facility Quarterly Report", "code": "QUA" }, { "name": "Co-Disposal", "code": "COD" }, { "name": "Hauler License", "code": "HAU" }, { "name": "Sherburne County Business Recycling Grant Program", "code": "BRP" }, { "name": "Solid Waste Ordinance Waiver/Modification", "code": "ORD" }, { "name": "Septage", "code": "SEP" }, { "name": "Non-Permitted Site Cleanup Program Application", "code": "NPS" }, { "name": "School SSO Recycling Grant Application", "code": "SRG" }, { "name": "SCORE Grant Application", "code": "SCO" }, { "name": "SCORE Institutional SSO Grant Application", "code": "SIG" }, { "name": "Solid Waste Cleanup Loan Application", "code": "CLL" }, { "name": "SSTS Low-Income Grant Application", "code": "LSG" }, { "name": "SSTS Low-Interest Loan Application", "code": "RFS" }, { "name": "SSTS Small Business Loan Application", "code": "SBL" }, { "name": "Solid Waste (Biosolids)", "code": "BIO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InitialReviewDate", "type": "esriFieldTypeDate", "alias": "Initial Review Date", "length": 8, "domain": null }, { "name": "MainReviewDate", "type": "esriFieldTypeDate", "alias": "Main Review Date", "length": 8, "domain": null }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 1073741822, "domain": null }, { "name": "ComplyLocalZoning", "type": "esriFieldTypeString", "alias": "Comply with Local Zoning Requirements", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AppCompanyContact", "type": "esriFieldTypeString", "alias": "Appropriate Company and Contact Information", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VehicleInformation", "type": "esriFieldTypeString", "alias": "Vehicle Information Provided", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VehicleEquipStorage", "type": "esriFieldTypeString", "alias": "Vehicle and Equipment Storage", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SWCollectedTransport", "type": "esriFieldTypeString", "alias": "Solid Waste Collected and Transported", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HaulerBondSubmitted", "type": "esriFieldTypeString", "alias": "HaulerBondSubmitted", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InsuranceProvided", "type": "esriFieldTypeString", "alias": "InsuranceProvided", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionReports", "type": "esriFieldTypeString", "alias": "InspectionReports", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AccurateFeeAmount", "type": "esriFieldTypeString", "alias": "AccurateFeeAmount", "length": 5, "domain": { "type": "codedValue", "name": "Yes_No", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null } ], "indexes": [ { "name": "UUID_483", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "gdb_ct3_483", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_6327_ApplicationNumber", "fields": "ApplicationNumber", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1768581055000 }, "serviceItemId": "029c6afe997645b7b3193b6e4d8916e7" }