Metadata: AMANDA Folder Detail

AMANDA Folder Detail

Category Development
Feature Dataset Name AMANDA_Folder_Publish
Item Name AMANDA_Folder_Publish
Database Type SDE
Originator AMANDA/BDS GIS
Bureau Bureau of Development Services
Publication Date 10/01/2020
Abstract AMANDA folder details and processing metrics
Purpose AMANDA folder details and processing metrics
Supplemental Information This dataset contains only permits that could be mapped.  Some of the older permits we do not have a reliable associated parcel centroid to associate the permit with.
Last Dataset Update
Last Source Update
Maintenance/Update Frequency Daily
Extent City of Portland
Data Type
Shape Type Point
Feature Count
Horizontal Position Accuracy
Horizontal Position Accuracy Link
Progress
North Bounding Coordinate
South Bounding Coordinate
East Bounding Coordinate
West Bounding Coordinate
Theme Keyword(s) Permit,AMANDA,Folder
Theme Keyword Thesaurus Permit,Construction
Place Keyword(s) Portland
Place Keyword Thesaurus
Access Constraints Available for Public Use
Use Constraints
Source Dataset Type Enterprise Geodatabase
Output Geodatabase EGH_Web
Distribution Grid: State plane coordinate system 1983(91).
Units: International feet
Datum: North American Datum of 1983/1991 (HPGN)
Liability: The information in this file was derived from digital databases on the City of Portland GIS. Care was taken in the creation of this file. The City cannot accept any responsibility for errors, omissions, or positional accuracy. There are no warranties, expressed or implied.
Format: Shapefile or File Geodatabase Feature Class - Data will be provided via City of Portland FTP Site.
Online Resource: http://portlandmaps.com/opendata
Online Instructions: City of Portland Public/Open Data is distributed via the PortlandMaps Open Data Site - http://portlandmaps.com/opendata. Data not available on the PortlandMaps Open Data site can be requested by contacting the City of Portland CGIS Group - maps@portlandoregon.gov
Transfer Size: varies
SPCS Zone Identifier: 5076
Contact(s)
Add
Jake Brown
503 823-5295
Jake.Brown@portlandoregon.gov
1900 SW 4th Ave, Suite 5000
Portland, OR 97201

City of Portland - BDS
503-823-7300
503-823-6868
BDS@portlandoregon.gov
File(s)
Add
Lineage
Add

Web Services

Service Description Feature Access Layer
BDS_Permit_Dashboard BDS Permit Dashboard contains AMANDA folder and process data that is updated nightly Dynamic Construction Project Status
BDS_Permit_Dashboard BDS Permit Dashboard contains AMANDA folder and process data that is updated nightly Dynamic Constuction Approved to Issue Days
Add

Attribute Tables & Domains

X
Table Description
Table Jurisdiction
Column Sort Column Name Column Alias Column Type Column Size Domain Value(s) Column Description
Add
1 Shape Shape Geometry 8
Add
X
map point in web mercator aux sphere
2 folder_rsn Folder RSN Integer 4
Add
X
folder record sequence number from AMANDA.   Also known as IVR number
3 property_rsn Property RSN Integer 4
Add
X
property record sequence number from AMANDA
4 eplans_project_id ePlans Project ID Integer 4
Add
X
5 intake_folder_rsn Intake Folder RSN Integer 4
Add
X
6 intake_folder_status Intake Folder Status String 255
Add
X
7 dev_hub_status Dev HUB Status String 255
Add
X
8 folder_name Folder Name String 255
Add
X
folder name; combines folder type, sequence, section revision and year
9 folder_type Folder Type String 40
Add
X
2 character abbreviation for type of permit
10 folder_number Folder Number String 25
Add
X
11 folder_section Folder Section String 3
Add
X
12 folder_revision Folder Revision String 3
Add
X
13 status Status String 40
Add
X
14 description Description String 4000
Add
X
15 work_type Work Type String 100
Add
X
16 sub_type Sub Type String 100
Add
X
17 reference_file Reference File String 255
Add
X
18 in_date In Date Date 8
Add
X
19 intake_complete_date Intake Complete Date Date 8
Add
X
20 approved_to_issue_date Approved to Issued Date Date 8
Add
X
21 issued_date Issued Date Date 8
Add
X
22 under_inspection_date Under Inspection Date Date 8
Add
X
23 finaled_date Finaled Date Date 8
Add
X
no updates made after permit reaches finaled date
23 final_date Final Date Date 8
Add
X
24 expiry_date Expiry Date Date 8
Add
X
25 property_address Property Address String 60
Add
X
26 property_r_number Property R Number String 9
Add
X
also called property_id.  This is set by the county
27 property_alt_r_number Property Alternate R Number String 15
Add
X
28 property_state_id Property State ID String 40
Add
X
Primary Property State ID
29 property_city Property City String 40
Add
X
30 property_county Property County String 40
Add
X
31 property_neighborhood Property Neighborhood String 255
Add
X
32 property_neighborhood_police Property Neighborhood (Police) String 255
Add
X
No neighborhood overlap
33 property_neighborhood_coalition Property Neighborhood Coalition String 255
Add
X
34 property_business_association Property Business Association String 255
Add
X
35 building_submitted_valuation Building Submitted Valuation Integer 4
Add
X
36 building_final_valuation Building Final Valuation Integer 4
Add
X
37 building_new_unit_count Building New Unit Count Integer 4
Add
X
38 building_removed_unit_count Building Removed Unit Count Integer 4
Add
X
39 building_net_unit_count Building Net Unit Count Integer 4
Add
X
40 building_story_count Building Story Count Integer 4
Add
X
41 timeline_exception_reason Timeline Exception Reason String 50
Add
X
42 review_type Review Type String 40
Add
X
Over the Counter or Standard Review 
43 mando_first_rev_overdue_status Mandatory First Review Overdue String 255
Add
X
44 mandatory_first_review_complete Mandatory First Review Complete String 40
Add
X
45 process_first_review_avg_days Process First Review Average Days Integer 4
Add
X
46 create_year Create Year String 4
Add
X
folder create year
47 create_year_month Create Year Month String 30
Add
X
format for sorting:  year-month number-month text
48 intake_complete_year Intake Complete Year String 4
Add
X
49 intake_complete_year_month Intake Complete Year Month String 30
Add
X
format for sorting:  year-month number-month text
50 intake_within_one_year Intake Within One Year String 5
Add
X
intake complete date +365 days - today
51 approved_to_issue_days Approved to Issue Days Integer 4
Add
X
elapsed days from intake complete to approved to issue
52 approved_to_issue_days_class Approved to Issue Days Class String 20
Add
X
elapsed days from intake complete to approved to issue broken into 4 classes<br><ul><li>Under Review</li><li>0-20 days</li><li>21-45 days</li><li>46+ days</li></ul>
53 tot_city_busy_to_ati_days Total Days City Processed Permit Integer 4
Add
X
waiting days calculated by corrections received date - corrections processed
54 tot_cust_busy_to_ati_days Total Days Customer Processed Permit Integer 4
Add
X
waiting days calculated by window open date (first review complete) - corrections received
55 corrections_received_count Corrections Received Count Integer 4
Add
X
number of corrections received processes that are associated with folder
56 reviewer_overdue_status Reviewer Overdue Status String 255
Add
X
if any of the reviewer groups have taken longer than 5 days to review corrections received
57 review_window_status Review Window Status String 255
Add
X
58 review_window_publish_text Review Window Publish Text String 255
Add
X
59 under_inspection_days Under Inspection Days Integer 4
Add
X
60 inspection_site_visit_count Inspection Site Visit Count Integer 4
Add
X
61 inspection_window_publish_text Inspection Window Publish Text String 255
Add
X
62 building_occupancy_group_1 Building Occupancy Group 1 String 255
Add
X
manually input in folder info&nbsp;
63 building_construction_type_1 Building Construction Type 1 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
64 building_total_sq_ft_1 Building Total Sq Ft 1 Integer 4
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
65 building_occupancy_group_2 Building Occupancy Group 2 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
66 building_construction_type_2 Building Construction Type 2 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
67 building_total_sq_ft_2 Building Total Sq Ft 2 Integer 4
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
68 building_occupancy_group_3 Building Occupancy Group 3 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
69 building_construction_type_3 Building Construction Type 3 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
70 building_total_sq_ft_3 Building Total Sq Ft 3 Integer 4
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
71 building_occupancy_group_4 Building Occupancy Group 4 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
72 building_construction_type_4 Building Construction Type 4 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
73 building_total_sq_ft_4 Building Total Sq Ft 4 Integer 4
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
74 aff_housing_unit_count Affordable Housing Unit Count Integer 4
Add
X
10/1/2020 this data is not currently available - we are hoping to add it
75 aff_housing_exempt_type_1 Affordable Housing Exempt Type 1 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
76 aff_housing_exempt_sqft_1 Affordable Housing Exempt Sq Ft 1 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
77 aff_housing_exempt_type_2 Affordable Housing Exempt Type 2 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
78 aff_housing_exempt_sqft_2 Affordable Housing Exempt Sq Ft 2 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
79 aff_housing_exempt_type_3 Affordable Housing Exempt Type 3 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
80 aff_housing_exempt_sqft_3 Affordable Housing Exempt Sq Ft 3 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
81 aff_housing_exempt_type_4 Affordable Housing Exempt Type 4 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
82 aff_housing_exempt_sqft_4 Affordable Housing Exempt Sq Ft 4 String 255
Add
X
manually input&nbsp;in&nbsp;folder info&nbsp;
83 gis_map_label GIS Map Label String 50
Add
X
text used for map labeling
84 gis_symbol_class GIS Symbol Class String 50
Add
X
drives map symbology in the BDS dashboard
85 gis_process_date GIS Process Date Date 8
Add
X
last update date by GIS
86 gis_portland_maps_url PortlandMaps URL String 100
Add
X
link to folder details in PortlandMaps
86 gis_process_status GIS Process Status String 100
Add
X
87 portland_maps_url PortlandMaps URL String 100
Add
X
88 eplans_url ePlans URL String 255
Add
X
89 efiles_url eFiles URL String 255
Add
X
90 report_date Report Date Date 8
Add
X
91 report_url Report URL String 255
Add
X