{ "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": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Veemac_Sources_ExcelToTable", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "pmvc_sources_geotext_22_": null, "pmvc_sources_geotext_10_": null, "pmvc_sources_repstatus_": null, "pmvc_sources_warrantstatus_": null, "pmvc_sources_ownemail_": null, "pmvc_sources_ownzip_": null, "pmvc_sources_ownnotes_": null, "pmvc_sources_servedate_": null, "pmvc_sources_nextinspection_": null, "pmvc_sources_ownfname_": null, "pmvc_sources_ownlname_": null, "pmvc_sources_createdby_": null, "pmvc_sources_collectionguid_": null, "pmvc_sources_geotext_7_": null, "pmvc_sources_geotext_15_": null, "pmvc_sources_geotext_3_": null, "pmvc_sources_area_": null, "pmvc_sources_geotext_19_": null, "pmvc_sources_sid_": null, "pmvc_sources_geotext_11_": null, "pmvc_sources_part_": null, "pmvc_sources_geotext_23_": null, "pmvc_sources_ownaddress_": null, "pmvc_sources_ticks_": null, "pmvc_sources_inactivedate_": null, "pmvc_sources_ownphone_": null, "pmvc_sources_ownstate_": null, "pmvc_sources_access_": null, "pmvc_sources_geotext_8_": null, "pmvc_sources_districtid_": null, "pmvc_sources_pendingtreat_": null, "pmvc_sources_geotext_4_": null, "pmvc_sources_geotext_16_": null, "pmvc_sources_isactive_": null, "pmvc_sources_geotext_20_": null, "pmvc_sources_easyid_": null, "pmvc_sources_geotext_24_": null, "pmvc_sources_color_": null, "pmvc_sources_geotext_12_": null, "pmvc_sources_interval_": null, "pmvc_sources_created_": null, "pmvc_sources_geotext_9_": null, "pmvc_sources_notes_": null, "pmvc_sources_geotext_5_": null, "pmvc_sources_customerguid_": null, "pmvc_sources_lon_": null, "pmvc_sources_geotext_17_": null, "pmvc_sources_icon_": null, "pmvc_sources_name_": null, "pmvc_sources_geotype_": null, "pmvc_sources_geotext_21_": null, "pmvc_sources_geotext_13_": null, "pmvc_sources_owncity_": null, "pmvc_sources_zoneguid_": null, "pmvc_sources_positive_": null, "pmvc_sources_geotext_6_": null, "pmvc_sources_lat_": null, "pmvc_sources_communityguid_": null, "pmvc_sources_issuedate_": null, "pmvc_sources_geotext_2_": null, "pmvc_sources_inspected_": null, "pmvc_sources_geotext_14_": null, "pmvc_sources_guid_": null, "pmvc_sources_isuswaters_": null, "pmvc_sources_geotext_18_": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Veemac_Sources_ExcelToTable", "displayField": "pmvc_sources_name_", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "pmvc_sources_collectionguid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_collectionguid_", "length": 315, "alias": "pmvc sources[collectionguid]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_name_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_name_", "length": 33207, "alias": "pmvc sources[name]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_created_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_created_", "length": 255, "alias": "pmvc sources[created]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_inspected_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_inspected_", "length": 255, "alias": "pmvc sources[inspected]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_nextinspection_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_nextinspection_", "length": 255, "alias": "pmvc sources[nextinspection]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_interval_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_interval_", "alias": "pmvc sources[interval]", "type": "esriFieldTypeInteger" }, { "modelName": "pmvc_sources_zoneguid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_zoneguid_", "length": 255, "alias": "pmvc sources[zoneguid]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_area_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_area_", "length": 255, "alias": "pmvc sources[area]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_communityguid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_communityguid_", "length": 255, "alias": "pmvc sources[communityguid]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotype_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotype_", "length": 255, "alias": "pmvc sources[geotype]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_isactive_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_isactive_", "alias": "pmvc sources[isactive]", "type": "esriFieldTypeInteger" }, { "modelName": "pmvc_sources_inactivedate_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_inactivedate_", "length": 255, "alias": "pmvc sources[inactivedate]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_customerguid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_customerguid_", "length": 255, "alias": "pmvc sources[customerguid]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_isuswaters_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_isuswaters_", "alias": "pmvc sources[isuswaters]", "type": "esriFieldTypeDouble" }, { "modelName": "pmvc_sources_notes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_notes_", "length": 476, "alias": "pmvc sources[notes]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_icon_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_icon_", "length": 255, "alias": "pmvc sources[icon]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_color_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_color_", "length": 255, "alias": "pmvc sources[color]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_guid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_guid_", "length": 255, "alias": "pmvc sources[guid]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ticks_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ticks_", "length": 255, "alias": "pmvc sources[ticks]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_repstatus_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_repstatus_", "length": 255, "alias": "pmvc sources[repstatus]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownfname_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownfname_", "length": 255, "alias": "pmvc sources[ownfname]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownlname_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownlname_", "length": 255, "alias": "pmvc sources[ownlname]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownaddress_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownaddress_", "length": 255, "alias": "pmvc sources[ownaddress]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_owncity_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_owncity_", "length": 255, "alias": "pmvc sources[owncity]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownzip_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownzip_", "length": 255, "alias": "pmvc sources[ownzip]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownstate_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownstate_", "length": 255, "alias": "pmvc sources[ownstate]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownphone_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownphone_", "length": 255, "alias": "pmvc sources[ownphone]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownemail_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownemail_", "length": 255, "alias": "pmvc sources[ownemail]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_ownnotes_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_ownnotes_", "length": 255, "alias": "pmvc sources[ownnotes]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_access_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_access_", "length": 255, "alias": "pmvc sources[access]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_sid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_sid_", "length": 255, "alias": "pmvc sources[sid]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_createdby_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_createdby_", "length": 255, "alias": "pmvc sources[createdby]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_part_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_part_", "length": 255, "alias": "pmvc sources[part]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_warrantstatus_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_warrantstatus_", "length": 255, "alias": "pmvc sources[warrantstatus]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_issuedate_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_issuedate_", "length": 255, "alias": "pmvc sources[issuedate]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_servedate_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_servedate_", "length": 255, "alias": "pmvc sources[servedate]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_districtid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_districtid_", "length": 255, "alias": "pmvc sources[districtID]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_easyid_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_easyid_", "alias": "pmvc sources[easyID]", "type": "esriFieldTypeInteger" }, { "modelName": "pmvc_sources_pendingtreat_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_pendingtreat_", "alias": "pmvc sources[pendingTreat]", "type": "esriFieldTypeInteger" }, { "modelName": "pmvc_sources_positive_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_positive_", "length": 255, "alias": "pmvc sources[positive]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_lat_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_lat_", "alias": "pmvc sources[Lat]", "type": "esriFieldTypeDouble" }, { "modelName": "pmvc_sources_lon_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_lon_", "alias": "pmvc sources[Lon]", "type": "esriFieldTypeDouble" }, { "modelName": "pmvc_sources_geotext_2_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_2_", "length": 255, "alias": "pmvc sources[geotext.2]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_3_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_3_", "length": 255, "alias": "pmvc sources[geotext.3]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_4_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_4_", "length": 255, "alias": "pmvc sources[geotext.4]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_5_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_5_", "length": 255, "alias": "pmvc sources[geotext.5]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_6_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_6_", "length": 255, "alias": "pmvc sources[geotext.6]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_7_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_7_", "length": 255, "alias": "pmvc sources[geotext.7]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_8_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_8_", "length": 255, "alias": "pmvc sources[geotext.8]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_9_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_9_", "length": 255, "alias": "pmvc sources[geotext.9]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_10_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_10_", "length": 255, "alias": "pmvc sources[geotext.10]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_11_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_11_", "length": 255, "alias": "pmvc sources[geotext.11]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_12_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_12_", "length": 255, "alias": "pmvc sources[geotext.12]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_13_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_13_", "length": 255, "alias": "pmvc sources[geotext.13]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_14_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_14_", "length": 255, "alias": "pmvc sources[geotext.14]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_15_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_15_", "length": 255, "alias": "pmvc sources[geotext.15]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_16_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_16_", "length": 255, "alias": "pmvc sources[geotext.16]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_17_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_17_", "length": 255, "alias": "pmvc sources[geotext.17]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_18_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_18_", "length": 255, "alias": "pmvc sources[geotext.18]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_19_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_19_", "length": 255, "alias": "pmvc sources[geotext.19]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_20_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_20_", "length": 255, "alias": "pmvc sources[geotext.20]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_21_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_21_", "length": 255, "alias": "pmvc sources[geotext.21]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_22_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_22_", "length": 255, "alias": "pmvc sources[geotext.22]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_23_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_23_", "length": 255, "alias": "pmvc sources[geotext.23]", "type": "esriFieldTypeString" }, { "modelName": "pmvc_sources_geotext_24_", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pmvc_sources_geotext_24_", "length": 255, "alias": "pmvc sources[geotext.24]", "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" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": true, "indexes": [ { "name": "r1026_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "a5e7990282c34ec2bef8c1d413c7d545", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }