{"id":18031,"date":"2024-07-11T06:00:00","date_gmt":"2024-07-10T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=18031"},"modified":"2024-07-11T21:25:38","modified_gmt":"2024-07-11T12:25:38","slug":"%e3%82%aa%e3%83%bc%e3%82%b9%e3%83%88%e3%83%a9%e3%83%aa%e3%82%a2%e3%81%ae%e3%82%b8%e3%82%aa%e3%82%b3%e3%83%bc%e3%83%87%e3%82%a3%e3%83%b3%e3%82%b0","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=18031","title":{"rendered":"\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u306e\u30b8\u30aa\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0"},"content":{"rendered":"\n

\u3000\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u3067\u306e\u4f4f\u6240\u304b\u3089\u306e\u30b8\u30aa\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306fGeoscape\u793e\u304c\u62c5\u5f53\u3057\u3066\u304a\u308a\uff0c\u305d\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3092G-NAF\u3068\u3044\u3046\uff0e\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u653f\u5e9c\u304b\u3089\u88dc\u52a9\u91d1\u3092\u53d7\u3051\u3066\u304a\u308a\uff0c2029\u5e74\u307e\u3067\u7121\u6599\u516c\u958b\u3055\u308c\u308b\u3053\u3068\u304c\u6c7a\u307e\u3063\u3066\u3044\u308b\uff0e<\/p>\n

\u3000\u30c7\u30fc\u30bf\u6570\u306f1500\u4e07\u4ef6\u4ee5\u4e0a\uff0c\u7a7a\u9593\u53c2\u7167\u7cfb\u306fGDA94(EPSG: 4283)\u307e\u305f\u306fGDA2020(EPSG: 7844)\u3067\u3042\u308b\uff0e<\/p>\n

\u3000\u4eca\u56de\u306fSQL Server\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\uff0c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\uff0c\u30c6\u30fc\u30d6\u30eb\u3078\u306e\u4e3b\u30ad\u30fc\u3068\u5916\u90e8\u30ad\u30fc\u306e\u4f5c\u6210\u307e\u3067\u3092\u884c\u3046\uff0e<\/p>\n

<\/p>\n

\u30c7\u30fc\u30bf\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h2>\n

\u3000\u30c7\u30fc\u30bf\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3053<\/a>\u304b\u3089\u884c\u3046\uff0e2024\u5e747\u67087\u65e5\u73fe\u5728\uff0cMAY 24 – Geoscape G-NAF – GDA2020(ZIP)\u3068\u3044\u3046\u540d\u79f0\u306e\u30d5\u30a1\u30a4\u30eb\u304c\u6700\u65b0\u3067\u3042\u308b\uff0e\u30b5\u30a4\u30ba\u306f\u7d045GB\u3042\u308b\uff0ezip\u30d5\u30a1\u30a4\u30eb\u3092\u89e3\u51cd\u3059\u308b\u30687GB\u306b\u5897\u3048\u308b\uff0e<\/p>\n

\u30d5\u30a1\u30a4\u30eb\u306e\u6982\u89b3<\/h3>\n

\u3000\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306f\u5927\u307e\u304b\u306bExtras\u30d5\u30a9\u30eb\u30c0\u3068G-NAF MAY 2024\u30d5\u30a9\u30eb\u30c0\u306b\u5206\u3051\u3089\u308c\u308b\uff0eExtras\u30d5\u30a9\u30eb\u30c0\u306b\u306f\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210\u306e\u305f\u3081\u306esql\u30d5\u30a1\u30a4\u30eb\u3068\u4e3b\u30ad\u30fc\u30fb\u5916\u90e8\u30ad\u30fc\u4f5c\u6210\u306e\u305f\u3081\u306esql\u30d5\u30a1\u30a4\u30eb\uff0c\u3055\u3089\u306b\u30d3\u30e5\u30fc\u3092\u4f5c\u6210\u3059\u308b\u305f\u3081\u306esql\u30d5\u30a1\u30a4\u30eb\u304c\u7f6e\u304b\u308c\u3066\u3044\u308b\uff0eG-NAF MAY 2024\u30d5\u30a9\u30eb\u30c0\u306b\u306f\u30c6\u30fc\u30d6\u30eb\u306b\u683c\u7d0d\u3055\u308c\u308b\u30c7\u30fc\u30bf\u304c\u7f6e\u304b\u308c\u3066\u3044\u308b\uff0eG-NAF MAY 2024\u30d5\u30a1\u30eb\u30c0\u306f\u3055\u3089\u306bAuthority Code\u30d5\u30a9\u30eb\u30c0\u3068Standard\u30d5\u30a9\u30eb\u30c0\u306b\u5206\u304b\u308c\u3066\u304a\u308a\uff0c\u305d\u308c\u305e\u308c\u30de\u30b9\u30bf\u30c7\u30fc\u30bf\uff0c\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u30c7\u30fc\u30bf\u304c\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u7f6e\u304b\u308c\u3066\u3044\u308b\uff0e<\/p>\n

Authority Code\u30d5\u30a9\u30eb\u30c0<\/h3>\n

\u3000Authority Code\u30d5\u30a9\u30eb\u30c0\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u8a18\u8f09\u3057\u3066\u304a\u304f\uff0epsv\u30d5\u30a1\u30a4\u30eb\u3068\u306fpipe separated value\u30d5\u30a1\u30a4\u30eb\u306e\u3053\u3068\u3067\uff0c\u30c7\u30ea\u30df\u30bf\u304c\u30d1\u30a4\u30d7(|)\u3067\u3042\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u3053\u3068\u3067\u3042\u308b\uff0e<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Authority_Code_ADDRESS_ALIAS_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_ADDRESS_CHANGE_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_ADDRESS_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_FLAT_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_GEOCODED_LEVEL_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_GEOCODE_RELIABILITY_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_GEOCODE_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_LEVEL_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_LOCALITY_ALIAS_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_LOCALITY_CLASS_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_MB_MATCH_CODE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_PS_JOIN_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_STREET_CLASS_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_STREET_LOCALITY_ALIAS_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_STREET_SUFFIX_AUT_psv.psv<\/td>\n<\/tr>\n
Authority_Code_STREET_TYPE_AUT_psv.psv<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Standard\u30d5\u30a9\u30eb\u30c0<\/h3>\n

\u3000Standard\u30d5\u30a9\u30eb\u30c0\u5185\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u8a18\u8f09\u3057\u3066\u304a\u304f\uff0e171\u30d5\u30a1\u30a4\u30eb\u304c\u3042\u308b\u304c\uff0c\u5dde\u3054\u3068\u306b19\u30d5\u30a1\u30a4\u30eb\u305a\u3064\u7d30\u5206\u3055\u308c\u3066\u3044\u308b\uff0e<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ACT_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
ACT_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
ACT_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
ACT_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
ACT_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
ACT_LOCALITY_psv.psv<\/td>\n<\/tr>\n
ACT_MB_2016_psv.psv<\/td>\n<\/tr>\n
ACT_MB_2021_psv.psv<\/td>\n<\/tr>\n
ACT_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
ACT_STATE_psv.psv<\/td>\n<\/tr>\n
ACT_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
ACT_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
ACT_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
NSW_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
NSW_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
NSW_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
NSW_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
NSW_LOCALITY_psv.psv<\/td>\n<\/tr>\n
NSW_MB_2016_psv.psv<\/td>\n<\/tr>\n
NSW_MB_2021_psv.psv<\/td>\n<\/tr>\n
NSW_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
NSW_STATE_psv.psv<\/td>\n<\/tr>\n
NSW_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
NSW_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
NSW_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
NT_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
NT_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
NT_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
NT_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
NT_LOCALITY_psv.psv<\/td>\n<\/tr>\n
NT_MB_2016_psv.psv<\/td>\n<\/tr>\n
NT_MB_2021_psv.psv<\/td>\n<\/tr>\n
NT_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
NT_STATE_psv.psv<\/td>\n<\/tr>\n
NT_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
NT_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
NT_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
OT_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
OT_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
OT_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
OT_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
OT_LOCALITY_psv.psv<\/td>\n<\/tr>\n
OT_MB_2016_psv.psv<\/td>\n<\/tr>\n
OT_MB_2021_psv.psv<\/td>\n<\/tr>\n
OT_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
OT_STATE_psv.psv<\/td>\n<\/tr>\n
OT_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
OT_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
OT_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
QLD_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
QLD_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
QLD_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
QLD_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
QLD_LOCALITY_psv.psv<\/td>\n<\/tr>\n
QLD_MB_2016_psv.psv<\/td>\n<\/tr>\n
QLD_MB_2021_psv.psv<\/td>\n<\/tr>\n
QLD_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
QLD_STATE_psv.psv<\/td>\n<\/tr>\n
QLD_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
QLD_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
QLD_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
SA_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
SA_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
SA_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
SA_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
SA_LOCALITY_psv.psv<\/td>\n<\/tr>\n
SA_MB_2016_psv.psv<\/td>\n<\/tr>\n
SA_MB_2021_psv.psv<\/td>\n<\/tr>\n
SA_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
SA_STATE_psv.psv<\/td>\n<\/tr>\n
SA_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
SA_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
SA_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
TAS_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
TAS_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
TAS_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
TAS_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
TAS_LOCALITY_psv.psv<\/td>\n<\/tr>\n
TAS_MB_2016_psv.psv<\/td>\n<\/tr>\n
TAS_MB_2021_psv.psv<\/td>\n<\/tr>\n
TAS_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
TAS_STATE_psv.psv<\/td>\n<\/tr>\n
TAS_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
TAS_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
TAS_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
VIC_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
VIC_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
VIC_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
VIC_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
VIC_LOCALITY_psv.psv<\/td>\n<\/tr>\n
VIC_MB_2016_psv.psv<\/td>\n<\/tr>\n
VIC_MB_2021_psv.psv<\/td>\n<\/tr>\n
VIC_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
VIC_STATE_psv.psv<\/td>\n<\/tr>\n
VIC_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
VIC_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
VIC_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_ALIAS_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_DEFAULT_GEOCODE_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_DETAIL_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_FEATURE_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_MESH_BLOCK_2016_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_MESH_BLOCK_2021_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_SITE_GEOCODE_psv.psv<\/td>\n<\/tr>\n
WA_ADDRESS_SITE_psv.psv<\/td>\n<\/tr>\n
WA_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
WA_LOCALITY_NEIGHBOUR_psv.psv<\/td>\n<\/tr>\n
WA_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
WA_LOCALITY_psv.psv<\/td>\n<\/tr>\n
WA_MB_2016_psv.psv<\/td>\n<\/tr>\n
WA_MB_2021_psv.psv<\/td>\n<\/tr>\n
WA_PRIMARY_SECONDARY_psv.psv<\/td>\n<\/tr>\n
WA_STATE_psv.psv<\/td>\n<\/tr>\n
WA_STREET_LOCALITY_ALIAS_psv.psv<\/td>\n<\/tr>\n
WA_STREET_LOCALITY_POINT_psv.psv<\/td>\n<\/tr>\n
WA_STREET_LOCALITY_psv.psv<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/h2>\n

\u3000SQL Server Management Studio\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\uff0c\u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9…\u300d\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n

\"SQL<\/a>
SQL Server Management Studio\u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u3067\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u300c\u65b0\u3057\u3044\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u300d<\/figcaption><\/figure>\n

\u3000\u4efb\u610f\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u5165\u529b\u3059\u308b\uff0e\u3053\u3053\u3067\u306fGNAFDB\u3068\u3057\u3066\u3044\u308b\uff0e<\/p>\n

\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u5165\u529b\u3057\u3066OK\u3092\u30af\u30ea\u30c3\u30af\"<\/a>
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u540d\u3092\u5165\u529b\u3057\u3066OK\u3092\u30af\u30ea\u30c3\u30af<\/figcaption><\/figure>\n

\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210<\/h2>\n

\u3000\u30c6\u30fc\u30d6\u30eb\u306e\u4f5c\u6210\u306f\u30b9\u30af\u30ea\u30d7\u30c8\u5316\u3055\u308c\u3066\u304a\u308a\uff0cGNAF_TableCreation_Scripts\u30d5\u30a9\u30eb\u30c0\u5185\u306ecreate_tables_sqlserver.sql\u30d5\u30a1\u30a4\u30eb\u3092SQL Server Management Studio\u304b\u3089\u958b\u3044\u3066\u5b9f\u884c\u3059\u308b\u3060\u3051\u3067\u30c6\u30fc\u30d6\u30eb\u304c\u4f5c\u6210\u3055\u308c\u308b\uff0ecreate_tables_sqlserver\u30d5\u30a1\u30a4\u30eb\u5185\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8a18\u8f09\u3057\u3066\u304a\u304f\uff0e\u30c7\u30fc\u30bf\u9577\u304c50\u3092\u8d85\u3048\u308b\u5217\u306b\u6ce8\u610f\u304c\u5fc5\u8981\u3067\u3042\u308b\uff0e\u5f8c\u3067\u30c7\u30fc\u30bf\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u969b\u306b\u6700\u521d\u306b\u30c7\u30fc\u30bf\u9577\u3092\u5e83\u3052\u3066\u304a\u304b\u306a\u3044\u3068\uff0c\u30a8\u30e9\u30fc\u3067\u5f3e\u304b\u308c\u308b\u3053\u3068\u306b\u306a\u308b\uff0e<\/p>\n

--  \n-- SQL script to Create the published ANSI compliant G-NAF database tables\n--   \n-- Automatically generated by Lynx on 2018.07.27 AD at 11:26:58 EST   \n-- Manually updated 2021.08.23 - added CREATE TABLE scripts for ADDRESS_MESH_BLOCK_2021 and MB_2021.  \n--   \n--\n\n\n-- ********************************************************************************************\n-- ********************************************************************************************\n-- Create ANSI tables \n-- ********************************************************************************************\n-- ********************************************************************************************\n\nCREATE TABLE ADDRESS_ALIAS (\n address_alias_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n principal_pid varchar(15) NOT NULL,\n alias_pid varchar(15) NOT NULL,\n alias_type_code varchar(10) NOT NULL,\n alias_comment varchar(200)\n);\n\nCREATE TABLE ADDRESS_ALIAS_TYPE_AUT (\n code varchar(10) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(30)\n);\n\nCREATE TABLE ADDRESS_CHANGE_TYPE_AUT (\n code varchar(50) NOT NULL,\n name varchar(100) NOT NULL,\n description varchar(500)\n);\n\nCREATE TABLE ADDRESS_DEFAULT_GEOCODE (\n address_default_geocode_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n address_detail_pid varchar(15) NOT NULL,\n geocode_type_code varchar(4) NOT NULL,\n longitude numeric(11,8),\n latitude numeric(10,8)\n);\n\nCREATE TABLE ADDRESS_DETAIL (\n address_detail_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_last_modified date,\n date_retired date,\n building_name varchar(200),\n lot_number_prefix varchar(2),\n lot_number varchar(5),\n lot_number_suffix varchar(2),\n flat_type_code varchar(7),\n flat_number_prefix varchar(2),\n flat_number numeric(5),\n flat_number_suffix varchar(2),\n level_type_code varchar(4),\n level_number_prefix varchar(2),\n level_number numeric(3),\n level_number_suffix varchar(2),\n number_first_prefix varchar(3),\n number_first numeric(6),\n number_first_suffix varchar(2),\n number_last_prefix varchar(3),\n number_last numeric(6),\n number_last_suffix varchar(2),\n street_locality_pid varchar(15),\n location_description varchar(45),\n locality_pid varchar(15) NOT NULL,\n alias_principal char(1),\n postcode varchar(4),\n private_street varchar(75),\n legal_parcel_id varchar(20),\n confidence numeric(1),\n address_site_pid varchar(15) NOT NULL,\n level_geocoded_code numeric(2) NOT NULL,\n property_pid varchar(15),\n gnaf_property_pid varchar(15),\n primary_secondary varchar(1)\n);\n\nCREATE TABLE ADDRESS_FEATURE (\n address_feature_id varchar(16) NOT NULL,\n address_feature_pid varchar(16) NOT NULL,\n address_detail_pid varchar(15) NOT NULL,\n date_address_detail_created date NOT NULL,\n date_address_detail_retired date,\n address_change_type_code varchar(50)\n);\n\nCREATE TABLE ADDRESS_MESH_BLOCK_2016 (\n address_mesh_block_2016_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n address_detail_pid varchar(15) NOT NULL,\n mb_match_code varchar(15) NOT NULL,\n mb_2016_pid varchar(15) NOT NULL\n);\n\nCREATE TABLE ADDRESS_MESH_BLOCK_2021 (\n address_mesh_block_2021_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n address_detail_pid varchar(15) NOT NULL,\n mb_match_code varchar(15) NOT NULL,\n mb_2021_pid varchar(15) NOT NULL\n);\n\nCREATE TABLE ADDRESS_SITE (\n address_site_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n address_type varchar(8),\n address_site_name varchar(200)\n);\n\nCREATE TABLE ADDRESS_SITE_GEOCODE (\n address_site_geocode_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n address_site_pid varchar(15),\n geocode_site_name varchar(200),\n geocode_site_description varchar(45),\n geocode_type_code varchar(4),\n reliability_code numeric(1) NOT NULL,\n boundary_extent numeric(7),\n planimetric_accuracy numeric(12),\n elevation numeric(7),\n longitude numeric(11,8),\n latitude numeric(10,8)\n);\n\nCREATE TABLE ADDRESS_TYPE_AUT (\n code varchar(8) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(30)\n);\n\nCREATE TABLE FLAT_TYPE_AUT (\n code varchar(7) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(30)\n);\n\nCREATE TABLE GEOCODED_LEVEL_TYPE_AUT (\n code numeric(2) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(70)\n);\n\nCREATE TABLE GEOCODE_RELIABILITY_AUT (\n code numeric(1) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(100)\n);\n\nCREATE TABLE GEOCODE_TYPE_AUT (\n code varchar(4) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(250)\n);\n\nCREATE TABLE LEVEL_TYPE_AUT (\n code varchar(4) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(30)\n);\n\nCREATE TABLE LOCALITY (\n locality_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n locality_name varchar(100) NOT NULL,\n primary_postcode varchar(4),\n locality_class_code char(1) NOT NULL,\n state_pid varchar(15) NOT NULL,\n gnaf_locality_pid varchar(15),\n gnaf_reliability_code numeric(1) NOT NULL\n);\n\nCREATE TABLE LOCALITY_ALIAS (\n locality_alias_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n locality_pid varchar(15) NOT NULL,\n name varchar(100) NOT NULL,\n postcode varchar(4),\n alias_type_code varchar(10) NOT NULL,\n state_pid varchar(15) NOT NULL\n);\n\nCREATE TABLE LOCALITY_ALIAS_TYPE_AUT (\n code varchar(10) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(100)\n);\n\nCREATE TABLE LOCALITY_CLASS_AUT (\n code char(1) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(200)\n);\n\nCREATE TABLE LOCALITY_NEIGHBOUR (\n locality_neighbour_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n locality_pid varchar(15) NOT NULL,\n neighbour_locality_pid varchar(15) NOT NULL\n);\n\nCREATE TABLE LOCALITY_POINT (\n locality_point_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n locality_pid varchar(15) NOT NULL,\n planimetric_accuracy numeric(12),\n longitude numeric(11,8),\n latitude numeric(10,8)\n);\n\nCREATE TABLE MB_2016 (\n mb_2016_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n mb_2016_code varchar(15) NOT NULL\n);\n\nCREATE TABLE MB_2021 (\n mb_2021_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n mb_2021_code varchar(15) NOT NULL\n);\n\n\nCREATE TABLE MB_MATCH_CODE_AUT (\n code varchar(15) NOT NULL,\n name varchar(100) NOT NULL,\n description varchar(250)\n);\n\nCREATE TABLE PRIMARY_SECONDARY (\n primary_secondary_pid varchar(15) NOT NULL,\n primary_pid varchar(15) NOT NULL,\n secondary_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n ps_join_type_code numeric(2) NOT NULL,\n ps_join_comment varchar(500)\n);\n\nCREATE TABLE PS_JOIN_TYPE_AUT (\n code numeric(2) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(500)\n);\n\nCREATE TABLE STATE (\n state_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n state_name varchar(50) NOT NULL,\n state_abbreviation varchar(3) NOT NULL\n);\n\nCREATE TABLE STREET_CLASS_AUT (\n code char(1) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(200)\n);\n\nCREATE TABLE STREET_LOCALITY (\n street_locality_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n street_class_code char(1) NOT NULL,\n street_name varchar(100) NOT NULL,\n street_type_code varchar(15),\n street_suffix_code varchar(15),\n locality_pid varchar(15) NOT NULL,\n gnaf_street_pid varchar(15),\n gnaf_street_confidence numeric(1),\n gnaf_reliability_code numeric(1) NOT NULL\n);\n\nCREATE TABLE STREET_LOCALITY_ALIAS (\n street_locality_alias_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n street_locality_pid varchar(15) NOT NULL,\n street_name varchar(100) NOT NULL,\n street_type_code varchar(15),\n street_suffix_code varchar(15),\n alias_type_code varchar(10) NOT NULL\n);\n\nCREATE TABLE STREET_LOCALITY_ALIAS_TYPE_AUT (\n code varchar(10) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(15)\n);\n\nCREATE TABLE STREET_LOCALITY_POINT (\n street_locality_point_pid varchar(15) NOT NULL,\n date_created date NOT NULL,\n date_retired date,\n street_locality_pid varchar(15) NOT NULL,\n boundary_extent numeric(7),\n planimetric_accuracy numeric(12),\n longitude numeric(11,8),\n latitude numeric(10,8)\n);\n\nCREATE TABLE STREET_SUFFIX_AUT (\n code varchar(15) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(30)\n);\n\nCREATE TABLE STREET_TYPE_AUT (\n code varchar(15) NOT NULL,\n name varchar(50) NOT NULL,\n description varchar(15)\n);\n<\/pre>\n
\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8<\/h2>\n
\u30a6\u30a3\u30b6\u30fc\u30c9\u7de8<\/h3>\n
\u3000\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306b\u306f\u30a6\u30a3\u30b6\u30fc\u30c9\u3092\u4f7f\u3046\uff0eAuthority Code\u30d5\u30a9\u30eb\u30c0\u5185\u306e16\u30d5\u30a1\u30a4\u30eb\uff0cStandard\u30d5\u30a9\u30eb\u30c0\u5185\u306e171\u30d5\u30a1\u30a4\u30eb\u306b\u5bfe\u3057\u3066\u30a4\u30f3\u30dd\u30fc\u30c8\u3092\u884c\u3046\uff0e\u9aa8\u306e\u6298\u308c\u308b\u4f5c\u696d\u3067\u3042\u308b\u304c\uff0c\u5909\u63db\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u624b\u52d5\u3067\u9078\u629e\u3057\u3066\u3084\u3089\u306a\u3044\u3068\u306a\u3089\u305a\uff0c\u30a6\u30a3\u30b6\u30fc\u30c9\u3067\u306f\u3053\u3053\u304c\u81ea\u52d5\u5316\u3067\u304d\u306a\u3044\uff0eeSTAT\u306e\u5c0f\u5730\u57df\uff08\u753a\u4e01\u30fb\u5b57\u7b49\u5225\uff09\u6bce\u306e\u5e74\u9f62\uff08\uff15\u6b73\u968e\u7d1a\u3001\uff14\u533a\u5206\uff09\u5225\u3001\u7537\u5973\u5225\u4eba\u53e3\u3092SQL Server\u306bBULK INSERT\u3059\u308b<\/a>\u3092\u53c2\u8003\u306bBULK INSERT\u3057\u305f\u307b\u3046\u304c\u826f\u3044\uff0e\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u30c6\u30fc\u30d6\u30eb\u540d\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u306e\u304c\u30d2\u30f3\u30c8\u3067\u3042\u308b\uff0e<\/p>\n
\u3000\u307e\u305f\uff0c\u30c7\u30fc\u30bf\u9577\u304c50\u3092\u8d85\u3048\u308b\u5217\u304c\u6df7\u3058\u3063\u3066\u304a\u308a\uff0c\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u969b\u306b\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067\u8a72\u5f53\u5217\u306eOutputColumnWidth\u306e\u5024\u3092500\u306a\u3069\u306e\u5927\u304d\u3044\u5024\u306b\u5909\u66f4\u3057\u3066\u304a\u304b\u306a\u3044\u3068\u30a4\u30f3\u30dd\u30fc\u30c8\u306e\u6700\u5f8c\u306b\u30a8\u30e9\u30fc\u3067\u5f3e\u304b\u308c\u308b\u3053\u3068\u306b\u306a\u308b\uff0e<\/p>\n
\u3000\u3068\u3082\u304b\u304f\uff0c\u30a4\u30f3\u30dd\u30fc\u30c8\u306e\u624b\u9806\u3092\u793a\u3059\uff0e<\/p>\n
\u3000\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30bf\u30b9\u30af\u300d\u300c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u300d\u3078\u3068\u9032\u3080\uff0e<\/p>\n
\"\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30bf\u30b9\u30af\u300d\u300c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u300d\"<\/a>
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u300c\u30bf\u30b9\u30af\u300d\u300c\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u300d<\/figcaption><\/figure>\n
\u3000\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u3067\u300cFlat File Source\u300d\u3092\u9078\u629e\u3057\uff0c\u300c\u53c2\u7167\u300d\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n
\"\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u3067\u300cFlat<\/a>
\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u3067\u300cFlat File Source\u300d\u3092\u9078\u629e\u3057\uff0c\u300c\u53c2\u7167\u300d\u304b\u3089\u30d5\u30a1\u30a4\u30eb\u3092\u9078\u629e\u3059\u308b<\/figcaption><\/figure>\n
\u3000\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u300c\u5217\u300d\u306b\u9032\u3093\u3060\u3068\u3053\u308d\uff0e\u300c\u5217\u533a\u5207\u308a\u8a18\u53f7\u300d\u304c\u30d1\u30a4\u30d7\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u306b\u6ce8\u76ee\uff0e<\/p>\n
\"\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u300c\u5217\u300d\u306b\u9032\u3093\u3060\u3068\u3053\u308d\"<\/a>
\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u300c\u5217\u300d\u306b\u9032\u3093\u3060\u3068\u3053\u308d<\/figcaption><\/figure>\n
\u3000\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067\u30c7\u30fc\u30bf\u9577\u304c50\u3092\u8d85\u3048\u308b\u5217\u306eOutputColumnWidth\u3092500\u306b\u5e83\u3052\u3066\u3044\u308b\uff0e\u3053\u3053\u306f\u30a6\u30a3\u30b6\u30fc\u30c9\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u3067\u3064\u307e\u3065\u304d\u3084\u3059\u3044\u7b87\u6240\u3067\u3042\u308b\uff0e<\/p>\n
\"\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067\u30c7\u30fc\u30bf\u9577\u304c50\u3092\u8d85\u3048\u308b\u5217\u306eOutputColumnWidth\u3092500\u306b\u5e83\u3052\u3066\u3044\u308b\"<\/a>
\u300c\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\u306e\u9078\u629e\u300d\u306e\u300c\u8a73\u7d30\u8a2d\u5b9a\u300d\u3067\u30c7\u30fc\u30bf\u9577\u304c50\u3092\u8d85\u3048\u308b\u5217\u306eOutputColumnWidth\u3092500\u306b\u5e83\u3052\u3066\u3044\u308b<\/figcaption><\/figure>\n
\u3000\u300c\u5909\u63db\u5148\u306e\u9078\u629e\u300d\u3067\u300cSQL Server Native Client 11.0\u300d\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n
\"\u300c\u5909\u63db\u5148\u306e\u9078\u629e\u300d\u3067\u300cSQL<\/a>
\u300c\u5909\u63db\u5148\u306e\u9078\u629e\u300d\u3067\u300cSQL Server Native Client 11.0\u300d\u3092\u9078\u629e<\/figcaption><\/figure>\n
\u3000\u300c\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e\u300d\u3067\u5909\u63db\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u5909\u63db\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4e00\u81f4\u3055\u305b\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u540d\u3068\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u7167\u5408\u3057\u3066\u9078\u629e\u3059\u308b\uff0e<\/p>\n
\"\u300c\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e\u300d\u3067\u5909\u63db\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u5909\u63db\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4e00\u81f4\u3055\u305b\u308b\"<\/a>
\u300c\u30b3\u30d4\u30fc\u5143\u306e\u30c6\u30fc\u30d6\u30eb\u304a\u3088\u3073\u30d3\u30e5\u30fc\u3092\u9078\u629e\u300d\u3067\u5909\u63db\u5143\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u5909\u63db\u5148\u306e\u30c6\u30fc\u30d6\u30eb\u3092\u4e00\u81f4\u3055\u305b\u308b<\/figcaption><\/figure>\n
\u3000\u300c\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3067\u5217\u540d\u3068\u30c7\u30fc\u30bf\u9577\u3092\u78ba\u8a8d\u3059\u308b\uff0e<\/p>\n
\"\u300c\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3067\u5217\u540d\u3068\u30c7\u30fc\u30bf\u9577\u3092\u78ba\u8a8d\u3059\u308b\"<\/a>
\u300c\u5217\u30de\u30c3\u30d4\u30f3\u30b0\u300d\u3067\u5217\u540d\u3068\u30c7\u30fc\u30bf\u9577\u3092\u78ba\u8a8d\u3059\u308b<\/figcaption><\/figure>\n
\u3000Finish\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u6210\u529f\u3059\u308b\u3068\u753b\u9762\u306e\u3088\u3046\u306b\u306a\u308b\uff0e<\/p>\n
\"Finish\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u6210\u529f\u3059\u308b\u3068\u753b\u9762\u306e\u3088\u3046\u306b\u306a\u308b\"<\/a>
Finish\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u6210\u529f\u3059\u308b\u3068\u753b\u9762\u306e\u3088\u3046\u306b\u306a\u308b<\/figcaption><\/figure>\n
BULK INSERT\u7de8<\/h3>\n
\u3000\u30b3\u30fc\u30c9\u3092\u8a18\u8f09\u3059\u308b\uff0e<\/p>\n
BULK INSERT \tADDRESS_ALIAS_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_ADDRESS_ALIAS_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tADDRESS_CHANGE_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_ADDRESS_CHANGE_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tADDRESS_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_ADDRESS_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tFLAT_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_FLAT_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tGEOCODED_LEVEL_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_GEOCODED_LEVEL_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tGEOCODE_RELIABILITY_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_GEOCODE_RELIABILITY_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tGEOCODE_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_GEOCODE_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tLEVEL_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_LEVEL_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tLOCALITY_ALIAS_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_LOCALITY_ALIAS_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tLOCALITY_CLASS_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_LOCALITY_CLASS_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tMB_MATCH_CODE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_MB_MATCH_CODE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tPS_JOIN_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_PS_JOIN_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tSTREET_CLASS_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_STREET_CLASS_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tSTREET_LOCALITY_ALIAS_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_STREET_LOCALITY_ALIAS_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tSTREET_SUFFIX_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_STREET_SUFFIX_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\nBULK INSERT \tSTREET_TYPE_AUT\t FROM \t'C:\\path\\g-naf_may24_allstates_gda2020_psv_1015\\G-NAF\\G-NAF MAY 2024\\Authority Code\\\\Authority_Code_STREET_TYPE_AUT_psv.psv'\t WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '\\n', FIRSTROW = 2)\n<\/pre>\n
(8 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(511 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(54 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(8 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(6 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(29 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(16 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(9 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(19 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(276 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n
\u3000\u3053\u306e\u30b3\u30fc\u30c9\u306e\u4f5c\u6210\u306b\u306fEXCEL\u306ePower Query\u3092\u7528\u3044\u3066\u3044\u308b\uff0e\u30d5\u30a9\u30eb\u30c0\u304b\u3089\u30c7\u30fc\u30bf\u3092\u62bd\u51fa\u3057\uff0c\u30d5\u30a1\u30a4\u30eb\u540d\u3068\u30d5\u30a1\u30a4\u30eb\u30d1\u30b9\u3092\u53d6\u5f97\u3057\u3066\u52a0\u5de5\u3057\uff0c\u30af\u30a8\u30ea\u306e\u30c6\u30fc\u30d6\u30eb\u540d\uff08BULK INSERT\u53e5\uff09\u3068\u30d5\u30a1\u30a4\u30eb\u540d\uff08FROM\u53e5\uff09\u306b\u3057\u3066\u3044\u308b\uff0e<\/p>\n
Power Query\u3067\u306e\u30af\u30a8\u30ea\u6587\u5b57\u5217\u751f\u6210<\/h3>\n
\u3000\u5177\u4f53\u4f8b\u3092\u898b\u3066\u3044\u3053\u3046\uff0e<\/p>\n
\u3000EXCEL\u306e\u30c7\u30fc\u30bf\u30bf\u30d6\u306e\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u300c\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u300d\u300c\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u300d\u3078\u3068\u9032\u3080\uff0e<\/p>\n
\"\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u300c\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u300d\u300c\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u300d\"<\/a>
\u300c\u30c7\u30fc\u30bf\u306e\u53d6\u5f97\u300d\u300c\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u300d\u300c\u30d5\u30a9\u30eb\u30c0\u30fc\u304b\u3089\u300d<\/figcaption><\/figure>\n
\u3000\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067\u30d5\u30a9\u30eb\u30c0\u3092\u6307\u5b9a\u3059\u308b\uff0e<\/p>\n
\"\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067\u30d5\u30a9\u30eb\u30c0\u3092\u6307\u5b9a\"<\/a>
\u30e6\u30fc\u30b6\u30fc\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3067\u30d5\u30a9\u30eb\u30c0\u3092\u6307\u5b9a<\/figcaption><\/figure>\n
\u3000\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\uff0e<\/p>\n
\"\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d\u3092\u30af\u30ea\u30c3\u30af\"<\/a>
\u300c\u30c7\u30fc\u30bf\u306e\u5909\u63db\u300d\u3092\u30af\u30ea\u30c3\u30af<\/figcaption><\/figure>\n
\u3000Name\u3068Folder Path\u4ee5\u5916\u306e\u5217\u3092\u524a\u9664\u3059\u308b\uff0e<\/p>\n
\"Name\u3068Folder<\/a>
Name\u3068Folder Path\u4ee5\u5916\u306e\u5217\u3092\u524a\u9664<\/figcaption><\/figure>\n
\u3000\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u56f3\u306e\u6587\u5b57\u5217\u3092\u8a18\u8ff0\u3059\u308b\uff0e\u3053\u308c\u306fFROM\u53e5\u3067\u6307\u5b9a\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30eb\u30d1\u30b9\u306b\u306a\u308b\uff0e<\/p>\n
\"\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u56f3\u306e\u6587\u5b57\u5217\u3092\u8a18\u8ff0\"<\/a>
\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u56f3\u306e\u6587\u5b57\u5217\u3092\u8a18\u8ff0<\/figcaption><\/figure>\n
\u3000Name\u5217\u3092\u5206\u5272\u3059\u308b\uff0e\u300c\u533a\u5207\u308a\u6587\u5b57\u306b\u3088\u308b\u5206\u5272\u300d\u3092\u9078\u629e\u3059\u308b\uff0e<\/p>\n
\"Name\u5217\u3092\u5206\u5272\u3059\u308b\uff0e\u300c\u533a\u5207\u308a\u6587\u5b57\u306b\u3088\u308b\u5206\u5272\u300d\u3092\u9078\u629e\"<\/a>
Name\u5217\u3092\u5206\u5272\u3059\u308b\uff0e\u300c\u533a\u5207\u308a\u6587\u5b57\u306b\u3088\u308b\u5206\u5272\u300d\u3092\u9078\u629e<\/figcaption><\/figure>\n
\u3000\u300c\u533a\u5207\u308a\u8a18\u53f7\u300d\u3092\u30ab\u30b9\u30bf\u30e0\u3068\u3057\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3092\u5165\u529b\u3057\uff0c\u300c\u4e00\u756a\u53f3\u306e\u533a\u5207\u308a\u8a18\u53f7\u300d\u3092\u30c1\u30a7\u30c3\u30af\u3059\u308b\uff0e<\/p>\n
\"\u300c\u533a\u5207\u308a\u8a18\u53f7\u300d\u3092\u30ab\u30b9\u30bf\u30e0\u3068\u3057\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3092\u5165\u529b\u3057\uff0c\u300c\u4e00\u756a\u53f3\u306e\u533a\u5207\u308a\u8a18\u53f7\u300d\u3092\u30c1\u30a7\u30c3\u30af\"<\/a>
\u300c\u533a\u5207\u308a\u8a18\u53f7\u300d\u3092\u30ab\u30b9\u30bf\u30e0\u3068\u3057\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3092\u5165\u529b\u3057\uff0c\u300c\u4e00\u756a\u53f3\u306e\u533a\u5207\u308a\u8a18\u53f7\u300d\u3092\u30c1\u30a7\u30c3\u30af<\/figcaption><\/figure>\n
\u3000\u518d\u5ea6\u300c\u533a\u5207\u308a\u6587\u5b57\u306b\u3088\u308b\u5206\u5272\u300d\u304b\u3089\u533a\u5207\u308a\u8a18\u53f7\u3092\u30ab\u30b9\u30bf\u30e0\u3068\u3057\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3092\u5165\u529b\u3057\uff0c\u300c\u5206\u5272\u300d\u3092\u300c\u4e00\u756a\u5de6\u306e\u533a\u5207\u308a\u8a18\u53f7\u300d\u3068\u3059\u308b\uff0e<\/p>\n
\"\u533a\u5207\u308a\u8a18\u53f7\u3092\u30ab\u30b9\u30bf\u30e0\u3068\u3057\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3092\u5165\u529b\u3057\uff0c\u300c\u5206\u5272\u300d\u3092\u300c\u4e00\u756a\u5de6\u306e\u533a\u5207\u308a\u8a18\u53f7\u300d\u3068\u3059\u308b\"<\/a>
\u533a\u5207\u308a\u8a18\u53f7\u3092\u30ab\u30b9\u30bf\u30e0\u3068\u3057\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3092\u5165\u529b\u3057\uff0c\u300c\u5206\u5272\u300d\u3092\u300c\u4e00\u756a\u5de6\u306e\u533a\u5207\u308a\u8a18\u53f7\u300d\u3068\u3059\u308b<\/figcaption><\/figure>\n
\u3000\u30d5\u30a1\u30a4\u30eb\u540d\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5207\u308a\u51fa\u3057\u305f\u72b6\u614b\uff0e\u9078\u629e\u3057\u305f\u5217\u3092\u300c\u524a\u9664\u300d\u3059\u308b\uff0e<\/p>\n
\"\u30d5\u30a1\u30a4\u30eb\u540d\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5207\u308a\u51fa\u3057\u305f\u72b6\u614b\uff0e\u9078\u629e\u3057\u305f\u5217\u3092\u300c\u524a\u9664\u300d\u3059\u308b\"<\/a>
\u30d5\u30a1\u30a4\u30eb\u540d\u304b\u3089\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u5207\u308a\u51fa\u3057\u305f\u72b6\u614b\uff0e\u9078\u629e\u3057\u305f\u5217\u3092\u300c\u524a\u9664\u300d\u3059\u308b<\/figcaption><\/figure>\n
\u3000\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c”BULK INSERT”\u300d\u3068\u5165\u529b\u3059\u308b\uff0e<\/p>\n
\"\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c"BULK<\/a>
\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c”BULK INSERT”\u300d\u3068\u5165\u529b\u3059\u308b<\/figcaption><\/figure>\n
\u3000\u518d\u5ea6\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c”FROM”\u300d\u3068\u5165\u529b\u3059\u308b\uff0e<\/p>\n
\"\u518d\u5ea6\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c"FROM"\u300d\u3068\u5165\u529b\u3059\u308b\"<\/a>
\u518d\u5ea6\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c”FROM”\u300d\u3068\u5165\u529b\u3059\u308b<\/figcaption><\/figure>\n
\u3000\u4e09\u5ea6\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c”WITH (FIELDTERMINATOR = ‘|’, ROWTERMINATOR = ‘\\n’, FIRSTROW = 2)”\u300d\u3068\u5165\u529b\u3059\u308b\uff0e<\/p>\n
\"\u4e09\u5ea6\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c"WITH<\/a>
\u4e09\u5ea6\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u633f\u5165\u3057\u300c”WITH (FIELDTERMINATOR = ‘|’, ROWTERMINATOR = ‘\\n’, FIRSTROW = 2)”\u300d\u3068\u5165\u529b\u3059\u308b<\/figcaption><\/figure>\n
\u3000\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u79fb\u52d5\u3057\u3066\u30af\u30a8\u30ea\u306e\u9806\u306b\u4e26\u3079\u308b\uff0e<\/p>\n
\"\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u79fb\u52d5\u3057\u3066\u30af\u30a8\u30ea\u306e\u9806\u306b\u4e26\u3079\u308b\"<\/a>
\u30ab\u30b9\u30bf\u30e0\u5217\u3092\u79fb\u52d5\u3057\u3066\u30af\u30a8\u30ea\u306e\u9806\u306b\u4e26\u3079\u308b<\/figcaption><\/figure>\n
\u3000\u300c\u9589\u3058\u3066\u8aad\u307f\u8fbc\u3080\u300d\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068171\u884c\u306e\u30c7\u30fc\u30bf\u304c\u8aad\u307f\u8fbc\u307e\u308c\u308b\uff0e2\u884c\u76ee\u304b\u3089172\u884c\u76ee\u307e\u3067\u3092\u30b3\u30d4\u30fc\u3057\u3066\u30e1\u30e2\u5e33\u306b\u8cbc\u308a\u4ed8\u3051\uff0c\u4efb\u610f\u306e\u30d5\u30a1\u30a4\u30eb\u540d\u306b.sql\u62e1\u5f35\u5b50\u3092\u4ed8\u52a0\u3057\u3066\u4fdd\u5b58\u3059\u308c\u3070\u5b8c\u6210\u3067\u3042\u308b\uff0e\u305f\u3060\u3057\uff0c1500\u4e07\u4ef6\u4ee5\u4e0a\u3042\u308b\u30c7\u30fc\u30bf\u3092\u8aad\u307f\u8fbc\u3080\u4f5c\u696d\u306a\u306e\u3067\u305d\u308c\u306a\u308a\u306b\u6642\u9593\u304c\u304b\u304b\u308b\uff0e<\/p>\n
(5145 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(270167 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(270167 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(194 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(270167 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(270167 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(480682 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(270167 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(185 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(844 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(146 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(146 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(6393 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(6662 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(99196 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(211 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(6839 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(6924 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(291187 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5072576 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5072576 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(58607 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5072576 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5072576 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4880574 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5072576 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(7716 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(26322 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4745 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4745 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(109880 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(112738 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1818100 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(9275 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(180069 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(187533 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3816 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(117658 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(117658 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(478 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(117658 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(117658 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(111569 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(117658 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2198 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1514 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1098 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1098 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3299 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3361 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(40059 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(177 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(8240 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(9511 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(40 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5169 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5169 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(58 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5169 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5169 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3523 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5169 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(15 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(15 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(15 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(137 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(136 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(471 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(18 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(165 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(250 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(230780 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3466610 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3466610 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(55011 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3466610 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3466610 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3331086 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3466610 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(8030 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(19160 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3543 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3543 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(69764 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(71862 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(975266 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(10411 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(154257 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(170083 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(38483 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1242329 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1242329 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(43706 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1242329 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1242329 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1272995 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1242329 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3599 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(10760 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2184 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2184 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(28205 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(28431 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(208704 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(5712 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(64777 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(67804 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(8707 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(368350 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(368350 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1615 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(368350 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(368350 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(350574 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(368350 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(768 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3876 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(782 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(782 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(12981 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(13034 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(65382 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(812 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(19057 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(19912 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(218748 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4262962 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4262962 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(36410 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4262962 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4262962 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(8120440 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(4262962 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3693 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(17236 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2996 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2996 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(85014 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(88739 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1233160 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(11698 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(195429 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(203116 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(63250 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1624635 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1624635 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(10225 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1624635 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1624635 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1572934 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1624635 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(3318 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(9658 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2052 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(2052 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(42449 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(43322 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(358753 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(1599 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(83459 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n(87734 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n
\u4e3b\u30ad\u30fc\u3068\u5916\u90e8\u30ad\u30fc\u306e\u4f5c\u6210<\/h2>\n
\u3000\u30c7\u30fc\u30bf\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u304c\u7d42\u308f\u3063\u305f\u3089\u30c6\u30fc\u30d6\u30eb\u306e\u4e3b\u30ad\u30fc\u3068\u5916\u90e8\u30ad\u30fc\u306e\u4f5c\u6210\u3067\u3042\u308b\uff0e\u3053\u306e\u4f5c\u696d\u3082\u30b9\u30af\u30ea\u30d7\u30c8\u5316\u3055\u308c\u3066\u304a\u308a\uff0cGNAF_TableCreation_Scripts\u30d5\u30a9\u30eb\u30c0\u5185\u306eadd_fk_constraints.sql\u30d5\u30a1\u30a4\u30eb\u3092SQL Server Management Studio\u304b\u3089\u958b\u3044\u3066\u5b9f\u884c\u3059\u308b\u3060\u3051\u3067\u3042\u308b\uff0e\u3053\u306e\u4f5c\u696d\u306b\u306f\u3084\u3084\u6642\u9593\u304c\u304b\u304b\u308b\uff0e<\/p>\n
\u3000\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u8a18\u8f09\u3057\u3066\u304a\u304f\uff0e<\/p>\n
--  \n-- SQL script to Add primary and foreign key constraints\n--   \n-- Automatically generated by Lynx on 2018.07.27 AD at 11:27:05 EST   \n-- Manually updated 2021.08.23 - added ADDRESS_MESH_BLOCK_2021_PK and MB_2021_PK constraint.  \n-- Manually updated 2021.08.23 - added ADDRESS_MESH_BLOCK_2021_FK1, ADDRESS_MESH_BLOCK_2021_FK2 and ADDRESS_MESH_BLOCK_2021_FK3.\n--\n--  \n\n-- ********************************************************************************************\n-- ********************************************************************************************\n-- Create primary key table constraints \n-- ********************************************************************************************\n-- ********************************************************************************************\nUSE GNAFDB;\nGO\nALTER TABLE ADDRESS_ALIAS ADD\n CONSTRAINT ADDRESS_ALIAS_PK PRIMARY KEY (address_alias_pid);\n\nALTER TABLE ADDRESS_ALIAS_TYPE_AUT ADD\n CONSTRAINT ADDRESS_ALIAS_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE ADDRESS_CHANGE_TYPE_AUT ADD\n CONSTRAINT ADDRESS_CHANGE_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE ADDRESS_DEFAULT_GEOCODE ADD\n CONSTRAINT ADDRESS_DEFAULT_GEOCODE_PK PRIMARY KEY (address_default_geocode_pid);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_PK PRIMARY KEY (address_detail_pid);\n\nALTER TABLE ADDRESS_FEATURE ADD\n CONSTRAINT ADDRESS_FEATURE_PK PRIMARY KEY (address_feature_id);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2016 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2016_PK PRIMARY KEY (address_mesh_block_2016_pid);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2021 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2021_PK PRIMARY KEY (address_mesh_block_2021_pid); \n\nALTER TABLE ADDRESS_SITE ADD\n CONSTRAINT ADDRESS_SITE_PK PRIMARY KEY (address_site_pid);\n\nALTER TABLE ADDRESS_SITE_GEOCODE ADD\n CONSTRAINT ADDRESS_SITE_GEOCODE_PK PRIMARY KEY (address_site_geocode_pid);\n\nALTER TABLE ADDRESS_TYPE_AUT ADD\n CONSTRAINT ADDRESS_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE FLAT_TYPE_AUT ADD\n CONSTRAINT FLAT_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE GEOCODED_LEVEL_TYPE_AUT ADD\n CONSTRAINT GEOCODED_LEVEL_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE GEOCODE_RELIABILITY_AUT ADD\n CONSTRAINT GEOCODE_RELIABILITY_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE GEOCODE_TYPE_AUT ADD\n CONSTRAINT GEOCODE_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE LEVEL_TYPE_AUT ADD\n CONSTRAINT LEVEL_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE LOCALITY ADD\n CONSTRAINT LOCALITY_PK PRIMARY KEY (locality_pid);\n\nALTER TABLE LOCALITY_ALIAS ADD\n CONSTRAINT LOCALITY_ALIAS_PK PRIMARY KEY (locality_alias_pid);\n\nALTER TABLE LOCALITY_ALIAS_TYPE_AUT ADD\n CONSTRAINT LOCALITY_ALIAS_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE LOCALITY_CLASS_AUT ADD\n CONSTRAINT LOCALITY_CLASS_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE LOCALITY_NEIGHBOUR ADD\n CONSTRAINT LOCALITY_NEIGHBOUR_PK PRIMARY KEY (locality_neighbour_pid);\n\nALTER TABLE LOCALITY_POINT ADD\n CONSTRAINT LOCALITY_POINT_PK PRIMARY KEY (locality_point_pid);\n\nALTER TABLE MB_2016 ADD\n CONSTRAINT MB_2016_PK PRIMARY KEY (mb_2016_pid);\n\nALTER TABLE MB_2021 ADD\n CONSTRAINT MB_2021_PK PRIMARY KEY (mb_2021_pid);\n\nALTER TABLE MB_MATCH_CODE_AUT ADD\n CONSTRAINT MB_MATCH_CODE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE PRIMARY_SECONDARY ADD\n CONSTRAINT PRIMARY_SECONDARY_PK PRIMARY KEY (primary_secondary_pid);\n\nALTER TABLE PS_JOIN_TYPE_AUT ADD\n CONSTRAINT PS_JOIN_TYPE_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE STATE ADD\n CONSTRAINT STATE_PK PRIMARY KEY (state_pid);\n\nALTER TABLE STREET_CLASS_AUT ADD\n CONSTRAINT STREET_CLASS_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE STREET_LOCALITY ADD\n CONSTRAINT STREET_LOCALITY_PK PRIMARY KEY (street_locality_pid);\n\nALTER TABLE STREET_LOCALITY_ALIAS ADD\n CONSTRAINT STREET_LOCALITY_ALIAS_PK PRIMARY KEY (street_locality_alias_pid);\n\nALTER TABLE STREET_LOCALITY_ALIAS_TYPE_AUT ADD\n CONSTRAINT STREET_LOCALITY_ALIAS_TYPE__PK PRIMARY KEY (code);\n\nALTER TABLE STREET_LOCALITY_POINT ADD\n CONSTRAINT STREET_LOCALITY_POINT_PK PRIMARY KEY (street_locality_point_pid);\n\nALTER TABLE STREET_SUFFIX_AUT ADD\n CONSTRAINT STREET_SUFFIX_AUT_PK PRIMARY KEY (code);\n\nALTER TABLE STREET_TYPE_AUT ADD\n CONSTRAINT STREET_TYPE_AUT_PK PRIMARY KEY (code);\n\n-- ********************************************************************************************\n-- ********************************************************************************************\n-- Create foreign key table constraints \n-- ********************************************************************************************\n-- ********************************************************************************************\n\nALTER TABLE ADDRESS_ALIAS ADD\n CONSTRAINT ADDRESS_ALIAS_FK1 FOREIGN KEY (alias_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE ADDRESS_ALIAS ADD\n CONSTRAINT ADDRESS_ALIAS_FK2 FOREIGN KEY (alias_type_code)\n  REFERENCES ADDRESS_ALIAS_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_ALIAS ADD\n CONSTRAINT ADDRESS_ALIAS_FK3 FOREIGN KEY (principal_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE ADDRESS_DEFAULT_GEOCODE ADD\n CONSTRAINT ADDRESS_DEFAULT_GEOCODE_FK1 FOREIGN KEY (address_detail_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE ADDRESS_DEFAULT_GEOCODE ADD\n CONSTRAINT ADDRESS_DEFAULT_GEOCODE_FK2 FOREIGN KEY (geocode_type_code)\n  REFERENCES GEOCODE_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_FK1 FOREIGN KEY (address_site_pid)\n  REFERENCES ADDRESS_SITE (address_site_pid);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_FK2 FOREIGN KEY (flat_type_code)\n  REFERENCES FLAT_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_FK3 FOREIGN KEY (level_geocoded_code)\n  REFERENCES GEOCODED_LEVEL_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_FK4 FOREIGN KEY (level_type_code)\n  REFERENCES LEVEL_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_FK5 FOREIGN KEY (locality_pid)\n  REFERENCES LOCALITY (locality_pid);\n\nALTER TABLE ADDRESS_DETAIL ADD\n CONSTRAINT ADDRESS_DETAIL_FK6 FOREIGN KEY (street_locality_pid)\n  REFERENCES STREET_LOCALITY (street_locality_pid);\n\nALTER TABLE ADDRESS_FEATURE ADD\n CONSTRAINT ADDRESS_FEATURE_FK1 FOREIGN KEY (address_change_type_code)\n  REFERENCES ADDRESS_CHANGE_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_FEATURE ADD\n CONSTRAINT ADDRESS_FEATURE_FK2 FOREIGN KEY (address_detail_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2016 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2016_FK1 FOREIGN KEY (address_detail_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2016 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2016_FK2 FOREIGN KEY (mb_2016_pid)\n  REFERENCES MB_2016 (mb_2016_pid);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2016 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2016_FK3 FOREIGN KEY (mb_match_code)\n  REFERENCES MB_MATCH_CODE_AUT (code);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2021 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2021_FK1 FOREIGN KEY (address_detail_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2021 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2021_FK2 FOREIGN KEY (mb_2021_pid)\n  REFERENCES MB_2021 (mb_2021_pid);\n\nALTER TABLE ADDRESS_MESH_BLOCK_2021 ADD\n CONSTRAINT ADDRESS_MESH_BLOCK_2021_FK3 FOREIGN KEY (mb_match_code)\n  REFERENCES MB_MATCH_CODE_AUT (code);\n\nALTER TABLE ADDRESS_SITE ADD\n CONSTRAINT ADDRESS_SITE_FK1 FOREIGN KEY (address_type)\n  REFERENCES ADDRESS_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_SITE_GEOCODE ADD\n CONSTRAINT ADDRESS_SITE_GEOCODE_FK1 FOREIGN KEY (address_site_pid)\n  REFERENCES ADDRESS_SITE (address_site_pid);\n\nALTER TABLE ADDRESS_SITE_GEOCODE ADD\n CONSTRAINT ADDRESS_SITE_GEOCODE_FK2 FOREIGN KEY (geocode_type_code)\n  REFERENCES GEOCODE_TYPE_AUT (code);\n\nALTER TABLE ADDRESS_SITE_GEOCODE ADD\n CONSTRAINT ADDRESS_SITE_GEOCODE_FK3 FOREIGN KEY (reliability_code)\n  REFERENCES GEOCODE_RELIABILITY_AUT (code);\n\nALTER TABLE LOCALITY ADD\n CONSTRAINT LOCALITY_FK1 FOREIGN KEY (gnaf_reliability_code)\n  REFERENCES GEOCODE_RELIABILITY_AUT (code);\n\nALTER TABLE LOCALITY ADD\n CONSTRAINT LOCALITY_FK2 FOREIGN KEY (locality_class_code)\n  REFERENCES LOCALITY_CLASS_AUT (code);\n\nALTER TABLE LOCALITY ADD\n CONSTRAINT LOCALITY_FK3 FOREIGN KEY (state_pid)\n  REFERENCES STATE (state_pid);\n\nALTER TABLE LOCALITY_ALIAS ADD\n CONSTRAINT LOCALITY_ALIAS_FK1 FOREIGN KEY (alias_type_code)\n  REFERENCES LOCALITY_ALIAS_TYPE_AUT (code);\n\nALTER TABLE LOCALITY_ALIAS ADD\n CONSTRAINT LOCALITY_ALIAS_FK2 FOREIGN KEY (locality_pid)\n  REFERENCES LOCALITY (locality_pid);\n\nALTER TABLE LOCALITY_NEIGHBOUR ADD\n CONSTRAINT LOCALITY_NEIGHBOUR_FK1 FOREIGN KEY (locality_pid)\n  REFERENCES LOCALITY (locality_pid);\n\nALTER TABLE LOCALITY_NEIGHBOUR ADD\n CONSTRAINT LOCALITY_NEIGHBOUR_FK2 FOREIGN KEY (neighbour_locality_pid)\n  REFERENCES LOCALITY (locality_pid);\n\nALTER TABLE LOCALITY_POINT ADD\n CONSTRAINT LOCALITY_POINT_FK1 FOREIGN KEY (locality_pid)\n  REFERENCES LOCALITY (locality_pid);\n\nALTER TABLE PRIMARY_SECONDARY ADD\n CONSTRAINT PRIMARY_SECONDARY_FK1 FOREIGN KEY (primary_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE PRIMARY_SECONDARY ADD\n CONSTRAINT PRIMARY_SECONDARY_FK2 FOREIGN KEY (ps_join_type_code)\n  REFERENCES PS_JOIN_TYPE_AUT (code);\n\nALTER TABLE PRIMARY_SECONDARY ADD\n CONSTRAINT PRIMARY_SECONDARY_FK3 FOREIGN KEY (secondary_pid)\n  REFERENCES ADDRESS_DETAIL (address_detail_pid);\n\nALTER TABLE STREET_LOCALITY ADD\n CONSTRAINT STREET_LOCALITY_FK1 FOREIGN KEY (gnaf_reliability_code)\n  REFERENCES GEOCODE_RELIABILITY_AUT (code);\n\nALTER TABLE STREET_LOCALITY ADD\n CONSTRAINT STREET_LOCALITY_FK2 FOREIGN KEY (locality_pid)\n  REFERENCES LOCALITY (locality_pid);\n\nALTER TABLE STREET_LOCALITY ADD\n CONSTRAINT STREET_LOCALITY_FK3 FOREIGN KEY (street_class_code)\n  REFERENCES STREET_CLASS_AUT (code);\n\nALTER TABLE STREET_LOCALITY ADD\n CONSTRAINT STREET_LOCALITY_FK4 FOREIGN KEY (street_suffix_code)\n  REFERENCES STREET_SUFFIX_AUT (code);\n\nALTER TABLE STREET_LOCALITY ADD\n CONSTRAINT STREET_LOCALITY_FK5 FOREIGN KEY (street_type_code)\n  REFERENCES STREET_TYPE_AUT (code);\n\nALTER TABLE STREET_LOCALITY_ALIAS ADD\n CONSTRAINT STREET_LOCALITY_ALIAS_FK1 FOREIGN KEY (alias_type_code)\n  REFERENCES STREET_LOCALITY_ALIAS_TYPE_AUT (code);\n\nALTER TABLE STREET_LOCALITY_ALIAS ADD\n CONSTRAINT STREET_LOCALITY_ALIAS_FK2 FOREIGN KEY (street_locality_pid)\n  REFERENCES STREET_LOCALITY (street_locality_pid);\n\nALTER TABLE STREET_LOCALITY_ALIAS ADD\n CONSTRAINT STREET_LOCALITY_ALIAS_FK3 FOREIGN KEY (street_suffix_code)\n  REFERENCES STREET_SUFFIX_AUT (code);\n\nALTER TABLE STREET_LOCALITY_ALIAS ADD\n CONSTRAINT STREET_LOCALITY_ALIAS_FK4 FOREIGN KEY (street_type_code)\n  REFERENCES STREET_TYPE_AUT (code);\n\nALTER TABLE STREET_LOCALITY_POINT ADD\n CONSTRAINT STREET_LOCALITY_POINT_FK1 FOREIGN KEY (street_locality_pid)\n  REFERENCES STREET_LOCALITY (street_locality_pid);<\/pre>\n
\u30d3\u30e5\u30fc\u306e\u4f5c\u6210<\/h2>\n
\u3000GNAF_View_Scripts\u30d5\u30a9\u30eb\u30c0\u5185\u306eaddress_view.sql\u30d5\u30a1\u30a4\u30eb\u3092SQL Server Management Studio\u3067\u958b\u3044\u3066\u5b9f\u884c\u3059\u308b\u3068\u30d3\u30e5\u30fc\u304c\u4f5c\u6210\u3055\u308c\u308b\uff0e<\/p>\n
USE GNAFDB;\nGO\n\nCREATE VIEW ADDRESS_VIEW\n\nAS\n\nSELECT\nAD.ADDRESS_DETAIL_PID as ADDRESS_DETAIL_PID,\nAD.STREET_LOCALITY_PID as STREET_LOCALITY_PID,\nAD.LOCALITY_PID as LOCALITY_PID,\nAD.BUILDING_NAME as BUILDING_NAME,\n\nAD.LOT_NUMBER_PREFIX as LOT_NUMBER_PREFIX,\nAD.LOT_NUMBER as LOT_NUMBER,\nAD.LOT_NUMBER_SUFFIX as LOT_NUMBER_SUFFIX,\n\nFTA.NAME as FLAT_TYPE,\nAD.FLAT_NUMBER_PREFIX as FLAT_NUMBER_PREFIX,\nAD.FLAT_NUMBER as FLAT_NUMBER,\nAD.FLAT_NUMBER_SUFFIX as FLAT_NUMBER_SUFFIX,\n\nLTA.NAME as LEVEL_TYPE,\nAD.LEVEL_NUMBER_PREFIX as LEVEL_NUMBER_PREFIX,\nAD.LEVEL_NUMBER as LEVEL_NUMBER,\nAD.LEVEL_NUMBER_SUFFIX as LEVEL_NUMBER_SUFFIX,\n\nAD.NUMBER_FIRST_PREFIX as NUMBER_FIRST_PREFIX,\nAD.NUMBER_FIRST as NUMBER_FIRST,\nAD.NUMBER_FIRST_SUFFIX as NUMBER_FIRST_SUFFIX,\nAD.NUMBER_LAST_PREFIX as NUMBER_LAST_PREFIX,\nAD.NUMBER_LAST as NUMBER_LAST,\nAD.NUMBER_LAST_SUFFIX as NUMBER_LAST_SUFFIX,\n\nSL.STREET_NAME as STREET_NAME,\nSL.STREET_CLASS_CODE as STREET_CLASS_CODE,\nSCA.NAME as STREET_CLASS_TYPE,\nSL.STREET_TYPE_CODE as STREET_TYPE_CODE,\nSL.STREET_SUFFIX_CODE as STREET_SUFFIX_CODE,\nSSA.NAME as STREET_SUFFIX_TYPE,\n\nL.LOCALITY_NAME as LOCALITY_NAME,\n\nST.STATE_ABBREVIATION as STATE_ABBREVIATION,\n\nAD.POSTCODE as POSTCODE,\n\nADG.LATITUDE as LATITUDE,\nADG.LONGITUDE as LONGITUDE,\nGTA.NAME as GEOCODE_TYPE,\n\nAD.CONFIDENCE as CONFIDENCE,\n\nAD.ALIAS_PRINCIPAL as ALIAS_PRINCIPAL,\nAD.PRIMARY_SECONDARY as PRIMARY_SECONDARY,\n\nAD.LEGAL_PARCEL_ID as LEGAL_PARCEL_ID,\n\nAD.DATE_CREATED as DATE_CREATED\n\nFROM\n\nADDRESS_DETAIL AD \nLEFT JOIN FLAT_TYPE_AUT FTA ON AD.FLAT_TYPE_CODE=FTA.CODE\nLEFT JOIN LEVEL_TYPE_AUT LTA ON AD.LEVEL_TYPE_CODE=LTA.CODE\nJOIN STREET_LOCALITY SL ON AD.STREET_LOCALITY_PID=SL.STREET_LOCALITY_PID\nLEFT JOIN STREET_SUFFIX_AUT SSA ON SL.STREET_SUFFIX_CODE=SSA.CODE\nLEFT JOIN STREET_CLASS_AUT SCA ON SL.STREET_CLASS_CODE=SCA.CODE \nLEFT JOIN STREET_TYPE_AUT STA ON SL.STREET_TYPE_CODE=STA.CODE\nJOIN LOCALITY L ON AD.LOCALITY_PID = L.LOCALITY_PID\nJOIN ADDRESS_DEFAULT_GEOCODE ADG ON AD.ADDRESS_DETAIL_PID=ADG.ADDRESS_DETAIL_PID\nLEFT JOIN GEOCODE_TYPE_AUT GTA ON ADG.GEOCODE_TYPE_CODE=GTA.CODE\nLEFT JOIN GEOCODED_LEVEL_TYPE_AUT GLTA ON AD.LEVEL_GEOCODED_CODE=GLTA.CODE\nJOIN STATE ST ON L.STATE_PID=ST.STATE_PID\n\nWHERE \nAD.CONFIDENCE > -1<\/pre>\n
\u30af\u30a8\u30ea\u306e\u5b9f\u884c<\/h2>\n
\u3000\u30d2\u30eb\u30c8\u30f3\u30b1\u30a2\u30f3\u30ba\u306e\u4f4f\u6240\uff0834 Esplanade, Cairns City QLD 4870\uff09\u3092\u5165\u529b\u3057\u3066\u307f\u308b\uff0e<\/p>\n
SELECT [ADDRESS_DETAIL_PID]\n      ,[STREET_LOCALITY_PID]\n      ,[LOCALITY_PID]\n      ,[BUILDING_NAME]\n      ,[LOT_NUMBER_PREFIX]\n      ,[LOT_NUMBER]\n      ,[LOT_NUMBER_SUFFIX]\n      ,[FLAT_TYPE]\n      ,[FLAT_NUMBER_PREFIX]\n      ,[FLAT_NUMBER]\n      ,[FLAT_NUMBER_SUFFIX]\n      ,[LEVEL_TYPE]\n      ,[LEVEL_NUMBER_PREFIX]\n      ,[LEVEL_NUMBER]\n      ,[LEVEL_NUMBER_SUFFIX]\n      ,[NUMBER_FIRST_PREFIX]\n      ,[NUMBER_FIRST]\n      ,[NUMBER_FIRST_SUFFIX]\n      ,[NUMBER_LAST_PREFIX]\n      ,[NUMBER_LAST]\n      ,[NUMBER_LAST_SUFFIX]\n      ,[STREET_NAME]\n      ,[STREET_CLASS_CODE]\n      ,[STREET_CLASS_TYPE]\n      ,[STREET_TYPE_CODE]\n      ,[STREET_SUFFIX_CODE]\n      ,[STREET_SUFFIX_TYPE]\n      ,[LOCALITY_NAME]\n      ,[STATE_ABBREVIATION]\n      ,[POSTCODE]\n      ,[LATITUDE]\n      ,[LONGITUDE]\n      ,[GEOCODE_TYPE]\n      ,[CONFIDENCE]\n      ,[ALIAS_PRINCIPAL]\n      ,[PRIMARY_SECONDARY]\n      ,[LEGAL_PARCEL_ID]\n      ,[DATE_CREATED]\n  FROM [GNAFDB].[dbo].[ADDRESS_VIEW]\n  WHERE POSTCODE = '4870'\n  AND\tSTATE_ABBREVIATION = 'QLD'\n  AND\tLOCALITY_NAME = 'Cairns City'\n  AND\tSTREET_NAME = 'Esplanade'\n  AND\tNUMBER_FIRST = '34'<\/pre>\n
\u7d50\u679c<\/h2>\n
\u3000\u7d50\u679c\u306f\u8907\u6570\u884c\u3060\u304c\uff0c\u7d4c\u5ea6\uff0c\u7def\u5ea6\u306e\u5ea7\u6a19\u306f\u3059\u3079\u3066\u4e00\u81f4\u3057\u3066\u3044\u308b\uff0e<\/p>\n
ADDRESS_DETAIL_PID\tSTREET_LOCALITY_PID\tLOCALITY_PID\tBUILDING_NAME\tLOT_NUMBER_PREFIX\tLOT_NUMBER\tLOT_NUMBER_SUFFIX\tFLAT_TYPE\tFLAT_NUMBER_PREFIX\tFLAT_NUMBER\tFLAT_NUMBER_SUFFIX\tLEVEL_TYPE\tLEVEL_NUMBER_PREFIX\tLEVEL_NUMBER\tLEVEL_NUMBER_SUFFIX\tNUMBER_FIRST_PREFIX\tNUMBER_FIRST\tNUMBER_FIRST_SUFFIX\tNUMBER_LAST_PREFIX\tNUMBER_LAST\tNUMBER_LAST_SUFFIX\tSTREET_NAME\tSTREET_CLASS_CODE\tSTREET_CLASS_TYPE\tSTREET_TYPE_CODE\tSTREET_SUFFIX_CODE\tSTREET_SUFFIX_TYPE\tLOCALITY_NAME\tSTATE_ABBREVIATION\tPOSTCODE\tLATITUDE\tLONGITUDE\tGEOCODE_TYPE\tCONFIDENCE\tALIAS_PRINCIPAL\tPRIMARY_SECONDARY\tLEGAL_PARCEL_ID\tDATE_CREATED\nGAQLD720480696\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t3\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20\nGAQLD720483038\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t6\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20\nGAQLD720482479\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t5\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20\nGAQLD720481480\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t7\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20\nGAQLD720481625\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t2\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20\nGAQLD155118382\tQLD172446\tloc48dc42f9f7dd\tHILTON HOTEL\tNULL\t10\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t2\tP\tP\t10\/SP214821\t2021-07-25\nGAQLD720481476\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t4\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20\nGAQLD720480712\tQLD172446\tloc48dc42f9f7dd\tNULL\tNULL\tNULL\tNULL\tSHOP\tNULL\t1\tNULL\tNULL\tNULL\tNULL\tNULL\tNULL\t34\tNULL\tNULL\t38\tNULL\tESPLANADE\tC\tCONFIRMED\tNULL\tNULL\tNULL\tCAIRNS CITY\tQLD\t4870\t-16.92483379\t145.78013420\tPROPERTY CENTROID\t0\tP\tS\t10\/SP214821\t2020-07-20<\/pre>\n
Cairns City\u306e\u30dd\u30a4\u30f3\u30c8\u3092\u62bd\u51fa\u3059\u308b\u30af\u30a8\u30ea<\/h2>\n
\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3059\u308b\uff0e<\/p>\n
SELECT [ADDRESS_DETAIL_PID]\n      ,[STREET_LOCALITY_PID]\n      ,[LOCALITY_PID]\n      ,[BUILDING_NAME]\n      ,[LOT_NUMBER_PREFIX]\n      ,[LOT_NUMBER]\n      ,[LOT_NUMBER_SUFFIX]\n      ,[FLAT_TYPE]\n      ,[FLAT_NUMBER_PREFIX]\n      ,[FLAT_NUMBER]\n      ,[FLAT_NUMBER_SUFFIX]\n      ,[LEVEL_TYPE]\n      ,[LEVEL_NUMBER_PREFIX]\n      ,[LEVEL_NUMBER]\n      ,[LEVEL_NUMBER_SUFFIX]\n      ,[NUMBER_FIRST_PREFIX]\n      ,[NUMBER_FIRST]\n      ,[NUMBER_FIRST_SUFFIX]\n      ,[NUMBER_LAST_PREFIX]\n      ,[NUMBER_LAST]\n      ,[NUMBER_LAST_SUFFIX]\n      ,[STREET_NAME]\n      ,[STREET_CLASS_CODE]\n      ,[STREET_CLASS_TYPE]\n      ,[STREET_TYPE_CODE]\n      ,[STREET_SUFFIX_CODE]\n      ,[STREET_SUFFIX_TYPE]\n      ,[LOCALITY_NAME]\n      ,[STATE_ABBREVIATION]\n      ,[POSTCODE]\n      ,[LATITUDE]\n      ,[LONGITUDE]\n      ,[GEOCODE_TYPE]\n      ,[CONFIDENCE]\n      ,[ALIAS_PRINCIPAL]\n      ,[PRIMARY_SECONDARY]\n      ,[LEGAL_PARCEL_ID]\n      ,[DATE_CREATED]\n  FROM [GNAFDB].[dbo].[ADDRESS_VIEW]\n  WHERE\tLOCALITY_NAME = 'CAIRNS CITY'<\/pre>\n
(6357 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n
\u7d50\u679c<\/h2>\n
\u3000\u7d50\u679c\u3092QGIS\u3067\u8868\u793a\u3059\u308b\uff0e<\/p>\n
\"Cairns<\/a>
Cairns City\u306e\u4f4f\u6240\u3092\u30de\u30c3\u30d4\u30f3\u30b0<\/figcaption><\/figure>\n
\u307e\u3068\u3081<\/h2>\n
\u3000\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u306eGeoscape\u793e\u306b\u3088\u308b\u4f4f\u6240\u304b\u3089\u306e\u30b8\u30aa\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3092\u884c\u3063\u305f\uff0e\u30d5\u30a1\u30a4\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306eBULK INSERT\u306b\u3088\u308a10\u5206\u3068\u304b\u304b\u3089\u305a\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u69cb\u7bc9\u3067\u304d\u305f\uff0e\u30c6\u30fc\u30d6\u30eb\u540d\u3092\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u542b\u3081\u3066\u3042\u308a\uff0cPower Query\u3067\u306e\u30b3\u30fc\u30c9\u4f5c\u6210\u304c\u5bb9\u6613\u3067\u3042\u3063\u305f\u3053\u3068\u304c\u305d\u306e\u7406\u7531\u3067\u3042\u308b\uff0e<\/p>\n
\u3000\u65e5\u672c\u306b\u304a\u3044\u3066\u306f\u6771\u5927\u304c\u540c\u69d8\u306e\u30b5\u30fc\u30d3\u30b9<\/a>\u3092\u5c55\u958b\u3057\u3066\u3044\u308b\u304c\uff0c\u7cbe\u5ea6\u306e\u70b9\u3067\u306f\u4eca\u3072\u3068\u3064\u304b\u3082\u3057\u308c\u306a\u3044\uff0e\u56fd\u5185\u3067\u552f\u4e00\u4f4f\u6240\u30ec\u30d9\u30eb\u306e\u30b8\u30aa\u30c7\u30fc\u30bf\u3092\u6709\u3057\u3066\u3044\u308b\u306e\u306f\u30bc\u30f3\u30ea\u30f3\u3067\u3042\u308d\u3046\uff0e\u500b\u4eba\u60c5\u5831\u4fdd\u8b77\u306e\u89b3\u70b9\u304b\u3089\u306f\u96e3\u3057\u3044\u306e\u304b\u3082\u3057\u308c\u306a\u3044\u304c\uff0c\u9632\u707d\u306e\u89b3\u70b9\u304b\u3089\u306f\u516c\u958b\u304c\u671b\u307e\u3057\u3044\uff0e\u653f\u5e9c\u3068\u4f01\u696d\u306e\u5354\u696d\u304c\u5fc5\u8981\u3067\u3042\u308b\uff0e<\/p>\n","protected":false},"excerpt":{"rendered":"
\u3000\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u3067\u306e\u4f4f\u6240\u304b\u3089\u306e\u30b8\u30aa\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306fGeoscape\u793e\u304c\u62c5\u5f53\u3057\u3066\u304a\u308a\uff0c\u305d\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d\u3092G-NAF\u3068\u3044\u3046\uff0e\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u653f\u5e9c\u304b\u3089\u88dc\u52a9\u91d1\u3092\u53d7\u3051\u3066\u304a\u308a\uff0c2029\u5e74\u307e\u3067\u7121\u6599\u516c\u958b\u3055\u308c\u308b\u3053\u3068\u304c\u6c7a\u307e\u3063\u3066\u3044\u308b\uff0e \u3000\u30c7\u30fc\u30bf … <\/p>\n
“\u30aa\u30fc\u30b9\u30c8\u30e9\u30ea\u30a2\u306e\u30b8\u30aa\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":18094,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[7907,7554,13771,7550,7901,13779,2884,265,11855,11857,2878,13777,4673,13768,13770,13769,13767,7095,3725,13775,4067,12019,13774,13778,11856,2740,2750,4165,7580,7595,2861,2871,9119,7230,4012,13776,13780,2684,462,2938,32,13773,4839,13772,4483,2703,13781,2765,2608],"class_list":["post-18031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-add-constraint","tag-alter-table","tag-authority-code","tag-bulk-insert","tag-create-table","tag-create-view","tag-date","tag-excel","tag-fieldterminator","tag-firstrow","tag-flat-file-source","tag-foreign-key","tag-from","tag-g-naf","tag-gda2020","tag-gda94","tag-geoscape","tag-left-join","tag-outputcolumnwidth","tag-pipe-separated-value","tag-power-query","tag-primary-key","tag-psv","tag-references","tag-rowterminator","tag-sql-server","tag-sql-server-management-studio","tag-sql-server-native-client-11-0","tag-standard","tag-varchar","tag-2861","tag-2871","tag-9119","tag-7230","tag-4012","tag-13776","tag-13780","tag-2684","tag-462","tag-2938","tag-32","tag-13773","tag-4839","tag-13772","tag-4483","tag-2703","tag-13781","tag-2765","tag-2608"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/18031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18031"}],"version-history":[{"count":38,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/18031\/revisions"}],"predecessor-version":[{"id":18096,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/18031\/revisions\/18096"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/18094"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}