{ "currentVersion": 10.91, "id": 15, "name": "Road Name Alias Table", "type": "Table", "description": "This latest version of the statewide Street Name Alias table was created to support New Jersey's future Next Generation 9-1-1 system, along with the current needs of Public Safety Answering Points (PSAP) using New Jersey's current Enhanced 9-1-1 (E9-1-1) system. It also will be used to help support the NJ Department of Transportaton, local goverment assest management needs, and statewide geocoding. \n\nThe previous New Jersey statewide road segment data (Tran_road_centerline_NJ), which included the road name alias information, has been transformed into the NENA data model to create the street name alias table.\n\nThe table can be joined to the road centerlines on field RCL_NGUID.", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AST_PNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "DISCRPAGID", "type": "esriFieldTypeString", "alias": "Discrepancy Agency ID", "length": 75, "domain": null }, { "name": "SOURCE", "type": "esriFieldTypeString", "alias": "Source", "length": 75, "domain": null }, { "name": "DATEUPDATE", "type": "esriFieldTypeDate", "alias": "Date Update", "length": 8, "domain": null }, { "name": "EDITOR", "type": "esriFieldTypeString", "alias": "Editor", "length": 50, "domain": null }, { "name": "EFFECTIVE", "type": "esriFieldTypeDate", "alias": "Effective Date", "length": 8, "domain": null }, { "name": "EXPIRE", "type": "esriFieldTypeDate", "alias": "Expiration Date", "length": 8, "domain": null }, { "name": "AST_NGUID", "type": "esriFieldTypeString", "alias": "Alias Street Name NENA Globally Unique\nID", "length": 254, "domain": null }, { "name": "RCL_NGUID", "type": "esriFieldTypeString", "alias": "Road Centerline NENA Globally Unique ID", "length": 254, "domain": null }, { "name": "ANAME_TYP", "type": "esriFieldTypeString", "alias": "Alias Name Type", "length": 1, "domain": null }, { "name": "ANAME_RANK", "type": "esriFieldTypeInteger", "alias": "Alias Name Rank", "domain": null }, { "name": "AST_PREMOD", "type": "esriFieldTypeString", "alias": "Alias Street Name Pre Modifier", "length": 15, "domain": null }, { "name": "AST_PREDIR", "type": "esriFieldTypeString", "alias": "Alias Street Name Pre Directional", "length": 9, "domain": null }, { "name": "AST_PRETYP", "type": "esriFieldTypeString", "alias": "Alias Street Name Pre Type", "length": 25, "domain": null }, { "name": "AST_PRESEP", "type": "esriFieldTypeString", "alias": "Alias Street Name Pre Type Separator", "length": 20, "domain": null }, { "name": "AST_NAME", "type": "esriFieldTypeString", "alias": "Alias Street Name", "length": 60, "domain": null }, { "name": "AST_POSTYP", "type": "esriFieldTypeString", "alias": "Alias Street Name Post Type", "length": 25, "domain": null }, { "name": "AST_POSDIR", "type": "esriFieldTypeString", "alias": "Alias Street Name Post Directional", "length": 9, "domain": null }, { "name": "AST_POSMOD", "type": "esriFieldTypeString", "alias": "Alias Street Name Post Modifier", "length": 25, "domain": null }, { "name": "AST_PNAME", "type": "esriFieldTypeString", "alias": "Alias Street Prime Name", "length": 245, "domain": null }, { "name": "SHLD_TYPE", "type": "esriFieldTypeString", "alias": "Highway Shield Type", "length": 3, "domain": null }, { "name": "SHLDSUBTYP", "type": "esriFieldTypeString", "alias": "Highway Shield Sub-Type", "length": 1, "domain": null }, { "name": "SHLD_NUM", "type": "esriFieldTypeString", "alias": "Shield Number", "length": 5, "domain": null }, { "name": "ALSTPREDIR", "type": "esriFieldTypeString", "alias": "Alias Legacy Street Name Pre Directional", "length": 2, "domain": null }, { "name": "ALSTNAME", "type": "esriFieldTypeString", "alias": "Alias Legacy Street Name", "length": 75, "domain": null }, { "name": "ALSTTYPE", "type": "esriFieldTypeString", "alias": "Alias Legacy Street Name Type", "length": 5, "domain": null }, { "name": "ALSTPOSDIR", "type": "esriFieldTypeString", "alias": "Alias Legacy Street Name Post Directional", "length": 2, "domain": null }, { "name": "ALST_PNAME", "type": "esriFieldTypeString", "alias": "Alias Legacy Street Prime Name", "length": 90, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_5_RCL_NGUID", "fields": "RCL_NGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Road Segment", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "RCL_NGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }