Name: TC Permit Apply4 Table

Display Field: app_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 17eb96511c434bd2b118cc29cdc7e1fb

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: App 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 )
• permit_type ( modelName: Permit_Type, nullable: true, editable: true, defaultValue: null, length: 255, alias: Permit Type, type: esriFieldTypeString )
• company_name ( modelName: Company_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Company Name, type: esriFieldTypeString )
• applicant_phone ( modelName: Applicant_Phone, nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicant Phone, type: esriFieldTypeString )
• project_title ( modelName: Project_Title, nullable: true, editable: true, defaultValue: null, length: 255, alias: Project Title, type: esriFieldTypeString )
• description ( modelName: Description, nullable: true, editable: true, defaultValue: null, length: 2000, alias: Description, type: esriFieldTypeString )
• location_name ( modelName: Location_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location Name, type: esriFieldTypeString )
• applicant_name ( modelName: Applicant_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicant Name, type: esriFieldTypeString )
• applicant_email ( modelName: Applicant_Email, nullable: true, editable: true, defaultValue: null, length: 255, alias: Applicant Email, type: esriFieldTypeString )
• application_status ( modelName: Application_Status, nullable: true, editable: true, defaultValue: null, length: 255, alias: Application Status, type: esriFieldTypeString )
• total_duration ( modelName: Total_Duration, nullable: true, editable: true, defaultValue: null, length: 255, alias: Total Duration, type: esriFieldTypeString )
• weekend_start ( modelName: Weekend_Start, nullable: true, editable: true, defaultValue: null, length: 255, alias: Weekend Start, type: esriFieldTypeString )
• weekend_end ( modelName: Weekend_End, nullable: true, editable: true, defaultValue: null, length: 255, alias: Weekend End, type: esriFieldTypeString )
• meters_blocked ( modelName: Meters_Blocked, nullable: true, editable: true, defaultValue: null, length: 255, alias: Meters Blocked, type: esriFieldTypeString )
• quadrant ( modelName: Quadrant, nullable: true, editable: true, defaultValue: null, length: 255, alias: Quadrant, type: esriFieldTypeString )
• side_of_street ( modelName: Side_of_Street, nullable: true, editable: true, defaultValue: null, length: 255, alias: Side of Street, 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 )
• council_district ( modelName: Council_District, nullable: true, editable: true, defaultValue: null, length: 255, alias: Council District, type: esriFieldTypeString )
• npu ( modelName: NPU, nullable: true, editable: true, defaultValue: null, length: 255, alias: NPU, type: esriFieldTypeString )
• lssc_closure_type ( modelName: LSSC_Closure_Type, nullable: true, editable: true, defaultValue: null, length: 255, alias: LSSC Closure Type, type: esriFieldTypeString )
• lanes_closed ( modelName: Lanes_Closed, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lanes Closed, type: esriFieldTypeString )
• feet_closed ( modelName: Feet_Closed, nullable: true, editable: true, defaultValue: null, length: 255, alias: Feet Closed, type: esriFieldTypeString )
• metal_plates_ ( modelName: Metal_Plates_, nullable: true, editable: true, defaultValue: null, length: 255, alias: Metal Plates?, type: esriFieldTypeString )
• parking_meters_blocked ( modelName: Parking_Meters_Blocked, nullable: true, editable: true, defaultValue: null, length: 255, alias: Parking Meters Blocked, type: esriFieldTypeString )
• nature_of_work ( modelName: Nature_of_work, nullable: true, editable: true, defaultValue: null, length: 255, alias: Nature of Work, type: esriFieldTypeString )
• owner ( modelName: Owner, nullable: true, editable: true, defaultValue: null, length: 255, alias: Owner, type: esriFieldTypeString )
• latitude ( modelName: LATITUDE, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( modelName: LONGITUDE, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• how_many ( modelName: How_Many, nullable: true, editable: true, defaultValue: null, length: 50, alias: How Many, type: esriFieldTypeString )
• submission_date ( modelName: SUBMISSION_DATE, nullable: true, editable: true, defaultValue: null, length: 50, alias: Submission Date, type: esriFieldTypeString )
• location ( modelName: LOCATION, nullable: true, editable: true, defaultValue: null, length: 300, alias: Location, type: esriFieldTypeString )
• mapped ( modelName: MAPPED, nullable: true, editable: true, defaultValue: null, length: 25, alias: Mapped?, type: esriFieldTypeString , Coded Values: [?: ?] , [No: No] , [Yes: Yes] )
• 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 )
• processingtime ( modelName: processingtime, nullable: true, editable: true, defaultValue: null, alias: Processing Time, type: esriFieldTypeDouble )
• end_time ( modelName: end_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: End Time, type: esriFieldTypeDate )
• submission_date_converted ( modelName: submission_date_converted, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Submission Date Converted, type: esriFieldTypeDate )
• from_date ( modelName: from_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: From_Date, type: esriFieldTypeDate )
• end_date ( modelName: end_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: End Date, type: esriFieldTypeDate )
• start_time ( modelName: start_time, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Start Time, 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 )

Templates:

• Name: TC Permit Apply4 Table
  Description:
  Prototype:
  end_date: null
  lssc_closure_type: null
  submission_date_converted: null
  latitude: null
  weekend_start: null
  description: null
  permit_issued_date: null
  cross_street_2: null
  cross_street_1: null
  submission_date: null
  application_status: null
  applicant_email: null
  processingtime: null
  weekend_end: null
  parking_meters_blocked: null
  start_date: null
  longitude: null
  owner: null
  how_many: null
  meters_blocked: null
  from_date: null
  quadrant: null
  end_time: null
  project_title: null
  side_of_street: null
  applicant_phone: null
  application_id: null
  permit_type: null
  applicant_name: null
  nature_of_work: null
  lanes_closed: null
  app_name: null
  start_time: null
  location_name: null
  npu: null
  total_duration: null
  company_name: null
  mapped: null
  location: null
  feet_closed: null
  authority_name: null
  council_district: null
  metal_plates_: 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

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