Description: Mecklenburg County creates and maintains the Master Address Table. The County provides a text file of the data each evening. This source data is processed within a City-managed ETL process that maps the data into destination fields within MasterAddress_pt. The field names within this table and the analogous fields names within the County's source data are listed below. The ETL process has several geoenrichment steps which update multiple fields using SQL Spatial statements. These statements are listed below.Field NameCounty Source Data Field NameNUM_STREETADDRNUMTXT_STSUFFADDRNUMSUFNUM_ST_CODECOUNTYSTCODEDTE_ADDTEMcreated_dateID_ADD_BYcreated_userDTE_UPDTEMlast_edited_dateID_UPD_BYlast_edited_userTXT_LOTLOTNOCDE_USEMECKUSETXT_CDEUSEMECKUSE_DESCCDE_JURISMUNICIPALITY_CODETXT_JURISMUNICIPALITY_DESCNME_PO_CITYPLACENAMETXT_STDIRPREADDRNUMNUM_ADDRSITEADDIDTXT_STYPE4STANDTYPECDE_STATUSSTATUS_CODETXT_STNAMESTREETNAMETXT_STYPE2STREETTYPENUM_SUBDIVSUBDIVISIONID_PARCELTAXPIDTXT_UNITUNITIDNUM_XCOORDXCOORDNUM_YCOORDYCOORDCDE_ZIP1ZIPCODEDeprecated fields that are no longer updated:ID_GISKEYTXT_MODELID_NCPININD_FOOTPTIND_OCCUPIND_GIS_OVIND_PUBLICNUM_LINKNUM_UNITSTXT_BLOCKCDE_ZIP2The following SQL Spatial statements are used to populate the corresponding fields:--Basin updateupdate MASTERADDRESS_LD SET BASIN = ISNULL(D.NAME,'') FROM MASTERADDRESS_LD M JOIN DRAINAGESPECIALISTS_PY D ON M.Shape.STIntersects(D.Shape)=1 --Police Division updateupdate MASTERADDRESS_LD SET POLICE_DIVISION = ISNULL(D.DIVISION,'') FROM MASTERADDRESS_LD M JOIN POLICEDIVISIONS_PY D ON M.Shape.STIntersects(D.Shape)=1 --FIPS updateupdate MASTERADDRESS_LD SET FIPS = ISNULL(D.GEOID10,'') FROMMASTERADDRESS_LD M JOIN CENSUSTRACTS2010_PY D ON M.Shape.STIntersects(D.Shape)=1 --Council District updateupdate MASTERADDRESS_LD SET COUNCIL_DISTRICT = ISNULL(D.DISTRICT,0) FROM MASTERADDRESS_LD M JOIN COUNCILDISTRICTs_PY D ON M.Shape.STIntersects(D.Shape)=1--NPA (listed as NSA) updateupdate MASTERADDRESS_LD SET NSA = ISNULL(D.ID,0) FROM MASTERADDRESS_LD M JOIN NPA_py D ON M.Shape.STIntersects(D.Shape)=1--Sphere Name updateupdate MASTERADDRESS_LD SET SPHERE_NAME = D.NAME FROMMASTERADDRESS_LD M JOIN SPHEREOFINFLUENCE2016_PY D ON M.Shape.STIntersects(D.Shape)=1--Wrecker Zone updateupdate MASTERADDRESS_LD SET WRECKER_ZONE = ISNULL(D.DIVISION,0) FROMMASTERADDRESS_LD M JOIN WRECKERZONES_PY D ON M.Shape.STIntersects(D.Shape)=1 --E911 updateUPDATE MASTERADDRESS_LDSET E911=ISNULL(R.E911,0)FROM MASTERADDRESS_LD M INNER JOIN (SELECT DISTINCT [NAME], NME_JURIS FROM JURISDICTIONS2016_py) J ON M.TXT_JURIS=J.NAMEINNER JOIN ROAD_ln R ON UPPER(R.WHOLESTNAME) = UPPER(CASE WHEN M.TXT_STDIR'' THEN M.TXT_STDIR+' ' ELSE '' END + M.TXT_STNAME + CASE WHEN M.TXT_STYPE2'' THEN ' ' + M.TXT_STYPE2 ELSE '' END + CASE WHEN M.TXT_STSUFF'' THEN ' ' + M.TXT_STSUFF ELSE '' END ) WHERE ((M.NUM_STREET BETWEEN R.LL_ADD AND R.UL_ADD) OR (M.NUM_STREET BETWEEN R.LR_ADD AND R.UR_ADD))AND (J.NME_JURIS=R.L_JURIS OR J.NME_JURIS=R.R_JURIS) --FULL ADDRESS updateUPDATE DBO.MASTERADDRESS_LDSET FULL_ADDRESS =(case when ([NUM_STREET] is null) then '' else (convert(varchar(20),[NUM_STREET]) + ' ') end + case when ([TXT_STDIR] = '') then '' else ([TXT_STDIR] + ' ') end + [TXT_STNAME] + case when ([TXT_STYPE2] = '') then '' else (' ' + [TXT_STYPE2]) end+ case when ([TXT_STSUFF] = '') then '' else (' ' + [TXT_STSUFF]) end + case when ([TXT_UNIT] = '') then '' else (' #' + [TXT_UNIT]) end ) WHERE ISNULL(FULL_ADDRESS,'') (case when ([NUM_STREET] is null) then '' else (convert(varchar(20),[NUM_STREET]) + ' ') end + case when ([TXT_STDIR] = '') then '' else ([TXT_STDIR] + ' ') end+ [TXT_STNAME] + case when ([TXT_STYPE2] = '') then '' else (' ' + [TXT_STYPE2]) end + case when ([TXT_STSUFF] = '') then '' else (' ' + [TXT_STSUFF]) end + case when ([TXT_UNIT] = '') then '' else (' #' + [TXT_UNIT]) end ) --TAX_PID AND GIS_PID updateUPDATE DBO.MasterAddress_LD SET TAX_PID = null, GIS_PID = null; UPDATE DBO.MasterAddress_LD SET TAX_PID = T.id_pid FROM MasterAddress_LD M inner join CAMAParcelInfo_tb T on M.ID_PARCEL = T.id_Pid; update MasterAddress_LD set GIS_PID = T.id_common_pid FROM MasterAddress_LD M inner join CAMAParcelInfo_tb T on M.ID_PARCEL = T.id_Common_Pid WHERE GIS_PID is null;update MasterAddress_LD set GIS_PID = P.PID FROM MasterAddress_LD Minner join Parcel_py P on M.SHAPE.STIntersects(P.SHAPE)=1;
Description: The "Centers and Corridors" development framework was originally introduced in 1994 and is the City of Charlotte's adopted policy for organizing and guiding growth and development within the City of Charlotte. The framework was updated and adopted by the Charlotte City Council in August 2010. The updated framework broadens the original transportation oriented focus to include other aspects of planning and development, such as public facility needs and environmental concerns. The update also provides more specific definitions and guidance for Centers and Corridors and expands the concept to provide recommendations for Wedges, as well.
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Description: This data layer corresponds with the Commercial Zoning division of Land Development and the areas their reviewers manage. These reviewers are responsible for the review and inspection of commercial development sites in their areas.
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: baseline Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 8 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Description: Five of Charlotte's most significant older neighborhoods have been designated by City Council as Local Historic Districts, in recognition of their importance in the history and character of the city. The Historic District Commission and its staff work with property owners and businesses in the districts to assure that development and renovation occurs in a manner that is consistent with the character of the neighborhood.
Copyright Text: Data is collected and maintained by The Charlotte Mecklenburg Planning Department.
Description: PCSO Watershed Districts are the areas of land that drain all the streams and rainfall to a common outlet along a stream channel. PCSO Watershed Districts layer is based on the USGS River Basin for Mecklenburg County, with the addition of Six Mile Creek. Six Mile Creek has distinct requirements according to the Sec 18-142 Watershed Districts of the Post Construction Stormwater Ordinance of the City of Charlotte.Sec. 18-142. Watershed districts. Standards for development and redevelopment vary depending on the watershed district in which a project is located as described in the "Post-Construction Ordinance Map of the City," which is adopted simultaneously herewith as described in subsection 18-105(d). The city is divided into the following watershed districts for purposes of this article: (1) Central Catawba. That area of land that drains to Sugar, Little Sugar and McAlpine Creeks in the city, including all tributaries, except Six Mile Creek. (2) Western Catawba. That area of land that drains to Lake Norman, Mountain Island Lake and Lake Wylie in Mecklenburg County including all creeks and tributaries. (3) Yadkin-Southeast Catawba. That area of land that drains to the Yadkin River basin in Mecklenburg County, including all creeks and tributaries and in addition including Six Mile Creek.Six Mile Creek watershed only. In addition to the above information for streams in the Yadkin-Southeast Basin Watershed, all perennial streams in the Six Mile Creek Watershed shall have undisturbed buffers, plus entire floodplain and all intermittent streams in the Six Mile Creek Watershed shall have undisturbed buffers all measured on each side of the stream from top of bank.For these reasons the Six Mile Creek basin is defined separately from the Yadkin-Southeast Catawba.
Color: [197, 0, 255, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 14 Font Family: Arial Font Style: normal Font Weight: normal Font Decoration: none
Description: The purpose of the Watershed Overlay Districts are to provide for the protection of public water supplies as required by the N.C. Water Supply Watershed Classification and Protection Act (G.S. 143-214.5) and regulations promulgated thereunder.
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Description: This is a dataset representing the Urban Forestry Inspector areas, and the inspectors assigned to each of these areas. The data is used to identify which inspectors are responsible for projections in a certain area of the city.
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Color: [0, 0, 0, 255] Background Color: N/A Outline Color: N/A Vertical Alignment: bottom Horizontal Alignment: left Right to Left: false Angle: 0 XOffset: 0 YOffset: 0 Size: 10 Font Family: Tahoma Font Style: normal Font Weight: normal Font Decoration: none
Description: This data layer is the taxbook assignment for Code Enforcement Inspector in each nuisance and zoning, and it also lists designated Service Center and Service Area.