{ "currentVersion": 10.71, "id": 107, "name": "PermitHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "contractorname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "Asset Key", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "AssetID" }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Workorder Key", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkActivity" }, { "name": "attachmentid1", "type": "esriFieldTypeInteger", "alias": "AttachmentID1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID1" }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "AttachmentID2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AttachmentID2" }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "WorkDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WorkDate" }, { "name": "workby", "type": "esriFieldTypeString", "alias": "WorkBy", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WorkBy" }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "worktype", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "worktype" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "comments" }, { "name": "permittype", "type": "esriFieldTypeString", "alias": "permittype", "domain": { "type": "codedValue", "name": "PermitType", "description": "", "codedValues": [ { "name": "Connection", "code": "Connection" }, { "name": "Disconnection", "code": "Disconnection" }, { "name": "Repair", "code": "Repair" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "permittype" }, { "name": "permitnum", "type": "esriFieldTypeString", "alias": "permitnum", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "permitnum" }, { "name": "bldgtype", "type": "esriFieldTypeString", "alias": "bldgtype", "domain": { "type": "codedValue", "name": "sedaBldgType", "description": "", "codedValues": [ { "name": "Commercial", "code": "Commercial" }, { "name": "Industrial", "code": "Industrial" }, { "name": "School", "code": "School" }, { "name": "Place of Worship", "code": "Place of Worship" }, { "name": "Hospital", "code": "Hospital" }, { "name": "Residential", "code": "Residential" }, { "name": "Single Family", "code": "Single Family" }, { "name": "Condo/Apts", "code": "Condo/Apts" }, { "name": "Multi Family", "code": "Multi Family" }, { "name": "Restaurant (FOG)", "code": "Restaurant (FOG)" }, { "name": "Bar/Cafe", "code": "Bar/Cafe" }, { "name": "Recreational", "code": "Recreational" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "bldgtype" }, { "name": "numberunits", "type": "esriFieldTypeSmallInteger", "alias": "numberunits", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "numberunits" }, { "name": "jobtype", "type": "esriFieldTypeString", "alias": "jobtype", "domain": { "type": "codedValue", "name": "sedaJobType", "description": "", "codedValues": [ { "name": "New Construction", "code": "New Construction" }, { "name": "Addition", "code": "Addition" }, { "name": "Repairs Only", "code": "Repairs Only" }, { "name": "Remodel", "code": "Remodel" }, { "name": "Disconnection", "code": "Disconnection" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "jobtype" }, { "name": "address", "type": "esriFieldTypeString", "alias": "address", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "address" }, { "name": "hub_used", "type": "esriFieldTypeString", "alias": "hub_used", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "hub_used" }, { "name": "sewermap", "type": "esriFieldTypeDouble", "alias": "sewermap", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sewermap" }, { "name": "contractorname", "type": "esriFieldTypeString", "alias": "contractorname", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "contractorname" }, { "name": "contractoraddr", "type": "esriFieldTypeString", "alias": "contractoraddr", "domain": null, "editable": true, "nullable": true, "length": 150, "defaultValue": null, "modelName": "contractoraddr" }, { "name": "contractorphone", "type": "esriFieldTypeString", "alias": "contractorphone", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "contractorphone" }, { "name": "installer", "type": "esriFieldTypeString", "alias": "installer", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "installer" }, { "name": "feepaid", "type": "esriFieldTypeString", "alias": "feepaid", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "feepaid" }, { "name": "sketchadded", "type": "esriFieldTypeString", "alias": "sketchadded", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "sketchadded" }, { "name": "connectfeepaid", "type": "esriFieldTypeString", "alias": "connectfeepaid", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "connectfeepaid" }, { "name": "connected", "type": "esriFieldTypeDate", "alias": "connected", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "connected" }, { "name": "asbuiltrecvd", "type": "esriFieldTypeDate", "alias": "asbuiltrecvd", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "asbuiltrecvd" }, { "name": "occ_cert", "type": "esriFieldTypeDate", "alias": "occ_cert", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "occ_cert" }, { "name": "repairtype", "type": "esriFieldTypeString", "alias": "repairtype", "domain": { "type": "codedValue", "name": "sedaRepairType", "description": "", "codedValues": [ { "name": "Corrective Maintenance", "code": "Corrective Maintenance" }, { "name": "Preventative Maintenance", "code": "Preventative Maintenance" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "repairtype" }, { "name": "wocomments", "type": "esriFieldTypeString", "alias": "wocomments", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "wocomments" }, { "name": "wodescription", "type": "esriFieldTypeString", "alias": "wodescription", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "wodescription" }, { "name": "attachmentid3", "type": "esriFieldTypeInteger", "alias": "attachmentid3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid3" }, { "name": "Work_Origin", "type": "esriFieldTypeString", "alias": "Work_Origin", "domain": { "type": "codedValue", "name": "WorkOrgin", "description": "Building Inspection (good)", "codedValues": [ { "name": "Emergency", "code": "Emergency" }, { "name": "Long-Term Maintenance Plan", "code": "Long-Term Maintenance Plan" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Work_Origin" }, { "name": "Inspection_Type", "type": "esriFieldTypeString", "alias": "Inspection_Type`", "domain": { "type": "codedValue", "name": "Inspection_Type", "description": "Building Inspection\n", "codedValues": [ { "name": "Internal", "code": "Internal" }, { "name": "External", "code": "External" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspection_Type" }, { "name": "Street_Name", "type": "esriFieldTypeString", "alias": "Street_Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Street_Name" }, { "name": "Street_No", "type": "esriFieldTypeString", "alias": "Street_No", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Street_No" }, { "name": "Building_Type", "type": "esriFieldTypeString", "alias": "Building_Type", "domain": { "type": "codedValue", "name": "Building_Type", "description": "Building Inspection", "codedValues": [ { "name": "Single Family", "code": "Single Family" }, { "name": "Multi Family", "code": "Multi Family" }, { "name": "Apartment", "code": "Apartment" }, { "name": "Commercial", "code": "Commercial" }, { "name": "Industrial", "code": "Industrial" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Building_Type" }, { "name": "Sewer_SubArea", "type": "esriFieldTypeString", "alias": "Sewer_SubArea", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Sewer_SubArea" }, { "name": "Map_No", "type": "esriFieldTypeString", "alias": "Map_No", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Map_No" }, { "name": "Line_Segment", "type": "esriFieldTypeString", "alias": "Line_Segment", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Line_Segment" }, { "name": "Upstream_MH", "type": "esriFieldTypeString", "alias": "Upstream_MH", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Upstream_MH" }, { "name": "Downstream_MH", "type": "esriFieldTypeString", "alias": "Downstream_MH", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Downstream_MH" }, { "name": "Owner_Contact_Name", "type": "esriFieldTypeString", "alias": "Owner_Contact_Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Owner_Contact_Name" }, { "name": "Owner_Contact_Number", "type": "esriFieldTypeString", "alias": "Owner_Contact_Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Owner_Contact_Number" }, { "name": "Inspection_Attempt", "type": "esriFieldTypeString", "alias": "Inspection_Attempt", "domain": { "type": "codedValue", "name": "Inspection_Attempt", "description": "Building Inspection", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "Reinspection", "code": "Reinspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Inspection_Attempt" }, { "name": "Date_Historical_Flooding", "type": "esriFieldTypeString", "alias": "Date_Historical_Flooding", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Date_Historical_Flooding" }, { "name": "Source_Historical_Flooding", "type": "esriFieldTypeString", "alias": "Source_Historical_Flooding", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Source_Historical_Flooding" }, { "name": "Actions_Take_After_Flooding", "type": "esriFieldTypeString", "alias": "Actions_Take_After_Flooding", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Actions_Take_After_Flooding" }, { "name": "Foundation_Type", "type": "esriFieldTypeString", "alias": "Foundation_Typep", "domain": { "type": "codedValue", "name": "Foundation_Type", "description": "Building Inspection", "codedValues": [ { "name": "Slab", "code": "Slab" }, { "name": "Crawl Space", "code": "Crawl Space" }, { "name": "Unfinished Basement", "code": "Unfinished Basement" }, { "name": "Partially Finished Basement", "code": "Partially Finished Basement" }, { "name": "Finished Basement", "code": "Finished Basement" }, { "name": "Split-Level", "code": "Split-Level" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Foundation_Type" }, { "name": "RoofDrain_Discharge_to_SS", "type": "esriFieldTypeString", "alias": "RoofDrain_Discharge_to_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RoofDrain_Discharge_to_SS" }, { "name": "FoundationDrain_Discharge_to_SS", "type": "esriFieldTypeString", "alias": "FoundationDrain_Discharge_to_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FoundationDrain_Discharge_to_SS" }, { "name": "Curb_Box_Present", "type": "esriFieldTypeString", "alias": "Curb_Box_Present", "domain": { "type": "codedValue", "name": "YesNO", "description": "YesNO", "codedValues": [ { "name": "Yes", "code": "1" }, { "name": "No", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Curb_Box_Present" }, { "name": "PatioDrain_Discharges_to_SS", "type": "esriFieldTypeString", "alias": "PatioDrain_Discharges_to_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PatioDrain_Discharges_to_SS" }, { "name": "DrivewayDrain_Discharges_to_SS", "type": "esriFieldTypeString", "alias": "DrivewayDrain_Discharges_to_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DrivewayDrain_Discharges_to_SS" }, { "name": "WindowWellDrain_to_SS", "type": "esriFieldTypeString", "alias": "WindowWellDrain_Discharges_to_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "WindowWellDrain_to_SS" }, { "name": "StairwellSidewalkDrain_to_SS", "type": "esriFieldTypeString", "alias": "StairwellSidewalkDrain_Discharges_to_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "StairwellSidewalkDrain_to_SS" }, { "name": "Diverter_Valve_On_Storm_Water", "type": "esriFieldTypeString", "alias": "Diverter_Valve_On_Storm_Water", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Diverter_Valve_On_Storm_Water" }, { "name": "Comment", "type": "esriFieldTypeString", "alias": "Comment", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Comment" }, { "name": "Picture1", "type": "esriFieldTypeInteger", "alias": "Picture1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Picture1" }, { "name": "Picture2", "type": "esriFieldTypeInteger", "alias": "Picture2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Picture2" }, { "name": "Combination_Pump", "type": "esriFieldTypeString", "alias": "Combination_Pump", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Combination_Pump" }, { "name": "YardDrain_Discharges_SS", "type": "esriFieldTypeString", "alias": "YardDrain_Discharges_SS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "YardDrain_Discharges_SS" }, { "name": "SuspectConnection", "type": "esriFieldTypeString", "alias": "SuspectConnection", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SuspectConnection" }, { "name": "PermissionGranted", "type": "esriFieldTypeString", "alias": "PermissionGranted", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PermissionGranted" }, { "name": "Dye_Test_Results", "type": "esriFieldTypeString", "alias": "Dye_Test_Results", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Dye_Test_Results" }, { "name": "Dye_test_comments", "type": "esriFieldTypeString", "alias": "Dye_test_comments", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Dye_test_comments" } ], "indexes": [ { "name": "R204_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "I1599assetkey", "fields": "assetkey", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1599workdate", "fields": "workdate", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "PermitHistory", "description": "", "prototype": { "attributes": { "Dye_Test_Results": null, "Dye_test_comments": null, "assetkey": null, "workorderid": null, "attachmentid1": null, "attachmentid2": null, "workdate": null, "workby": null, "worktype": null, "comments": null, "permittype": null, "permitnum": null, "bldgtype": null, "numberunits": null, "jobtype": null, "address": null, "hub_used": null, "sewermap": null, "contractorname": null, "contractoraddr": null, "contractorphone": null, "installer": null, "feepaid": null, "sketchadded": null, "connectfeepaid": null, "connected": null, "asbuiltrecvd": null, "occ_cert": null, "repairtype": null, "wocomments": null, "wodescription": null, "attachmentid3": null, "Work_Origin": null, "Inspection_Type": null, "Street_Name": null, "Street_No": null, "Building_Type": null, "Sewer_SubArea": null, "Map_No": null, "Line_Segment": null, "Upstream_MH": null, "Downstream_MH": null, "Owner_Contact_Name": null, "Owner_Contact_Number": null, "Inspection_Attempt": null, "Date_Historical_Flooding": null, "Source_Historical_Flooding": null, "Actions_Take_After_Flooding": null, "Foundation_Type": null, "RoofDrain_Discharge_to_SS": null, "FoundationDrain_Discharge_to_SS": null, "Curb_Box_Present": null, "PatioDrain_Discharges_to_SS": null, "DrivewayDrain_Discharges_to_SS": null, "WindowWellDrain_to_SS": null, "StairwellSidewalkDrain_to_SS": null, "Diverter_Valve_On_Storm_Water": null, "Comment": null, "Picture1": null, "Picture2": null, "Combination_Pump": null, "YardDrain_Discharges_SS": null, "SuspectConnection": null, "PermissionGranted": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 3000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 3000, "tileMaxRecordCount": 3000, "maxRecordCountFactor": 1 }