Name: Franchise Utility Permit Apply4 Table

Display Field: app_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 46acd4e6a9944d97b311a8885ea32751

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 )
• app_name ( modelName: APP_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: Application Name, type: esriFieldTypeString )
• authority_name ( modelName: AUTHORITY_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: Authority Name, type: esriFieldTypeString )
• application_id ( modelName: APPLICATION_ID, nullable: true, editable: true, defaultValue: null, length: 255, alias: Application ID, type: esriFieldTypeString )
• company_name ( modelName: COMPANY_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: Company Name, type: esriFieldTypeString )
• company_phone ( modelName: COMPANY_PHONE, nullable: true, editable: true, defaultValue: null, length: 255, alias: Company Phone, type: esriFieldTypeString )
• applicant_name ( modelName: APPLICANT_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicant Name, type: esriFieldTypeString )
• franchise_contact ( modelName: FRANCHISE_CONTACT, nullable: true, editable: true, defaultValue: null, length: 255, alias: Franchise Contact, type: esriFieldTypeString )
• project_name ( modelName: PROJECT_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Name, type: esriFieldTypeString )
• description_of_work ( modelName: DESCRIPTION_OF_WORK, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Description of Work, type: esriFieldTypeString )
• location_number ( modelName: LOCATION_NUMBER, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Number, type: esriFieldTypeString )
• location_name ( modelName: LOCATION_NAME, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Name, type: esriFieldTypeString )
• cross_street_1 ( modelName: CROSS_STREET_1, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cross Street 1, type: esriFieldTypeString )
• cross_street_2 ( modelName: CROSS_STREET_2, nullable: true, editable: true, defaultValue: null, length: 255, alias: Cross Street 2, type: esriFieldTypeString )
• side_of_street ( modelName: SIDE_OF_STREET, nullable: true, editable: true, defaultValue: null, length: 255, alias: Side of Street, type: esriFieldTypeString )
• number_of_lanes ( modelName: NUMBER_OF_LANES, nullable: true, editable: true, defaultValue: null, alias: Number of Lanes, type: esriFieldTypeInteger )
• close_sidewalk ( modelName: CLOSE_SIDEWALK, nullable: true, editable: true, defaultValue: null, alias: Close Sidewalk, type: esriFieldTypeInteger )
• metal_plates ( modelName: METAL_PLATES, nullable: true, editable: true, defaultValue: null, alias: Metal Plates, type: esriFieldTypeInteger )
• time_restriction ( modelName: TIME_RESTRICTION, nullable: true, editable: true, defaultValue: null, length: 255, alias: Time Restriction, type: esriFieldTypeString )
• application_status ( modelName: APPLICATION_STATUS, nullable: true, editable: true, defaultValue: null, length: 255, alias: Application Status, type: esriFieldTypeString )
• owner ( modelName: OWNER, nullable: true, editable: true, defaultValue: null, length: 255, alias: Owner, type: esriFieldTypeString )
• mapped ( modelName: MAPPED, nullable: true, editable: true, defaultValue: null, length: 512, alias: MAPPED, type: esriFieldTypeString )
• created_user ( modelName: CREATED_USER, nullable: true, editable: false, defaultValue: null, length: 255, alias: CREATED_USER, type: esriFieldTypeString )
• created_date ( modelName: CREATED_DATE, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: CREATED_DATE, type: esriFieldTypeDate )
• last_edited_user ( modelName: LAST_EDITED_USER, nullable: true, editable: false, defaultValue: null, length: 255, alias: LAST_EDITED_USER, type: esriFieldTypeString )
• last_edited_date ( modelName: LAST_EDITED_DATE, nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: LAST_EDITED_DATE, type: esriFieldTypeDate )
• submission_date ( modelName: SUBMISSION_DATE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Submission Date, type: esriFieldTypeString )
• processingtime ( modelName: processingtime, nullable: true, editable: true, defaultValue: null, alias: Processing Time, type: esriFieldTypeDouble )
• submission_date_converted ( modelName: submission_date_converted, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Submission Date Converted, type: esriFieldTypeDate )
• start_date ( modelName: start_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Start Date, type: esriFieldTypeDate )
• permit_issued_date ( modelName: permit_issued_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Permit Issued Date, type: esriFieldTypeDate )
• end_date ( modelName: end_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: End Date, type: esriFieldTypeDate )

Templates:

• Name: Franchise Utility Permit Apply4 Table
  Description:
  Prototype:
  end_date: null
  company_phone: null
  submission_date_converted: null
  franchise_contact: null
  number_of_lanes: null
  project_name: null
  time_restriction: null
  permit_issued_date: null
  cross_street_2: null
  cross_street_1: null
  submission_date: null
  metal_plates: null
  application_status: null
  processingtime: null
  start_date: null
  owner: null
  close_sidewalk: null
  side_of_street: null
  application_id: null
  applicant_name: null
  app_name: null
  location_name: null
  description_of_work: null
  company_name: null
  mapped: null
  authority_name: null
  location_number: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

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

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

Child Resources:   Field Groups   Contingent Values

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