FrontageType-WaterfrontFeatures

	A	B	C	D	E	F	G	H	I	J	K	L
1	Current Field	LookupValue	# of Orgs	# of Systems	Data Availability Mean	Option 1	Option 2	Option 3	Option 4	Name Correction	Definition	Rob

2	WaterfrontFeatures	-	365	13	70.3%				Change field name to WaterfrontType?		-
3	WaterfrontFeatures	Bay	21	5	1.5%				New
4	WaterfrontFeatures	Bay Access	2	3	0.0%			Move to CommunityFeatures	Move to CommunityFeatures		This property has access to a bay.
5	WaterfrontFeatures	Bayfront	2	2	1.6%	Move to FrontageType		Move to FrontageType	Move to FrontageType		This property is on a bayfront.
6	WaterfrontFeatures	Beach Access	33	9	3.2%			Move to CommunityFeatures	Move to CommunityFeatures		The property has access to the beach.
7	WaterfrontFeatures	Beach Front	26	9	1.7%	Move to FrontageType		Move to FrontageType	Move to FrontageType (as Beachfront)	Beachfront	The property is on the beach front.
8	WaterfrontFeatures	Brook	4	2	0.7%				New
9	WaterfrontFeatures	Canal	16	5	1.2%				New
10	WaterfrontFeatures	Canal Access	27	10	1.9%			Move to CommunityFeatures	Move to CommunityFeatures		The property has access to the canal(s).
11	WaterfrontFeatures	Canal Front	36	11	4.0%	Move to FrontageType		Move to FrontageType	Move to FrontageType		The property is located on the canal.
12	WaterfrontFeatures	Cove	9	5	5.6%				New
13	WaterfrontFeatures	Creek	137	11	2.3%						The property is either on or near a creek.	We should also consider LotFeatures, so we have complete "On lot" options?
14	WaterfrontFeatures	Harbor	17	4	0.5%				New
15	WaterfrontFeatures	Lagoon	30	8	0.4%	Deprecate		Deprecate			The property is either on or near a lagoon.	Keep, but we need front and access like the others.
16	WaterfrontFeatures	Lake	127	11	2.7%				New
17	WaterfrontFeatures	Lake Front	130	11	2.5%	Deprecate		Deprecate	Deprecate (avail. under FrontageType)	Lakefront	The property is on the lake front.
18	WaterfrontFeatures	Lake Privileges	59	10	2.6%			Move to CommunityFeatures	Move to CommunityFeatures		The property includes rights to access the lake.
19	WaterfrontFeatures	Marina in Community	-	-	-			Move to CommunityFeatures	Move to CommunityFeatures		This property has a marina in the community. This doesn't insinuate a marina on the property or rights to the marina.
20	WaterfrontFeatures	Navigable Water	31	9	0.6%						The water wide, slow and deep enough for water vessels.
21	WaterfrontFeatures	Ocean	6	2	2.9%				New
22	WaterfrontFeatures	Ocean Access	18	6	4.6%			Move to CommunityFeatures	Move to CommunityFeatures		The property has access to the ocean.
23	WaterfrontFeatures	Ocean Front	38	9	2.4%	Deprecate		Deprecate	Deprecate (avail. under FrontageType)	Oceanfront	The property is on the ocean front.
24	WaterfrontFeatures	Pond	194	10	2.3%	Move to FrontageType					The property is on or near a pond.
25	WaterfrontFeatures	River	60	6	1.4%				New
26	WaterfrontFeatures	River Access	66	11	1.0%			Move to CommunityFeatures	Move to CommunityFeatures		The property has access to the river.
27	WaterfrontFeatures	River Front	127	12	1.3%	Move to FrontageType		Move to FrontageType	Move to FrontageType (as Riverfront)	Riverfront	The property is located on the river front.
28	WaterfrontFeatures	Seawall	40	9	2.9%						The property is protected by a sea wall or barrier.
29	WaterfrontFeatures	Stream	105	10	1.6%						The property is on our near a stream.
30	WaterfrontFeatures	Waterfront	145	11	3.6%			Deprecate	Deprecate (avail. under FrontageType)		The property is located on the waterfront.
31
32	FrontageType	-	218	10	64.1%						-
33	FrontageType	Bay/Harbor	11	6	1.0%				Change to Harbor Front (Bayfront exists)		The property fronts to a bay or harbor.
34	FrontageType	Golf Course	66	8	1.46%						The property fronts to a golf course.
35	FrontageType	Lagoon/Estuary	5	4	0.1%		Deprecate		Split into individual/rename? (Lagoon Front and Estuary Front)		The property fronts to a lagoon or estuary.
36	FrontageType	Lakefront	22	6	2.43%		Deprecate				The property is on a lakefront.
37	FrontageType	Oceanfront	13	5	1.45%		Deprecate				The property is on an oceanfront.
38	FrontageType	Other	15	6	4.78%						The frontage of the property is something other than the options in this list.
39	FrontageType	River	24	6	1.3%	Deprecate		Deprecate	Deprecate		The property is on a riverfront.
40	FrontageType	See Remarks	8	5	0.88%						See the Public or Private Remarks for details on the frontage of the property.
41	FrontageType	Waterfront	29	7	2.4%						The property is on a waterfront.
42	Resulting Fields/Lookups
43	WaterfrontFeatures					Bay Access	Bay Access	Creek	Bay
44	WaterfrontFeatures					Beach Access	Bayfront	Navigable Water	Brook
45	WaterfrontFeatures					Canal Access	Beach Access	Pond	Canal
46	WaterfrontFeatures					Creek	Beach Front	Seawall	Cove
47	WaterfrontFeatures					Lake Privileges	Canal Access	Stream	Creek
48	WaterfrontFeatures					Marina in Community	Canal Front		Harbor
49	WaterfrontFeatures					Navigable Water	Creek		Lagoon
50	WaterfrontFeatures					Ocean Access	Lagoon		Lake
51	WaterfrontFeatures					River Access	Lake Front		Navigable Water
52	WaterfrontFeatures					Seawall	Lake Privileges		Ocean
53	WaterfrontFeatures					Stream	Marina in Community		Pond
54	WaterfrontFeatures					Waterfront	Navigable Water		River
55	WaterfrontFeatures						Ocean Access		Seawall
56	WaterfrontFeatures						Ocean Front		Stream
57							Pond
58							River Access
59							River Front
60							Seawall
61							Stream
62							Waterfront
63
64	FrontageType					Bayfront	Bay/Harbor	Bayfront	Bayfront
65	FrontageType					Bay/Harbor	Golf Course	Beach Front	Beach Front
66	FrontageType					Beach Front	Other	Canal Front	Canal Front
67	FrontageType					Canal Front	River	Bay/Harbor	Estuary Front
68	FrontageType					Golf Course	See Remarks	Golf Course	Golf Course
69	FrontageType					Lagoon/Estuary	Waterfront	Lagoon/Estuary	Harbor Front
70	FrontageType					Lakefront		Lakefront	Lagoon Front
71	FrontageType					Oceanfront		Oceanfront	Lakefront
72	FrontageType					Other		Other	Oceanfront
73	FrontageType					Pond		River Front	Other
74	FrontageType					River Front		See Remarks	Riverfront
75	FrontageType					See Remarks		Waterfront	See Remarks
76	FrontageType					Waterfront			Waterfront
77
78	CommunityFeatures							Airport/Runway	Airport/Runway
79	CommunityFeatures							Bay Access	Bay Access
80	CommunityFeatures							Beach Access	Beach Access
81	CommunityFeatures							Canal Access	Canal Access
82	CommunityFeatures							Clubhouse	Clubhouse
83	CommunityFeatures							Curbs	Curbs
84	CommunityFeatures							Fishing	Fishing
85	CommunityFeatures							Fitness Center	Fitness Center
86	CommunityFeatures							Gated	Gated
87	CommunityFeatures							Golf	Golf
88	CommunityFeatures							Lake	Lake
89	CommunityFeatures							Lake Privileges	Lake Privileges
90	CommunityFeatures							Marina in Community	Marina in Community
91	CommunityFeatures							None	None
92	CommunityFeatures							Ocean Access	Ocean Access
93	CommunityFeatures							Other	Other
94	CommunityFeatures							Park	Park
95	CommunityFeatures							Playground	Playground
96	CommunityFeatures							Pool	Pool
97	CommunityFeatures							Racquetball	Racquetball
98	CommunityFeatures							Restaurant	Restaurant
99	CommunityFeatures							River Access	River Access
100	CommunityFeatures							Sidewalks	Sidewalks