{ "currentVersion" : 12, "id" : 0, "name" : "Code_Violations", "type" : "Feature Layer", "serviceItemId" : "9810c7d5732b4d0ba616770e79af9d0b", "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "objectid", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "ownershipBasedAccessControlForFeatures" : { "allowOthersToQuery" : true, "allowOthersToDelete" : true, "allowOthersToUpdate" : true, "allowAnonymousToQuery" : true, "allowAnonymousToUpdate" : false, "allowAnonymousToDelete" : false }, "serverGens" : { "minServerGen" : 329326, "serverGen" : 329326 }, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1790955791858, "schemaLastEditDate" : 1790691227830, "dataLastEditDate" : 1790955791928 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "supportsOBACForAnonymousUsers" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true }, "fullTextSearchableFields" : [ "Violation_ID", "Prop_address", "Lot_block_num", "Owner_name", "Owner_address" ] }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -180, "ymin" : -90, "xmax" : 180, "ymax" : 90, "spatialReference" : { "wkid" : 4326, "latestWkid" : 4326 } }, "spatialReference" : { "wkid" : 4326, "latestWkid" : 4326 }, "drawingInfo":{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Code_Violations","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}, "allowGeometryUpdates" : true, "hasAttachments" : true, "propagateVisibleFields" : true, "viewSourceHasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasM" : false, "hasZ" : false, "objectIdField" : "objectid", "uniqueIdField" : { "name" : "objectid", "isSystemMaintained" : true }, "globalIdField" : "globalid", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "objectid", "type" : "esriFieldTypeOID", "alias" : "ObjectID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "globalid", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeGUID", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "Violation_ID", "type" : "esriFieldTypeString", "alias" : "Violation ID", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Date", "type" : "esriFieldTypeDate", "alias" : "Date of Violation", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Status", "type" : "esriFieldTypeString", "alias" : "Source", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_Status", "codedValues" : [ { "name" : "Public Complaint/Access Dormont", "code" : "Public Complaint_Access Dormont" }, { "name" : "Phone Call", "code" : "Phone Call" }, { "name" : "Door Hanger", "code" : "Door Hanger" }, { "name" : "Other", "code" : "Other" }, { "name" : "Public Complaint_Access Dormont", "code" : "Public Complaint/Access Dormont" } ] }, "defaultValue" : null }, { "name" : "Prop_address", "type" : "esriFieldTypeString", "alias" : "Property Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Lot_block_num", "type" : "esriFieldTypeString", "alias" : "Lot & Block No.", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_name", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_address", "type" : "esriFieldTypeString", "alias" : "Mailing Address", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_city", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_state", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_zip", "type" : "esriFieldTypeString", "alias" : "Zip", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Phone", "type" : "esriFieldTypeString", "alias" : "Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Owner_Email", "type" : "esriFieldTypeString", "alias" : "Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Compaint_Received", "type" : "esriFieldTypeString", "alias" : "Complaint Received By", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_Compaint_Received", "codedValues" : [ { "name" : "Don Tang", "code" : "Don Tang" }, { "name" : "Dan Williams", "code" : "Dan Williams" }, { "name" : "Tony Shuey", "code" : "Tony Shuey" }, { "name" : "Joe Dryburgh", "code" : "Joe Dryburgh" }, { "name" : "Jeff Stakich", "code" : "Jeff Stakich" }, { "name" : "Jim Kolesky", "code" : "Jim Kolesky" }, { "name" : "Online Submittal", "code" : "Online Submittal" }, { "name" : "Clerks", "code" : "Clerks" } ] }, "defaultValue" : null }, { "name" : "Complainant_Contact", "type" : "esriFieldTypeString", "alias" : "Contact Complainant", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Complainant_Name", "type" : "esriFieldTypeString", "alias" : "Complainant Name", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Comp_Pref_Contact_Method", "type" : "esriFieldTypeString", "alias" : "Complainant Preferred Contact Method", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_Comp_Pref_Contact_Method", "codedValues" : [ { "name" : "Phone", "code" : "Phone" }, { "name" : "Email", "code" : "Email" } ] }, "defaultValue" : null }, { "name" : "Complainant_Phone", "type" : "esriFieldTypeString", "alias" : "Complainant Phone", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Complainant_Email", "type" : "esriFieldTypeString", "alias" : "Complainant Email", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Complaint_Cat", "type" : "esriFieldTypeString", "alias" : "Complaint Category", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "cvd_Complaint_Cat", "codedValues" : [ { "name" : "Annual Tree Trimming/Removal", "code" : "Annual Tree Trimming_Removal" }, { "name" : "Borough Construction Projects", "code" : "Borough Construction Projects" }, { "name" : "Code Enforcement", "code" : "Code Enforcement" }, { "name" : "Compliments/Thank Our Staff", "code" : "Compliments_Thank Our Staff" }, { "name" : "Stormwater Drain Backup", "code" : "Stormwater Drain Backup" }, { "name" : "Garbage", "code" : "Garbage" }, { "name" : "Other Issues", "code" : "Other Issues" }, { "name" : "Playground Repairs/Park Issues", "code" : "Playground Repairs_Park Issues" }, { "name" : "Power Line Down", "code" : "Power Line Down" }, { "name" : "Recreation Program Issues", "code" : "Recreation Program Issues" }, { "name" : "Sewage Leak", "code" : "Sewage Leak" }, { "name" : "Street Issues", "code" : "Street Issues" }, { "name" : "Traffic Signal and Walk Signal", "code" : "Traffic Signal and Walk Signal" }, { "name" : "Tree Down", "code" : "Tree Down" }, { "name" : "Water Break", "code" : "Water Break" }, { "name" : "Yard and Woody Waste Program", "code" : "Yard and Woody Waste Program" } ] }, "defaultValue" : null }, { "name" : "Complaint_Sub", "type" : "esriFieldTypeString", "alias" : "Issue Sub-Type", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Complaint_Notes", "type" : "esriFieldTypeString", "alias" : "Complaint Notes", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Woody_Date", "type" : "esriFieldTypeString", "alias" : "Woody Waste Collection Date", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zoning", "type" : "esriFieldTypeString", "alias" : "Zoning District", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__service___5242E6329A5BE670", "fields" : "objectid", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "GlobalIDIndex", "fields" : "globalid", "isAscending" : false, "isUnique" : true, "description" : "GlobalID index", "indexType" : "Attribute" }, { "name" : "service_7019da4ea35b4460828b525aaf99096b_CODE_VIOLATIONS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "exb_Violation_ID", "fields" : "Violation_ID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "exb_Prop_address", "fields" : "Prop_address", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "exb_Lot_block_num", "fields" : "Lot_block_num", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "exb_Owner_name", "fields" : "Owner_name", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "exb_Owner_address", "fields" : "Owner_address", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "exb_Violation_ID_total", "fields" : "Violation_ID, Prop_address, Lot_block_num, Owner_name, Owner_address", "description" : "", "locale" : "neutral", "indexType" : "FullText" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Violation_ID" : null, "Date" : null, "Inspector" : null, "Inspector_Title" : null, "Inspector_Phone" : null, "Inspector_Email" : null, "Status" : null, "Hanger_Date" : null, "Phone_Date" : null, "Phone_Notes" : null, "Cancel_Notes" : null, "Letter_Date" : null, "Citation_Date" : null, "Due_Date" : null, "Prop_address" : null, "Lot_block_num" : null, "Owner_name" : null, "Owner_address" : null, "Owner_city" : null, "Owner_state" : null, "Owner_zip" : null, "Owner_Phone" : null, "Owner_Email" : null, "Compaint_Received" : null, "Complainant_Contact" : null, "Complainant_Name" : null, "Comp_Pref_Contact_Method" : null, "Complainant_Phone" : null, "Complainant_Email" : null, "Complaint_Cat" : null, "Complaint_Sub" : null, "Complaint_Notes" : null, "Woody_Date" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Create,Query,Editing,Sync,ChangeTracking" }