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 Add File File Description Cancel Add File
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

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