{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 7, "name": "AppRequests", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user", "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false } }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "ReportingArea", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "GISRequestAreaID", "composite": false } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Name", "type": "esriFieldTypeString", "alias": "Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Name" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Request Type", "domain": { "type": "codedValue", "name": "SolutionType", "description": "Indicates GIS Solution/Service type", "codedValues": [ { "name": "DOCUMENTATION: A front end supplementary document used to support our decision, action, development, or data entry (i.e.: Letter, MSAG Submission, email, etc...)", "code": "Documentation" }, { "name": "VISUALIZATION: Map, Imagery, or other visualization aids (i.e.: Paper Maps, Web Maps, Images, Presentations, etc...)", "code": "Visualization" }, { "name": "DATA: ArcGIS formatted resources, provided or built, ready for use in a desktop GIS platform (i.e.: Shapefiles, Feature Classes, Geodatabases, Data Stores, etc...)", "code": "Data" }, { "name": "SERVICE: Feature Services, Layers, or Geoprocessing Services used for online functionality (i.e.: Feature Service, Map Services, Image Service, Feature Collections, etc...)", "code": "Service" }, { "name": "APPLICATION: Front end applications developed for information dissemination or data collection (i.e.: Reporters, Locators, Stories, Dashboards, etc...)", "code": "App" }, { "name": "DEVELOPMENT: A backend resource, system or admin input, used to develop applications or solution components (i.e.: CSV, Code, Links, Solutions, etc...)", "code": "Development" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "App", "modelName": "Type" }, { "name": "ReportMuni", "type": "esriFieldTypeString", "alias": "Municipality", "domain": { "type": "codedValue", "name": "Municipality", "description": "Municipality in which the feature is located", "codedValues": [ { "name": "Andes", "code": "AN" }, { "name": "Bethel", "code": "BE" }, { "name": "Bloomingburg Village", "code": "VBLOOM" }, { "name": "Callicoon", "code": "CA" }, { "name": "Cochecton", "code": "CO" }, { "name": "Colchester", "code": "CL" }, { "name": "Crawford", "code": "CR" }, { "name": "Deerpark", "code": "DP" }, { "name": "Delaware", "code": "DE" }, { "name": "Denning", "code": "DN" }, { "name": "Fallsburg", "code": "FA" }, { "name": "Forestburgh", "code": "FO" }, { "name": "Fremont", "code": "FR" }, { "name": "Hancock", "code": "HC" }, { "name": "Hardenburgh", "code": "HD" }, { "name": "Highland", "code": "HI" }, { "name": "Jeffersonville Village", "code": "VJEFF" }, { "name": "Liberty", "code": "LI" }, { "name": "Liberty Village", "code": "VLIB" }, { "name": "Lumberland", "code": "LU" }, { "name": "Mamakating", "code": "MA" }, { "name": "Monticello Village", "code": "VMON" }, { "name": "Mount Hope", "code": "MT" }, { "name": "Neversink", "code": "NE" }, { "name": "Rockland", "code": "RO" }, { "name": "Shawangunk", "code": "SG" }, { "name": "Sullivan County", "code": "SC" }, { "name": "Thompson", "code": "TH" }, { "name": "Tusten", "code": "TU" }, { "name": "Wallkill", "code": "WK" }, { "name": "Wawarsing", "code": "WW" }, { "name": "Woodridge Village", "code": "VWOO" }, { "name": "Wurtsboro Village", "code": "VWU" }, { "name": "Ateres Village", "code": "VAT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "SC", "modelName": "ReportMuni" }, { "name": "Requestor", "type": "esriFieldTypeString", "alias": "Provide for or on Behalf of", "domain": { "type": "codedValue", "name": "Department", "description": "Sullivan County Dep'ts", "codedValues": [ { "name": "911 Dispatch Center", "code": "911" }, { "name": "Aging, Office for the", "code": "Aging" }, { "name": "Airport, Sullivan County International", "code": "Airport" }, { "name": "Audit & Control, Office of", "code": "Audit" }, { "name": "Care Center at Sunset Lake", "code": "Care" }, { "name": "Center for Workforce Development", "code": "WorkDev" }, { "name": "Community Services, Department of", "code": "Community" }, { "name": "Coroner's Office", "code": "Coroner" }, { "name": "County Attorney, Office of the", "code": "CtyAttorney" }, { "name": "County Clerk, Office of the", "code": "CtyClerk" }, { "name": "County Historian, Office of the", "code": "CtyHist" }, { "name": "County Legislature, Office of the", "code": "CtyLegis" }, { "name": "County Manager, Office of the", "code": "CtyMgr" }, { "name": "County Treasurer, Office of the", "code": "CtyTrsr" }, { "name": "District Attorney, Office of the", "code": "DistAttorney" }, { "name": "Elections, Board of", "code": "Elections" }, { "name": "Electrical Licensing Board", "code": "Electrical" }, { "name": "Economic Development", "code": "EconDev" }, { "name": "Emergency Management/Homeland Security", "code": "EMHS" }, { "name": "EMS, Bureau of", "code": "EMS" }, { "name": "Family Services, Department of", "code": "Family" }, { "name": "Fire, Bureau of", "code": "Fire" }, { "name": "GIS Program", "code": "GIS" }, { "name": "Grants Administration, Department of", "code": "Grants" }, { "name": "Health & Family Services Division", "code": "HealthFam" }, { "name": "HIPAA Compliance", "code": "HIPAA" }, { "name": "Human Rights Commission", "code": "Human" }, { "name": "Information Technology Services", "code": "IT" }, { "name": "Management & Budget, Office of", "code": "MgtBudget" }, { "name": "Motor Vehicle Bureau", "code": "DMV" }, { "name": "Parks & Recreation, Department of", "code": "Parks" }, { "name": "Personnel, Department of", "code": "Personnel" }, { "name": "Planning & Community Development Division", "code": "Planning" }, { "name": "Probation, Department of", "code": "Probation" }, { "name": "Public Health Services, Department of", "code": "PubHlth" }, { "name": "Public Safety Division", "code": "PSEM" }, { "name": "Public Works, Division of", "code": "DPW" }, { "name": "Purchasing, Department of", "code": "Purchasing" }, { "name": "Real Property Tax Services", "code": "RPS" }, { "name": "Risk Management and Insurance, Department of", "code": "Risk" }, { "name": "Sheriff's Office", "code": "Sheriff" }, { "name": "Solid Waste and Recycling, Department of", "code": "Waste" }, { "name": "STOP DWI", "code": "STOP" }, { "name": "Sullivan Tobacco Asset Securitization Corp", "code": "Tobacco" }, { "name": "Sustainable Energy, Office of", "code": "Sustainable" }, { "name": "Transportation, Department of", "code": "Transportation" }, { "name": "Veterans Service Agency", "code": "Veterans" }, { "name": "Wellness Committee", "code": "Wellness" }, { "name": "Youth Bureau, Department of", "code": "Youth" }, { "name": "Municipal Ageny", "code": "Municipal" }, { "name": "Public Agency or Individual", "code": "Public" }, { "name": "State Agency", "code": "State" }, { "name": "Federal Agency", "code": "Federal" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "GIS", "modelName": "Requestor" }, { "name": "Tech", "type": "esriFieldTypeInteger", "alias": "Tech", "domain": { "type": "codedValue", "name": "Revisors", "description": "Name of technician making the update.", "codedValues": [ { "name": "Jennifer D. Stone", "code": 1 }, { "name": "Thomas Wells", "code": 2 }, { "name": "Dave Catizone", "code": 3 }, { "name": "Ed Homenick", "code": 4 }, { "name": "Eugene Bouton", "code": 5 }, { "name": "Leon Sinsabaugh", "code": 6 }, { "name": "Chris Knapp", "code": 7 }, { "name": "Daniel Berens", "code": 8 }, { "name": "Anita Hunt", "code": 9 }, { "name": "Kathleen Lara", "code": 10 }, { "name": "Jaqueline LaPlante", "code": 11 }, { "name": "Consultant", "code": 12 }, { "name": "Other", "code": 13 }, { "name": "Arash Amiri", "code": 14 }, { "name": "Alison Heaney", "code": 15 }, { "name": "Jennifer Moore", "code": 16 }, { "name": "Tom Jenkins", "code": 17 }, { "name": "Rob Woytowick", "code": 18 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Tech" }, { "name": "ReportArea", "type": "esriFieldTypeString", "alias": "Report Area", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ReportArea" }, { "name": "PublicView", "type": "esriFieldTypeString", "alias": "Visible to Public", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "N", "modelName": "PublicView" }, { "name": "Protected", "type": "esriFieldTypeString", "alias": "HIPAA/Privacy Protected", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Y", "modelName": "Protected" }, { "name": "RequestID", "type": "esriFieldTypeString", "alias": "Request/Ticket ID", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "RequestID" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "Status", "description": "The status of a feature", "codedValues": [ { "name": "Current", "code": "Current" }, { "name": "Pending", "code": "Pending" }, { "name": "Retired", "code": "Retired" }, { "name": "Temporary", "code": "Temporary" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 255, "defaultValue": "Current", "modelName": "Status" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Item Type", "domain": { "type": "codedValue", "name": "ItemType", "description": "Type of item created, received, or published", "codedValues": [ { "name": "Code Attachment", "code": "Code Attachment" }, { "name": "CSV", "code": "CSV" }, { "name": "Dashboard", "code": "Dashboard" }, { "name": "Data Store", "code": "Data Store" }, { "name": "Document Link", "code": "Document Link" }, { "name": "Feature Service", "code": "Feature Service" }, { "name": "Form", "code": "Form" }, { "name": "Map Service", "code": "Map Service" }, { "name": "Microsoft Excel", "code": "Microsoft Excel" }, { "name": "Microsoft Word", "code": "Microsoft Word" }, { "name": "Notebook", "code": "Notebook" }, { "name": "PDF", "code": "PDF" }, { "name": "QuickCapture Project", "code": "QuickCapture Project" }, { "name": "Service Definition", "code": "Service Definition" }, { "name": "Shapefile", "code": "Shapefile" }, { "name": "Site Application", "code": "Site Application" }, { "name": "Site Page", "code": "Site Page" }, { "name": "Solution", "code": "Solution" }, { "name": "StoryMap", "code": "StoryMap" }, { "name": "Web Experience", "code": "Web Experience" }, { "name": "Web Map", "code": "Web Map" }, { "name": "Web Mapping Application", "code": "Web Mapping Application" }, { "name": "ArcMap File (mxd)", "code": "ArcMap" }, { "name": "ArcGIS Pro Project Package", "code": "ArcPro" }, { "name": "Image (tif, bmp, jpeg, gif, png, etc...)", "code": "Image" }, { "name": "Package File (lypk, pkg, ctpk, etc...)", "code": "Package" }, { "name": "XML File", "code": "XML" }, { "name": "KML File", "code": "KML" }, { "name": "GPS File", "code": "GPS" }, { "name": "Geodatabase (SQLite, SDE, File, PGDB, etc...)", "code": "Geodatabase" }, { "name": "Layer File (lyr)", "code": "Layer" }, { "name": "Auto-CAD File (DWG)", "code": "DWG" }, { "name": "Feature or Image Collection", "code": "Collection" }, { "name": "Scene or Scene File", "code": "Scene" }, { "name": "Template", "code": "Template" }, { "name": "Feature Class", "code": "Feature Class" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Notes" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GISRequestAreaID", "type": "esriFieldTypeGUID", "alias": "GIS Request Area ID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "GISRequestAreaID" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Comments" }, { "name": "DateComp", "type": "esriFieldTypeDate", "alias": "Completion Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateComp" }, { "name": "DateReq", "type": "esriFieldTypeDate", "alias": "Request Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateReq" }, { "name": "Revenue", "type": "esriFieldTypeDouble", "alias": "Revenue Collected", "domain": null, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Revenue" } ], "indexes": [ { "name": "R281_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_281", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G936GISRequestAr", "fields": "GISRequestAreaID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Applications and Solutions", "description": "", "prototype": { "attributes": { "DateReq": null, "Name": null, "Type": "App", "ReportMuni": "SC", "Requestor": "GIS", "Tech": null, "ReportArea": null, "PublicView": "N", "Protected": "Y", "RequestID": null, "Status": "Current", "Notes": null, "Revenue": 0, "DateComp": null, "Comments": null, "GISRequestAreaID": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "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": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "12de1eae9deb4f4cbdbb0aef933c2a02" }