{ "layers": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 0, "name": "Application Sites", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "BURKE.AppsPermitsInspections", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "addrssFullAddress", "composite": false, "catalogID": "{8E6820FA-31E1-4FA9-9753-24541B79571A}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "extent", "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 1124258.152343735, "ymin": 668545.5175781101, "xmax": 1298065.5026041567, "ymax": 830248.3164062351, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "vcsWkid": 105703, "latestVcsWkid": 6360, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "heightModelInfo": { "heightModel": "gravity_related_height", "vertCRS": "NAVD88_height_(ftUS)", "heightUnit": "us-foot" }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.02083333333333329, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -1.2184189999999976E8, "falseY": -9.365899999999982E7, "xyUnits": 1536.0000000000032, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSSquare", "color": [ 0, 0, 0, 255 ], "size": 2, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": [ { "labelExpressionInfo": { "expression": "$feature.addrssFullAddress", "title": "Custom" }, "labelPlacement": "esriServerPointLabelPlacementAboveRight", "deconflictionStrategy": "dynamic", "stackLabel": true, "stackAlignment": "dynamic", "removeDuplicates": "none", "stackRowLength": 24, "useCodedValues": true, "maxScale": 0, "minScale": 5000, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": null, "haloSize": null, "font": { "family": "Tahoma", "size": 10, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "hasM": true, "hasZ": true, "enableZDefaults": true, "zDefault": 0, "supportsVCSProjection": true, "allowUpdateWithoutMValues": true, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "ctylmtCITYNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "DistTo_SewerPipe", "type": "esriFieldTypeDouble", "alias": "DistTo_SewerPipe", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DistTo_SewerPipe" }, { "name": "DistTo_WaterPipe", "type": "esriFieldTypeDouble", "alias": "DistTo_WaterPipe", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DistTo_WaterPipe" }, { "name": "addrssFullAddress", "type": "esriFieldTypeString", "alias": "Full Address from Original Address Record", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "addrssFullAddress" }, { "name": "addrssMSAG", "type": "esriFieldTypeString", "alias": "MSAG Community Name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "addrssMSAG" }, { "name": "addrssPostComm", "type": "esriFieldTypeString", "alias": "Postal Community Name", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "addrssPostComm" }, { "name": "addrssCITY", "type": "esriFieldTypeString", "alias": "City by Address Record", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "addrssCITY" }, { "name": "addrssETJ", "type": "esriFieldTypeString", "alias": "ETJ from Address Record", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "addrssETJ" }, { "name": "addrssCADCITY", "type": "esriFieldTypeString", "alias": "CAD City by Address Record", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "addrssCADCITY" }, { "name": "ctylmtCITYNAME", "type": "esriFieldTypeString", "alias": "City By CityLimit Boundary", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ctylmtCITYNAME" }, { "name": "parcelREID", "type": "esriFieldTypeString", "alias": "REID from Parcel", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "parcelREID" }, { "name": "parcelPIN", "type": "esriFieldTypeString", "alias": "PIN from Parcel", "domain": null, "editable": true, "nullable": true, "length": 14, "defaultValue": null, "modelName": "parcelPIN" }, { "name": "parcelPINEXT", "type": "esriFieldTypeString", "alias": "PIN_EXT", "domain": null, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "parcelPINEXT" }, { "name": "parcelOwner", "type": "esriFieldTypeString", "alias": "parcelOwner", "domain": null, "editable": true, "nullable": true, "length": 600, "defaultValue": null, "modelName": "parcelOwner" }, { "name": "parcelOwnerMail1", "type": "esriFieldTypeString", "alias": "parcelOwnerMail1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelOwnerMail1" }, { "name": "parcelOwnerMail2", "type": "esriFieldTypeString", "alias": "parcelOwnerMail2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelOwnerMail2" }, { "name": "parcelOwnerMail3", "type": "esriFieldTypeString", "alias": "parcelOwnerMail3", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelOwnerMail3" }, { "name": "parcelOwnerMail_City", "type": "esriFieldTypeString", "alias": "parcelOwnerMail_City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelOwnerMail_City" }, { "name": "parcelOwnerMail_State", "type": "esriFieldTypeString", "alias": "parcelOwnerMail_State", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelOwnerMail_State" }, { "name": "parcelOwnerMail_ZIP", "type": "esriFieldTypeString", "alias": "parcelOwnerMail_ZIP", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelOwnerMail_ZIP" }, { "name": "waterSystem", "type": "esriFieldTypeString", "alias": "waterSystem", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "waterSystem" }, { "name": "waterMATERIAL", "type": "esriFieldTypeString", "alias": "Water Pipe Material", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "waterMATERIAL" }, { "name": "waterYEARBUILT", "type": "esriFieldTypeString", "alias": "YEARBUILT of water pipe", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "waterYEARBUILT" }, { "name": "waterAssetid", "type": "esriFieldTypeString", "alias": "Asset ID of nearest water pipe", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "waterAssetid" }, { "name": "waterOwnedby", "type": "esriFieldTypeString", "alias": "water pipe Owned By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "waterOwnedby" }, { "name": "waterMaintainedby", "type": "esriFieldTypeString", "alias": "water pipe Maintained By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "waterMaintainedby" }, { "name": "waterAssettype", "type": "esriFieldTypeString", "alias": "Type of Water Pipe", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "waterAssettype" }, { "name": "waterSubtype", "type": "esriFieldTypeString", "alias": "Water Pipe Subtype", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "waterSubtype" }, { "name": "sewerAssettype", "type": "esriFieldTypeString", "alias": "Sewer Pipe Type", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "sewerAssettype" }, { "name": "sewerSize", "type": "esriFieldTypeString", "alias": "Sewer Size", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "sewerSize" }, { "name": "sewerMaterial", "type": "esriFieldTypeString", "alias": "Sewer Pipe Material", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "sewerMaterial" }, { "name": "sewerYearInstall", "type": "esriFieldTypeString", "alias": "Sewer Year Installed", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "sewerYearInstall" }, { "name": "sewerInstallationYear", "type": "esriFieldTypeSmallInteger", "alias": "Sewer InstallationYear", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sewerInstallationYear" }, { "name": "sewerOwnedBy", "type": "esriFieldTypeString", "alias": "Sewer Owner", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sewerOwnedBy" }, { "name": "sewerMaintby", "type": "esriFieldTypeString", "alias": "Sewer Maintainer", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sewerMaintby" }, { "name": "sewerAssetid", "type": "esriFieldTypeString", "alias": "Sewer Asset ID", "domain": null, "editable": true, "nullable": true, "length": 64, "defaultValue": null, "modelName": "sewerAssetid" }, { "name": "sewerSubtype", "type": "esriFieldTypeString", "alias": "Sewer Subtype", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sewerSubtype" }, { "name": "zoningZoneCode", "type": "esriFieldTypeString", "alias": "zoningZoneCode", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "zoningZoneCode" }, { "name": "zoningMERGE_SRC", "type": "esriFieldTypeString", "alias": "Zoning MERGE_SRC", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "zoningMERGE_SRC" }, { "name": "townshipName", "type": "esriFieldTypeString", "alias": "Township Name", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "townshipName" }, { "name": "votingPrecinct", "type": "esriFieldTypeString", "alias": "Voting Precinct", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "votingPrecinct" }, { "name": "schoolElem", "type": "esriFieldTypeString", "alias": "Elementary School District", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "schoolElem" }, { "name": "schoolMiddle", "type": "esriFieldTypeString", "alias": "Middle School District", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "schoolMiddle" }, { "name": "schoolHigh", "type": "esriFieldTypeString", "alias": "High School District", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "schoolHigh" }, { "name": "fireStation", "type": "esriFieldTypeString", "alias": "Fire Station District", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "fireStation" }, { "name": "overlayVAD_YN", "type": "esriFieldTypeString", "alias": "Within Half Mile of VAD", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "overlayVAD_YN" }, { "name": "overlayAdultCare_YN", "type": "esriFieldTypeString", "alias": "Within Half Mile of Adult Care Facility", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "overlayAdultCare_YN" }, { "name": "parcelLatestDeed_Date", "type": "esriFieldTypeDate", "alias": "Latest Recorded Deed Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "parcelLatestDeed_Date" }, { "name": "parcelLatestDeed_BookPage", "type": "esriFieldTypeString", "alias": "Latest Recorded Deed Book/Page", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelLatestDeed_BookPage" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R6484_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S4701_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Application Sites", "description": "", "prototype": { "attributes": { "parcelLatestDeed_Date": null, "DistTo_SewerPipe": null, "DistTo_WaterPipe": null, "addrssFullAddress": null, "addrssMSAG": null, "addrssPostComm": null, "addrssCITY": null, "addrssETJ": null, "addrssCADCITY": null, "ctylmtCITYNAME": null, "parcelREID": null, "parcelPIN": null, "parcelPINEXT": null, "parcelOwner": null, "parcelOwnerMail1": null, "parcelOwnerMail2": null, "parcelOwnerMail3": null, "parcelOwnerMail_City": null, "parcelOwnerMail_State": null, "parcelOwnerMail_ZIP": null, "waterSystem": null, "waterMATERIAL": null, "waterYEARBUILT": null, "waterAssetid": null, "waterOwnedby": null, "waterMaintainedby": null, "waterAssettype": null, "waterSubtype": null, "sewerAssettype": null, "sewerSize": null, "sewerMaterial": null, "sewerYearInstall": null, "sewerInstallationYear": null, "sewerOwnedBy": null, "sewerMaintby": null, "sewerAssetid": null, "sewerSubtype": null, "zoningZoneCode": null, "zoningMERGE_SRC": null, "townshipName": null, "votingPrecinct": null, "schoolElem": null, "schoolMiddle": null, "schoolHigh": null, "fireStation": null, "overlayVAD_YN": null, "overlayAdultCare_YN": null, "parcelLatestDeed_BookPage": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "e7ccebb681d4486a8f1d2dadef89fcfe" } ], "tables": [ { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 11, "name": "Application Submissions", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "BURKE.InspectionsTable", "relatedTableId": 12, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "appid", "composite": false, "catalogID": "{D5139378-C526-44B1-912C-33EA81CDDE99}" }, { "id": 2, "name": "BURKE.ProjectsTable", "relatedTableId": 13, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "appid", "composite": false, "catalogID": "{7306C8C6-95DE-4522-98E0-2D7B7CC6B45F}" }, { "id": 0, "name": "BURKE.ApplicationSites", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SiteAddress", "composite": false, "catalogID": "{8E6820FA-31E1-4FA9-9753-24541B79571A}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "applicant_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SiteAddress", "type": "esriFieldTypeString", "alias": "SiteAddress", "domain": null, "editable": true, "nullable": true, "length": 900, "defaultValue": null, "modelName": "SiteAddress" }, { "name": "appid", "type": "esriFieldTypeString", "alias": "Application ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appid" }, { "name": "appType", "type": "esriFieldTypeString", "alias": "Application Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appType" }, { "name": "appSubtype", "type": "esriFieldTypeString", "alias": "Application Subtype", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appSubtype" }, { "name": "appDate", "type": "esriFieldTypeDate", "alias": "Application Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "appDate" }, { "name": "status", "type": "esriFieldTypeString", "alias": "Application Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "status" }, { "name": "internal_status", "type": "esriFieldTypeString", "alias": "Status as per Internal Staff", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "internal_status" }, { "name": "internal_decisionDate", "type": "esriFieldTypeDate", "alias": "Date of Application Decision by Staff", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "internal_decisionDate" }, { "name": "appNote", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appNote" }, { "name": "appGroup", "type": "esriFieldTypeString", "alias": "Application Group", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appGroup" }, { "name": "applicant_id", "type": "esriFieldTypeString", "alias": "Applicant ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_id" }, { "name": "applicant_type", "type": "esriFieldTypeString", "alias": "Applicant Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_type" }, { "name": "applicant_name", "type": "esriFieldTypeString", "alias": "Applicant Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_name" }, { "name": "applicant_address", "type": "esriFieldTypeString", "alias": "Applicant Address", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_address" }, { "name": "applicant_address2", "type": "esriFieldTypeString", "alias": "Applicant Address Line 2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_address2" }, { "name": "applicant_city", "type": "esriFieldTypeString", "alias": "Applicant City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_city" }, { "name": "applicant_state", "type": "esriFieldTypeString", "alias": "Applicant State", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_state" }, { "name": "applicant_ZIP", "type": "esriFieldTypeString", "alias": "Applicant ZIP", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "applicant_ZIP" }, { "name": "internal_comments", "type": "esriFieldTypeString", "alias": "Comments by Internal Staff", "domain": null, "editable": true, "nullable": true, "length": 3000, "defaultValue": null, "modelName": "internal_comments" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "appURL_Tyler", "type": "esriFieldTypeString", "alias": "Tyler Munis Application URL", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appURL_Tyler" }, { "name": "project_YN", "type": "esriFieldTypeString", "alias": "Part of a Project?", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "project_YN" }, { "name": "projid", "type": "esriFieldTypeString", "alias": "Project ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projid" }, { "name": "parcelREID", "type": "esriFieldTypeString", "alias": "Parcel REID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "parcelREID" }, { "name": "contractorName", "type": "esriFieldTypeString", "alias": "Contractor Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contractorName" }, { "name": "internal_phasing", "type": "esriFieldTypeString", "alias": "Internal Phase 1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "internal_phasing" }, { "name": "internal_activeflag", "type": "esriFieldTypeString", "alias": "Internal Active or Closed", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "internal_activeflag" }, { "name": "SiteAddress_backup", "type": "esriFieldTypeString", "alias": "SiteAddress Backup", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SiteAddress_backup" } ], "indexes": [ { "name": "R6509_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_6509", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_10353_SiteAddress", "fields": "SiteAddress", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Application Submissions", "description": "", "prototype": { "attributes": { "internal_activeflag": null, "SiteAddress": null, "appid": null, "appType": null, "appSubtype": null, "appDate": null, "status": null, "internal_status": null, "internal_decisionDate": null, "appNote": null, "appGroup": null, "applicant_id": null, "applicant_type": null, "applicant_name": null, "applicant_address": null, "applicant_address2": null, "applicant_city": null, "applicant_state": null, "applicant_ZIP": null, "internal_comments": null, "SiteAddress_backup": null, "appURL_Tyler": null, "project_YN": null, "projid": null, "parcelREID": null, "contractorName": null, "internal_phasing": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": 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": "e7ccebb681d4486a8f1d2dadef89fcfe" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 12, "name": "Inspections Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 1, "name": "BURKE.AppsPermitsInspections", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "appid", "composite": false, "catalogID": "{D5139378-C526-44B1-912C-33EA81CDDE99}" } ], "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsAttachmentsResizing": true, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "appid", "type": "esriFieldTypeString", "alias": "Application ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appid" }, { "name": "inspid", "type": "esriFieldTypeString", "alias": "Inspection ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspid" }, { "name": "type", "type": "esriFieldTypeString", "alias": "Inspection Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "type" }, { "name": "inspector", "type": "esriFieldTypeString", "alias": "Inspector Assigned", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "inspector" }, { "name": "passfail", "type": "esriFieldTypeString", "alias": "Pass or Fail", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "passfail" }, { "name": "deptid", "type": "esriFieldTypeString", "alias": "Department ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "deptid" }, { "name": "contractorid", "type": "esriFieldTypeString", "alias": "Contractor ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "contractorid" }, { "name": "date_insp_created", "type": "esriFieldTypeDate", "alias": "Date Inspection-Request was Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_insp_created" }, { "name": "date_requested", "type": "esriFieldTypeDate", "alias": "Date Customer Requested for Inspection", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_requested" }, { "name": "date_scheduled", "type": "esriFieldTypeDate", "alias": "Scheduled Time for Inspection", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_scheduled" }, { "name": "date_performed", "type": "esriFieldTypeDate", "alias": "Date Inspection was Performed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "date_performed" }, { "name": "scheduledby", "type": "esriFieldTypeString", "alias": "Scheduled By", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "scheduledby" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R6515_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_10360_appid", "fields": "appid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_6515", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Inspections Table", "description": "", "prototype": { "attributes": { "scheduledby": null, "appid": null, "inspid": null, "type": null, "inspector": null, "passfail": null, "deptid": null, "contractorid": null, "date_insp_created": null, "date_requested": null, "date_scheduled": null, "date_performed": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": 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": "e7ccebb681d4486a8f1d2dadef89fcfe" }, { "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 13, "name": "Projects Table", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 2, "name": "BURKE.AppsPermitsInspections", "relatedTableId": 11, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "appid", "composite": false, "catalogID": "{7306C8C6-95DE-4522-98E0-2D7B7CC6B45F}" } ], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "OBJECTID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "appid", "type": "esriFieldTypeString", "alias": "Application ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "appid" }, { "name": "projid", "type": "esriFieldTypeString", "alias": "Project ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projid" }, { "name": "projName", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projName" }, { "name": "projDesc", "type": "esriFieldTypeString", "alias": "Project Description", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projDesc" }, { "name": "projStatus", "type": "esriFieldTypeString", "alias": "Project Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projStatus" }, { "name": "projDept", "type": "esriFieldTypeString", "alias": "Project Department", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projDept" }, { "name": "projType", "type": "esriFieldTypeString", "alias": "Project Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "projType" }, { "name": "projOpened", "type": "esriFieldTypeDate", "alias": "Date Project Opened", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "projOpened" }, { "name": "projClosed", "type": "esriFieldTypeDate", "alias": "Date Project Closed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "projClosed" }, { "name": "feedbackStatus", "type": "esriFieldTypeString", "alias": "Internal Feedback Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "feedbackStatus" } ], "indexes": [ { "name": "R6516_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_10756_appid", "fields": "appid", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Projects Table", "description": "", "prototype": { "attributes": { "projClosed": null, "appid": null, "projid": null, "projName": null, "projDesc": null, "projStatus": null, "projDept": null, "projType": null, "projOpened": null, "feedbackStatus": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "e7ccebb681d4486a8f1d2dadef89fcfe" } ] }