{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Data_ExportTable", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "building_description": null, "esn": null, "lot_num": null, "objectid_12": null, "cfirst_name": null, "alt2_telephone": null, "plack_generated": null, "county": null, "full_address": null, "tax_account_num": null, "initials_mapping": null, "delby": null, "sentto": null, "archive_date": null, "property_location": null, "trans_by": null, "intersection": null, "prf_language": null, "state": null, "lock_tck": null, "id": null, "geocoding_date": null, "postal_comm": null, "mapping_verified_date": null, "date_addressed": null, "prd": null, "dmi_beg": null, "date_verified": null, "cemail": null, "telephone_land_line": null, "msag_comm": null, "address_issued": null, "property_id": null, "range_high": null, "mailing_address": null, "rd": null, "unit": null, "alt_cemail": null, "sts": null, "started_ticket": null, "address_issued_by": null, "plast_name": null, "region": null, "id_ticket_1": null, "status": null, "alt4_telephone": null, "pod": null, "system_assign": null, "alt_telephone": null, "utility": null, "trans_id": null, "point": null, "letter_name": null, "subdivision": null, "block_num": null, "called_cust": null, "street": null, "cfull_name": null, "address_issued_date": null, "field82": null, "pfirst_name": null, "field83": null, "alt3_telephone": null, "spartan_old_ticket": null, "pfull_name": null, "comments": null, "file_name": null, "initials_geocoding": null, "add_num": null, "inside_city": null, "range_low": null, "objectid_1": null, "address_by": null, "structure": null, "lv_assign": null, "id_ticket": null, "verified_by": null, "letter_generated": null, "walk_in": null, "clast_name": null, "msag_valid": null, "exch": null, "organization": null, "x": null, "y": null, "created_date": null, "dmi_end": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Data_ExportTable", "displayField": "cfull_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "id_ticket", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id_ticket", "length": 8000, "alias": "id_ticket", "type": "esriFieldTypeString" }, { "modelName": "objectid_1", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid_1", "alias": "objectid", "type": "esriFieldTypeDouble" }, { "modelName": "started_ticket", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "started_ticket", "alias": "started_ticket", "type": "esriFieldTypeInteger" }, { "modelName": "created_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 8000, "alias": "created_date", "type": "esriFieldTypeString" }, { "modelName": "cfull_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cfull_name", "length": 8000, "alias": "cfull_name", "type": "esriFieldTypeString" }, { "modelName": "cfirst_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cfirst_name", "length": 8000, "alias": "cfirst_name", "type": "esriFieldTypeString" }, { "modelName": "clast_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "clast_name", "length": 8000, "alias": "clast_name", "type": "esriFieldTypeString" }, { "modelName": "telephone_land_line", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "telephone_land_line", "length": 8000, "alias": "telephone_land_line", "type": "esriFieldTypeString" }, { "modelName": "alt_telephone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alt_telephone", "length": 8000, "alias": "alt_telephone", "type": "esriFieldTypeString" }, { "modelName": "alt2_telephone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alt2_telephone", "length": 8000, "alias": "alt2_telephone", "type": "esriFieldTypeString" }, { "modelName": "alt3_telephone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alt3_telephone", "length": 8000, "alias": "alt3_telephone", "type": "esriFieldTypeString" }, { "modelName": "alt4_telephone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alt4_telephone", "length": 8000, "alias": "alt4_telephone", "type": "esriFieldTypeString" }, { "modelName": "property_location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_location", "length": 8000, "alias": "property_location", "type": "esriFieldTypeString" }, { "modelName": "inside_city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "inside_city", "length": 8000, "alias": "inside_city", "type": "esriFieldTypeString" }, { "modelName": "pfull_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pfull_name", "length": 8000, "alias": "pfull_name", "type": "esriFieldTypeString" }, { "modelName": "pfirst_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pfirst_name", "length": 8000, "alias": "pfirst_name", "type": "esriFieldTypeString" }, { "modelName": "plast_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plast_name", "length": 8000, "alias": "plast_name", "type": "esriFieldTypeString" }, { "modelName": "subdivision", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "subdivision", "length": 8000, "alias": "subdivision", "type": "esriFieldTypeString" }, { "modelName": "block_num", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "block_num", "length": 8000, "alias": "block_num", "type": "esriFieldTypeString" }, { "modelName": "lot_num", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lot_num", "length": 8000, "alias": "lot_num", "type": "esriFieldTypeString" }, { "modelName": "tax_account_num", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tax_account_num", "length": 8000, "alias": "tax_account_num", "type": "esriFieldTypeString" }, { "modelName": "property_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "property_id", "length": 8000, "alias": "property_id", "type": "esriFieldTypeString" }, { "modelName": "street", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "street", "length": 8000, "alias": "street", "type": "esriFieldTypeString" }, { "modelName": "intersection", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "intersection", "length": 8000, "alias": "intersection", "type": "esriFieldTypeString" }, { "modelName": "mailing_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mailing_address", "length": 8000, "alias": "mailing_address", "type": "esriFieldTypeString" }, { "modelName": "building_description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "building_description", "length": 8000, "alias": "building_description", "type": "esriFieldTypeString" }, { "modelName": "comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 8000, "alias": "comments", "type": "esriFieldTypeString" }, { "modelName": "dmi_beg", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dmi_beg", "length": 8000, "alias": "dmi_beg", "type": "esriFieldTypeString" }, { "modelName": "structure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "structure", "length": 8000, "alias": "structure", "type": "esriFieldTypeString" }, { "modelName": "dmi_end", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dmi_end", "length": 8000, "alias": "dmi_end", "type": "esriFieldTypeString" }, { "modelName": "full_address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "full_address", "length": 8000, "alias": "full_address", "type": "esriFieldTypeString" }, { "modelName": "add_num", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "add_num", "alias": "add_num", "type": "esriFieldTypeInteger" }, { "modelName": "prd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "prd", "length": 8000, "alias": "prd", "type": "esriFieldTypeString" }, { "modelName": "rd", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "rd", "length": 8000, "alias": "rd", "type": "esriFieldTypeString" }, { "modelName": "sts", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sts", "length": 8000, "alias": "sts", "type": "esriFieldTypeString" }, { "modelName": "pod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pod", "length": 8000, "alias": "pod", "type": "esriFieldTypeString" }, { "modelName": "unit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "unit", "length": 8000, "alias": "unit", "type": "esriFieldTypeString" }, { "modelName": "msag_comm", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "msag_comm", "length": 8000, "alias": "msag_comm", "type": "esriFieldTypeString" }, { "modelName": "postal_comm", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "postal_comm", "length": 8000, "alias": "postal_comm", "type": "esriFieldTypeString" }, { "modelName": "county", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county", "length": 8000, "alias": "county", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 8000, "alias": "state", "type": "esriFieldTypeString" }, { "modelName": "esn", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "esn", "length": 8000, "alias": "esn", "type": "esriFieldTypeString" }, { "modelName": "exch", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "exch", "length": 8000, "alias": "exch", "type": "esriFieldTypeString" }, { "modelName": "region", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "region", "length": 8000, "alias": "region", "type": "esriFieldTypeString" }, { "modelName": "x", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "x", "alias": "x", "type": "esriFieldTypeDouble" }, { "modelName": "y", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "y", "alias": "y", "type": "esriFieldTypeDouble" }, { "modelName": "verified_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "verified_by", "length": 8000, "alias": "verified_by", "type": "esriFieldTypeString" }, { "modelName": "msag_valid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "msag_valid", "length": 8000, "alias": "msag_valid", "type": "esriFieldTypeString" }, { "modelName": "range_low", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "range_low", "length": 8000, "alias": "range_low", "type": "esriFieldTypeString" }, { "modelName": "range_high", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "range_high", "length": 8000, "alias": "range_high", "type": "esriFieldTypeString" }, { "modelName": "trans_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trans_id", "alias": "trans_id", "type": "esriFieldTypeDouble" }, { "modelName": "trans_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "trans_by", "length": 8000, "alias": "trans_by", "type": "esriFieldTypeString" }, { "modelName": "address_issued", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_issued", "alias": "address_issued", "type": "esriFieldTypeInteger" }, { "modelName": "address_issued_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_issued_by", "length": 8000, "alias": "address_issued_by", "type": "esriFieldTypeString" }, { "modelName": "initials_mapping", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "initials_mapping", "length": 8000, "alias": "initials_mapping", "type": "esriFieldTypeString" }, { "modelName": "initials_geocoding", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "initials_geocoding", "length": 8000, "alias": "initials_geocoding", "type": "esriFieldTypeString" }, { "modelName": "status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 8000, "alias": "status", "type": "esriFieldTypeString" }, { "modelName": "spartan_old_ticket", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spartan_old_ticket", "alias": "spartan_old_ticket", "type": "esriFieldTypeInteger" }, { "modelName": "sentto", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sentto", "alias": "sentto", "type": "esriFieldTypeInteger" }, { "modelName": "organization", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "organization", "length": 8000, "alias": "organization", "type": "esriFieldTypeString" }, { "modelName": "point", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "point", "length": 8000, "alias": "point", "type": "esriFieldTypeString" }, { "modelName": "lv_assign", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lv_assign", "length": 8000, "alias": "lv_assign", "type": "esriFieldTypeString" }, { "modelName": "delby", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "delby", "length": 8000, "alias": "delby", "type": "esriFieldTypeString" }, { "modelName": "lock_tck", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "lock_tck", "length": 8000, "alias": "lock_tck", "type": "esriFieldTypeString" }, { "modelName": "system_assign", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "system_assign", "length": 8000, "alias": "system_assign", "type": "esriFieldTypeString" }, { "modelName": "letter_generated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "letter_generated", "length": 8000, "alias": "letter_generated", "type": "esriFieldTypeString" }, { "modelName": "plack_generated", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plack_generated", "length": 8000, "alias": "plack_generated", "type": "esriFieldTypeString" }, { "modelName": "address_by", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_by", "length": 8000, "alias": "address_by", "type": "esriFieldTypeString" }, { "modelName": "date_addressed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date_addressed", "length": 8000, "alias": "date_addressed", "type": "esriFieldTypeString" }, { "modelName": "prf_language", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "prf_language", "length": 8000, "alias": "prf_language", "type": "esriFieldTypeString" }, { "modelName": "walk_in", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "walk_in", "length": 8000, "alias": "walk_in", "type": "esriFieldTypeString" }, { "modelName": "called_cust", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "called_cust", "length": 8000, "alias": "called_cust", "type": "esriFieldTypeString" }, { "modelName": "utility", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "utility", "length": 8000, "alias": "utility", "type": "esriFieldTypeString" }, { "modelName": "cemail", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "cemail", "length": 8000, "alias": "cemail", "type": "esriFieldTypeString" }, { "modelName": "alt_cemail", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "alt_cemail", "length": 8000, "alias": "alt_cemail", "type": "esriFieldTypeString" }, { "modelName": "archive_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "archive_date", "length": 8000, "alias": "archive_date", "type": "esriFieldTypeString" }, { "modelName": "letter_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "letter_name", "alias": "letter_name", "type": "esriFieldTypeInteger" }, { "modelName": "field82", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "field82", "length": 8000, "alias": "Field82", "type": "esriFieldTypeString" }, { "modelName": "field83", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "field83", "length": 8000, "alias": "Field83", "type": "esriFieldTypeString" }, { "modelName": "geocoding_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "geocoding_date", "length": 29, "alias": "geocoding_date", "type": "esriFieldTypeDate" }, { "modelName": "mapping_verified_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mapping_verified_date", "length": 29, "alias": "mapping_verified_date", "type": "esriFieldTypeDate" }, { "modelName": "address_issued_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address_issued_date", "length": 29, "alias": "address_issued_date", "type": "esriFieldTypeDate" }, { "modelName": "date_verified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date_verified", "length": 29, "alias": "date_verified", "type": "esriFieldTypeDate" }, { "modelName": "objectid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "objectid_12", "alias": "OBJECTID", "type": "esriFieldTypeInteger" }, { "modelName": "id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id", "alias": "id", "type": "esriFieldTypeInteger" }, { "modelName": "file_name", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "file_name", "length": 8000, "alias": "file_name", "type": "esriFieldTypeString" }, { "modelName": "id_ticket", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id_ticket_1", "length": 8000, "alias": "id_ticket", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "r492_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "72bae66c68114601908f0c29348e3a33", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 }