{
 "culture": "en-US",
 "name": "",
 "guid": "",
 "catalogPath": "",
 "snippet": "",
 "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;",
 "summary": "",
 "title": "Master Address Points",
 "tags": [],
 "type": "",
 "typeKeywords": [],
 "thumbnail": "",
 "url": "",
 "minScale": "NaN",
 "maxScale": "NaN",
 "spatialReference": "",
 "accessInformation": "",
 "licenseInfo": "",
 "portalUrl": ""
}