Attributes to be imported

	A	B	C	D	E	F
1	Attributes to be imported	Updated 8.25.2015
2	Attribute	OSM Equivalent	Dataset Used	Description	Add/Ignore?	Notes

3
4	Building Attributes
5	CODE				Ignore	Note: only CODE='Building' is used for this import. We ignore CODE='Courtyard'. This filtering step happens in the Makefile
6	BLD_ID	lacounty:bld_id	Building Outlines	Unique Building ID	Add	Special OSM Tag
7	HEIGHT	height	Building Outlines	The height of the highest major feature of the building (not including roof objects like antennas and chimneys)	Add	map to tag, only if height >0
8	ELEV	elevation	Building Outlines	The elevation of the building	Add	map to elevation, only if elevation > 0
9	AREA		Building Outlines	Roof Area	Ignore	Mostly null
10	SOURCE		Building Outlines	The data source (either LARIAC2, Pasadena, Palmdale, or Glendale)	Ignore
11	AIN		Building Outlines	The parcel ID number	Ignore	Used to map stray addresses to buildings and link datasets
12	Shape_Leng		Building Outlines		Ignore
13	Shape_Area	area	Building Outlines		Ignore
14	GeneralUseType	building	Assessor 2015	General use type of the property	Add
15	SpecificUseType	building:use	Assessor 2015	More specific use type of the property	Add
16	YearBuilt	start_date	Assessor 2015	Year property was originally built	Add
17	EffectiveYearBuilt		Assessor 2015	Effective year built taking into account subsequent construction, remodeling, building maintenance, etc.		what is this?
18	SpecificUseDetail1	amenity	Assessor 2015	More specific use type of the property	Add
19	SpecificUseDetail2		Assessor 2015	Additional property usage detail
20	SQFTmain		Assessor 2015	Total square footage of the main structure(s),	Ignore
21	Bedrooms		Assessor 2015	Total number of bedrooms.
22	Bathrooms		Assessor 2015	Total number of bathrooms.
23	Units	building:units	Assessor 2015	Total number of living units.	Add
24
25	Address Attributes
26	AIN		LA County Address Points	Parcel this address falls inside	Ignore
27	Numprefix	addr:housenumber	LA County Address Points	Number prefix	Add	These are extremely rare (only 33 of them), mainly showing up for addresses in Lakewood Center Mall, Lakewood CA. Handling these would require treating `addr:housenumber` as a string, not an integer. However, the OSM wiki says this is permitted.
28	Number	addr:housenumber	LA County Address Points	House Number	Add
29	NumSuffix	addr:housenumber	LA County Address Points	House Number Suffix (1/2, 3/4 etc)	Add
30	PreMod	addr:street	LA County Address Points	Prefix Modifier	Add	Examples: OLD RANCH ROAD, LOWER ASUZA ROAD
31	PreDir	addr:street	LA County Address Points	Prefix Direction (E, S, W, N)	Add	Examples: SOUTH RANCH ROAD
32	PreType	addr:street	LA County Address Points	Prefix Type (Ave, Avenida, etc)	Add	Examples: NORTH VIA SORRENTO, RUE DE LA PIERRE
33	STArticle	addr:street	LA County Address Points	Street Article (de la, les, etc)	Add	Examples: RUE DE LA PIERRE. Change to titlecase
34	StreetName	addr:street	LA County Address Points	Street Name	Add	Change to titlecase (but full lowercase on numeral suffixes "st", "nd", "rd", "th")
35	PostType	addr:street	LA County Address Points	Post Type (Ave, St, Dr, Blvd, etc)	Add	Change to titlecase
36	PostDir	addr:street	LA County Address Points	Post Direction (N, S, E, W)	Add	Examples: MARINA DRIVE SOUTH. Note: the data is already expanded into "NORTH", "SOUTH", etc. We do not condense into "N", "S". Change to Titlecase
37	PostMod	addr:street	LA County Address Points	Post Modifier (OLD, etc)	Add	Note: this is always null in the current data. Treat like PreMod for consistency. Change to titlecase
38	UnitType		LA County Address Points	Unit Type (#, Apt, etc) - where these are known		Ignore???
39	UnitName	addr:unit	LA County Address Points	Unit Name (A, 1, 100, etc)	Add
40	Zipcode	addr:postcode	LA County Address Points	Zipcode	Add
41	Zip4		LA County Address Points	Not currently filled out	Ignore
42	LegalComm	is_in:city	LA County Address Points	Legal City or primary postal city in Unincorporated Areas	Add	Fall back to this if `PCITY1` is null. Potentially could map this to `is_in:city`, but given that OSM already has good city boundaries this seems unnecessary.
43	PostComm1	addr:city	LA County Address Points	Primary Postal Community	Ignore
44	PostComm2		LA County Address Points	Secondary Postal Community	Ignore
45	PostComm3		LA County Address Points	Third Postal Community	Ignore
46	Source		LA County Address Points	source of the address point, one of: Assessor, LACity, Regional Planning, other	Ignore	this generally corresponds to whichever city the address falls within
47	SourceID		LA County Address Points	ID of the Address in the source system	Ignore
48	MADrank		LA County Address Points	Method Accuracy Description (MAD) provides a number between 1 and 100 detailing the accuracy of the location.	Ignore
49	PCITY1	addr:city		1st postal city (from the USPS)	add	this is null for 1469 records. When null, fall back to `LegalComm`. Change to titlecase
50	PCITY2			2nd postal city (from the USPS)	ignore	mostly null or same as LegalComm. Always null when `PCITY1` is null.
51	PCITY3			3rd postal city (from the USPS)	ignore	mostly null. Always null when `PCITY1` is null.
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100