Name: Community Services Adopted Streets Work History Table

Display Field: OBJECTID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: f139fb43201c4f32b23f2e8bdb2ce593

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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: true
Supports Returning Query Extent: true
Supports Query With Distance: true
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: true
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• council_district ( type: esriFieldTypeString, alias: council_district, editable: true, nullable: true, length: 255, defaultValue: null, modelName: council_district )
• name_of_organization ( type: esriFieldTypeString, alias: Name of Organization, editable: true, nullable: true, length: 256, defaultValue: null, modelName: name_of_organization )
• type_of_organization ( type: esriFieldTypeString, alias: Type of Organization, editable: true, nullable: true, length: 255, defaultValue: null, modelName: type_of_organization , Coded Values: [Corporation: Corporation] , [Limited Liability Company: Limited Liability Company] , [General Partnership: General Partnership] , ...2 more... )
• adopted_street_id ( type: esriFieldTypeString, alias: adopted_street_id, editable: true, nullable: true, length: 255, defaultValue: null, modelName: adopted_street_id )
• rel_globalid ( type: esriFieldTypeString, alias: Related GlobalID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: rel_globalid )
• trash_weight_lbs ( type: esriFieldTypeDouble, alias: Trash Weight (lbs), editable: true, nullable: true, defaultValue: null, modelName: trash_weight_lbs )
• number_of_volunteers ( type: esriFieldTypeInteger, alias: Number of Volunteers, editable: true, nullable: true, defaultValue: null, modelName: number_of_volunteers )
• number_of_trash_bags ( type: esriFieldTypeInteger, alias: Number of Trash Bags, editable: true, nullable: true, defaultValue: null, modelName: number_of_trash_bags )
• any_concerns_or_suggestions ( type: esriFieldTypeString, alias: Any Concerns Or Suggestions For The Street?, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: any_concerns_or_suggestions )
• street_to_be_adopted_name ( type: esriFieldTypeString, alias: Street to Be Adopted Name, editable: true, nullable: true, length: 256, defaultValue: null, modelName: street_to_be_adopted_name )
• applicant_name ( type: esriFieldTypeString, alias: Applicant Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: applicant_name )
• email_address ( type: esriFieldTypeString, alias: Email Address, editable: true, nullable: true, length: 255, defaultValue: null, modelName: email_address )

Templates:

• Name: Community Services Adopted Streets Work History Table
  Description:
  Prototype:
  applicant_name: null
  email_address: null
  street_to_be_adopted_name: null
  any_concerns_or_suggestions: null
  number_of_trash_bags: null
  number_of_volunteers: null
  council_district: null
  name_of_organization: null
  type_of_organization: null
  adopted_street_id: null
  rel_globalid: null
  trash_weight_lbs: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• GISADMIN.COMMUNITY_SERVICES_ADOPTED_STREETS_L (1) -- Related To: Community Services Adopt A Street Lines (1)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata