Name: query

Display Field: design_firm_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 019c00c46514409cb3e3553d83cfbc1e

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• title ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: title, alias: ProjectName )
• pwp_no_ ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: pwp_no_, alias: PWP_No_ )
• city_contract_no_ ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: city_contract_no_, alias: City_Contract_No_ )
• reno_project_manager ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: reno_project_manager, alias: Reno_Project_Manager )
• reno_contact_phone ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: reno_contact_phone, alias: Reno_Contact_Phone )
• reno_contact_email ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: reno_contact_email, alias: Reno_Contact_Email )
• design_firm_name ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: design_firm_name, alias: Design_Firm_Name )
• construction_contractor ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: construction_contractor, alias: Construction_Contractor )
• contractor_phone ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: contractor_phone, alias: Contractor_Phone )
• department ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: department, alias: Department )
• latest_news ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: latest_news, alias: Latest_News )
• construction_start ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: construction_start, alias: Construction_Start )
• construction_complete_date ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: construction_complete_date, alias: Construction_Complete_Date )
• project_image_or_map ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: project_image_or_map, alias: Project_Image_or_Map )
• cost_and_funding_sources ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: cost_and_funding_sources, alias: Cost_and_Funding_Sources )
• project_status ( nullable: true, editable: true, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: project_status, alias: Project_Status )
• council_award_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: council_award_date, alias: Council_Award_Date )
• design_complete_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: design_complete_date, alias: Design_Complete_Date )
• latest_news_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: latest_news_date, alias: Latest_News_Date )
• bid_opening_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: bid_opening_date, alias: Bid_Opening_Date )
• advertise_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, type: esriFieldTypeDate, modelName: advertise_date, alias: Advertise_Date )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: globalid )
• project_description ( nullable: true, editable: true, defaultValue: null, length: 2000, alias: project_description, type: esriFieldTypeString )
• cost ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Cost, type: esriFieldTypeString )
• projecttype ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Project Type, type: esriFieldTypeString )
• image_url ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Image URL, type: esriFieldTypeString )
• alt_text ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: alt text for project image, type: esriFieldTypeString )
• council_award_status ( nullable: true, editable: true, defaultValue: null, length: 256, alias: Council Award Status, type: esriFieldTypeString )

Templates:

• Name: query
  Description:
  Prototype:
  reno_contact_phone: null
  contractor_phone: null
  reno_project_manager: null
  project_status: null
  pwp_no_: null
  construction_contractor: null
  title: null
  construction_start: null
  project_image_or_map: null
  cost_and_funding_sources: null
  council_award_date: null
  advertise_date: null
  bid_opening_date: null
  design_firm_name: null
  latest_news_date: null
  city_contract_no_: null
  reno_contact_email: null
  design_complete_date: null
  department: null
  construction_complete_date: null
  latest_news: 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: true

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