Name: Building Permit Details

Display Field: folder_name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 150

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• folder_rsn ( type: esriFieldTypeOID, alias: folder_rsn )
• property_rsn ( type: esriFieldTypeInteger, alias: property_rsn )
• eplans_project_id ( type: esriFieldTypeInteger, alias: eplans_project_id )
• intake_folder_rsn ( type: esriFieldTypeInteger, alias: intake_folder_rsn )
• intake_folder_status ( type: esriFieldTypeString, alias: intake_folder_status, length: 255 )
• intake_request_submitted ( type: esriFieldTypeDate, alias: intake_request_submitted, length: 8 )
• intake_review_approved ( type: esriFieldTypeDate, alias: intake_review_approved, length: 8 )
• intake_category_of_const ( type: esriFieldTypeString, alias: intake_category_of_const, length: 255 )
• intake_request_type ( type: esriFieldTypeString, alias: intake_request_type, length: 255 )
• intake_type_of_work ( type: esriFieldTypeString, alias: intake_type_of_work, length: 255 )
• intake_link_to_permit ( type: esriFieldTypeDate, alias: intake_link_to_permit, length: 8 )
• intake_work_valuation ( type: esriFieldTypeInteger, alias: intake_work_valuation )
• dev_hub_status ( type: esriFieldTypeString, alias: dev_hub_status, length: 255 )
• folder_name ( type: esriFieldTypeString, alias: folder_name, length: 255 )
• folder_type ( type: esriFieldTypeString, alias: folder_type, length: 40 )
• folder_number ( type: esriFieldTypeString, alias: folder_number, length: 25 )
• folder_section ( type: esriFieldTypeString, alias: folder_section, length: 3 )
• folder_revision ( type: esriFieldTypeString, alias: folder_revision, length: 3 )
• status ( type: esriFieldTypeString, alias: status, length: 40 )
• description ( type: esriFieldTypeString, alias: description, length: 4000 )
• work_type ( type: esriFieldTypeString, alias: work_type, length: 100 )
• sub_type ( type: esriFieldTypeString, alias: sub_type, length: 100 )
• reference_file ( type: esriFieldTypeString, alias: reference_file, length: 255 )
• in_date ( type: esriFieldTypeDate, alias: in_date, length: 8 )
• under_review_date ( type: esriFieldTypeDate, alias: under_review_date, length: 8 )
• pre_issuance_start_date ( type: esriFieldTypeDate, alias: pre_issuance_start_date, length: 8 )
• pre_issuance_complete_date ( type: esriFieldTypeDate, alias: pre_issuance_complete_date, length: 8 )
• approved_to_issue_date ( type: esriFieldTypeDate, alias: approved_to_issue_date, length: 8 )
• issued_date ( type: esriFieldTypeDate, alias: issued_date, length: 8 )
• under_inspection_date ( type: esriFieldTypeDate, alias: under_inspection_date, length: 8 )
• final_date ( type: esriFieldTypeDate, alias: final_date, length: 8 )
• expiry_date ( type: esriFieldTypeDate, alias: expiry_date, length: 8 )
• property_address ( type: esriFieldTypeString, alias: property_address, length: 60 )
• property_r_number ( type: esriFieldTypeString, alias: property_r_number, length: 9 )
• property_alt_r_number ( type: esriFieldTypeString, alias: property_alt_r_number, length: 15 )
• property_state_id ( type: esriFieldTypeString, alias: property_state_id, length: 40 )
• property_city ( type: esriFieldTypeString, alias: property_city, length: 40 )
• property_county ( type: esriFieldTypeString, alias: property_county, length: 40 )
• property_neighborhood ( type: esriFieldTypeString, alias: property_neighborhood, length: 255 )
• property_neighborhood_police ( type: esriFieldTypeString, alias: property_neighborhood_police, length: 255 )
• property_neighborhood_coalition ( type: esriFieldTypeString, alias: property_neighborhood_coalition, length: 255 )
• property_business_association ( type: esriFieldTypeString, alias: property_business_association, length: 255 )
• building_submitted_valuation ( type: esriFieldTypeInteger, alias: building_submitted_valuation )
• building_final_valuation ( type: esriFieldTypeInteger, alias: building_final_valuation )
• building_final_value_class ( type: esriFieldTypeString, alias: building_final_value_class, length: 255 )
• building_new_unit_count ( type: esriFieldTypeInteger, alias: building_new_unit_count )
• building_removed_unit_count ( type: esriFieldTypeInteger, alias: building_removed_unit_count )
• building_net_unit_count ( type: esriFieldTypeInteger, alias: building_net_unit_count )
• building_story_count ( type: esriFieldTypeInteger, alias: building_story_count )
• timeline_exception_reason ( type: esriFieldTypeString, alias: timeline_exception_reason, length: 50 )
• review_type ( type: esriFieldTypeString, alias: review_type, length: 40 )
• intake_folder_days ( type: esriFieldTypeInteger, alias: intake_folder_days )
• first_review_complete_date ( type: esriFieldTypeDate, alias: first_review_complete_date, length: 8 )
• first_rev_overdue_status ( type: esriFieldTypeString, alias: first_rev_overdue_status, length: 255 )
• first_review_complete ( type: esriFieldTypeString, alias: first_review_complete, length: 40 )
• first_review_avg_days ( type: esriFieldTypeInteger, alias: first_review_avg_days )
• create_year ( type: esriFieldTypeString, alias: create_year, length: 4 )
• create_year_month ( type: esriFieldTypeString, alias: create_year_month, length: 30 )
• create_fiscal_year ( type: esriFieldTypeString, alias: create_fiscal_year, length: 20 )
• relative_date_class ( type: esriFieldTypeString, alias: relative_date_class, length: 50 )
• under_review_year ( type: esriFieldTypeString, alias: under_review_year, length: 4 )
• under_review_year_month ( type: esriFieldTypeString, alias: under_review_year_month, length: 30 )
• under_review_within_one_year ( type: esriFieldTypeString, alias: under_review_within_one_year, length: 5 )
• app_to_und_rev_days ( type: esriFieldTypeInteger, alias: app_to_und_rev_days )
• und_rev_to_pre_iss_days ( type: esriFieldTypeInteger, alias: und_rev_to_pre_iss_days )
• pre_issuance_days ( type: esriFieldTypeInteger, alias: pre_issuance_days )
• pre_issue_to_ati_days ( type: esriFieldTypeInteger, alias: pre_issue_to_ati_days )
• app_to_ati_days ( type: esriFieldTypeInteger, alias: app_to_ati_days )
• app_to_issue_days ( type: esriFieldTypeInteger, alias: app_to_issue_days )
• approved_to_issue_days ( type: esriFieldTypeInteger, alias: approved_to_issue_days )
• approved_to_issue_days_class ( type: esriFieldTypeString, alias: approved_to_issue_days_class, length: 20 )
• tot_city_busy_to_ati_days ( type: esriFieldTypeInteger, alias: tot_city_busy_to_ati_days )
• tot_cust_busy_to_ati_days ( type: esriFieldTypeInteger, alias: tot_cust_busy_to_ati_days )
• days_since_intake ( type: esriFieldTypeInteger, alias: days_since_intake )
• days_since_setup ( type: esriFieldTypeInteger, alias: days_since_setup )
• days_since_und_rev ( type: esriFieldTypeInteger, alias: days_since_und_rev )
• days_since_first_rev_done ( type: esriFieldTypeInteger, alias: days_since_first_rev_done )
• days_since_pre_issue_start ( type: esriFieldTypeInteger, alias: days_since_pre_issue_start )
• days_since_pre_issue_done ( type: esriFieldTypeInteger, alias: days_since_pre_issue_done )
• days_since_ati ( type: esriFieldTypeInteger, alias: days_since_ati )
• days_since_issue ( type: esriFieldTypeInteger, alias: days_since_issue )
• checksheet_count ( type: esriFieldTypeInteger, alias: checksheet_count )
• corrections_received_count ( type: esriFieldTypeInteger, alias: corrections_received_count )
• reviewer_overdue_status ( type: esriFieldTypeString, alias: reviewer_overdue_status, length: 255 )
• review_window_status ( type: esriFieldTypeString, alias: review_window_status, length: 255 )
• review_window_publish_text ( type: esriFieldTypeString, alias: review_window_publish_text, length: 255 )
• under_inspection_days ( type: esriFieldTypeInteger, alias: under_inspection_days )
• inspection_site_visit_count ( type: esriFieldTypeInteger, alias: inspection_site_visit_count )
• inspection_window_publish_text ( type: esriFieldTypeString, alias: inspection_window_publish_text, length: 255 )
• building_occupancy_group_1 ( type: esriFieldTypeString, alias: building_occupancy_group_1, length: 255 )
• building_construction_type_1 ( type: esriFieldTypeString, alias: building_construction_type_1, length: 255 )
• building_total_sq_ft_1 ( type: esriFieldTypeInteger, alias: building_total_sq_ft_1 )
• building_occupancy_group_2 ( type: esriFieldTypeString, alias: building_occupancy_group_2, length: 255 )
• building_construction_type_2 ( type: esriFieldTypeString, alias: building_construction_type_2, length: 255 )
• building_total_sq_ft_2 ( type: esriFieldTypeInteger, alias: building_total_sq_ft_2 )
• building_occupancy_group_3 ( type: esriFieldTypeString, alias: building_occupancy_group_3, length: 255 )
• building_construction_type_3 ( type: esriFieldTypeString, alias: building_construction_type_3, length: 255 )
• building_total_sq_ft_3 ( type: esriFieldTypeInteger, alias: building_total_sq_ft_3 )
• building_occupancy_group_4 ( type: esriFieldTypeString, alias: building_occupancy_group_4, length: 255 )
• building_construction_type_4 ( type: esriFieldTypeString, alias: building_construction_type_4, length: 255 )
• building_total_sq_ft_4 ( type: esriFieldTypeInteger, alias: building_total_sq_ft_4 )
• aff_housing_unit_count ( type: esriFieldTypeInteger, alias: aff_housing_unit_count )
• aff_housing_exempt_type_1 ( type: esriFieldTypeString, alias: aff_housing_exempt_type_1, length: 255 )
• aff_housing_exempt_sqft_1 ( type: esriFieldTypeString, alias: aff_housing_exempt_sqft_1, length: 255 )
• aff_housing_exempt_type_2 ( type: esriFieldTypeString, alias: aff_housing_exempt_type_2, length: 255 )
• aff_housing_exempt_sqft_2 ( type: esriFieldTypeString, alias: aff_housing_exempt_sqft_2, length: 255 )
• aff_housing_exempt_type_3 ( type: esriFieldTypeString, alias: aff_housing_exempt_type_3, length: 255 )
• aff_housing_exempt_sqft_3 ( type: esriFieldTypeString, alias: aff_housing_exempt_sqft_3, length: 255 )
• aff_housing_exempt_type_4 ( type: esriFieldTypeString, alias: aff_housing_exempt_type_4, length: 255 )
• aff_housing_exempt_sqft_4 ( type: esriFieldTypeString, alias: aff_housing_exempt_sqft_4, length: 255 )
• gis_map_label ( type: esriFieldTypeString, alias: gis_map_label, length: 50 )
• gis_symbol_class ( type: esriFieldTypeString, alias: gis_symbol_class, length: 50 )
• gis_process_date ( type: esriFieldTypeDate, alias: gis_process_date, length: 8 )
• gis_process_status ( type: esriFieldTypeString, alias: gis_process_status, length: 100 )
• portland_maps_url ( type: esriFieldTypeString, alias: portland_maps_url, length: 100 )
• eplans_url ( type: esriFieldTypeString, alias: eplans_url, length: 255 )
• efiles_url ( type: esriFieldTypeString, alias: efiles_url, length: 255 )
• report_date ( type: esriFieldTypeDate, alias: report_date, length: 8 )
• report_url ( type: esriFieldTypeString, alias: report_url, length: 255 )
• life_cycle_image_url ( type: esriFieldTypeString, alias: life_cycle_image_url, length: 255 )
• gantt_chart_url ( type: esriFieldTypeString, alias: gantt_chart_url, length: 255 )
• web_merc_x ( type: esriFieldTypeDouble, alias: web_merc_x )
• web_merc_y ( type: esriFieldTypeDouble, alias: web_merc_y )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata