{ "tables": [{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "infoInEstimates": ["count"], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Table", "relationships": [], "cimVersion": "3.7.0", "isDataArchived": false, "id": 1, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml,excel,featureCollection", "hasLastEditTime": false, "standardMaxRecordCount": 32000, "isDataVersioned": false, "templates": [{ "name": "Comments", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "Comment": null, "CommentSequenceNum": null, "AccountID": null, "PaymentPlan": null, "CommentDate": null, "CommentCode": null }} }], "supportsAdvancedQueries": true, "currentVersion": 12.1, "advancedEditingCapabilities": { "supportsSessionBasedAddAttachments": true, "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsSessionBasedUpdateFeatures": true, "supportsSessionBasedDeleteAttachments": true, "supportsDivideCombineGroupedObjects": true, "supportsDeleteAssociations": true, "supportsSessionBasedUpdateAttachments": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF", "supportsSessionBasedDeleteFeatures": true, "supportsSessionBasedAddFeatures": true }, "objectIdField": "OBJECTID", "name": "Comments", "displayField": "AccountID", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "AccountID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "AccountID", "alias": "Billing Account ID", "type": "esriFieldTypeInteger" }, { "modelName": "CommentSequenceNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "CommentSequenceNum", "alias": "Comment Sequence Number", "type": "esriFieldTypeSmallInteger" }, { "modelName": "CommentDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "CommentDate", "length": 8, "alias": "Comment Date", "type": "esriFieldTypeDate" }, { "modelName": "CommentCode", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "CommentCodes", "description": "Comment Code Descriptions", "type": "codedValue", "codedValues": [ { "code": "AB", "name": "ABATEMENT DESCRIPTION" }, { "code": "AC", "name": "Mail Address Change" }, { "code": "AP", "name": "Admin Prin Adjustment" }, { "code": "AR", "name": "Advanced Pymt Refund" }, { "code": "AX", "name": "Annexation" }, { "code": "AY", "name": "Refered to Attorney" }, { "code": "CO", "name": "Pay city owned assessment" }, { "code": "CR", "name": "Certified Receipt" }, { "code": "FQ", "name": "Fax Quote" }, { "code": "GC", "name": "General Comment" }, { "code": "IA", "name": "Interest Date Adjustment" }, { "code": "ID", "name": "Property ID Note" }, { "code": "NR", "name": "Not Refered to Attorney" }, { "code": "OC", "name": "Ownership Change" }, { "code": "PB", "name": "PAID BY BANK GARNISHMENT" }, { "code": "PC", "name": "Changed JV Num, Post Date" }, { "code": "PI", "name": "Paid In Permits" }, { "code": "PQ", "name": "Phone Quote" }, { "code": "PR", "name": "Overpaid Closing Refund" }, { "code": "PW", "name": "PAID BY WAGE GARNISHMENT" }, { "code": "RA", "name": "Reversal - ABS" }, { "code": "RC", "name": "Reversal - Rev Collector" }, { "code": "RM", "name": "Returned Mail" }, { "code": "SC", "name": "Status Change" }, { "code": "TA", "name": "Transfer PrePayment" }, { "code": "TC", "name": "Talked to Customer" }, { "code": "VM", "name": "Left Voice Mail" }, { "code": "WA", "name": "Waived Account" }, { "code": "WO", "name": "Write-Off Account" }, { "code": "WQ", "name": "Written Quote" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CommentCode", "length": 2, "alias": "Comment Code", "type": "esriFieldTypeString" }, { "modelName": "Comment", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Comment", "length": 1000, "alias": "Comment", "type": "esriFieldTypeString" }, { "modelName": "GlobalID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "PaymentPlan", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes No", "description": "Yes No", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "Y", "name": "Yes" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "PaymentPlan", "length": 1, "alias": "Payment Plan", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" }, "bigIntegerRestrictedTo53Bits": true, "preferredTimeReference": null, "useStandardizedQueries": true, "globalIdField": "GlobalID", "description": "", "syncCanReturnChanges": false, "supportsRollbackOnFailureParameter": false, "isDataReplicaTracked": false, "indexes": [ { "name": "R23_SDE_ROWID_UK", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "UUID_23", "isUnique": true, "description": "", "isAscending": true, "fields": "GlobalID" }, { "name": "GDB_29_AccountID", "isUnique": false, "description": "", "isAscending": true, "fields": "AccountID" } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user", "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" } }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsUseEstimateForExceedsLimit": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsCurrentUserQueries": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "serviceItemId": "fe3711939d534f02944f39d2c8d8c5ca", "supportsCoordinatesQuantization": false, "types": [], "capabilities": "Create,Uploads,Editing", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "supportedTrueCurvePbfFeatureEncodings": [ "esriCompressedShapeBuffer", "esriDefault" ], "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF,CSV", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "copyrightText": "" }], "layers": [{ "isCoGoEnabled": false, "extent": { "ymin": "NaN", "zmin": null, "xmin": "NaN", "ymax": "NaN", "zmax": null, "xmax": "NaN", "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2264, "zTolerance": 0.001, "wkid": 102719, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "relationships": [], "cimVersion": "3.7.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0032808333333333331, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2264, "zTolerance": 0.001, "wkid": 102719, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "falseZ": -100000 }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml,excel,featureCollection", "hasLastEditTime": false, "standardMaxRecordCount": 4000, "isDataVersioned": false, "hasGeometryProperties": true, "templates": [{ "name": "Placeholder", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": {"attributes": {}} }], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 12.1, "canScaleSymbols": false, "hasZ": true, "advancedEditingCapabilities": { "supportsSessionBasedAddAttachments": true, "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsSessionBasedUpdateFeatures": true, "supportsSessionBasedDeleteAttachments": true, "supportsDivideCombineGroupedObjects": true, "supportsDeleteAssociations": true, "supportsSessionBasedUpdateAttachments": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF", "supportsSessionBasedDeleteFeatures": true, "supportsSessionBasedAddFeatures": true }, "supportsQuantizationEditMode": true, "objectIdField": "OBJECTID", "name": "Placeholder", "allowTrueCurvesUpdates": false, "displayField": "OBJECTID", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "Shape.STArea()", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "Shape__Area", "alias": "Shape.STArea()", "type": "esriFieldTypeDouble", "required": true }, { "modelName": "Shape.STLength()", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "Shape__Length", "alias": "Shape.STLength()", "type": "esriFieldTypeDouble", "required": true } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true, "timeZone": "Eastern Standard Time" }, "bigIntegerRestrictedTo53Bits": true, "hasM": false, "allowGeometryUpdates": false, "preferredTimeReference": null, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 0.0032808333333333331, "mUnits": 1, "zUnits": 10000, "latestWkid": 2264, "zTolerance": 0.001, "wkid": 102719, "xyUnits": 3048.00609601219276, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "falseZ": -100000 }, "globalIdField": "", "description": "", "syncCanReturnChanges": false, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 32000, "indexes": [ { "name": "R37_pk", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "S7_idx", "isUnique": true, "description": "", "isAscending": true, "fields": "Shape" } ], "editFieldsInfo": null, "supportsDatumTransformation": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsUseEstimateForExceedsLimit": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsTrueCurve": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsReturningGeometryEnvelope": true, "supportedCurveTypes": [ "esriGeometryCircularArc", "esriGeometryEllipticArc", "esriGeometryBezier3Curve" ], "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": false, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Uploads,Editing", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "supportedTrueCurvePbfFeatureEncodings": [ "esriCompressedShapeBuffer", "esriDefault" ], "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF,CSV", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportsVCSProjection": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 110, 110, 110, 255 ], "width": 0.69999999999999996, "style": "esriSLSSolid", "type": "esriSLS" }, "color": [ 252, 189, 212, 255 ], "style": "esriSFSSolid", "type": "esriSFS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "Shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon" }] }