| description:
|
This is a polygon feature class maintained by the City of Sunrise that identifies the areas within Sunrise, Florida that are elidible for alcohol sales. The process for creating the feature is as follows:Step 1: Create a new map containing:City of Sunrise Zoning DistrictsParcel PolygonsParksReligious InstitutionsSchoolsSunrise City LimitsWestern Sunrise Entertainment District Step 2: Create Buffers:Create separate 600 feet buffers around the schools, parks and religious institutions. Remove any portion of the religious institution buffer that is NOT in the Western Sunrise Entertainment District. In the case for Sunrise, there are no religious institutions within 600’ of the Western Sunrise Entertainment District therefore, these features were removed. Step 3: Merge Buffers:Merge the individual buffer layers into a single layer: Step 4: Filter Zoning Districts:Create a new layer containing only the Zoning Districts that are approved for alcohol sales:B-2B-3B-3AB-4B-5B-6PDDI-1The Select by Attributes code is:ZONECODE = 'B-2' OR ZONECODE = 'B-3' OR ZONECODE = 'B-3A' OR ZONECODE = 'B-4' OR ZONECODE = 'B-5' OR ZONECODE = 'B-6' OR ZONECODE = 'PDD' OR ZONECODE = 'I-1' Step 5: Union Zoning, 600’ Buffer and City Limits:Perform a Union on the zoning, 600’ buffer and City Limits layer to remove any portion of the zoning districts that overlap with the schools, parks, and religious institutions 600’ buffer. Step 6: Filter non-alcohol-sales-approved areas from the unioned layer:Select and remove all records without a zoning district, or without a city name or with BufferDist = 600. Step 7: Dissolve features to create a single record of Alcohol Sales Permitted Areas:Perform a dissolve of the new layer based on an attribute that is common to all remaining features (e.g. City Name). The resulting layer will have a single record in its attribute table. Add a new field to the attribute table “Alcohol_Sales_Permitted” (Text, length 5) and calculate the single record to be “True”.Step 8: Perform a Union Between Alcohol Permitted Areas and Sunrise City Limits:Perform a Union between the filtered zoning layer from the previous step and the City Limits to create the final layer “AlcoholSalesPermittedAreas”: The resulting layer will have the Alcohol Sales Permitted areas already set to “True” in the attribute table. The other record in the new layer will be the areas within the city limits that do NOT allow alcohol sales so set the attribute value to false. Remove any extra fields that were added as part of the union operations. Calculate the geometry for the Area and Acreage. |