Name: Veemac_Sources_ExcelToTable

Display Field: pmvc_sources_name_

Type: Table

Geometry Type: N/A

Description:

Service Item Id: a5e7990282c34ec2bef8c1d413c7d545

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• pmvc_sources_collectionguid_ ( modelName: pmvc_sources_collectionguid_, nullable: true, editable: true, defaultValue: null, length: 315, alias: pmvc sources[collectionguid], type: esriFieldTypeString )
• pmvc_sources_name_ ( modelName: pmvc_sources_name_, nullable: true, editable: true, defaultValue: null, length: 33207, alias: pmvc sources[name], type: esriFieldTypeString )
• pmvc_sources_created_ ( modelName: pmvc_sources_created_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[created], type: esriFieldTypeString )
• pmvc_sources_inspected_ ( modelName: pmvc_sources_inspected_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[inspected], type: esriFieldTypeString )
• pmvc_sources_nextinspection_ ( modelName: pmvc_sources_nextinspection_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[nextinspection], type: esriFieldTypeString )
• pmvc_sources_interval_ ( modelName: pmvc_sources_interval_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[interval], type: esriFieldTypeInteger )
• pmvc_sources_zoneguid_ ( modelName: pmvc_sources_zoneguid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[zoneguid], type: esriFieldTypeString )
• pmvc_sources_area_ ( modelName: pmvc_sources_area_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[area], type: esriFieldTypeString )
• pmvc_sources_communityguid_ ( modelName: pmvc_sources_communityguid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[communityguid], type: esriFieldTypeString )
• pmvc_sources_geotype_ ( modelName: pmvc_sources_geotype_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotype], type: esriFieldTypeString )
• pmvc_sources_isactive_ ( modelName: pmvc_sources_isactive_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[isactive], type: esriFieldTypeInteger )
• pmvc_sources_inactivedate_ ( modelName: pmvc_sources_inactivedate_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[inactivedate], type: esriFieldTypeString )
• pmvc_sources_customerguid_ ( modelName: pmvc_sources_customerguid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[customerguid], type: esriFieldTypeString )
• pmvc_sources_isuswaters_ ( modelName: pmvc_sources_isuswaters_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[isuswaters], type: esriFieldTypeDouble )
• pmvc_sources_notes_ ( modelName: pmvc_sources_notes_, nullable: true, editable: true, defaultValue: null, length: 476, alias: pmvc sources[notes], type: esriFieldTypeString )
• pmvc_sources_icon_ ( modelName: pmvc_sources_icon_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[icon], type: esriFieldTypeString )
• pmvc_sources_color_ ( modelName: pmvc_sources_color_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[color], type: esriFieldTypeString )
• pmvc_sources_guid_ ( modelName: pmvc_sources_guid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[guid], type: esriFieldTypeString )
• pmvc_sources_ticks_ ( modelName: pmvc_sources_ticks_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ticks], type: esriFieldTypeString )
• pmvc_sources_repstatus_ ( modelName: pmvc_sources_repstatus_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[repstatus], type: esriFieldTypeString )
• pmvc_sources_ownfname_ ( modelName: pmvc_sources_ownfname_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownfname], type: esriFieldTypeString )
• pmvc_sources_ownlname_ ( modelName: pmvc_sources_ownlname_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownlname], type: esriFieldTypeString )
• pmvc_sources_ownaddress_ ( modelName: pmvc_sources_ownaddress_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownaddress], type: esriFieldTypeString )
• pmvc_sources_owncity_ ( modelName: pmvc_sources_owncity_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[owncity], type: esriFieldTypeString )
• pmvc_sources_ownzip_ ( modelName: pmvc_sources_ownzip_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownzip], type: esriFieldTypeString )
• pmvc_sources_ownstate_ ( modelName: pmvc_sources_ownstate_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownstate], type: esriFieldTypeString )
• pmvc_sources_ownphone_ ( modelName: pmvc_sources_ownphone_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownphone], type: esriFieldTypeString )
• pmvc_sources_ownemail_ ( modelName: pmvc_sources_ownemail_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownemail], type: esriFieldTypeString )
• pmvc_sources_ownnotes_ ( modelName: pmvc_sources_ownnotes_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[ownnotes], type: esriFieldTypeString )
• pmvc_sources_access_ ( modelName: pmvc_sources_access_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[access], type: esriFieldTypeString )
• pmvc_sources_sid_ ( modelName: pmvc_sources_sid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[sid], type: esriFieldTypeString )
• pmvc_sources_createdby_ ( modelName: pmvc_sources_createdby_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[createdby], type: esriFieldTypeString )
• pmvc_sources_part_ ( modelName: pmvc_sources_part_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[part], type: esriFieldTypeString )
• pmvc_sources_warrantstatus_ ( modelName: pmvc_sources_warrantstatus_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[warrantstatus], type: esriFieldTypeString )
• pmvc_sources_issuedate_ ( modelName: pmvc_sources_issuedate_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[issuedate], type: esriFieldTypeString )
• pmvc_sources_servedate_ ( modelName: pmvc_sources_servedate_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[servedate], type: esriFieldTypeString )
• pmvc_sources_districtid_ ( modelName: pmvc_sources_districtid_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[districtID], type: esriFieldTypeString )
• pmvc_sources_easyid_ ( modelName: pmvc_sources_easyid_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[easyID], type: esriFieldTypeInteger )
• pmvc_sources_pendingtreat_ ( modelName: pmvc_sources_pendingtreat_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[pendingTreat], type: esriFieldTypeInteger )
• pmvc_sources_positive_ ( modelName: pmvc_sources_positive_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[positive], type: esriFieldTypeString )
• pmvc_sources_lat_ ( modelName: pmvc_sources_lat_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[Lat], type: esriFieldTypeDouble )
• pmvc_sources_lon_ ( modelName: pmvc_sources_lon_, nullable: true, editable: true, defaultValue: null, alias: pmvc sources[Lon], type: esriFieldTypeDouble )
• pmvc_sources_geotext_2_ ( modelName: pmvc_sources_geotext_2_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.2], type: esriFieldTypeString )
• pmvc_sources_geotext_3_ ( modelName: pmvc_sources_geotext_3_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.3], type: esriFieldTypeString )
• pmvc_sources_geotext_4_ ( modelName: pmvc_sources_geotext_4_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.4], type: esriFieldTypeString )
• pmvc_sources_geotext_5_ ( modelName: pmvc_sources_geotext_5_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.5], type: esriFieldTypeString )
• pmvc_sources_geotext_6_ ( modelName: pmvc_sources_geotext_6_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.6], type: esriFieldTypeString )
• pmvc_sources_geotext_7_ ( modelName: pmvc_sources_geotext_7_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.7], type: esriFieldTypeString )
• pmvc_sources_geotext_8_ ( modelName: pmvc_sources_geotext_8_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.8], type: esriFieldTypeString )
• pmvc_sources_geotext_9_ ( modelName: pmvc_sources_geotext_9_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.9], type: esriFieldTypeString )
• pmvc_sources_geotext_10_ ( modelName: pmvc_sources_geotext_10_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.10], type: esriFieldTypeString )
• pmvc_sources_geotext_11_ ( modelName: pmvc_sources_geotext_11_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.11], type: esriFieldTypeString )
• pmvc_sources_geotext_12_ ( modelName: pmvc_sources_geotext_12_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.12], type: esriFieldTypeString )
• pmvc_sources_geotext_13_ ( modelName: pmvc_sources_geotext_13_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.13], type: esriFieldTypeString )
• pmvc_sources_geotext_14_ ( modelName: pmvc_sources_geotext_14_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.14], type: esriFieldTypeString )
• pmvc_sources_geotext_15_ ( modelName: pmvc_sources_geotext_15_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.15], type: esriFieldTypeString )
• pmvc_sources_geotext_16_ ( modelName: pmvc_sources_geotext_16_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.16], type: esriFieldTypeString )
• pmvc_sources_geotext_17_ ( modelName: pmvc_sources_geotext_17_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.17], type: esriFieldTypeString )
• pmvc_sources_geotext_18_ ( modelName: pmvc_sources_geotext_18_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.18], type: esriFieldTypeString )
• pmvc_sources_geotext_19_ ( modelName: pmvc_sources_geotext_19_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.19], type: esriFieldTypeString )
• pmvc_sources_geotext_20_ ( modelName: pmvc_sources_geotext_20_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.20], type: esriFieldTypeString )
• pmvc_sources_geotext_21_ ( modelName: pmvc_sources_geotext_21_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.21], type: esriFieldTypeString )
• pmvc_sources_geotext_22_ ( modelName: pmvc_sources_geotext_22_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.22], type: esriFieldTypeString )
• pmvc_sources_geotext_23_ ( modelName: pmvc_sources_geotext_23_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.23], type: esriFieldTypeString )
• pmvc_sources_geotext_24_ ( modelName: pmvc_sources_geotext_24_, nullable: true, editable: true, defaultValue: null, length: 255, alias: pmvc sources[geotext.24], type: esriFieldTypeString )

Templates:

• Name: Veemac_Sources_ExcelToTable
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata